1 | DESCRIBE `bases` | | 31 | 31 | 1 |
2 | DESCRIBE `categories` | | 21 | 21 | 1 |
3 | DESCRIBE `contents` | | 6 | 6 | 1 |
4 | DESCRIBE `m_contents` | | 6 | 6 | 1 |
5 | DESCRIBE `content_lists` | | 9 | 9 | 0 |
6 | DESCRIBE `ratings` | | 7 | 7 | 1 |
7 | DESCRIBE `sites` | | 15 | 15 | 1 |
8 | DESCRIBE `templates` | | 8 | 8 | 0 |
9 | DESCRIBE `admins` | | 23 | 23 | 1 |
10 | DESCRIBE `spaces` | | 22 | 22 | 1 |
11 | DESCRIBE `advertisements` | | 23 | 23 | 1 |
12 | DESCRIBE `rankings` | | 7 | 7 | 1 |
13 | DESCRIBE `comments` | | 10 | 10 | 0 |
14 | DESCRIBE `base_comments` | | 7 | 7 | 0 |
15 | SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_h1`, `Site`.`introduction`, `Site`.`site_intro`, `Site`.`site_keyword`, `Site`.`site_url`, `Site`.`site_body`, `Site`.`analysis`, `Site`.`news_num`, `Site`.`disp_flag`, `Site`.`sitemap_flag`, `Site`.`contact_flag`, `Site`.`created`, `Site`.`modified` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 4 |
16 | SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_h1`, `Site`.`introduction`, `Site`.`site_intro`, `Site`.`site_keyword`, `Site`.`site_url`, `Site`.`site_body`, `Site`.`analysis`, `Site`.`news_num`, `Site`.`disp_flag`, `Site`.`sitemap_flag`, `Site`.`contact_flag`, `Site`.`created`, `Site`.`modified` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
17 | SELECT `Space`.`space_name`, `Space`.`id`, `Space`.`space_file`, `Space`.`adv_type`, `Space`.`adv_timage`, `Space`.`adv_tagtitle`, `Space`.`adv_tagtext`, `Space`.`adv_text`, `Space`.`adv_intro`, `Space`.`adv_html`, `Space`.`adv_image`, `Space`.`adv_url`, `Space`.`adv_alt`, `Space`.`adv_follow`, `Space`.`adv_target`, `Space`.`adv_space` FROM `spaces` AS `Space` WHERE `Space`.`use_flag` = 1 ORDER BY `Space`.`id` DESC | | 4 | 4 | 0 |
18 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 7 AND `Advertisement`.`start_date` < '2024-11-22 02:50:31' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-22 02:50:31')))) | | 1 | 1 | 1 |
19 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 6 AND `Advertisement`.`start_date` < '2024-11-22 02:50:31' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-22 02:50:31')))) | | 1 | 1 | 4 |
20 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 5 AND `Advertisement`.`start_date` < '2024-11-22 02:50:31' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-22 02:50:31')))) | | 1 | 1 | 5 |
21 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 4 AND `Advertisement`.`start_date` < '2024-11-22 02:50:31' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-22 02:50:31')))) | | 1 | 1 | 19 |
22 | SELECT `Advertisement`.`adv_name`, `Advertisement`.`adv_type`, `Advertisement`.`adv_text`, `Advertisement`.`adv_timage`, `Advertisement`.`adv_tagtitle`, `Advertisement`.`adv_tagtext`, `Advertisement`.`adv_intro`, `Advertisement`.`adv_html`, `Advertisement`.`adv_image`, `Advertisement`.`adv_url`, `Advertisement`.`adv_alt`, `Advertisement`.`adv_follow`, `Advertisement`.`adv_target`, `Advertisement`.`adv_space` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 4 AND `Advertisement`.`start_date` < '2024-11-22 02:50:31' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-22 02:50:31')))) ORDER BY `Advertisement`.`id` DESC | | 1 | 1 | 1 |
23 | SELECT `Ranking`.`id`, `Ranking`.`ng_ip`, `Ranking`.`recognition_flag`, `Ranking`.`limit_rating`, `Ranking`.`type_write`, `Ranking`.`created`, `Ranking`.`modified` FROM `rankings` AS `Ranking` WHERE `Ranking`.`id` = 1 LIMIT 1 | | 1 | 1 | 15 |
24 | SELECT `Basis`.`title`, `Basis`.`path_file`, `Basis`.`new_text`, `Basis`.`cat_id`, `Basis`.`disp_date`, `Category`.`belong_id`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`new_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-22 02:50:31' ORDER BY `Basis`.`disp_date` DESC, `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 2 | | 2 | 2 | 13 |
25 | SELECT `Category`.`id`, `Category`.`belong_id`, `Category`.`position`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Category`.`cat_temp`, `Category`.`list_temp`, `Category`.`order`, `Category`.`cat_description`, `Category`.`cat_keyword`, `Category`.`cat_exp`, `Category`.`catchcopy`, `Category`.`lead`, `Category`.`keitai_flag`, `Category`.`disp_flag`, `Category`.`pimg_size`, `Category`.`rank_flag`, `Category`.`limit_page`, `Category`.`renewal_adm`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1 | | 1 | 1 | 0 |
26 | SELECT `Basis`.`id`, `Basis`.`title`, `Basis`.`cat_id`, `Basis`.`path_file`, `Basis`.`keyword`, `Basis`.`description`, `Basis`.`image`, `Basis`.`img_size`, `Basis`.`link_url`, `Basis`.`order`, `Basis`.`rate_number`, `Basis`.`rate_member`, `Basis`.`catchcopy`, `Basis`.`lead`, `Basis`.`page_temp`, `Basis`.`cont_temp`, `Basis`.`topdisp_flag`, `Basis`.`new_flag`, `Basis`.`renewal_flag`, `Basis`.`pickup_flag`, `Basis`.`bkup_flag`, `Basis`.`keitai_flag`, `Basis`.`new_text`, `Basis`.`comment_flag`, `Basis`.`list_disp_flag`, `Basis`.`disp_flag`, `Basis`.`disp_date`, `Basis`.`page_memo`, `Basis`.`renewal_adm`, `Basis`.`created`, `Basis`.`modified` FROM `bases` AS `Basis` WHERE `Basis`.`cat_id` = (5) ORDER BY `Basis`.`order` DESC | | 38 | 38 | 0 |
27 | SELECT `Category`.`id`, `Category`.`belong_id`, `Category`.`position`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Category`.`cat_temp`, `Category`.`list_temp`, `Category`.`order`, `Category`.`cat_description`, `Category`.`cat_keyword`, `Category`.`cat_exp`, `Category`.`catchcopy`, `Category`.`lead`, `Category`.`keitai_flag`, `Category`.`disp_flag`, `Category`.`pimg_size`, `Category`.`rank_flag`, `Category`.`limit_page`, `Category`.`renewal_adm`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1 | | 1 | 1 | 38 |
28 | SELECT `Basis`.`id`, `Basis`.`title`, `Basis`.`cat_id`, `Basis`.`path_file`, `Basis`.`keyword`, `Basis`.`description`, `Basis`.`image`, `Basis`.`img_size`, `Basis`.`link_url`, `Basis`.`order`, `Basis`.`rate_number`, `Basis`.`rate_member`, `Basis`.`catchcopy`, `Basis`.`lead`, `Basis`.`page_temp`, `Basis`.`cont_temp`, `Basis`.`topdisp_flag`, `Basis`.`new_flag`, `Basis`.`renewal_flag`, `Basis`.`pickup_flag`, `Basis`.`bkup_flag`, `Basis`.`keitai_flag`, `Basis`.`new_text`, `Basis`.`comment_flag`, `Basis`.`list_disp_flag`, `Basis`.`disp_flag`, `Basis`.`disp_date`, `Basis`.`page_memo`, `Basis`.`renewal_adm`, `Basis`.`created`, `Basis`.`modified` FROM `bases` AS `Basis` WHERE `Basis`.`cat_id` = (5) ORDER BY `Basis`.`order` DESC | | 38 | 38 | 0 |
29 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag`, `Category`.`rank_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 0 ORDER BY `Category`.`order` ASC | | 5 | 5 | 11 |
30 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-22 02:50:31' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 2 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 8 | 8 | 3 |
31 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 15 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 2 |
32 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
33 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
34 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 2 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
35 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
36 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
37 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 35 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
38 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
39 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
40 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 6 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 3 |
41 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 2 |
42 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
43 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 5 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
44 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
45 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
46 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 4 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 4 |
47 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 9 |
48 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 9 |
49 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 3 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 6 |
50 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 2 |
51 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
52 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 73 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 5 |
53 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 4 |
54 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
55 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 2 ORDER BY `Category`.`order` ASC | | 1 | 1 | 5 |
56 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-22 02:50:31' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 1 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 11 | 11 | 11 |
57 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 19 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 3 |
58 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 4 |
59 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 5 |
60 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 1 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
61 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
62 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
63 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 21 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 6 |
64 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
65 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 11 |
66 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 20 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 1 |
67 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 1 |
68 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 1 |
69 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 23 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
70 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 1 |
71 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 2 |
72 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 22 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
73 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
74 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
75 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 24 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
76 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
77 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
78 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 42 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
79 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
80 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
81 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 66 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
82 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
83 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
84 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 52 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
85 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
86 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
87 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 25 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
88 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
89 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
90 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 1 ORDER BY `Category`.`order` ASC | | 0 | 0 | 0 |
91 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-22 02:50:31' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 5 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 21 | 21 | 10 |
92 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 87 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
93 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 3 |
94 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 1 |
95 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 87 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 1 |
96 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 68 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
97 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
98 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
99 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 68 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
100 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 18 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
101 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 1 |
102 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
103 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 18 ORDER BY `ContentList`.`id` ASC | | 13 | 13 | 0 |
104 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 77 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
105 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
106 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 9 |
107 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 77 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 9 |
108 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 78 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 7 |
109 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 3 |
110 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
111 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 78 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 4 |
112 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 95 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 18 |
113 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 1 |
114 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
115 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 95 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
116 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 93 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
117 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
118 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
119 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 93 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 6 |
120 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 91 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 10 |
121 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
122 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
123 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 91 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
124 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 90 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 8 |
125 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 8 |
126 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 7 |
127 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 90 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 5 |
128 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 88 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 2 |
129 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
130 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
131 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 88 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
132 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 86 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
133 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
134 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
135 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 86 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
136 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 85 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
137 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
138 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
139 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 85 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
140 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 79 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
141 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
142 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
143 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 79 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
144 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 34 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
145 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
146 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
147 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 34 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
148 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 33 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
149 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
150 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
151 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 33 ORDER BY `ContentList`.`id` ASC | | 11 | 11 | 0 |
152 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 9 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
153 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
154 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
155 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 9 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
156 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 80 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
157 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
158 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
159 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 80 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
160 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 32 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
161 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
162 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
163 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 32 ORDER BY `ContentList`.`id` ASC | | 11 | 11 | 0 |
164 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 17 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
165 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
166 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
167 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 17 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
168 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 81 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
169 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
170 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
171 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 81 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
172 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 70 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
173 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
174 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
175 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 70 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
176 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 5 ORDER BY `Category`.`order` ASC | | 1 | 1 | 0 |
177 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-22 02:50:31' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 3 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 13 | 13 | 16 |
178 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 41 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 18 |
179 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 6 |
180 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 11 |
181 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 44 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
182 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
183 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
184 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 46 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
185 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
186 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
187 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 48 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
188 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
189 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
190 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 47 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 6 |
191 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 10 |
192 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
193 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 51 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 5 |
194 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
195 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
196 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 49 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 13 |
197 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
198 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
199 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 60 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
200 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 60 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |