Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT 
						o.id,
						o.price,
						o.yearporduction AS year,
						o.offeroftheday,
						cm.name AS carmodel, 
						et.name AS enginetype, 
						gb.name AS gearbox, 
						o.enginecapacity,
						o.carmileage,
						eo.name AS equipmentoption,
						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__gear_box` gb ON o.gearbox = gb.id 
					LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id 
					LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers 
					WHERE o.id NOT IN (1106) AND o.carmodel = 5 AND o.act = 1 
					ORDER BY RAND() 
					LIMIT 3 
					;

[]

SELECT
  o.id,
  o.price,
  o.yearporduction AS year,
  o.offeroftheday,
  cm.name AS carmodel,
  et.name AS enginetype,
  gb.name AS gearbox,
  o.enginecapacity,
  o.carmileage,
  eo.name AS equipmentoption,
  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__gear_box` gb ON o.gearbox = gb.id
  LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id
  LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers
WHERE
  o.id NOT IN (1106)
  AND o.carmodel = 5
  AND o.act = 1
ORDER BY
  RAND()
LIMIT
  3;

SELECT 
						o.id,
						o.price,
						o.yearporduction AS year,
						o.offeroftheday,
						cm.name AS carmodel, 
						et.name AS enginetype, 
						gb.name AS gearbox, 
						o.enginecapacity,
						o.carmileage,
						eo.name AS equipmentoption,
						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__gear_box` gb ON o.gearbox = gb.id 
					LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id 
					LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers 
					WHERE o.id NOT IN (1106) AND o.carmodel = 5 AND o.act = 1 
					ORDER BY RAND() 
					LIMIT 3 
					;;

SELECT 
					o.id,
					o.offeroftheday,
					o.price, 
					o.carmodel AS carmodelid, 
					cm.name AS carmodel, 
					o.yearporduction AS year,
					bc.name AS bodycolor, 
					ic.name AS interiorcolor, 
					im.name AS interiormaterial, 
					bt.name AS bodytype, 
					dt.name AS doortype, 
					o.seatsnum, 
					o.weight, 
					o.vin, 
					et.name AS enginetype, 
					gb.name AS gearbox, 
					wd.name AS wheeldrive, 
					o.enginepower,
					o.enginecapacity,
					o.fuelconsumption,
					o.co2emissions,
					o.emissionclass,
					o.carmileage,
					o.firstregistration,
					ct.name AS conditiontype,
					eo.name AS equipmentoption,
					o.equipmentpoint,
					o.added,
					de.description, 
					o.added,
					d.name_dealers AS dealername, 
					d.street AS dealerstreet, 
					CONCAT(d.postcode, ' ', d.city) AS dealercity, 
					d.latitude AS maplat, 
					d.longitude AS maplan, 
					d.email_contact AS email, 
					d.phone AS phone,
					o.act,
					d.www 
				FROM `oohand__offer` o 
				LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id 
				LEFT JOIN `oohand__body_color` bc ON o.bodycolor = bc.id
				LEFT JOIN `oohand__interior_color` ic ON o.interiorcolor = ic.id 
				LEFT JOIN `oohand__interior_material` im ON o.interiormaterial = im.id 
				LEFT JOIN `oohand__body_type` bt ON o.bodytype = bt.id 
				LEFT JOIN `oohand__door_type` dt ON o.doortype = dt.id 
				LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id 
				LEFT JOIN `oohand__gear_box` gb ON o.gearbox = gb.id 
				LEFT JOIN `oohand__wheel_drive` wd ON o.wheeldrive = wd.id 
				LEFT JOIN `oohand__condition_type` ct ON o.conditiontype = ct.id 
				LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id  
				LEFT JOIN `oohand__description` de ON o.id = de.offerid 
				LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers 
				WHERE o.id = 1106
				;

[]

SELECT
  o.id,
  o.offeroftheday,
  o.price,
  o.carmodel AS carmodelid,
  cm.name AS carmodel,
  o.yearporduction AS year,
  bc.name AS bodycolor,
  ic.name AS interiorcolor,
  im.name AS interiormaterial,
  bt.name AS bodytype,
  dt.name AS doortype,
  o.seatsnum,
  o.weight,
  o.vin,
  et.name AS enginetype,
  gb.name AS gearbox,
  wd.name AS wheeldrive,
  o.enginepower,
  o.enginecapacity,
  o.fuelconsumption,
  o.co2emissions,
  o.emissionclass,
  o.carmileage,
  o.firstregistration,
  ct.name AS conditiontype,
  eo.name AS equipmentoption,
  o.equipmentpoint,
  o.added,
  de.description,
  o.added,
  d.name_dealers AS dealername,
  d.street AS dealerstreet,
  CONCAT(d.postcode, ' ', d.city) AS dealercity,
  d.latitude AS maplat,
  d.longitude AS maplan,
  d.email_contact AS email,
  d.phone AS phone,
  o.act,
  d.www
FROM
  `oohand__offer` o
  LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id
  LEFT JOIN `oohand__body_color` bc ON o.bodycolor = bc.id
  LEFT JOIN `oohand__interior_color` ic ON o.interiorcolor = ic.id
  LEFT JOIN `oohand__interior_material` im ON o.interiormaterial = im.id
  LEFT JOIN `oohand__body_type` bt ON o.bodytype = bt.id
  LEFT JOIN `oohand__door_type` dt ON o.doortype = dt.id
  LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id
  LEFT JOIN `oohand__gear_box` gb ON o.gearbox = gb.id
  LEFT JOIN `oohand__wheel_drive` wd ON o.wheeldrive = wd.id
  LEFT JOIN `oohand__condition_type` ct ON o.conditiontype = ct.id
  LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id
  LEFT JOIN `oohand__description` de ON o.id = de.offerid
  LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers
WHERE
  o.id = 1106;

SELECT 
					o.id,
					o.offeroftheday,
					o.price, 
					o.carmodel AS carmodelid, 
					cm.name AS carmodel, 
					o.yearporduction AS year,
					bc.name AS bodycolor, 
					ic.name AS interiorcolor, 
					im.name AS interiormaterial, 
					bt.name AS bodytype, 
					dt.name AS doortype, 
					o.seatsnum, 
					o.weight, 
					o.vin, 
					et.name AS enginetype, 
					gb.name AS gearbox, 
					wd.name AS wheeldrive, 
					o.enginepower,
					o.enginecapacity,
					o.fuelconsumption,
					o.co2emissions,
					o.emissionclass,
					o.carmileage,
					o.firstregistration,
					ct.name AS conditiontype,
					eo.name AS equipmentoption,
					o.equipmentpoint,
					o.added,
					de.description, 
					o.added,
					d.name_dealers AS dealername, 
					d.street AS dealerstreet, 
					CONCAT(d.postcode, ' ', d.city) AS dealercity, 
					d.latitude AS maplat, 
					d.longitude AS maplan, 
					d.email_contact AS email, 
					d.phone AS phone,
					o.act,
					d.www 
				FROM `oohand__offer` o 
				LEFT JOIN `oohand__car_model` cm ON o.carmodel = cm.id 
				LEFT JOIN `oohand__body_color` bc ON o.bodycolor = bc.id
				LEFT JOIN `oohand__interior_color` ic ON o.interiorcolor = ic.id 
				LEFT JOIN `oohand__interior_material` im ON o.interiormaterial = im.id 
				LEFT JOIN `oohand__body_type` bt ON o.bodytype = bt.id 
				LEFT JOIN `oohand__door_type` dt ON o.doortype = dt.id 
				LEFT JOIN `oohand__engine_type` et ON o.enginetype = et.id 
				LEFT JOIN `oohand__gear_box` gb ON o.gearbox = gb.id 
				LEFT JOIN `oohand__wheel_drive` wd ON o.wheeldrive = wd.id 
				LEFT JOIN `oohand__condition_type` ct ON o.conditiontype = ct.id 
				LEFT JOIN `oohand__equipment_option` eo ON o.equipmentoption = eo.id  
				LEFT JOIN `oohand__description` de ON o.id = de.offerid 
				LEFT JOIN `dealers` d ON o.dealerid = d.id_dealers 
				WHERE o.id = 1106
				;;

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

[]

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

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

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

[]

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

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

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

[]

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

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

SELECT 
							ep.name
						FROM `oohand__equipment_point` ep 
						WHERE ep.id IN (173)
						;

[]

SELECT
  ep.name
FROM
  `oohand__equipment_point` ep
WHERE
  ep.id IN (173);

SELECT 
							ep.name
						FROM `oohand__equipment_point` ep 
						WHERE ep.id IN (173)
						;;

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 = 1276 ORDER BY num ASC;;