Symfony Profiler

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

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

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

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

SELECT
  *
FROM
  menucontents m
WHERE
  m.content_id = 101

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

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

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

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 = 4

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

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 58

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

SELECT
  *
FROM
  contents
WHERE
  content_id = '101'

SELECT * FROM contents WHERE content_id = '101';

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 5

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

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 69

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

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 67

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