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

Query Metrics

9 Database Queries
5 Different statements
2.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 ms
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_.updated_at AS updated_at_5, b0_.prefix AS prefix_6, b0_.domain AS domain_7, b0_.guestbook_token AS guestbook_token_8, b0_.last_minutes_enabled AS last_minutes_enabled_9, b0_.last_minutes_content AS last_minutes_content_10, b0_.last_minutes_link AS last_minutes_link_11, b0_.has_registration_form AS has_registration_form_12, b0_.logo_id AS logo_id_13, b0_.language_id AS language_id_14 FROM brand b0_ WHERE b0_.domain = ?
Parameters:
[
  "laroutedeslangues.com"
]
2 0.36 ms
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
]
3 0.46 ms
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.original_how_known AS original_how_known_9, t0.comment AS comment_10, t0.last_update_at AS last_update_at_11, t0.created_at AS created_at_12, t0.email AS email_13, t0.tax_code AS tax_code_14, t0.sdi_code AS sdi_code_15, t0.archived AS archived_16, t0.last_customer_update_at AS last_customer_update_at_17, t0.customer_id AS customer_id_18, t0.vat_number AS vat_number_19, t0.state AS state_20, t0.last_validated_at AS last_validated_at_21, t0.validated AS validated_22, t0.job AS job_23, t0.hubspot_id AS hubspot_id_24, t0.hubspot_matched AS hubspot_matched_25, t0.hubspot_email_added AS hubspot_email_added_26, t0.check_hubspot AS check_hubspot_27, t0.check_tags AS check_tags_28, t0.civility_id AS civility_id_29, t0.family_status_id AS family_status_id_30, t0.main_address_id AS main_address_id_31, t0.billing_address_id AS billing_address_id_32, t0.howknown_id AS howknown_id_33, t0.user_id AS user_id_34, t0.brand_id AS brand_id_35, t0.new_job_id AS new_job_id_36 FROM customer t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "[email protected]"
]
4 0.28 ms
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"
]
5 0.26 ms
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"
]
6 0.20 ms
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_educated"
]
7 0.20 ms
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_commited"
]
8 0.17 ms
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_won_canceled"
]
9 0.19 ms
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_scholarship"
]

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\File 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\Currency No errors.
App\Entity\GlobalFee No errors.
App\Entity\PricingDateSlot No errors.
App\Entity\Export No errors.