GET https://samochodyuzywane.honda.pl/oferta/1093/hr-v-hybryda-skrzynia-automatyczna-wersja-elegance-2025

Response
200 OK
IP
216.73.216.178
Profiled on
Token
0cc0a4

Query Metrics

6 Database Queries
6 Different statements
5.60 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.64 ms 
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 = 1093
				;
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.30 ms 
SELECT 
						num, 
						file 
					FROM `oohand__photo` 
					WHERE offerid = 1093 
					ORDER BY num ASC
					;
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 3.92 ms 
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 (1093) AND o.carmodel = 4 AND o.act = 1 
					ORDER BY RAND() 
					LIMIT 3 
					;
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.31 ms 
SELECT num, file FROM `oohand__photo` WHERE offerid = 1044 ORDER BY num ASC;
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 0.21 ms 
SELECT num, file FROM `oohand__photo` WHERE offerid = 1097 ORDER BY num ASC;
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.21 ms 
SELECT num, file FROM `oohand__photo` WHERE offerid = 468 ORDER BY num ASC;
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
apisite doctrine.dbal.apisite_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.