Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.start_date AS start_date_1,
  e0_.start_time AS start_time_2,
  e0_.end_date AS end_date_3,
  e0_.end_time AS end_time_4,
  e0_.name AS name_5,
  e0_.description AS description_6,
  e0_.details AS details_7,
  e0_.created_at AS created_at_8,
  e0_.is_enabled AS is_enabled_9,
  e0_.date AS date_10,
  e0_.slug AS slug_11,
  e0_.place AS place_12,
  e0_.created_by_id AS created_by_id_13,
  e0_.album_id AS album_id_14,
  e0_.biblio_id AS biblio_id_15,
  e0_.banner_id AS banner_id_16
FROM
  events e0_
WHERE
  e0_.is_enabled = 1
ORDER BY
  e0_.start_date DESC
LIMIT
  30

SELECT e0_.id AS id_0, e0_.start_date AS start_date_1, e0_.start_time AS start_time_2, e0_.end_date AS end_date_3, e0_.end_time AS end_time_4, e0_.name AS name_5, e0_.description AS description_6, e0_.details AS details_7, e0_.created_at AS created_at_8, e0_.is_enabled AS is_enabled_9, e0_.date AS date_10, e0_.slug AS slug_11, e0_.place AS place_12, e0_.created_by_id AS created_by_id_13, e0_.album_id AS album_id_14, e0_.biblio_id AS biblio_id_15, e0_.banner_id AS banner_id_16 FROM events e0_ WHERE e0_.is_enabled = 1 ORDER BY e0_.start_date DESC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.isEnabled AS isEnabled_3
FROM
  albums t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM albums t0 WHERE t0.id IN (66, 64, 63, 62, 61, 60, 59, 58, 57, 55, 53, 50, 49, 46, 45, 44, 42, 41, 39, 40, 38, 37, 36, 35, 34, 33, 32, 28, 31);

SELECT
  t0.target AS target_1,
  t0.thumbnailDir AS thumbnailDir_2,
  t0.hasThumbnail AS hasThumbnail_3,
  t0.id AS id_4,
  t0.pages AS pages_5,
  t0.downloads AS downloads_6,
  t0.reading AS reading_7,
  t0.name AS name_8,
  t0.dir AS dir_9,
  t0.source AS source_10,
  t0.size AS size_11,
  t0.is_enabled AS is_enabled_12,
  t0.is_deleted AS is_deleted_13,
  t0.last_update AS last_update_14,
  t0.created_at AS created_at_15,
  t0.formatSize AS formatSize_16,
  t0.mimetype AS mimetype_17
FROM
  picture t0
WHERE
  t0.id IN (?)

SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id IN (438, 428, 422, 418, 412, 405, 400, 382, 377, 360, 353, 352, 326, 322, 312, 304, 298, 288, 284, 270, 278, 263, 256, 248, 242, 237, 229, 222, 180, 214);

SELECT
  count(e0_.id) AS sclr_0
FROM
  events e0_
WHERE
  e0_.is_enabled = 1
ORDER BY
  e0_.start_date DESC
LIMIT
  30

SELECT count(e0_.id) AS sclr_0 FROM events e0_ WHERE e0_.is_enabled = 1 ORDER BY e0_.start_date DESC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.is_enabled AS is_enabled_4,
  t0.slug AS slug_5
FROM
  partners_categories t0
WHERE
  t0.is_enabled = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.is_enabled AS is_enabled_4, t0.slug AS slug_5 FROM partners_categories t0 WHERE t0.is_enabled = 1 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.banner_id AS banner_id_5
FROM
  articles_categories t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_id AS banner_id_5 FROM articles_categories t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.slug AS slug_4
FROM
  services_categories t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM services_categories t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.position AS position_4,
  t0.content AS content_5,
  t0.slug AS slug_6
FROM
  members_categories t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.position AS position_4, t0.content AS content_5, t0.slug AS slug_6 FROM members_categories t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.content AS content_4,
  t0.isEnabled AS isEnabled_5,
  t0.createdAt AS createdAt_6,
  t0.lastUpdate AS lastUpdate_7,
  t0.btn_text AS btn_text_8,
  t0.btn_link AS btn_link_9,
  t0.color AS color_10,
  t0.tasks AS tasks_11,
  t0.resume AS resume_12,
  t0.missions AS missions_13,
  t0.benefits AS benefits_14,
  t0.slug AS slug_15,
  t0.banner_id AS banner_id_16,
  t0.icon_id AS icon_id_17,
  t0.category_id AS category_id_18,
  t19.id AS id_20,
  t19.label AS label_21,
  t19.description AS description_22,
  t19.slug AS slug_23
FROM
  services t0
  LEFT JOIN services_categories t19 ON t0.category_id = t19.id
WHERE
  t0.isEnabled = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.isEnabled AS isEnabled_5, t0.createdAt AS createdAt_6, t0.lastUpdate AS lastUpdate_7, t0.btn_text AS btn_text_8, t0.btn_link AS btn_link_9, t0.color AS color_10, t0.tasks AS tasks_11, t0.resume AS resume_12, t0.missions AS missions_13, t0.benefits AS benefits_14, t0.slug AS slug_15, t0.banner_id AS banner_id_16, t0.icon_id AS icon_id_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.label AS label_21, t19.description AS description_22, t19.slug AS slug_23 FROM services t0 LEFT JOIN services_categories t19 ON t0.category_id = t19.id WHERE t0.isEnabled = 1 ORDER BY t0.id ASC;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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 = 'efpj'
  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 = 'efpj' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;

SELECT
  DATABASE()

SELECT DATABASE();

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 = 'efpj'
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'efpj' */
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 = 'efpj' /*!50116 AND c.CONSTRAINT_SCHEMA = 'efpj' */ORDER BY k.ORDINAL_POSITION;

SELECT
  DATABASE()

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

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

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();