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
  contents
WHERE
  content_id = '123'

SELECT * FROM contents WHERE content_id = '123';

SELECT
  *
FROM
  contentforms cf,
  enginefields ef
WHERE
  cf.content_id = 123
  and cf.enginefield_id = ef.enginefield_id

SELECT * FROM contentforms cf, enginefields ef WHERE cf.content_id = 123 and cf.enginefield_id = ef.enginefield_id ;

SELECT
  *
FROM
  menucontents m
WHERE
  m.content_id = 123

SELECT * FROM menucontents m WHERE m.content_id = 123;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 26

SELECT * FROM menus m WHERE m.menu_id = 26;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 1

SELECT * FROM menus m WHERE m.menu_id = 1;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 29

SELECT * FROM menus m WHERE m.menu_id = 29;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 26

SELECT * FROM menus m WHERE m.menu_id = 26;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 1

SELECT * FROM menus m WHERE m.menu_id = 1;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 50

SELECT * FROM menus m WHERE m.menu_id = 50;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 2

SELECT * FROM menus m WHERE m.menu_id = 2;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 73

SELECT * FROM menus m WHERE m.menu_id = 73;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 50

SELECT * FROM menus m WHERE m.menu_id = 50;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 2

SELECT * FROM menus m WHERE m.menu_id = 2;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 51

SELECT * FROM menus m WHERE m.menu_id = 51;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 3

SELECT * FROM menus m WHERE m.menu_id = 3;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 74

SELECT * FROM menus m WHERE m.menu_id = 74;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 51

SELECT * FROM menus m WHERE m.menu_id = 51;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 3

SELECT * FROM menus m WHERE m.menu_id = 3;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 52

SELECT * FROM menus m WHERE m.menu_id = 52;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 4

SELECT * FROM menus m WHERE m.menu_id = 4;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 75

SELECT * FROM menus m WHERE m.menu_id = 75;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 52

SELECT * FROM menus m WHERE m.menu_id = 52;

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 4

SELECT * FROM menus m WHERE m.menu_id = 4;

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
  photos
WHERE
  content_id = '123'
ORDER BY
  photo_ordernum DESC

SELECT * FROM photos WHERE content_id='123' ORDER BY photo_ordernum DESC;