https://betaerp.laroutedeslangues.com/webhook/email/track

Query Metrics

11 Database Queries
6 Different statements
59.40 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.62 ms
(66.71%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.society_name AS society_name_3, t0.lastname AS lastname_4, t0.firstname AS firstname_5, t0.family_situation AS family_situation_6, t0.mobile_phone_number AS mobile_phone_number_7, t0.fix_phone_number AS fix_phone_number_8, t0.comment AS comment_9, t0.last_update_at AS last_update_at_10, t0.created_at AS created_at_11, t0.email AS email_12, t0.tax_code AS tax_code_13, t0.sdi_code AS sdi_code_14, t0.archived AS archived_15, t0.last_customer_update_at AS last_customer_update_at_16, t0.customer_id AS customer_id_17, t0.vat_number AS vat_number_18, t0.state AS state_19, t0.last_validated_at AS last_validated_at_20, t0.validated AS validated_21, t0.job AS job_22, t0.hubspot_id AS hubspot_id_23, t0.hubspot_matched AS hubspot_matched_24, t0.hubspot_email_added AS hubspot_email_added_25, t0.check_hubspot AS check_hubspot_26, t0.check_tags AS check_tags_27, t0.civility_id AS civility_id_28, t0.family_status_id AS family_status_id_29, t0.main_address_id AS main_address_id_30, t0.billing_address_id AS billing_address_id_31, t0.howknown_id AS howknown_id_32, t0.user_id AS user_id_33, t0.brand_id AS brand_id_34, t0.new_job_id AS new_job_id_35 FROM customer t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "[email protected]"
]
9.53 ms
(16.04%)
5
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.def AS def_3, t0.parameter_value AS parameter_value_4, t0.brand_id AS brand_id_5 FROM parameters t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "hubspot_stage_interested"
]
9.21 ms
(15.51%)
1
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.def AS def_2, p0_.parameter_value AS parameter_value_3, p0_.brand_id AS brand_id_4 FROM parameters p0_ WHERE p0_.parameter_key = ?
Parameters:
[
  "rdl_hubspot_access_token"
]
0.47 ms
(0.80%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3 FROM satisfaction_survey_rule t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "start"
]
0.30 ms
(0.50%)
1
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.def AS def_3, t0.parameter_value AS parameter_value_4, t0.brand_id AS brand_id_5 FROM parameters t0 WHERE t0.brand_id = ?
Parameters:
[
  1
]
0.26 ms
(0.44%)
1
SELECT b0_.id AS id_0, b0_.legal_name AS legal_name_1, b0_.name AS name_2, b0_.email AS email_3, b0_.color AS color_4, b0_.default_locale AS default_locale_5, b0_.updated_at AS updated_at_6, b0_.prefix AS prefix_7, b0_.domain AS domain_8, b0_.guestbook_token AS guestbook_token_9, b0_.last_minutes_enabled AS last_minutes_enabled_10, b0_.last_minutes_content AS last_minutes_content_11, b0_.last_minutes_link AS last_minutes_link_12, b0_.has_registration_form AS has_registration_form_13, b0_.logo_id AS logo_id_14, b0_.language_id AS language_id_15 FROM brand b0_ WHERE b0_.domain = ?
Parameters:
[
  "laroutedeslangues.com"
]

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\Brand No errors.
App\Entity\Media No errors.
App\Entity\Language No errors.
App\Entity\Parameters No errors.
App\Entity\Billing No errors.
App\Entity\Invoice No errors.
App\Entity\BrandCodeCompta No errors.
App\Entity\ProductCategoryRegistrationForm No errors.
App\Entity\LandingPage No errors.
App\Entity\Article No errors.
App\Entity\Brochure No errors.
App\Entity\Howknown No errors.
App\Entity\GeneralConditionOfSale No errors.
App\Entity\Faq No errors.
App\Entity\Webinar No errors.
App\Entity\GuestbookProgramCacheBrandParameter No errors.
App\Entity\DocumentHeaderFooterVersion No errors.
App\Entity\ProductProfile No errors.
App\Entity\CustomerEmailTemplate No errors.
App\Entity\Customer No errors.
App\Entity\Participant No errors.
App\Entity\ExchangeRateHistory No errors.
App\Entity\ProviderInvoice No errors.
App\Entity\ProductPeriod No errors.
App\Entity\ParticipantSibling No errors.
App\Entity\ParticipantSchoolEstablishment No errors.
App\Entity\Civility No errors.
App\Entity\FamilyStatus No errors.
App\Entity\Address No errors.
App\Entity\User No errors.
App\Entity\Job No errors.
App\Entity\ProductCategory No errors.
App\Entity\Option No errors.
App\Entity\Country No errors.
App\Entity\Exam No errors.
App\Entity\SatisfactionSurveyRule No errors.
App\Entity\SatisfactionSurveyRuleLine No errors.
App\Entity\Currency No errors.
App\Entity\GlobalFee No errors.
App\Entity\PricingDateSlot No errors.
App\Entity\Export No errors.