Symfony Profiler

SELECT
  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
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT 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 TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.logo AS logo_4,
  t0.website_url AS website_url_5,
  t0.facebook_url AS facebook_url_6,
  t0.twitter_url AS twitter_url_7,
  t0.instagram_url AS instagram_url_8,
  t0.dailymotion_url AS dailymotion_url_9,
  t0.youtube_url AS youtube_url_10,
  t0.mailing_list AS mailing_list_11,
  t0.active AS active_12,
  t0.contact_emails AS contact_emails_13,
  t0.contact_phone AS contact_phone_14,
  t0.price_cenacle_joining AS price_cenacle_joining_15,
  t0.price_base_subscribe AS price_base_subscribe_16
FROM
  club t0
WHERE
  t0.uuid = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = 'le_perreux_sur_marne';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME
  /*!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_NAME = 'doctrine_migration_versions'
  AND k.TABLE_SCHEMA = 'sc2cenacle_crm_dev'
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'sc2cenacle_crm_dev' */
ORDER BY
  k.ORDINAL_POSITION

SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!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_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'sc2cenacle_crm_dev' /*!50116 AND c.CONSTRAINT_SCHEMA = 'sc2cenacle_crm_dev' */ORDER BY k.ORDINAL_POSITION;

SELECT
  les.club_id AS club_id,
  loc.*
FROM
  club_lesson les
  JOIN club_location loc ON les.club_location_id = loc.id
WHERE
  les.club_id IN (?)
GROUP BY
  1,
  2

SELECT les.club_id AS club_id, loc.* FROM club_lesson les  JOIN club_location loc ON les.club_location_id = loc.id WHERE les.club_id IN (14) GROUP BY 1, 2;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  COLUMN_NAME AS Field,
  COLUMN_TYPE AS Type,
  IS_NULLABLE AS `Null`,
  COLUMN_KEY AS `Key`,
  COLUMN_DEFAULT AS `Default`,
  EXTRA AS Extra,
  COLUMN_COMMENT AS Comment,
  CHARACTER_SET_NAME AS CharacterSet,
  COLLATION_NAME AS Collation
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = 'sc2cenacle_crm_dev'
  AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'sc2cenacle_crm_dev' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;

SELECT
  c0_.id AS id_0,
  c0_.property_key AS property_key_1,
  c0_.property_value AS property_value_2,
  c0_.updated_date AS updated_date_3,
  c0_.updater_user_id AS updater_user_id_4,
  c0_.previous_value AS previous_value_5
FROM
  configuration_property c0_
WHERE
  c0_.property_key LIKE ?

SELECT c0_.id AS id_0, c0_.property_key AS property_key_1, c0_.property_value AS property_value_2, c0_.updated_date AS updated_date_3, c0_.updater_user_id AS updater_user_id_4, c0_.previous_value AS previous_value_5 FROM configuration_property c0_ WHERE c0_.property_key LIKE 'menu.%';

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.point AS point_3,
  t0.discipline AS discipline_4,
  t0.age_level AS age_level_5,
  t0.day_of_week AS day_of_week_6,
  t0.start_time AS start_time_7,
  t0.end_time AS end_time_8,
  t0.description AS description_9,
  t0.club_location_id AS club_location_id_10,
  t0.club_id AS club_id_11
FROM
  club_lesson t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.point AS point_3, t0.discipline AS discipline_4, t0.age_level AS age_level_5, t0.day_of_week AS day_of_week_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.description AS description_9, t0.club_location_id AS club_location_id_10, t0.club_id AS club_id_11 FROM club_lesson t0 WHERE t0.club_id = 14;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.discipline AS discipline_3,
  t0.category AS category_4,
  t0.comment AS comment_5,
  t0.price_child_1 AS price_child_1_6,
  t0.price_child_2 AS price_child_2_7,
  t0.price_child_3 AS price_child_3_8,
  t0.price_adult AS price_adult_9,
  t0.club_id AS club_id_10
FROM
  club_price t0
WHERE
  t0.club_id IN (?)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.discipline AS discipline_3, t0.category AS category_4, t0.comment AS comment_5, t0.price_child_1 AS price_child_1_6, t0.price_child_2 AS price_child_2_7, t0.price_child_3 AS price_child_3_8, t0.price_adult AS price_adult_9, t0.club_id AS club_id_10 FROM club_price t0 WHERE t0.club_id IN (14);

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_NAME = 'doctrine_migration_versions'
  AND TABLE_SCHEMA = 'sc2cenacle_crm_dev'
ORDER BY
  SEQ_IN_INDEX ASC

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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'sc2cenacle_crm_dev' ORDER BY SEQ_IN_INDEX ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.value AS value_4,
  t0.club_id AS club_id_5
FROM
  club_property t0
WHERE
  t0.club_id IN (?)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.value AS value_4, t0.club_id AS club_id_5 FROM club_property t0 WHERE t0.club_id IN (14);

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;