Query Metrics
7
Database Queries
7
Different statements
4.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.33 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 = 109 ;
Parameters:
[] |
| 2 | 0.17 ms |
SELECT num, file FROM `oohand__photo` WHERE offerid = 109 ORDER BY num ASC ;
Parameters:
[] |
| 3 | 0.17 ms |
SELECT ep.name FROM `oohand__equipment_point` ep WHERE ep.id IN (151,174,143,144,147,82,20,70,44,97,98,42,22,142,150,15,100,8,27,91,21,118,4,78,108,104,109,76,128,105,38,115,89,71,6,49,34,94,35,102,124,107,18,114,84,67,68,179,134,127,1,111,51,183,14,25,159,95,19,132,10,86,149,161,167,53,113,40,141,29,41,31,28,9,36,32,59,122,123,96,112,23,106,182) ;
Parameters:
[] |
| 4 | 3.63 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 (109) AND o.carmodel = 4 AND o.act = 1 ORDER BY RAND() LIMIT 3 ;
Parameters:
[] |
| 5 | 0.18 ms |
SELECT num, file FROM `oohand__photo` WHERE offerid = 885 ORDER BY num ASC;
Parameters:
[] |
| 6 | 0.13 ms |
SELECT num, file FROM `oohand__photo` WHERE offerid = 1025 ORDER BY num ASC;
Parameters:
[] |
| 7 | 0.15 ms |
SELECT num, file FROM `oohand__photo` WHERE offerid = 1064 ORDER BY num ASC;
Parameters:
[] |
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.