Symfony Profiler

SELECT
  c.*
FROM
  club c
  JOIN (
    SELECT
      c.*
    FROM
      club c
      JOIN club_lesson cles ON c.id = cles.club_id
    WHERE
      cles.club_location_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    GROUP BY
      c.id
  ) cs ON c.id = cs.id

SELECT c.* FROM club c JOIN (SELECT c.*        FROM club c          JOIN club_lesson cles ON c.id = cles.club_id         WHERE cles.club_location_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 15, 16, 17, 18, 19, 21, 23, 24, 25, 26, 28, 27, 29, 30, 31, 32, 33, 35, 34)         GROUP BY c.id) cs ON c.id = cs.id;

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
  cl.*
FROM
  club_location cl
  JOIN club_lesson cles ON (cles.club_location_id = cl.id)
  JOIN club c ON (c.id = cles.club_id)
WHERE
  c.active

SELECT cl.* FROM club_location cl  JOIN club_lesson cles ON (cles.club_location_id = cl.id)  JOIN club c ON (c.id = cles.club_id) WHERE  c.active;

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 (1, 2, 3, 4, 6, 9, 10, 13, 14, 15, 17, 18, 19, 21, 23, 24, 29, 30, 31, 32, 39, 40, 41) GROUP BY 1, 2;

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
  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 (1, 2, 3, 4, 6, 9, 10, 13, 14, 15, 17, 18, 19, 21, 23, 24, 29, 30, 31, 32, 39, 40, 41);

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.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 (1, 2, 3, 4, 6, 9, 10, 13, 14, 15, 17, 18, 19, 21, 23, 24, 29, 30, 31, 32, 39, 40, 41);

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
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;