| time: 0 | SELECT * FROM place WHERE parent_id = 1 |
| time: 0 | SELECT text FROM meta_tags WHERE location=1 AND type='keywords' AND page='services' |
| time: 0 | SELECT text FROM meta_tags WHERE location=1 AND type='description' AND page='services' |
| time: 0 | SELECT text FROM meta_tags WHERE location=1 AND type='title' AND page='services' |
| time: 0 | SELECT name FROM place WHERE id = 1 |
| time: 0 | SELECT * FROM place WHERE parent_id = 1 |
| time: 0 | SELECT parent_id FROM place WHERE id = 1 |
| time: 0 | SELECT name FROM place WHERE id = 1 |
| time: 0 | SELECT * FROM place WHERE parent_id = 1 ORDER BY name |
| time: 0.18 | SELECT SQL_CALC_FOUND_ROWS global.*, posting.*, place.name AS place_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = global.g_tid LEFT JOIN ratings ON ratings.posting_id = posting.id LEFT JOIN place ON posting.place_id = place.id
WHERE
posting.category_id = '428'
AND global.g_type = 5
AND global.g_is_comment = 0
AND g_place_id IN (2,3,4,5,6,7,8,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,136,1) GROUP BY g_id ORDER BY score DESC, reviews, review_date
LIMIT 0, 10 |
| time: 0 | SELECT FOUND_ROWS() |
| time: 0.17 | SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '100237' GROUP BY g_id |
| time: 0 | SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 100237 |
| time: 0 | SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 100237 GROUP BY posting_id |
| time: 0 | SELECT * FROM global_image WHERE g_id = 1774 |
| time: 0.17 | SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '100238' GROUP BY g_id |
| time: 0 | SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 100238 |
| time: 0 | SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 100238 GROUP BY posting_id |
| time: 0 | SELECT * FROM global_image WHERE g_id = 1775 |
| time: 0 | SELECT name FROM category WHERE id = 428 |
