Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'BREVO_API_KEY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.alt AS alt_3,
  t0.url AS url_4,
  t0.title AS title_5,
  t0.active AS active_6
FROM
  partner_home t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3, t0.url AS url_4, t0.title AS title_5, t0.active AS active_6 FROM partner_home t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.siret AS siret_4,
  t0.tva AS tva_5,
  t0.phone AS phone_6,
  t0.siren AS siren_7,
  t0.nic AS nic_8,
  t0.cat_juridique AS cat_juridique_9,
  t0.denomination AS denomination_10,
  t0.activite_principal AS activite_principal_11,
  t0.address1 AS address1_12,
  t0.address2 AS address2_13,
  t0.zip_code AS zip_code_14,
  t0.city AS city_15,
  t0.frequency AS frequency_16,
  t0.iban AS iban_17,
  t0.bic AS bic_18,
  t0.mandate_id AS mandate_id_19,
  t0.mandate_date AS mandate_date_20,
  t0.offer_value AS offer_value_21,
  t0.societe_old_id AS societe_old_id_22,
  t0.tirelire AS tirelire_23,
  t0.abondement AS abondement_24,
  t0.subdomain AS subdomain_25,
  t0.color_primary AS color_primary_26,
  t0.color_secondary AS color_secondary_27,
  t0.contract_date AS contract_date_28,
  t0.date_abondement AS date_abondement_29,
  t0.bans AS bans_30,
  t0.bans_sg AS bans_sg_31,
  t0.card_price AS card_price_32,
  t0.wallet_id AS wallet_id_33,
  t0.start_contract AS start_contract_34,
  t0.contract_duration AS contract_duration_35,
  t0.renewal_year AS renewal_year_36,
  t0.months_notice AS months_notice_37,
  t0.date_cancellation AS date_cancellation_38,
  t0.theoretical_end_contract AS theoretical_end_contract_39,
  t0.end_contract_renewal AS end_contract_renewal_40,
  t0.date_request_cancellation AS date_request_cancellation_41,
  t0.benefeciary_id AS benefeciary_id_42,
  t0.offer_id AS offer_id_43,
  t0.salesperson_id AS salesperson_id_44,
  t0.departement_id AS departement_id_45,
  t46.id AS id_47,
  t46.bic AS bic_48,
  t46.iban AS iban_49,
  t46.company_id_id AS company_id_id_50,
  t0.debit_bank_id AS debit_bank_id_51
FROM
  company t0
  LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = 'developpement' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.published AS published_2,
  a0_.datecreate AS datecreate_3,
  a0_.content AS content_4,
  a0_.dateedited AS dateedited_5,
  a0_.datepublished AS datepublished_6,
  a0_.image AS image_7,
  a0_.slug AS slug_8,
  a0_.author_id AS author_id_9
FROM
  article_blog a0_
WHERE
  a0_.published = ?
ORDER BY
  a0_.datepublished DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.published AS published_2, a0_.datecreate AS datecreate_3, a0_.content AS content_4, a0_.dateedited AS dateedited_5, a0_.datepublished AS datepublished_6, a0_.image AS image_7, a0_.slug AS slug_8, a0_.author_id AS author_id_9 FROM article_blog a0_ WHERE a0_.published = 1 ORDER BY a0_.datepublished DESC LIMIT 3;

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.position AS position_2,
  a0_.detail AS detail_3,
  a0_.image AS image_4,
  a0_.slug AS slug_5,
  a0_.content AS content_6,
  a0_.bootstrap_icon_id AS bootstrap_icon_id_7
FROM
  avantages_home a0_
ORDER BY
  a0_.position ASC
LIMIT
  6

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.position AS position_2, a0_.detail AS detail_3, a0_.image AS image_4, a0_.slug AS slug_5, a0_.content AS content_6, a0_.bootstrap_icon_id AS bootstrap_icon_id_7 FROM avantages_home a0_ ORDER BY a0_.position ASC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon_id AS icon_id_3
FROM
  avantages_cse_home t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon_id AS icon_id_3 FROM avantages_cse_home t0;

SELECT
  t0.id AS id_1,
  t0.text1 AS text1_2,
  t0.text2 AS text2_3,
  t0.icon_id AS icon_id_4
FROM
  rhtools_home t0

SELECT t0.id AS id_1, t0.text1 AS text1_2, t0.text2 AS text2_3, t0.icon_id AS icon_id_4 FROM rhtools_home t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.icon_id AS icon_id_3
FROM
  avantages_dirigeant_home t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.icon_id AS icon_id_3 FROM avantages_dirigeant_home t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'AVT_HOME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'AVT_DIR_HOME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'RH_TOOLS_HOME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'PART_HOME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'AVT_CSE_HOME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.date_naissance AS date_naissance_8,
  t0.civilite AS civilite_9,
  t0.mobile AS mobile_10,
  t0.fix AS fix_11,
  t0.date_inscription AS date_inscription_12,
  t0.derniere_visite AS derniere_visite_13,
  t0.iban AS iban_14,
  t0.bic AS bic_15,
  t0.is_famille AS is_famille_16,
  t0.societe_old_id AS societe_old_id_17,
  t0.cgu AS cgu_18,
  t0.notification AS notification_19,
  t0.email_accept AS email_accept_20,
  t0.notif_app AS notif_app_21,
  t0.notif_sms AS notif_sms_22,
  t0.notif_newsletter AS notif_newsletter_23,
  t0.actif AS actif_24,
  t0.alias_cb AS alias_cb_25,
  t0.ruleset_id AS ruleset_id_26,
  t0.auth_code AS auth_code_27,
  t0.fcm_token AS fcm_token_28,
  t0.cagnotte_id AS cagnotte_id_29,
  t0.famille_id AS famille_id_30,
  t0.adresse_defaut_id AS adresse_defaut_id_31,
  t32.id AS id_33,
  t32.photo AS photo_34,
  t32.code AS code_35,
  t32.user_id AS user_id_36,
  t37.id AS id_38,
  t37.analytics_storage AS analytics_storage_39,
  t37.ad_storage AS ad_storage_40,
  t37.ad_user_data AS ad_user_data_41,
  t37.ad_personalization AS ad_personalization_42,
  t37.user_id AS user_id_43,
  t44.id AS id_45,
  t44.date AS date_46,
  t44.actif AS actif_47,
  t44.user_id AS user_id_48,
  t44.user_company_id AS user_company_id_49,
  t50.id AS id_51,
  t50.id_utilisateur AS id_utilisateur_52,
  t50.actif AS actif_53,
  t50.user_id AS user_id_54
FROM
  `user` t0
  LEFT JOIN card t32 ON t32.user_id = t0.id
  LEFT JOIN analytics_permissions t37 ON t37.user_id = t0.id
  LEFT JOIN mail_programmation t44 ON t44.user_id = t0.id
  LEFT JOIN user_treezor t50 ON t50.user_id = t0.id

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.date_naissance AS date_naissance_8, t0.civilite AS civilite_9, t0.mobile AS mobile_10, t0.fix AS fix_11, t0.date_inscription AS date_inscription_12, t0.derniere_visite AS derniere_visite_13, t0.iban AS iban_14, t0.bic AS bic_15, t0.is_famille AS is_famille_16, t0.societe_old_id AS societe_old_id_17, t0.cgu AS cgu_18, t0.notification AS notification_19, t0.email_accept AS email_accept_20, t0.notif_app AS notif_app_21, t0.notif_sms AS notif_sms_22, t0.notif_newsletter AS notif_newsletter_23, t0.actif AS actif_24, t0.alias_cb AS alias_cb_25, t0.ruleset_id AS ruleset_id_26, t0.auth_code AS auth_code_27, t0.fcm_token AS fcm_token_28, t0.cagnotte_id AS cagnotte_id_29, t0.famille_id AS famille_id_30, t0.adresse_defaut_id AS adresse_defaut_id_31, t32.id AS id_33, t32.photo AS photo_34, t32.code AS code_35, t32.user_id AS user_id_36, t37.id AS id_38, t37.analytics_storage AS analytics_storage_39, t37.ad_storage AS ad_storage_40, t37.ad_user_data AS ad_user_data_41, t37.ad_personalization AS ad_personalization_42, t37.user_id AS user_id_43, t44.id AS id_45, t44.date AS date_46, t44.actif AS actif_47, t44.user_id AS user_id_48, t44.user_company_id AS user_company_id_49, t50.id AS id_51, t50.id_utilisateur AS id_utilisateur_52, t50.actif AS actif_53, t50.user_id AS user_id_54 FROM `user` t0 LEFT JOIN card t32 ON t32.user_id = t0.id LEFT JOIN analytics_permissions t37 ON t37.user_id = t0.id LEFT JOIN mail_programmation t44 ON t44.user_id = t0.id LEFT JOIN user_treezor t50 ON t50.user_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.siret AS siret_4,
  t0.tva AS tva_5,
  t0.phone AS phone_6,
  t0.siren AS siren_7,
  t0.nic AS nic_8,
  t0.cat_juridique AS cat_juridique_9,
  t0.denomination AS denomination_10,
  t0.activite_principal AS activite_principal_11,
  t0.address1 AS address1_12,
  t0.address2 AS address2_13,
  t0.zip_code AS zip_code_14,
  t0.city AS city_15,
  t0.frequency AS frequency_16,
  t0.iban AS iban_17,
  t0.bic AS bic_18,
  t0.mandate_id AS mandate_id_19,
  t0.mandate_date AS mandate_date_20,
  t0.offer_value AS offer_value_21,
  t0.societe_old_id AS societe_old_id_22,
  t0.tirelire AS tirelire_23,
  t0.abondement AS abondement_24,
  t0.subdomain AS subdomain_25,
  t0.color_primary AS color_primary_26,
  t0.color_secondary AS color_secondary_27,
  t0.contract_date AS contract_date_28,
  t0.date_abondement AS date_abondement_29,
  t0.bans AS bans_30,
  t0.bans_sg AS bans_sg_31,
  t0.card_price AS card_price_32,
  t0.wallet_id AS wallet_id_33,
  t0.start_contract AS start_contract_34,
  t0.contract_duration AS contract_duration_35,
  t0.renewal_year AS renewal_year_36,
  t0.months_notice AS months_notice_37,
  t0.date_cancellation AS date_cancellation_38,
  t0.theoretical_end_contract AS theoretical_end_contract_39,
  t0.end_contract_renewal AS end_contract_renewal_40,
  t0.date_request_cancellation AS date_request_cancellation_41,
  t0.benefeciary_id AS benefeciary_id_42,
  t0.offer_id AS offer_id_43,
  t0.salesperson_id AS salesperson_id_44,
  t0.departement_id AS departement_id_45,
  t46.id AS id_47,
  t46.bic AS bic_48,
  t46.iban AS iban_49,
  t46.company_id_id AS company_id_id_50,
  t0.debit_bank_id AS debit_bank_id_51
FROM
  company t0
  LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reducce_articles r0_

SELECT COUNT(r0_.id) AS sclr_0 FROM reducce_articles r0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.siret AS siret_4,
  t0.tva AS tva_5,
  t0.phone AS phone_6,
  t0.siren AS siren_7,
  t0.nic AS nic_8,
  t0.cat_juridique AS cat_juridique_9,
  t0.denomination AS denomination_10,
  t0.activite_principal AS activite_principal_11,
  t0.address1 AS address1_12,
  t0.address2 AS address2_13,
  t0.zip_code AS zip_code_14,
  t0.city AS city_15,
  t0.frequency AS frequency_16,
  t0.iban AS iban_17,
  t0.bic AS bic_18,
  t0.mandate_id AS mandate_id_19,
  t0.mandate_date AS mandate_date_20,
  t0.offer_value AS offer_value_21,
  t0.societe_old_id AS societe_old_id_22,
  t0.tirelire AS tirelire_23,
  t0.abondement AS abondement_24,
  t0.subdomain AS subdomain_25,
  t0.color_primary AS color_primary_26,
  t0.color_secondary AS color_secondary_27,
  t0.contract_date AS contract_date_28,
  t0.date_abondement AS date_abondement_29,
  t0.bans AS bans_30,
  t0.bans_sg AS bans_sg_31,
  t0.card_price AS card_price_32,
  t0.wallet_id AS wallet_id_33,
  t0.start_contract AS start_contract_34,
  t0.contract_duration AS contract_duration_35,
  t0.renewal_year AS renewal_year_36,
  t0.months_notice AS months_notice_37,
  t0.date_cancellation AS date_cancellation_38,
  t0.theoretical_end_contract AS theoretical_end_contract_39,
  t0.end_contract_renewal AS end_contract_renewal_40,
  t0.date_request_cancellation AS date_request_cancellation_41,
  t0.benefeciary_id AS benefeciary_id_42,
  t0.offer_id AS offer_id_43,
  t0.salesperson_id AS salesperson_id_44,
  t0.departement_id AS departement_id_45,
  t46.id AS id_47,
  t46.bic AS bic_48,
  t46.iban AS iban_49,
  t46.company_id_id AS company_id_id_50,
  t0.debit_bank_id AS debit_bank_id_51
FROM
  company t0
  LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = 'developpement' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.platform AS platform_3,
  t0.parameters AS parameters_4
FROM
  customization t0
WHERE
  t0.label = ?
  AND t0.platform = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.platform AS platform_3, t0.parameters AS parameters_4 FROM customization t0 WHERE t0.label = 'banner' AND t0.platform = 'Web' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.description_home AS description_home_4,
  t0.link_video AS link_video_5,
  t0.image AS image_6,
  t0.image_group AS image_group_7,
  t0.position AS position_8,
  t0.reverse AS reverse_9,
  t0.slug AS slug_10,
  t0.display_home AS display_home_11
FROM
  solution t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_home AS description_home_4, t0.link_video AS link_video_5, t0.image AS image_6, t0.image_group AS image_group_7, t0.position AS position_8, t0.reverse AS reverse_9, t0.slug AS slug_10, t0.display_home AS display_home_11 FROM solution t0;