https://api-edenwork.dtv-projects.com/wm-api/catalogues/evasion/products?limit=200&page=4

Method
GET
HTTP Status
200
IP
149.202.56.9
Profiled on
Token
ed1226

Query Metrics

4 Database Queries
4 Different statements
6.71 ms Query time
4 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 2.34 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.created_at AS created_at_91, t0.updated_at AS updated_at_92, t0.country_id AS country_id_93, t0.main_account_user_id AS main_account_user_id_94, t0.godfather_id AS godfather_id_95, t0.regate_id AS regate_id_96, t0.commercial_id AS commercial_id_97, t0.heating_commercial_id AS heating_commercial_id_98, t0.agency_id AS agency_id_99, t100.id AS id_101, t100.code AS code_102, t100.name AS name_103, t100.region AS region_104, t100.manager_last_name AS manager_last_name_105, t100.manager_first_name AS manager_first_name_106, t100.address1 AS address1_107, t100.address2 AS address2_108, t100.post_code AS post_code_109, t100.city AS city_110, t100.phone AS phone_111, t0.programme_id AS programme_id_112, t0.sale_order_validation_id AS sale_order_validation_id_113, t0.billing_point_id AS billing_point_id_114, t0.request_registration_id AS request_registration_id_115, t0.subscription_id AS subscription_id_116, t0.point_of_sale_id AS point_of_sale_id_117, t118.id AS id_119, t118.code AS code_120, t118.name AS name_121, t118.city AS city_122, t118.enabled AS enabled_123, t118.created_by_id AS created_by_id_124, t118.address_id AS address_id_125, t0.point_conversion_rate_id AS point_conversion_rate_id_126, t0.responsable_regate_id AS responsable_regate_id_127, t0.coverage_area_id AS coverage_area_id_128, t0.activated_by_id AS activated_by_id_129 FROM user t0 LEFT JOIN agence t100 ON t0.agency_id = t100.id LEFT JOIN point_of_sale t118 ON t0.point_of_sale_id = t118.id WHERE t0.email = ? LIMIT 1
Parameters: 
[
  "super_admin@37deux.com"
]
View formatted query    View runnable query    Explain query
2 0.96 ms 
SELECT a0_.id AS id_0, a0_.concat_key AS concat_key_1, a0_.value AS value_2, a0_.env AS env_3, a0_.route AS route_4, a0_.params AS params_5, a0_.component AS component_6, a0_.slug AS slug_7, a0_.role AS role_8, a0_.action AS action_9, a0_.job AS job_10 FROM acl_setting a0_ WHERE a0_.concat_key LIKE ?
Parameters: 
[
  "%api_list_product.no-component.no-slug.%.ROLE_DEVELOPER.NaN"
]
View formatted query    View runnable query    Explain query
3 1.57 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.created_at AS created_at_91, t0.updated_at AS updated_at_92, t0.country_id AS country_id_93, t0.main_account_user_id AS main_account_user_id_94, t0.godfather_id AS godfather_id_95, t0.regate_id AS regate_id_96, t0.commercial_id AS commercial_id_97, t0.heating_commercial_id AS heating_commercial_id_98, t0.agency_id AS agency_id_99, t100.id AS id_101, t100.code AS code_102, t100.name AS name_103, t100.region AS region_104, t100.manager_last_name AS manager_last_name_105, t100.manager_first_name AS manager_first_name_106, t100.address1 AS address1_107, t100.address2 AS address2_108, t100.post_code AS post_code_109, t100.city AS city_110, t100.phone AS phone_111, t0.programme_id AS programme_id_112, t0.sale_order_validation_id AS sale_order_validation_id_113, t0.billing_point_id AS billing_point_id_114, t0.request_registration_id AS request_registration_id_115, t0.subscription_id AS subscription_id_116, t0.point_of_sale_id AS point_of_sale_id_117, t118.id AS id_119, t118.code AS code_120, t118.name AS name_121, t118.city AS city_122, t118.enabled AS enabled_123, t118.created_by_id AS created_by_id_124, t118.address_id AS address_id_125, t0.point_conversion_rate_id AS point_conversion_rate_id_126, t0.responsable_regate_id AS responsable_regate_id_127, t0.coverage_area_id AS coverage_area_id_128, t0.activated_by_id AS activated_by_id_129 FROM user t0 LEFT JOIN agence t100 ON t0.agency_id = t100.id LEFT JOIN point_of_sale t118 ON t0.point_of_sale_id = t118.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
4 1.84 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.created_at AS created_at_91, t0.updated_at AS updated_at_92, t0.country_id AS country_id_93, t0.main_account_user_id AS main_account_user_id_94, t0.godfather_id AS godfather_id_95, t0.regate_id AS regate_id_96, t0.commercial_id AS commercial_id_97, t0.heating_commercial_id AS heating_commercial_id_98, t0.agency_id AS agency_id_99, t100.id AS id_101, t100.code AS code_102, t100.name AS name_103, t100.region AS region_104, t100.manager_last_name AS manager_last_name_105, t100.manager_first_name AS manager_first_name_106, t100.address1 AS address1_107, t100.address2 AS address2_108, t100.post_code AS post_code_109, t100.city AS city_110, t100.phone AS phone_111, t0.programme_id AS programme_id_112, t0.sale_order_validation_id AS sale_order_validation_id_113, t0.billing_point_id AS billing_point_id_114, t0.request_registration_id AS request_registration_id_115, t0.subscription_id AS subscription_id_116, t0.point_of_sale_id AS point_of_sale_id_117, t118.id AS id_119, t118.code AS code_120, t118.name AS name_121, t118.city AS city_122, t118.enabled AS enabled_123, t118.created_by_id AS created_by_id_124, t118.address_id AS address_id_125, t0.point_conversion_rate_id AS point_conversion_rate_id_126, t0.responsable_regate_id AS responsable_regate_id_127, t0.coverage_area_id AS coverage_area_id_128, t0.activated_by_id AS activated_by_id_129 FROM user t0 LEFT JOIN agence t100 ON t0.agency_id = t100.id LEFT JOIN point_of_sale t118 ON t0.point_of_sale_id = t118.id WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
user_logs doctrine.dbal.user_logs_connection
dtv_blacklisted_emails doctrine.dbal.dtv_blacklisted_emails_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\Newsletter No errors.
App\Entity\ContactList
  • The field App\Entity\ContactList#smsSpotHitCampaigns is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SmsSpotHitCampaign#contactList does not contain the required 'inversedBy="smsSpotHitCampaigns"' attribute.
App\Entity\User No errors.
App\Entity\Country No errors.
App\Entity\Regate No errors.
App\Entity\Agence No errors.
App\Entity\Programme No errors.
App\Entity\SaleOrderValidation No errors.
App\Entity\BillingPoint No errors.
App\Entity\RequestRegistration No errors.
App\Entity\UserSubscription No errors.
App\Entity\PointOfSale No errors.
App\Entity\PointOfSaleAddress No errors.
App\Entity\PointConversionRate No errors.
App\Entity\CoverageArea No errors.
App\Entity\Address No errors.
App\Entity\Cart No errors.
App\Entity\Distributor No errors.
App\Entity\Purchase No errors.
App\Entity\SaleOrder
  • The field 'App\Entity\SaleOrder#total' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Satisfaction No errors.
App\Entity\RequestProductAvailable No errors.
App\Entity\UserImportHistory No errors.
App\Entity\Devis No errors.
App\Entity\PointTransaction
  • The association App\Entity\PointTransaction#saleOrderItem refers to the inverse side field App\Entity\SaleOrderItem#pointTransaction which does not exist.
App\Entity\UserBusinessResult No errors.
App\Entity\Project No errors.
App\Entity\ServiceUser No errors.
App\Entity\Univers No errors.
App\Entity\Score No errors.
App\Entity\ScoreObjective No errors.
App\Entity\Message No errors.
App\Entity\CustomProductOrder No errors.
App\Entity\CustomProduct
  • The mappings App\Entity\CustomProduct#quotaProductJobs and App\Entity\QuotaProductJob#customProduct are inconsistent with each other.
App\Entity\UserExtension No errors.
App\Entity\Parameter No errors.
App\Entity\QuizUserAnswer No errors.
App\Entity\IdeaBoxAnswer No errors.
App\Entity\IdeaBoxRating No errors.
App\Entity\IdeaBoxRecipient No errors.
App\Entity\ActionLog No errors.
App\Entity\PasswordHistory No errors.
App\Entity\UserFavorites No errors.
App\Entity\BoosterProductResult No errors.
App\Entity\PushSubscription No errors.
App\Entity\AzureGroup No errors.
App\Entity\QuotaProductUser No errors.
App\Entity\RankingScore No errors.
App\Entity\AclSetting No errors.