Symfony Profiler

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;

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;

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;

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';

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;

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;

SELECT
  DATABASE()

SELECT DATABASE();

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);

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);

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;