Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_locale" => "fr"
    "_controller" => "App\Controller\Home\AppController::index"
  ]
  "request_uri" => "https://demo.churchmanager.fr/"
  "method" => "GET"
]

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

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

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

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

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

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

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

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

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

[
  "key" => "packaging.monthly.fr"
]

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

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nb_entite AS nb_entite_2, p0_.nb_user AS nb_user_3, p0_.count_manager AS count_manager_4, p0_.price AS price_5, p0_.state AS state_6, p0_.delail_by_mounth AS delail_by_mounth_7, p0_.stripe_price AS stripe_price_8, p0_.max_duplications_per_month AS max_duplications_per_month_9, p0_.description AS description_10, p0_.option1 AS option1_11, p0_.option2 AS option2_12, p0_.option3 AS option3_13, p0_.option4 AS option4_14, p0_.option5 AS option5_15, p0_.option6 AS option6_16, p0_.option7 AS option7_17, p0_.option8 AS option8_18, p0_.option9 AS option9_19, p0_.option10 AS option10_20, p0_.uuid AS uuid_21, p0_.updated_at AS updated_at_22, p0_.created_at AS created_at_23 FROM packaging p0_ WHERE p0_.state = ? AND p0_.delail_by_mounth = ? ORDER BY p0_.price ASC"
  "params" => [
    1 => "active"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1559
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "http_code" => 200
  "url" => "https://maps.googleapis.com/maps/api/place/details/json?place_id=&fields=rating%2Cuser_ratings_total&key=AIzaSyBDo9_kI-yl_IMHgHy-Il_2T3bHLD1g4rE"
  "total_time" => 0.038043
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.position AS position_2, h0_.type AS type_3, h0_.content AS content_4, h0_.is_active AS is_active_5, h0_.priority AS priority_6, h0_.uuid AS uuid_7, h0_.updated_at AS updated_at_8, h0_.created_at AS created_at_9 FROM head_tag h0_ WHERE h0_.position = ? AND h0_.is_active = ? ORDER BY h0_.priority DESC, h0_.id ASC"
  "params" => [
    1 => "head"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "http_code" => 200
  "url" => "https://maps.googleapis.com/maps/api/place/details/json?place_id=&fields=name%2Creviews%2Crating%2Cuser_ratings_total&key=AIzaSyBDo9_kI-yl_IMHgHy-Il_2T3bHLD1g4rE&language=fr"
  "total_time" => 0.024137
]

[
  "sql" => "SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 5"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "http_code" => 200
  "url" => "https://maps.googleapis.com/maps/api/place/details/json?place_id=&fields=name%2Creviews%2Crating%2Cuser_ratings_total&key=AIzaSyBDo9_kI-yl_IMHgHy-Il_2T3bHLD1g4rE&language=fr"
  "total_time" => 0.013686
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.position AS position_2, h0_.type AS type_3, h0_.content AS content_4, h0_.is_active AS is_active_5, h0_.priority AS priority_6, h0_.uuid AS uuid_7, h0_.updated_at AS updated_at_8, h0_.created_at AS created_at_9 FROM head_tag h0_ WHERE h0_.position = ? AND h0_.is_active = ? ORDER BY h0_.priority DESC, h0_.id ASC"
  "params" => [
    1 => "body_top"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1"
  "params" => [
    1 => "manager"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.position AS position_2, h0_.type AS type_3, h0_.content AS content_4, h0_.is_active AS is_active_5, h0_.priority AS priority_6, h0_.uuid AS uuid_7, h0_.updated_at AS updated_at_8, h0_.created_at AS created_at_9 FROM head_tag h0_ WHERE h0_.position = ? AND h0_.is_active = ? ORDER BY h0_.priority DESC, h0_.id ASC"
  "params" => [
    1 => "body_bottom"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1122
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#971
      +name: "BOOLEAN"
    }
  ]
]