| 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 * FROM flag WHERE ref_id = 3115 |
| time: 0 | SELECT * FROM `global` WHERE g_id = '3115' |
| time: 0.24 | 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 = '101592' GROUP BY g_id |
| time: 0 | 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 = '101592' GROUP BY g_id |
| time: 0 | UPDATE global SET g_votes=202 WHERE g_id =3115 |
| time: 0 | SELECT * FROM global_image WHERE g_id = 3115 |
| 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 = 101592 |
| 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 = 101592 GROUP BY posting_id |
| time: 0 | SELECT name FROM category WHERE id = 667 |
