Symfony Profiler

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

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

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 = 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 = 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 = 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 = 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 = 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 = 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 = 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 = 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 = 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 m
WHERE
  m.menu_id = 1

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

SELECT
  *
FROM
  menucontents m
WHERE
  m.content_id = 97

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

SELECT
  *
FROM
  contents
WHERE
  content_id = '97'

SELECT * FROM contents WHERE content_id = '97';

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

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

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 28

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

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 25

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