Symfony Profiler

[
  "route" => "companies_list"
  "route_parameters" => [
    "_route" => "companies_list"
    "_controller" => "App\Controller\HomeController::companies"
  ]
  "request_uri" => "https://www.drilleedo.softsquareit.com/companies-list?page=2"
  "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 u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, c2_.website AS website_13, c2_.foundation_year AS foundation_year_14, c2_.emp_num AS emp_num_15, u0_.type AS type_16 FROM company c2_ INNER JOIN business b1_ ON c2_.id = b1_.id INNER JOIN `user` u0_ ON c2_.id = u0_.id ORDER BY u0_.id DESC) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 ORDER BY t0.name ASC"
]

[
  "sql" => "SELECT DISTINCT a0_.city AS city_0 FROM company c1_ INNER JOIN business b2_ ON c1_.id = b2_.id INNER JOIN `user` u3_ ON c1_.id = u3_.id INNER JOIN adress a0_ ON b2_.id = a0_.business_id WHERE a0_.city IS NOT NULL ORDER BY a0_.city ASC"
]

[
  "sql" => "SELECT c0_.id AS id_0, COUNT(u1_.id) AS sclr_1 FROM company c2_ INNER JOIN business b3_ ON c2_.id = b3_.id INNER JOIN `user` u1_ ON c2_.id = u1_.id INNER JOIN company_category c4_ ON c2_.id = c4_.company_id INNER JOIN category c0_ ON c0_.id = c4_.category_id GROUP BY c0_.id"
]

[
  "sql" => "SELECT a0_.city AS city_0, COUNT(u1_.id) AS sclr_1 FROM company c2_ INNER JOIN business b3_ ON c2_.id = b3_.id INNER JOIN `user` u1_ ON c2_.id = u1_.id INNER JOIN adress a0_ ON b3_.id = a0_.business_id WHERE a0_.city IS NOT NULL GROUP BY a0_.city"
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, c2_.website AS website_13, c2_.foundation_year AS foundation_year_14, c2_.emp_num AS emp_num_15, u0_.type AS type_16 FROM company c2_ INNER JOIN business b1_ ON c2_.id = b1_.id INNER JOIN `user` u0_ ON c2_.id = u0_.id) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 6 OFFSET 6"
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, c2_.website AS website_13, c2_.foundation_year AS foundation_year_14, c2_.emp_num AS emp_num_15, u0_.type AS type_16, u0_.personal_infos_id AS personal_infos_id_17, b1_.primary_contact_id AS primary_contact_id_18, b1_.entrepreneur_type_id AS entrepreneur_type_id_19 FROM company c2_ INNER JOIN business b1_ ON c2_.id = b1_.id INNER JOIN `user` u0_ ON c2_.id = u0_.id WHERE u0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC"
  "params" => [
    1 => 57
    2 => 56
    3 => 55
    4 => 54
    5 => 53
    6 => 52
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1324}
    3 => Doctrine\DBAL\ParameterType {#1324}
    4 => Doctrine\DBAL\ParameterType {#1324}
    5 => Doctrine\DBAL\ParameterType {#1324}
    6 => Doctrine\DBAL\ParameterType {#1324}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1324
      +name: "INTEGER"
    }
  ]
]