Sort by:
Showing 1-9 from 9 total
Showing 1-9 from 9 total
« Prev Next »
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `rest_chains` | 35 | 35 | 27 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 2 | |
3 | SHOW FULL COLUMNS FROM `countries` | 9 | 9 | 23 | |
4 | SHOW FULL COLUMNS FROM `nonmembers` | 3 | 3 | 10 | |
5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 2 | |
6 | SHOW FULL COLUMNS FROM `rests_pics` | 22 | 22 | 11 | |
7 | SHOW FULL COLUMNS FROM `rest_pic_types` | 6 | 6 | 11 | |
8 | SHOW FULL COLUMNS FROM `admin_tmp_pics` | 12 | 12 | 10 | |
9 | SHOW FULL COLUMNS FROM `blds_pics` | 19 | 19 | 11 | |
10 | SHOW FULL COLUMNS FROM `blds_pics_likes` | 5 | 5 | 22 | |
11 | SHOW FULL COLUMNS FROM `visits` | 7 | 7 | 11 | |
12 | SHOW FULL COLUMNS FROM `unique_visitors` | 5 | 5 | 21 | |
13 | SHOW FULL COLUMNS FROM `searches` | 10 | 10 | 22 | |
14 | SHOW FULL COLUMNS FROM `rests_comments_likes` | 5 | 5 | 11 | |
15 | SHOW FULL COLUMNS FROM `rests_pics_likes` | 5 | 5 | 16 | |
16 | SHOW FULL COLUMNS FROM `external_reviews_likes` | 5 | 5 | 20 | |
17 | SHOW FULL COLUMNS FROM `external_reviews` | 23 | 23 | 13 | |
18 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
19 | SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` = 279 AND `RestChain`.`active` = 1 LIMIT 1 | 1 | 1 | 2 | |
20 | SELECT Result.`rank` FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R, `rests` AS `Rest` WHERE `RestsPic`.`rest_id` = `Rest`.`id` AND `Rest`.`rest_chain_id` = '279' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '796' LIMIT 1 | 1 | 1 | 15 | |
21 | SELECT COUNT(*) AS `count` FROM `rests_pics` AS `RestsPic` LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) LEFT JOIN `rests` AS `Rest` ON (`RestsPic`.`rest_id` = `Rest`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`rest_chain_id` = 279 | 1 | 1 | 0 | |
22 | SELECT `RestsPic`.`id`, `RestsPic`.`member_id`, `RestsPic`.`member_ip`, `RestsPic`.`rest_id`, `RestsPic`.`rests_comment_id`, `RestsPic`.`order_in_comment`, `RestsPic`.`created`, `RestsPic`.`file_name`, `RestsPic`.`file_name_l`, `RestsPic`.`file_name_m`, `RestsPic`.`file_name_s`, `RestsPic`.`file_name_thumb_l`, `RestsPic`.`file_name_thumb_m`, `RestsPic`.`file_name_thumb_s`, `RestsPic`.`caption`, `RestsPic`.`rest_pic_type_id`, `RestsPic`.`file_size`, `RestsPic`.`date_taken`, `RestsPic`.`active`, `RestsPic`.`reported`, `RestsPic`.`modified`, `RestsPic`.`num_likes`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Rest`.`id`, `Rest`.`rest_chain_id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`branch_nameEn`, `Rest`.`seo_url`, (CONCAT(`Rest`.`nameTh`, " (", `Rest`.`nameEn`, ")")) AS `Rest__nameThEn` FROM `rests_pics` AS `RestsPic` LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) LEFT JOIN `rests` AS `Rest` ON (`RestsPic`.`rest_id` = `Rest`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`rest_chain_id` = 279 ORDER BY `RestsPic`.`id` DESC LIMIT 60 | 9 | 9 | 18 | |
23 | SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R, `rests` AS `Rest` WHERE `RestsPic`.`rest_id` = `Rest`.`id` AND `Rest`.`rest_chain_id` = '279' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`rank` BETWEEN 4 AND 6 AND Result.`rank` <> 5 ORDER BY Result.`rank` DESC LIMIT 2 | 2 | 2 | 9 |