Symfony Profiler

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 0
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
  and menu_top = 1
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=0 AND menu_status=2 AND language_id = 1 and company_id=2 and menu_top = 1 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 162
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=162 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 1
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=1 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 2
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=2 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 3
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=3 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 4
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=4 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 5
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=5 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 7
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=7 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 34
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=34 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 14
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=14 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '71'

SELECT * FROM menus WHERE menu_id = '71';

SELECT
  *
FROM
  menus
WHERE
  menu_id = '1'

SELECT * FROM menus WHERE menu_id = '1';

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 25
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=25 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 26
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=26 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 27
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=27 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '2'

SELECT * FROM menus WHERE menu_id = '2';

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 56
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=56 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 50
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=50 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 44
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=44 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '3'

SELECT * FROM menus WHERE menu_id = '3';

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 19
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=19 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 51
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=51 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 45
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=45 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '4'

SELECT * FROM menus WHERE menu_id = '4';

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 57
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=57 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 52
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=52 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 46
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=46 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '5'

SELECT * FROM menus WHERE menu_id = '5';

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 58
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=58 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 53
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=53 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 47
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=47 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '7'

SELECT * FROM menus WHERE menu_id = '7';

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 60
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=60 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 55
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=55 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  menus
WHERE
  menu_parent = 49
  AND menu_status = 2
  AND language_id = 1
  and company_id = 2
ORDER BY
  menu_number ASC

SELECT * FROM menus WHERE menu_parent=49 AND menu_status=2 AND language_id = 1 and company_id=2 ORDER BY menu_number ASC;

SELECT
  *
FROM
  contents c,
  menus m,
  menucontents mc
WHERE
  m.menu_id = 6
  and m.menu_id = mc.menu_id
  and mc.content_id = c.content_id
  and c.content_status = 2
order by
  c.content_id desc
LIMIT
  2

SELECT * FROM contents c, menus m, menucontents mc WHERE m.menu_id = 6 and m.menu_id = mc.menu_id and mc.content_id = c.content_id and c.content_status = 2 order by c.content_id desc LIMIT 2;