Query Metrics
34
Database Queries
16
Different statements
135.06 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108.00 ms (79.96%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
5.84 ms (4.33%) |
2 |
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
Parameters:
[
"developpement"
]
|
||||||||||||||||||||||||||||
5.16 ms (3.82%) |
12 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM bootstrap_icons t0 WHERE t0.id = ?
Parameters:
[
1929
]
|
||||||||||||||||||||||||||||
4.65 ms (3.44%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
3.07 ms (2.27%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"BREVO_API_KEY"
]
|
||||||||||||||||||||||||||||
1.45 ms (1.07%) |
2 |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.url AS url_3, t0.active AS active_4, t0.position AS position_5 FROM social_media t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
0.89 ms (0.66%) |
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 = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
0.85 ms (0.63%) |
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
Parameters:
[ "banner" "Web" ] |
||||||||||||||||||||||||||||
0.85 ms (0.63%) |
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
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
0.75 ms (0.56%) |
1 |
SELECT COUNT(r0_.id) AS sclr_0 FROM reducce_articles r0_
Parameters:
[]
|
||||||||||||||||||||||||||||
0.74 ms (0.54%) |
1 |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
0.66 ms (0.49%) |
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
Parameters:
[] |
||||||||||||||||||||||||||||
0.65 ms (0.48%) |
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 ORDER BY t0.position ASC
Parameters:
[] |
||||||||||||||||||||||||||||
0.59 ms (0.44%) |
1 |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
0.49 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.icon_id AS icon_id_3 FROM avantages_cse_home t0
Parameters:
[]
|
||||||||||||||||||||||||||||
0.42 ms (0.31%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.icon_id AS icon_id_3 FROM avantages_dirigeant_home t0
Parameters:
[]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.