GET https://developpement.amhappy.fr/

Query Metrics

34 Database Queries
16 Different statements
135.06 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

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.

Entities Mapping

Class Mapping errors
App\Entity\Configuration No errors.
App\Entity\PartnerHome No errors.
App\Entity\Company No errors.
App\Entity\Offer No errors.
App\Entity\User No errors.
App\Entity\Maps\Notification\Departement No errors.
App\Entity\CompanyTreezorWallet No errors.
App\Entity\Finance\DebitBank No errors.
App\Entity\ArticleBlog No errors.
App\Entity\BlockArticle No errors.
App\Entity\AvantagesHome No errors.
App\Entity\BootstrapIcons No errors.
App\Entity\AvantagesCseHome No errors.
App\Entity\RHToolsHome No errors.
App\Entity\AvantagesDirigeantHome No errors.
App\Entity\Cagnotte No errors.
App\Entity\Famille\Famille No errors.
App\Entity\UserAdresse No errors.
App\Entity\Card No errors.
App\Entity\Analytics\AnalyticsPermissions No errors.
App\Entity\MailProgrammation No errors.
App\Entity\UserCompany No errors.
App\Entity\UserTreezor No errors.
App\Entity\Famille\FamilleMembre No errors.
App\Entity\Log\LogsDirigeant No errors.
App\Entity\Refund\RefundRequest No errors.
App\Entity\Salarie\IbanChange No errors.
App\Entity\Log\LogsAdmin No errors.
App\Entity\Emails\EmailList No errors.
App\Entity\Company\CompanyTaxFile No errors.
App\Entity\Order\Order No errors.
App\Entity\Notifications\NotificationsUser No errors.
App\Entity\CagnotteRequest No errors.
App\Entity\CompanyUserStatus No errors.
App\Entity\CompanyAbondementExceptionnel No errors.
App\Entity\CompanyAbondement No errors.
App\Entity\ReducCe\ProductRequest No errors.
App\Entity\Company\CompanyHistoryOs No errors.
App\Entity\Reminder No errors.
App\Entity\Treezor\HistoryApiException No errors.
App\Entity\Treezor\HistoryWebHookId No errors.
App\Entity\Treezor\TreezorTransfert
  • The mappings App\Entity\Treezor\TreezorTransfert#creditedWallet and App\Entity\CompanyTreezorWallet#treezorTransferts are inconsistent with each other.
App\Entity\UserTreezorCard No errors.
App\Entity\UpdateTreezor No errors.
App\Entity\TreezorOrderCard No errors.
App\Entity\Refund\RefundActivity No errors.
App\Entity\Article No errors.
App\Entity\SharedPdf No errors.
App\Entity\Company\IbanCompanyChange No errors.
App\Entity\AdditionalProduct\AdditionalProductOrder No errors.
App\Entity\Company\OfferRulesCompany No errors.
App\Entity\TreezorDeliveryDetails No errors.
App\Entity\ReducCe\Articles No errors.
App\Entity\Configuration\Customization No errors.
App\Entity\Solutions\Solution No errors.
App\Entity\Solutions\BlockSolution No errors.
App\Entity\Configuration\SocialMedia No errors.
App\Entity\Maps\Notification\Region No errors.
App\Entity\CompanyRoles No errors.
App\Entity\Famille\FamilleRole No errors.
App\Entity\Refund\RefundTransfer No errors.
App\Entity\Refund\RefundReasonRefusal No errors.
App\Entity\Salarie\IbanChangeReasonRefusal No errors.
App\Entity\Order\OrderDetail No errors.
App\Entity\Order\OrderHistory No errors.
App\Entity\Order\OrderState No errors.
App\Entity\Order\OrderTreezorDetail No errors.
App\Entity\Notifications\Notifications No errors.
App\Entity\CagnotteTransfer No errors.
App\Entity\ReducCe\SousGenres
  • The association App\Entity\ReducCe\SousGenres#commercial refers to the inverse side field App\Entity\User#sousGenres which does not exist.
App\Entity\Configuration\Activity No errors.
App\Entity\AdditionalProduct\AdditionalProduct No errors.
App\Entity\Company\OfferRulesLabel No errors.
App\Entity\ReducCe\ArticlesTarifs No errors.
App\Entity\ReducCe\Lieux No errors.
App\Entity\ReducCe\Catalogues No errors.