| 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 | SELECT category.*, COUNT(posting.id) AS num FROM category INNER JOIN posting ON posting.category_id=category.id WHERE root_parent_id = 100 GROUP BY category.id |
| time: 0 | SELECT category.*, COUNT(posting.id) AS num FROM category INNER JOIN posting ON posting.category_id=category.id WHERE root_parent_id = 100 GROUP BY category.id |
| time: 0.21 | 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
global.g_type = '5'
AND global.g_is_comment = 0
AND posting.category_id = '667'
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, 5 |
| time: 0 | SELECT FOUND_ROWS() |
| time: 0.04 | SELECT * FROM global INNER JOIN posting ON g_tid = posting.id AND g_type = 5 INNER JOIN global_image ON global_image.g_id = global.g_id WHERE category_id = 667 ORDER BY rand(); |
| time: 0.19 | 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
global.g_type = '5'
AND global.g_is_comment = 0
AND posting.category_id = '667'
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 g_date_created DESC
LIMIT 0, 5 |
| time: 0 | SELECT FOUND_ROWS() |
| time: 0.01 | SELECT * FROM global INNER JOIN posting ON g_tid = posting.id AND g_type = 5 INNER JOIN global_image ON global_image.g_id = global.g_id WHERE category_id = 667 ORDER BY rand(); |
| time: 0.6 | 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
global.g_type = '5'
AND global.g_is_comment = 0
AND posting.category_id = '183'
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, 5 |
| time: 0 | SELECT FOUND_ROWS() |
| time: 0 | SELECT * FROM global INNER JOIN posting ON g_tid = posting.id AND g_type = 5 INNER JOIN global_image ON global_image.g_id = global.g_id WHERE category_id = 183 ORDER BY rand(); |
| time: 0.19 | 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
global.g_type = '5'
AND global.g_is_comment = 0
AND posting.category_id = '183'
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 g_date_created DESC
LIMIT 0, 5 |
| time: 0 | SELECT FOUND_ROWS() |
| time: 0.01 | SELECT * FROM global INNER JOIN posting ON g_tid = posting.id AND g_type = 5 INNER JOIN global_image ON global_image.g_id = global.g_id WHERE category_id = 183 ORDER BY rand(); |
| time: 0.02 | SELECT posting.headline as bus_title, ratings.*, global.*, global_image.*, members.member_name FROM global INNER JOIN global_image ON global.g_id = global_image.g_id INNER JOIN posting ON posting.id = global.g_tid INNER JOIN ratings ON ratings.posting_id = global.g_tid INNER JOIN members ON members.id = ratings.member_id WHERE g_type = 5 ORDER BY rand() |
| time: 0.19 | 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 = '101509' GROUP BY g_id |
| time: 0 | SELECT * FROM global_image WHERE g_id = 3032 |
Cost: 
by 
