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

Query Metrics

15 Database Queries
5 Different statements
4.17 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.18 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.email AS email_2, b0_.color AS color_3, b0_.updated_at AS updated_at_4, b0_.prefix AS prefix_5, b0_.domain AS domain_6, b0_.last_minutes_enabled AS last_minutes_enabled_7, b0_.last_minutes_content AS last_minutes_content_8, b0_.last_minutes_link AS last_minutes_link_9, b0_.has_registration_form AS has_registration_form_10, b0_.seller AS seller_11, b0_.public_brand AS public_brand_12, l1_.id AS id_13, l1_.name AS name_14, l1_.name_it AS name_it_15, l1_.slug AS slug_16, l1_.active AS active_17, l1_.priority AS priority_18, l1_.alpha2 AS alpha2_19, p2_.id AS id_20, p2_.parameter_key AS parameter_key_21, p2_.def AS def_22, p2_.parameter_value AS parameter_value_23, p2_.parameter_write_granted AS parameter_write_granted_24, b0_.logo_id AS logo_id_25, b0_.language_id AS language_id_26, p2_.brand_id AS brand_id_27 FROM brand b0_ LEFT JOIN language l1_ ON b0_.language_id = l1_.id LEFT JOIN parameters p2_ ON b0_.id = p2_.brand_id WHERE b0_.domain = ?
Parameters:
[
  "laroutedeslangues.com"
]
2 0.35 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  118
]
3 0.35 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.26 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_.parameter_write_granted AS parameter_write_granted_4, p0_.brand_id AS brand_id_5 FROM parameters p0_ WHERE p0_.parameter_key = ?
Parameters:
[
  "rdl_hubspot_access_token"
]
5 0.20 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  74
]
6 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.parameter_write_granted AS parameter_write_granted_5, t0.brand_id AS brand_id_6 FROM parameters t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "hubspot_stage_interested"
]
7 0.17 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  183
]
8 0.16 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.parameter_write_granted AS parameter_write_granted_5, t0.brand_id AS brand_id_6 FROM parameters t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "hubspot_stage_educated"
]
9 0.16 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  184
]
10 0.15 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.parameter_write_granted AS parameter_write_granted_5, t0.brand_id AS brand_id_6 FROM parameters t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "hubspot_stage_commited"
]
11 0.15 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  185
]
12 0.21 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.parameter_write_granted AS parameter_write_granted_5, t0.brand_id AS brand_id_6 FROM parameters t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "hubspot_stage_won_canceled"
]
13 0.22 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  186
]
14 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.parameter_write_granted AS parameter_write_granted_5, t0.brand_id AS brand_id_6 FROM parameters t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "hubspot_stage_scholarship"
]
15 0.16 ms
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  202
]

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.