Symfony Profiler

Query Metrics

18 Database Queries

10 Different statements

16.75 ms Query time

12 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements


SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c0_.customer_group_id AS customer_group_id_27, c0_.user_id AS user_id_28, c0_.vendor_id AS vendor_id_29, c0_.city_region_id AS city_region_id_30, c0_.store_id AS store_id_31 FROM customer c0_ WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL)
SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.name AS name_29, c1_.code AS code_30, s2_.id AS id_31, s2_.name AS name_32, s2_.description AS description_33, s2_.code AS code_34, s2_.is_enabled AS is_enabled_35, s2_.created_at AS created_at_36, s2_.processing_duration AS processing_duration_37, s2_.preparation_duration AS preparation_duration_38, s2_.shipping_duration AS shipping_duration_39, s2_.price AS price_40, s2_.is_separately_calculated AS is_separately_calculated_41, s2_.calculation_method AS calculation_method_42, s2_.declared_value_tax AS declared_value_tax_43, s2_.papers_fees AS papers_fees_44, s2_.cod_cash_fees AS cod_cash_fees_45, s2_.cod_check_or_bill_fees AS cod_check_or_bill_fees_46, s2_.is_taxes_included_in_price AS is_taxes_included_in_price_47, s2_.deleted_at AS deleted_at_48, u3_.id AS id_49, u3_.username AS username_50, u3_.roles AS roles_51, u3_.password AS password_52, u3_.is_valid AS is_valid_53, u3_.is_verified AS is_verified_54, u3_.exponent_push_token AS exponent_push_token_55, u3_.google_id AS google_id_56, u3_.avatar AS avatar_57, u3_.facebook_id AS facebook_id_58, c4_.id AS id_59, c4_.name AS name_60, c4_.description AS description_61, c4_.is_default AS is_default_62, c4_.is_active AS is_active_63, c4_.color AS color_64, c4_.type AS type_65, c4_.zip_code AS zip_code_66, c4_.region_code AS region_code_67, c4_.lng AS lng_68, c4_.lat AS lat_69, AsBinary(c4_.geo_json) AS geo_json_70, c4_.meta_data AS meta_data_71, p5_.id AS id_72, p5_.start_at AS start_at_73, p5_.end_at AS end_at_74, p5_.description AS description_75, p5_.status AS status_76, p5_.created_at AS created_at_77, s6_.id AS id_78, s6_.name AS name_79, s6_.created_at AS created_at_80, s6_.description AS description_81, s6_.store_type AS store_type_82, s6_.deleted_at AS deleted_at_83, c7_.id AS id_84, c7_.subject AS subject_85, c7_.message AS message_86, c7_.created_at AS created_at_87, c7_.status AS status_88, c0_.customer_group_id AS customer_group_id_89, c0_.user_id AS user_id_90, c0_.vendor_id AS vendor_id_91, c0_.city_region_id AS city_region_id_92, c0_.store_id AS store_id_93, s2_.shipping_vehicle_type_id AS shipping_vehicle_type_id_94, s2_.customer_group_id AS customer_group_id_95, s2_.tax_vat_id AS tax_vat_id_96, s2_.shipping_tax_id AS shipping_tax_id_97, c4_.city_id AS city_id_98, c4_.vendor_id AS vendor_id_99, p5_.product_id AS product_id_100, p5_.customer_id AS customer_id_101, p5_.related_order_id AS related_order_id_102, s6_.city_id AS city_id_103, s6_.user_id AS user_id_104, s6_.city_region_id AS city_region_id_105, c7_.customer_id AS customer_id_106, c7_.complaint_subject_id AS complaint_subject_id_107, c7_.agent_id AS agent_id_108 FROM customer c0_ LEFT JOIN customer_group c1_ ON c0_.customer_group_id = c1_.id LEFT JOIN shipping_method s2_ ON c1_.id = s2_.customer_group_id AND (s2_.deleted_at IS NULL) LEFT JOIN user u3_ ON c0_.user_id = u3_.id LEFT JOIN city_region c4_ ON c0_.city_region_id = c4_.id LEFT JOIN product_subscription p5_ ON c0_.id = p5_.customer_id LEFT JOIN store s6_ ON c0_.store_id = s6_.id AND (s6_.deleted_at IS NULL) LEFT JOIN complaint c7_ ON c0_.id = c7_.customer_id WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL)
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'gebcloud_ilaveu' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	0.73 ms	SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c0_.customer_group_id AS customer_group_id_27, c0_.user_id AS user_id_28, c0_.vendor_id AS vendor_id_29, c0_.city_region_id AS city_region_id_30, c0_.store_id AS store_id_31 FROM customer c0_ WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL) Parameters: [`0`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c0_.customer_group_id AS customer_group_id_27, c0_.user_id AS user_id_28, c0_.vendor_id AS vendor_id_29, c0_.city_region_id AS city_region_id_30, c0_.store_id AS store_id_31 FROM customer c0_ WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL) SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c0_.customer_group_id AS customer_group_id_27, c0_.user_id AS user_id_28, c0_.vendor_id AS vendor_id_29, c0_.city_region_id AS city_region_id_30, c0_.store_id AS store_id_31 FROM customer c0_ WHERE (c0_.id = 0) AND (c0_.deleted_at IS NULL);
2	1.01 ms	SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.name AS name_29, c1_.code AS code_30, s2_.id AS id_31, s2_.name AS name_32, s2_.description AS description_33, s2_.code AS code_34, s2_.is_enabled AS is_enabled_35, s2_.created_at AS created_at_36, s2_.processing_duration AS processing_duration_37, s2_.preparation_duration AS preparation_duration_38, s2_.shipping_duration AS shipping_duration_39, s2_.price AS price_40, s2_.is_separately_calculated AS is_separately_calculated_41, s2_.calculation_method AS calculation_method_42, s2_.declared_value_tax AS declared_value_tax_43, s2_.papers_fees AS papers_fees_44, s2_.cod_cash_fees AS cod_cash_fees_45, s2_.cod_check_or_bill_fees AS cod_check_or_bill_fees_46, s2_.is_taxes_included_in_price AS is_taxes_included_in_price_47, s2_.deleted_at AS deleted_at_48, u3_.id AS id_49, u3_.username AS username_50, u3_.roles AS roles_51, u3_.password AS password_52, u3_.is_valid AS is_valid_53, u3_.is_verified AS is_verified_54, u3_.exponent_push_token AS exponent_push_token_55, u3_.google_id AS google_id_56, u3_.avatar AS avatar_57, u3_.facebook_id AS facebook_id_58, c4_.id AS id_59, c4_.name AS name_60, c4_.description AS description_61, c4_.is_default AS is_default_62, c4_.is_active AS is_active_63, c4_.color AS color_64, c4_.type AS type_65, c4_.zip_code AS zip_code_66, c4_.region_code AS region_code_67, c4_.lng AS lng_68, c4_.lat AS lat_69, AsBinary(c4_.geo_json) AS geo_json_70, c4_.meta_data AS meta_data_71, p5_.id AS id_72, p5_.start_at AS start_at_73, p5_.end_at AS end_at_74, p5_.description AS description_75, p5_.status AS status_76, p5_.created_at AS created_at_77, s6_.id AS id_78, s6_.name AS name_79, s6_.created_at AS created_at_80, s6_.description AS description_81, s6_.store_type AS store_type_82, s6_.deleted_at AS deleted_at_83, c7_.id AS id_84, c7_.subject AS subject_85, c7_.message AS message_86, c7_.created_at AS created_at_87, c7_.status AS status_88, c0_.customer_group_id AS customer_group_id_89, c0_.user_id AS user_id_90, c0_.vendor_id AS vendor_id_91, c0_.city_region_id AS city_region_id_92, c0_.store_id AS store_id_93, s2_.shipping_vehicle_type_id AS shipping_vehicle_type_id_94, s2_.customer_group_id AS customer_group_id_95, s2_.tax_vat_id AS tax_vat_id_96, s2_.shipping_tax_id AS shipping_tax_id_97, c4_.city_id AS city_id_98, c4_.vendor_id AS vendor_id_99, p5_.product_id AS product_id_100, p5_.customer_id AS customer_id_101, p5_.related_order_id AS related_order_id_102, s6_.city_id AS city_id_103, s6_.user_id AS user_id_104, s6_.city_region_id AS city_region_id_105, c7_.customer_id AS customer_id_106, c7_.complaint_subject_id AS complaint_subject_id_107, c7_.agent_id AS agent_id_108 FROM customer c0_ LEFT JOIN customer_group c1_ ON c0_.customer_group_id = c1_.id LEFT JOIN shipping_method s2_ ON c1_.id = s2_.customer_group_id AND (s2_.deleted_at IS NULL) LEFT JOIN user u3_ ON c0_.user_id = u3_.id LEFT JOIN city_region c4_ ON c0_.city_region_id = c4_.id LEFT JOIN product_subscription p5_ ON c0_.id = p5_.customer_id LEFT JOIN store s6_ ON c0_.store_id = s6_.id AND (s6_.deleted_at IS NULL) LEFT JOIN complaint c7_ ON c0_.id = c7_.customer_id WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL) Parameters: [`0`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.name AS name_29, c1_.code AS code_30, s2_.id AS id_31, s2_.name AS name_32, s2_.description AS description_33, s2_.code AS code_34, s2_.is_enabled AS is_enabled_35, s2_.created_at AS created_at_36, s2_.processing_duration AS processing_duration_37, s2_.preparation_duration AS preparation_duration_38, s2_.shipping_duration AS shipping_duration_39, s2_.price AS price_40, s2_.is_separately_calculated AS is_separately_calculated_41, s2_.calculation_method AS calculation_method_42, s2_.declared_value_tax AS declared_value_tax_43, s2_.papers_fees AS papers_fees_44, s2_.cod_cash_fees AS cod_cash_fees_45, s2_.cod_check_or_bill_fees AS cod_check_or_bill_fees_46, s2_.is_taxes_included_in_price AS is_taxes_included_in_price_47, s2_.deleted_at AS deleted_at_48, u3_.id AS id_49, u3_.username AS username_50, u3_.roles AS roles_51, u3_.password AS password_52, u3_.is_valid AS is_valid_53, u3_.is_verified AS is_verified_54, u3_.exponent_push_token AS exponent_push_token_55, u3_.google_id AS google_id_56, u3_.avatar AS avatar_57, u3_.facebook_id AS facebook_id_58, c4_.id AS id_59, c4_.name AS name_60, c4_.description AS description_61, c4_.is_default AS is_default_62, c4_.is_active AS is_active_63, c4_.color AS color_64, c4_.type AS type_65, c4_.zip_code AS zip_code_66, c4_.region_code AS region_code_67, c4_.lng AS lng_68, c4_.lat AS lat_69, AsBinary(c4_.geo_json) AS geo_json_70, c4_.meta_data AS meta_data_71, p5_.id AS id_72, p5_.start_at AS start_at_73, p5_.end_at AS end_at_74, p5_.description AS description_75, p5_.status AS status_76, p5_.created_at AS created_at_77, s6_.id AS id_78, s6_.name AS name_79, s6_.created_at AS created_at_80, s6_.description AS description_81, s6_.store_type AS store_type_82, s6_.deleted_at AS deleted_at_83, c7_.id AS id_84, c7_.subject AS subject_85, c7_.message AS message_86, c7_.created_at AS created_at_87, c7_.status AS status_88, c0_.customer_group_id AS customer_group_id_89, c0_.user_id AS user_id_90, c0_.vendor_id AS vendor_id_91, c0_.city_region_id AS city_region_id_92, c0_.store_id AS store_id_93, s2_.shipping_vehicle_type_id AS shipping_vehicle_type_id_94, s2_.customer_group_id AS customer_group_id_95, s2_.tax_vat_id AS tax_vat_id_96, s2_.shipping_tax_id AS shipping_tax_id_97, c4_.city_id AS city_id_98, c4_.vendor_id AS vendor_id_99, p5_.product_id AS product_id_100, p5_.customer_id AS customer_id_101, p5_.related_order_id AS related_order_id_102, s6_.city_id AS city_id_103, s6_.user_id AS user_id_104, s6_.city_region_id AS city_region_id_105, c7_.customer_id AS customer_id_106, c7_.complaint_subject_id AS complaint_subject_id_107, c7_.agent_id AS agent_id_108 FROM customer c0_ LEFT JOIN customer_group c1_ ON c0_.customer_group_id = c1_.id LEFT JOIN shipping_method s2_ ON c1_.id = s2_.customer_group_id AND (s2_.deleted_at IS NULL) LEFT JOIN user u3_ ON c0_.user_id = u3_.id LEFT JOIN city_region c4_ ON c0_.city_region_id = c4_.id LEFT JOIN product_subscription p5_ ON c0_.id = p5_.customer_id LEFT JOIN store s6_ ON c0_.store_id = s6_.id AND (s6_.deleted_at IS NULL) LEFT JOIN complaint c7_ ON c0_.id = c7_.customer_id WHERE (c0_.id = ?) AND (c0_.deleted_at IS NULL) SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.name AS name_29, c1_.code AS code_30, s2_.id AS id_31, s2_.name AS name_32, s2_.description AS description_33, s2_.code AS code_34, s2_.is_enabled AS is_enabled_35, s2_.created_at AS created_at_36, s2_.processing_duration AS processing_duration_37, s2_.preparation_duration AS preparation_duration_38, s2_.shipping_duration AS shipping_duration_39, s2_.price AS price_40, s2_.is_separately_calculated AS is_separately_calculated_41, s2_.calculation_method AS calculation_method_42, s2_.declared_value_tax AS declared_value_tax_43, s2_.papers_fees AS papers_fees_44, s2_.cod_cash_fees AS cod_cash_fees_45, s2_.cod_check_or_bill_fees AS cod_check_or_bill_fees_46, s2_.is_taxes_included_in_price AS is_taxes_included_in_price_47, s2_.deleted_at AS deleted_at_48, u3_.id AS id_49, u3_.username AS username_50, u3_.roles AS roles_51, u3_.password AS password_52, u3_.is_valid AS is_valid_53, u3_.is_verified AS is_verified_54, u3_.exponent_push_token AS exponent_push_token_55, u3_.google_id AS google_id_56, u3_.avatar AS avatar_57, u3_.facebook_id AS facebook_id_58, c4_.id AS id_59, c4_.name AS name_60, c4_.description AS description_61, c4_.is_default AS is_default_62, c4_.is_active AS is_active_63, c4_.color AS color_64, c4_.type AS type_65, c4_.zip_code AS zip_code_66, c4_.region_code AS region_code_67, c4_.lng AS lng_68, c4_.lat AS lat_69, AsBinary(c4_.geo_json) AS geo_json_70, c4_.meta_data AS meta_data_71, p5_.id AS id_72, p5_.start_at AS start_at_73, p5_.end_at AS end_at_74, p5_.description AS description_75, p5_.status AS status_76, p5_.created_at AS created_at_77, s6_.id AS id_78, s6_.name AS name_79, s6_.created_at AS created_at_80, s6_.description AS description_81, s6_.store_type AS store_type_82, s6_.deleted_at AS deleted_at_83, c7_.id AS id_84, c7_.subject AS subject_85, c7_.message AS message_86, c7_.created_at AS created_at_87, c7_.status AS status_88, c0_.customer_group_id AS customer_group_id_89, c0_.user_id AS user_id_90, c0_.vendor_id AS vendor_id_91, c0_.city_region_id AS city_region_id_92, c0_.store_id AS store_id_93, s2_.shipping_vehicle_type_id AS shipping_vehicle_type_id_94, s2_.customer_group_id AS customer_group_id_95, s2_.tax_vat_id AS tax_vat_id_96, s2_.shipping_tax_id AS shipping_tax_id_97, c4_.city_id AS city_id_98, c4_.vendor_id AS vendor_id_99, p5_.product_id AS product_id_100, p5_.customer_id AS customer_id_101, p5_.related_order_id AS related_order_id_102, s6_.city_id AS city_id_103, s6_.user_id AS user_id_104, s6_.city_region_id AS city_region_id_105, c7_.customer_id AS customer_id_106, c7_.complaint_subject_id AS complaint_subject_id_107, c7_.agent_id AS agent_id_108 FROM customer c0_ LEFT JOIN customer_group c1_ ON c0_.customer_group_id = c1_.id LEFT JOIN shipping_method s2_ ON c1_.id = s2_.customer_group_id AND (s2_.deleted_at IS NULL) LEFT JOIN user u3_ ON c0_.user_id = u3_.id LEFT JOIN city_region c4_ ON c0_.city_region_id = c4_.id LEFT JOIN product_subscription p5_ ON c0_.id = p5_.customer_id LEFT JOIN store s6_ ON c0_.store_id = s6_.id AND (s6_.deleted_at IS NULL) LEFT JOIN complaint c7_ ON c0_.id = c7_.customer_id WHERE (c0_.id = 0) AND (c0_.deleted_at IS NULL);
3	0.40 ms	SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"main"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;
4	0.49 ms	SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"main"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;
5	0.38 ms	SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"main"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;
6	0.22 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
7	2.58 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"gebcloud_ilaveu"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'gebcloud_ilaveu' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
8	0.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
9	2.39 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"gebcloud_ilaveu"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'gebcloud_ilaveu' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
10	0.20 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
11	1.48 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"gebcloud_ilaveu" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'gebcloud_ilaveu' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
12	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
13	2.34 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'gebcloud_ilaveu' / ORDER BY k.ORDINAL_POSITION Parameters: [`"gebcloud_ilaveu" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'gebcloud_ilaveu' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'gebcloud_ilaveu' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'gebcloud_ilaveu' / ORDER BY k.ORDINAL_POSITION;
14	2.41 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"gebcloud_ilaveu" "gebcloud_ilaveu" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'gebcloud_ilaveu' AND t.TABLE_SCHEMA = 'gebcloud_ilaveu' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
15	0.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
16	1.14 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"gebcloud_ilaveu" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'gebcloud_ilaveu' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
17	0.31 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
18	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
App\Flexy\ShopBundle\Entity\Customer\Customer	No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerGroup	No errors.
App\Entity\User	No errors.
App\Flexy\ShopBundle\Entity\Vendor\Vendor	No errors.
App\Flexy\ShopBundle\Entity\Shipping\CityRegion	The association App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders refers to the owning side field App\Flexy\ShopBundle\Entity\Order\Order#cityRegion which does not exist. The association App\Flexy\ShopBundle\Entity\Shipping\CityRegion#stores refers to the owning side field App\Flexy\ShopBundle\Entity\Store\Store#�cityRegion which does not exist.
App\Flexy\ShopBundle\Entity\Store\Store	The mappings App\Flexy\ShopBundle\Entity\Store\Store#cityRegion and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#stores are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Shipping\ShippingMethod	No errors.
App\Flexy\ShopBundle\Entity\Product\ProductSubscription	No errors.
App\Flexy\ShopBundle\Entity\Customer\Complaint	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\ShippingVehicleType	No errors.
App\Flexy\ShopBundle\Entity\Taxes\ValueAddedTax	No errors.
App\Flexy\ShopBundle\Entity\Taxes\ShippingTax	No errors.
App\Flexy\ShopBundle\Entity\Shipping\City	No errors.
App\Flexy\ShopBundle\Entity\Product\Product	The mappings App\Flexy\ShopBundle\Entity\Product\Product#childrenProductsPack and App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Order\Order	The mappings App\Flexy\ShopBundle\Entity\Order\Order#cityRegionShipping and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Customer\ComplaintSubject	No errors.
App\Flexy\ShopBundle\Entity\Resource\Agent	No errors.
App\Entity\Settings	No errors.
App\Entity\FrontTheme	No errors.
App\Entity\WebsiteTheme	No errors.
App\Flexy\ShopBundle\Entity\Product\Comment	No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerAddress	No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint	The mappings App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint#originInvoice and App\Flexy\ShopBundle\Entity\Accounting\Invoice#customerWalletPoints are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Customer\PackEngagement	No errors.
App\Flexy\ShopBundle\Entity\Promotion\Coupon	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Shipment	No errors.
App\Flexy\ShopBundle\Entity\Payment\BankBookItem	No errors.
App\Flexy\ShopBundle\Entity\Shipping\CashOnDelivery	No errors.
App\Flexy\ShopBundle\Entity\Accounting\Invoice	The association App\Flexy\ShopBundle\Entity\Accounting\Invoice#customerWalletPoints refers to the owning side field App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint#invoice which does not exist.
App\Entity\Role	No errors.
App\Entity\AiRequest	No errors.
App\Flexy\ShopBundle\Entity\Product\ImportExcel	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShipmentItem	No errors.
App\Flexy\ShopBundle\Entity\Shipping\CashBox	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShippingRule	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShippingCalculationMethod	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Country	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\ShippingVehicle	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Departement	No errors.
App\Flexy\ShopBundle\Entity\Shipping\StepType	No errors.
App\Flexy\ShopBundle\Entity\Product\CategoryProduct	No errors.
App\Flexy\ShopBundle\Entity\Product\AttributValue	No errors.
App\Flexy\ShopBundle\Entity\Product\ImageProduct	No errors.
App\Flexy\ShopBundle\Entity\Product\ProductVariant	No errors.
App\Flexy\ShopBundle\Entity\Order\OrderItem	No errors.
App\Flexy\ShopBundle\Entity\Promotion\Promotion	No errors.
App\Flexy\ShopBundle\Entity\Brand	No errors.
App\Flexy\ShopBundle\Entity\Product\ProductPack	The association App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct refers to the inverse side field App\Flexy\ShopBundle\Entity\Product\Product#childrenPackProducts which does not exist.
App\Flexy\ShopBundle\Entity\Payment\PaymentMethod	No errors.
App\Flexy\ShopBundle\Entity\Order\Adjustment	No errors.
App\Flexy\ShopBundle\Entity\Order\DemandeFund	No errors.
App\Flexy\ShopBundle\Entity\Resource\AgentType	No errors.
App\Entity\LinkType	No errors.
App\Entity\CurrencyExchangeRate	No errors.
App\Entity\LogHistory	No errors.
App\Entity\Notification	No errors.
App\Entity\ThreadAiRequest	No errors.
App\Entity\Link	No errors.
App\Entity\ExportExcel	No errors.
App\Entity\Application	No errors.
App\Entity\Image	No errors.
App\Entity\ResetPasswordRequest	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Flexy\Apps\POSBundle\Entity\Caisse	No errors.
App\Flexy\Apps\POSBundle\Entity\Table	No errors.
App\Flexy\Apps\StockBundle\Entity\Stock	No errors.
App\Flexy\Apps\StockBundle\Entity\Document	The mappings App\Flexy\Apps\StockBundle\Entity\Document#cityRegionShipping and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders are inconsistent with each other.
App\Flexy\Apps\StockBundle\Entity\Article	The mappings App\Flexy\Apps\StockBundle\Entity\Article#childrenProductsPack and App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct are inconsistent with each other.
App\Flexy\FrontBundle\Entity\Slide	No errors.
App\Flexy\FrontBundle\Entity\Menu	No errors.
App\Flexy\FrontBundle\Entity\Form	The mappings App\Flexy\FrontBundle\Entity\Form#formDatas and App\Flexy\FrontBundle\Entity\FormField#form are inconsistent with each other.
App\Flexy\FrontBundle\Entity\MenuItem	No errors.
App\Flexy\FrontBundle\Entity\CategoryPage	No errors.
App\Flexy\FrontBundle\Entity\MasterSlider	No errors.
App\Flexy\FrontBundle\Entity\Section	No errors.
App\Flexy\FrontBundle\Entity\Slider	No errors.
App\Flexy\FrontBundle\Entity\FormData	No errors.
App\Flexy\FrontBundle\Entity\Bloc	No errors.
App\Flexy\FrontBundle\Entity\FormField	No errors.
App\Flexy\FrontBundle\Entity\PubBanner	No errors.
App\Flexy\FrontBundle\Entity\Page	No errors.
App\Flexy\ShopBundle\Entity\Promotion\PromotionAction	No errors.
App\Flexy\ShopBundle\Entity\Promotion\PromotionRule	No errors.
App\Flexy\ShopBundle\Entity\Order\OrderItemNote	No errors.
App\Flexy\ShopBundle\Entity\Product\ProductShop	The mappings App\Flexy\ShopBundle\Entity\Product\ProductShop#childrenProductsPack and App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Product\Attribut	No errors.
App\Flexy\ShopBundle\Entity\Payment\Transaction	No errors.
App\Flexy\ShopBundle\Entity\Payment\BankBook	No errors.
App\Flexy\ShopBundle\Entity\Payment\Payment	The association App\Flexy\ShopBundle\Entity\Payment\Payment#vehicleRent refers to the inverse side field App\Flexy\ShopBundle\Entity\Shipping\Vehicle\VehicleRent#payments which does not exist.
App\Flexy\ShopBundle\Entity\Payment\Bank	No errors.
App\Flexy\ShopBundle\Entity\Payment\TransactionList	No errors.
App\Flexy\ShopBundle\Entity\Customer\Pack	No errors.
App\Flexy\ShopBundle\Entity\ImportExcel\ImportExcel	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShipmentItemType	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShipmentPaper	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShipmentItemChild	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\BrakingControl	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\VehicleRepair	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\StatusTrackingVehicle	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\BodyCondition	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\EquipmentVehicle	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\VehicleIncident	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\TireControl	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\OilMaintenance	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\VehicleConsumption	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\VehicleRentType	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\VehicleRent	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\PowerControl	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\OtherControl	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\TechnicalControl	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\DisplayControl	No errors.
App\Flexy\ShopBundle\Entity\Shipping\Vehicle\FuelType	No errors.
App\Flexy\ShopBundle\Entity\Shipping\ShipmentCollectMoney	No errors.
App\Flexy\ShopBundle\Entity\Shipping\TrackingStep	No errors.
App\Flexy\ShopBundle\Entity\Supplier\Supplier	No errors.
App\Flexy\ShopBundle\Entity\Accounting\FinancialPeriod	No errors.
App\Flexy\ShopBundle\Entity\Accounting\Account	No errors.
App\Flexy\ShopBundle\Entity\Accounting\AccountClass	No errors.
App\Flexy\ShopBundle\Entity\Accounting\PayableInvoice	No errors.
App\Flexy\ShopBundle\Entity\Accounting\FinancialYear	No errors.
App\Flexy\ShopBundle\Entity\Accounting\JournalEntryItem	No errors.
App\Flexy\ShopBundle\Entity\Accounting\JournalEntry	No errors.
App\Flexy\Apps\BookingBundle\Entity\Reservation	No errors.
App\Flexy\Apps\BookingBundle\Entity\Offer	No errors.
App\Flexy\Apps\BookingBundle\Entity\CategoryOffer	No errors.
App\Flexy\Apps\TransportBundle\Entity\RequestMission	No errors.
App\Flexy\Apps\TransportBundle\Entity\Mission	No errors.
App\Flexy\Apps\TransportBundle\Entity\MissionExtraFeesType	No errors.
App\Flexy\Apps\TransportBundle\Entity\MissionExtraFees	No errors.
App\Flexy\Apps\TransportBundle\Entity\Vehicle	No errors.
App\Flexy\Apps\CJDropShippingBundle\Entity\CjProduct	No errors.
App\Flexy\Apps\CueClubBundle\Entity\CueClubProduct	No errors.
App\Flexy\Apps\ListingBundle\Entity\ListingOption	No errors.
App\Flexy\Apps\ListingBundle\Entity\Listing	No errors.
App\Flexy\Apps\NewsletterBundle\Entity\NewsletterMailLog	No errors.
App\Flexy\Apps\NewsletterBundle\Entity\NewsletterCompaign	No errors.
App\Flexy\Apps\NewsletterBundle\Entity\NewsletterCompaignLaunch	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://ilaveu.gebanalysis.cloud/fr/api/customers/null

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping