Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.icon AS icon_4,
  t0.thumbnail AS thumbnail_5,
  t0.description AS description_6,
  t0.sort_order AS sort_order_7,
  t0.display AS display_8,
  t0.deleted AS deleted_9,
  t0.level AS level_10,
  t0.hot AS hot_11,
  t0.menu AS menu_12,
  t0.post_type AS post_type_13,
  t0.custom_path AS custom_path_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.parent AS parent_17
FROM
  amz_core_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.thumbnail AS thumbnail_5, t0.description AS description_6, t0.sort_order AS sort_order_7, t0.display AS display_8, t0.deleted AS deleted_9, t0.level AS level_10, t0.hot AS hot_11, t0.menu AS menu_12, t0.post_type AS post_type_13, t0.custom_path AS custom_path_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent AS parent_17 FROM amz_core_category t0 WHERE t0.slug = '.html' LIMIT 1;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  amz_article_article a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a1_.deleted = 'normal'
  AND a1_.published = 'published'

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM amz_article_article a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a1_.deleted = 'normal' AND a1_.published = 'published';

SELECT
  DISTINCT a0_.id AS id_0,
  a1_.sort_order AS sort_order_1,
  a1_.created_at AS created_at_2
FROM
  amz_article_article a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a1_.deleted = 'normal'
  AND a1_.published = 'published'
ORDER BY
  a1_.sort_order DESC,
  a1_.created_at DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a1_.sort_order AS sort_order_1, a1_.created_at AS created_at_2 FROM amz_article_article a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a1_.deleted = 'normal' AND a1_.published = 'published' ORDER BY a1_.sort_order DESC, a1_.created_at DESC LIMIT 12;

SELECT
  a0_.id AS id_0,
  a0_.deleted AS deleted_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.user_id AS user_id_4,
  a0_.post_id AS post_id_5
FROM
  amz_article_article a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a1_.deleted = 'normal'
  AND a1_.published = 'published'
  AND a0_.id IN (?)
ORDER BY
  a1_.sort_order DESC,
  a1_.created_at DESC

SELECT a0_.id AS id_0, a0_.deleted AS deleted_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.user_id AS user_id_4, a0_.post_id AS post_id_5 FROM amz_article_article a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a1_.deleted = 'normal' AND a1_.published = 'published' AND a0_.id IN (320, 318, 317, 315, 313, 311, 310, 309, 308, 307, 306, 305) ORDER BY a1_.sort_order DESC, a1_.created_at DESC;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';