Query Metrics
6
Database Queries
6
Different statements
4.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.53 ms (61.99%) |
1 |
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 (570) AND o.carmodel = 3 AND o.act = 1 ORDER BY RAND() LIMIT 3 ;
Parameters:
[] |
|
0.56 ms (13.62%) |
1 |
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 = 570 ;
Parameters:
[] |
|
0.29 ms (7.05%) |
1 |
SELECT num, file FROM `oohand__photo` WHERE offerid = 1123 ORDER BY num ASC;
Parameters:
[] |
|
0.24 ms (5.94%) |
1 |
SELECT num, file FROM `oohand__photo` WHERE offerid = 570 ORDER BY num ASC ;
Parameters:
[] |
|
0.23 ms (5.70%) |
1 |
SELECT num, file FROM `oohand__photo` WHERE offerid = 1262 ORDER BY num ASC;
Parameters:
[] |
|
0.23 ms (5.70%) |
1 |
SELECT num, file FROM `oohand__photo` WHERE offerid = 971 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.