Query Metrics
11
Database Queries
6
Different statements
59.40 ms
Query time
0
Invalid entities
Grouped Statements
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. |