Symfony Profiler

[
  "route" => "smartideas"
  "route_parameters" => [
    "_route" => "smartideas"
    "_controller" => "App\Controller\HomeController::smartideas"
  ]
  "request_uri" => "https://www.drilleedo.softsquareit.com/smartideas?page=1"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "baddalgprod.mysql.db"
    "port" => 3306
    "user" => "baddalgprod"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "baddalgprod"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8 FROM blog b0_ WHERE b0_.type = ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => "Idea"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#865
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_8 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8 FROM blog b0_ WHERE b0_.type = ?) dctrn_result_inner ORDER BY created_at_8 DESC) dctrn_result LIMIT 6"
  "params" => [
    1 => "Idea"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#865
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8, b0_.category_id AS category_id_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.type = ? AND b0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC"
  "params" => [
    1 => "Idea"
    2 => 41
    3 => 40
    4 => 37
    5 => 33
    6 => 30
    7 => 29
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#865
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#872
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#872}
    4 => Doctrine\DBAL\ParameterType {#872}
    5 => Doctrine\DBAL\ParameterType {#872}
    6 => Doctrine\DBAL\ParameterType {#872}
    7 => Doctrine\DBAL\ParameterType {#872}
  ]
]

[
  "sql" => "SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#872
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#872
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = ?"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#872
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#872
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#872
      +name: "INTEGER"
    }
  ]
]