Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.paragraph_title AS paragraph_title_6,
  t0.description AS description_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  category_translation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.paragraph_title AS paragraph_title_6, t0.description AS description_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM category_translation t0 WHERE t0.slug = 'vide' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.position AS position_1,
  s0_.sub_category_icon_file_name AS sub_category_icon_file_name_2,
  s0_.sub_category_bg_file_name AS sub_category_bg_file_name_3,
  s0_.sub_category_bg_file_size AS sub_category_bg_file_size_4,
  s0_.sub_category_bg_file_updated_at AS sub_category_bg_file_updated_at_5,
  s0_.sub_category_icon_file_size AS sub_category_icon_file_size_6,
  s0_.sub_category_icon_file_updated_at AS sub_category_icon_file_updated_at_7,
  s0_.sub_category_file_name AS sub_category_file_name_8,
  s0_.sub_category_file_size AS sub_category_file_size_9,
  s0_.sub_category_file_updated_at AS sub_category_file_updated_at_10,
  s0_.published AS published_11,
  s0_.pdf_file_name AS pdf_file_name_12,
  s0_.pdf_file_size AS pdf_file_size_13,
  s0_.pdf_file_updated_at AS pdf_file_updated_at_14,
  s0_.category_id AS category_id_15
FROM
  sub_category s0_
  LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id
WHERE
  s0_.id IS NOT NULL
  AND s1_.slug = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_icon_file_name AS sub_category_icon_file_name_2, s0_.sub_category_bg_file_name AS sub_category_bg_file_name_3, s0_.sub_category_bg_file_size AS sub_category_bg_file_size_4, s0_.sub_category_bg_file_updated_at AS sub_category_bg_file_updated_at_5, s0_.sub_category_icon_file_size AS sub_category_icon_file_size_6, s0_.sub_category_icon_file_updated_at AS sub_category_icon_file_updated_at_7, s0_.sub_category_file_name AS sub_category_file_name_8, s0_.sub_category_file_size AS sub_category_file_size_9, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_10, s0_.published AS published_11, s0_.pdf_file_name AS pdf_file_name_12, s0_.pdf_file_size AS pdf_file_size_13, s0_.pdf_file_updated_at AS pdf_file_updated_at_14, s0_.category_id AS category_id_15 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s1_.slug = 'iso-k' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.sub_sub_category_icon_file_name AS sub_sub_category_icon_file_name_1,
  s0_.sub_sub_category_bg_file_name AS sub_sub_category_bg_file_name_2,
  s0_.sub_sub_category_bg_file_size AS sub_sub_category_bg_file_size_3,
  s0_.sub_sub_category_bg_file_updated_at AS sub_sub_category_bg_file_updated_at_4,
  s0_.sub_sub_category_icon_file_size AS sub_sub_category_icon_file_size_5,
  s0_.sub_sub_category_icon_file_updated_at AS sub_sub_category_icon_file_updated_at_6,
  s0_.sub_sub_category_file_name AS sub_sub_category_file_name_7,
  s0_.sub_sub_category_file_size AS sub_sub_category_file_size_8,
  s0_.sub_sub_category_file_updated_at AS sub_sub_category_file_updated_at_9,
  s0_.position AS position_10,
  s0_.published AS published_11,
  s0_.pdf_file_name AS pdf_file_name_12,
  s0_.pdf_file_size AS pdf_file_size_13,
  s0_.pdf_file_updated_at AS pdf_file_updated_at_14,
  s0_.sub_category_id AS sub_category_id_15
FROM
  sub_sub_category s0_
  LEFT JOIN sub_sub_category_translation s1_ ON s0_.id = s1_.translatable_id
WHERE
  s0_.id IS NOT NULL
  AND s1_.slug = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.sub_sub_category_icon_file_name AS sub_sub_category_icon_file_name_1, s0_.sub_sub_category_bg_file_name AS sub_sub_category_bg_file_name_2, s0_.sub_sub_category_bg_file_size AS sub_sub_category_bg_file_size_3, s0_.sub_sub_category_bg_file_updated_at AS sub_sub_category_bg_file_updated_at_4, s0_.sub_sub_category_icon_file_size AS sub_sub_category_icon_file_size_5, s0_.sub_sub_category_icon_file_updated_at AS sub_sub_category_icon_file_updated_at_6, s0_.sub_sub_category_file_name AS sub_sub_category_file_name_7, s0_.sub_sub_category_file_size AS sub_sub_category_file_size_8, s0_.sub_sub_category_file_updated_at AS sub_sub_category_file_updated_at_9, s0_.position AS position_10, s0_.published AS published_11, s0_.pdf_file_name AS pdf_file_name_12, s0_.pdf_file_size AS pdf_file_size_13, s0_.pdf_file_updated_at AS pdf_file_updated_at_14, s0_.sub_category_id AS sub_category_id_15 FROM sub_sub_category s0_ LEFT JOIN sub_sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s1_.slug = 'joints-iso-k' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.published AS published_1,
  s0_.sub_sub_sub_category_icon_file_name AS sub_sub_sub_category_icon_file_name_2,
  s0_.sub_sub_sub_category_icon_file_size AS sub_sub_sub_category_icon_file_size_3,
  s0_.sub_sub_sub_category_bg_file_name AS sub_sub_sub_category_bg_file_name_4,
  s0_.sub_sub_sub_category_bg_file_size AS sub_sub_sub_category_bg_file_size_5,
  s0_.sub_sub_sub_category_bg_file_updated_at AS sub_sub_sub_category_bg_file_updated_at_6,
  s0_.sub_sub_sub_category_icon_file_updated_at AS sub_sub_sub_category_icon_file_updated_at_7,
  s0_.position AS position_8,
  s0_.sub_sub_sub_category_file_name AS sub_sub_sub_category_file_name_9,
  s0_.sub_sub_sub_category_file_size AS sub_sub_sub_category_file_size_10,
  s0_.sub_sub_sub_category_file_updated_at AS sub_sub_sub_category_file_updated_at_11,
  s0_.pdf_file_name AS pdf_file_name_12,
  s0_.pdf_file_size AS pdf_file_size_13,
  s0_.pdf_file_updated_at AS pdf_file_updated_at_14,
  s0_.sub_sub_category_id AS sub_sub_category_id_15
FROM
  sub_sub_sub_category s0_
  LEFT JOIN sub_sub_sub_category_translation s1_ ON s0_.id = s1_.translatable_id
WHERE
  s0_.id IS NOT NULL
  AND s1_.slug = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.published AS published_1, s0_.sub_sub_sub_category_icon_file_name AS sub_sub_sub_category_icon_file_name_2, s0_.sub_sub_sub_category_icon_file_size AS sub_sub_sub_category_icon_file_size_3, s0_.sub_sub_sub_category_bg_file_name AS sub_sub_sub_category_bg_file_name_4, s0_.sub_sub_sub_category_bg_file_size AS sub_sub_sub_category_bg_file_size_5, s0_.sub_sub_sub_category_bg_file_updated_at AS sub_sub_sub_category_bg_file_updated_at_6, s0_.sub_sub_sub_category_icon_file_updated_at AS sub_sub_sub_category_icon_file_updated_at_7, s0_.position AS position_8, s0_.sub_sub_sub_category_file_name AS sub_sub_sub_category_file_name_9, s0_.sub_sub_sub_category_file_size AS sub_sub_sub_category_file_size_10, s0_.sub_sub_sub_category_file_updated_at AS sub_sub_sub_category_file_updated_at_11, s0_.pdf_file_name AS pdf_file_name_12, s0_.pdf_file_size AS pdf_file_size_13, s0_.pdf_file_updated_at AS pdf_file_updated_at_14, s0_.sub_sub_category_id AS sub_sub_category_id_15 FROM sub_sub_sub_category s0_ LEFT JOIN sub_sub_sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s1_.slug = 'obfsm:Y29udGFjdEBkbWRpbm94LmNvbQ==' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.slug AS slug_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.photo_title AS photo_title_7,
  t0.schema_title AS schema_title_8,
  t0.intro AS intro_9,
  t0.locale AS locale_10,
  t0.translatable_id AS translatable_id_11
FROM
  product_translation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.photo_title AS photo_title_7, t0.schema_title AS schema_title_8, t0.intro AS intro_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM product_translation t0 WHERE t0.slug = 'obfsm:Y29udGFjdEBkbWRpbm94LmNvbQ==' LIMIT 1;

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

SELECT
  DISTINCT 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 = 'doctrine_migration_versions' */
WHERE
  k.table_name = 'doctrine_migration_versions'
  AND k.table_schema = 'dmdinox_dev'
  /*!50116 AND c.constraint_schema = 'dmdinox_dev' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT 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 = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'dmdinox_dev' /*!50116 AND c.constraint_schema = 'dmdinox_dev' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

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 = 'dmdinox_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 = 'dmdinox_dev' ORDER BY SEQ_IN_INDEX ASC;

SELECT
  ENGINE,
  AUTO_INCREMENT,
  TABLE_COLLATION,
  TABLE_COMMENT,
  CREATE_OPTIONS
FROM
  information_schema.TABLES
WHERE
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
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;