Symfony Profiler

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM contentforms cf, enginefields ef WHERE cf.content_id = 102 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 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 = 143
  and cf.enginefield_id = ef.enginefield_id

SELECT * FROM contentforms cf, enginefields ef WHERE cf.content_id = 143 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 = 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_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 = 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 = 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 = 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 = 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
  contents c,
  menus m,
  menucontents mc
WHERE
  m.menu_id = 57
  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
  20

SELECT * FROM contents c, menus m, menucontents mc WHERE m.menu_id = 57 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 20;

SELECT
  *
FROM
  menus
WHERE
  menu_id = '57'

SELECT * FROM menus WHERE menu_id = '57';

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 57

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

SELECT
  *
FROM
  menus m
WHERE
  m.menu_id = 4

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