| 0.0027 |
SELECT *,(select fuel_name from setup_fuel where setup_fuel.fuel_id = listing.listing_fuel) as gorivo, (select transmission_name from setup_transmission where setup_transmission.transmission_id = listing.listing_transmission) as menjac, (select make_name from setup_make where setup_make.make_id = listing.listing_make) as marka FROM listing, showroom WHERE listing.listing_showroom = showroom.showroom_id and listing_status_displayed ='yes' and listing_id = '210'
|
| 0.0014 |
UPDATE listing set brojac = brojac + 1 WHERE listing_id = '210' LIMIT 1
|
| 0.0011 |
SELECT * FROM (`showroom`)
|
| 0.0048 |
SELECT * FROM (`listing_photo`) WHERE `photo_listing` = '210' ORDER BY `photo_status` DESC
|
| 0.0587 |
SELECT make_id, make_name, count(listing_make) as ukupno FROM setup_make, listing WHERE setup_make.make_id = listing.listing_make group by make_id
|
| 0.0128 |
SELECT *, (select photo_file from listing_photo where listing_photo.photo_listing = listing.listing_id and photo_status ='main') as slika, (select fuel_name from setup_fuel where setup_fuel.fuel_id = listing.listing_fuel) as gorivo, (select make_name from setup_make where setup_make.make_id = listing.listing_make) as marka FROM listing WHERE listing_status_featured = 'no' AND listing_status_displayed = 'yes' ORDER BY listing_id desc LIMIT 5
|
| 0.0012 |
SELECT * FROM (setup_feature) WHERE feature_id IN (16,14,24,8,3,6,1,25,15,12)
|
| 0.0012 |
SELECT * FROM (`showroom`)
|