Symfony Profiler

SELECT
  COUNT(o.id) as count
FROM
  `oohand__offer` o
  LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id
  LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id
  LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id
  LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers
WHERE
  o.act = 1;

SELECT 
					COUNT(o.id) as count 
				FROM `oohand__offer` o 
				LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id 
				LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id 
				LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id 
				LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers 
				WHERE o.act = 1 
				
				
				
				
				;;

SELECT
  cm.id,
  cm.name AS carmodel,
  COUNT(o.id) AS offer_count
FROM
  `oohand__offer` o
  LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id
  LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id
  LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id
  LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers
WHERE
  o.act = 1 --  
GROUP BY
  cm.id,
  cm.name
HAVING
  offer_count > 0;

SELECT 
					cm.id, 
					cm.name AS carmodel, 
					COUNT(o.id) AS offer_count
				FROM `oohand__offer` o
				LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id
				LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id 
				LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id 
				LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers
				WHERE o.act = 1 
					--  
					
					
                    
                    
				GROUP BY cm.id, cm.name 
				HAVING offer_count > 0;
				;

SELECT
  o.id,
  o.dealerid,
  o.offeroftheday,
  o.price,
  cm.name AS carmodel,
  et.name AS enginetype,
  o.enginecapacity,
  eo.name AS equipmentoption,
  o.yearporduction AS year,
  o.carmileage AS carmileage,
  gb.name AS gearbox,
  o.added,
  d.www,
  d.name_dealers AS dealerName
FROM
  `oohand__offer` o
  LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id
  LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id
  LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id
  LEFT JOIN `oohand__gear_box` gb ON o.gearbox = gb.id
  LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers
WHERE
  o.act = 1
  AND d.car_dealer = "Y"
  AND d.visible = "Y"
ORDER BY
  added DESC
LIMIT
  12 OFFSET 0;

SELECT 
					o.id, 
					o.dealerid,
					o.offeroftheday, 
					o.price, 
					cm.name AS carmodel, 
					et.name AS enginetype, 
					o.enginecapacity, 
					eo.name AS equipmentoption, 
					o.yearporduction AS year, 
					o.carmileage AS carmileage, 
					gb.name AS gearbox,
					o.added,
					d.www,
					d.name_dealers AS dealerName 
				FROM `oohand__offer` o 
				LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id 
				LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id 
				LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id 
				LEFT JOIN `oohand__gear_box` gb ON o.gearbox = gb.id 
				LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers 
				WHERE 
					o.act = 1 
					AND d.car_dealer = "Y" 
					AND d.visible = "Y" 
					 
					
					
                    
                    
				ORDER BY added DESC 
				LIMIT 12 OFFSET 0;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1276
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1276 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1275
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1275 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1274
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1274 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1273
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1273 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1272
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1272 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1271
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1271 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1270
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1270 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1269
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1269 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1268
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1268 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1267
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1267 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1266
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1266 ORDER BY num ASC;;

SELECT
  num,
  file
FROM
  `oohand__photo`
WHERE
  offerid = 1265
ORDER BY
  num ASC;

SELECT num, file FROM `oohand__photo` WHERE offerid = 1265 ORDER BY num ASC;;

SELECT
  DISTINCT d.id_region id
FROM
  `dealers` d
  JOIN (
    SELECT
      o.dealerid,
      COUNT(*) AS offer_count
    FROM
      `oohand__offer` o
    WHERE
      o.act = 1
    GROUP BY
      o.dealerid
    HAVING
      offer_count > 0
  ) o ON d.id_dealers = o.dealerid
WHERE
  d.car_dealer = "Y"
  AND d.visible = "Y";

SELECT 
					DISTINCT d.id_region id
				FROM `dealers` d 
				JOIN (
					SELECT o.dealerid, COUNT(*) AS offer_count
					FROM `oohand__offer` o
					WHERE o.act = 1
					GROUP BY o.dealerid
					HAVING offer_count > 0
				) o ON d.id_dealers = o.dealerid 
				WHERE 
					d.car_dealer = "Y" 
					AND d.visible = "Y" 
				;;

SELECT
  d.id_dealers AS id,
  d.name_dealers AS name,
  d.city AS city,
  d.id_region AS region,
  offer_count
FROM
  `dealers` d
  JOIN (
    SELECT
      o.dealerid,
      COUNT(*) AS offer_count
    FROM
      `oohand__offer` o
    WHERE
      o.act = 1
    GROUP BY
      o.dealerid
    HAVING
      offer_count > 0
  ) o ON d.id_dealers = o.dealerid
WHERE
  d.car_dealer = "Y"
  AND d.visible = "Y";

SELECT 
					d.id_dealers AS id, 
					d.name_dealers AS name, 
					d.city AS city,
					d.id_region AS region,
					offer_count
				FROM `dealers` d
				JOIN (
					SELECT o.dealerid, COUNT(*) AS offer_count
					FROM `oohand__offer` o
					WHERE o.act = 1
					GROUP BY o.dealerid
					HAVING offer_count > 0
				) o ON d.id_dealers = o.dealerid
				WHERE 
					d.car_dealer = "Y" 
					AND d.visible = "Y" 
					
				;;