Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE ((`Item`.`item_code` Like '%巾着%') OR (`Item`.`item_name` Like '%巾着%') OR (`Item`.`item_figure` Like '%巾着%') OR (`Item`.`item_color` Like '%巾着%') OR (`Item`.`item_materials` Like '%巾着%') OR (`Item`.`item_note` Like '%巾着%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 396 | 396 | 253 | maybe slow |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (35576, 35577, 35578, 35578, 35579, 35579, 54042, 54043, 54046, 54056, 54057, 54058, 54060, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 77070, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77705, 77705, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 80768, 80769, 80770, 80805, 81545, 81545, 81546, 81546, 83853, 83854, 83855, 83855, 83859, 83860, 83865, 83866, 83867, 83868, 84117, 84118, 84119, 84120, 84546, 84546, 84547, 84547, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 85014, 85014, 85014, 85109, 85110, 85111, 85112, 85160, 85161, 85162, 85444, 87758, 87759, 87760, 87853, 87854, 87855, 87855, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88192, 88193, 88194, 88195, 88196, 88197, 88228, 88228, 88229, 88229, 88238, 88238, 88238, 90374, 90375, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90392, 90393, 90394, 90397, 90397, 90398, 90399, 90451, 90451, 90894, 90895, 90896, 90897, 90898, 90899, 90900, 90901, 90902, 90903, 90904, 90905, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91027, 91028, 91628, 91629, 91630, 91634, 91635, 91636, 91637, 91638, 91639, 91640, 91641, 91642, 91664, 91829, 91830, 92840, 92841, 92842, 94563, 94564, 94602, 94602, 94673, 94674, 94675, 94676, 95071, 95071, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95233, 95234, 95249, 95250, 95251, 95252, 95510, 95511, 95512, 95524, 95525, 95526, 95527, 95528, 95529, 95676, 95677, 95678, 95679, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95734, 95735, 95736, 95737, 95738, 95766, 97365, 97612, 97613, 97614, 97850, 97851, 97852, 97891, 97892, 97893, 97894, 97895, 97896, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98167, 98174, 98174, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (35576, 35577, 35578, 35578, 35579, 35579, 54042, 54043, 54046, 54056, 54057, 54058, 54060, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 77070, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77705, 77705, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 80768, 80769, 80770, 80805, 81545, 81545, 81546, 81546, 83853, 83854, 83855, 83855, 83859, 83860, 83865, 83866, 83867, 83868, 84117, 84118, 84119, 84120, 84546, 84546, 84547, 84547, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 85014, 85014, 85014, 85109, 85110, 85111, 85112, 85160, 85161, 85162, 85444, 87758, 87759, 87760, 87853, 87854, 87855, 87855, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88192, 88193, 88194, 88195, 88196, 88197, 88228, 88228, 88229, 88229, 88238, 88238, 88238, 90374, 90375, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90392, 90393, 90394, 90397, 90397, 90398, 90399, 90451, 90451, 90894, 90895, 90896, 90897, 90898, 90899, 90900, 90901, 90902, 90903, 90904, 90905, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91027, 91028, 91628, 91629, 91630, 91634, 91635, 91636, 91637, 91638, 91639, 91640, 91641, 91642, 91664, 91829, 91830, 92840, 92841, 92842, 94563, 94564, 94602, 94602, 94673, 94674, 94675, 94676, 95071, 95071, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95233, 95234, 95249, 95250, 95251, 95252, 95510, 95511, 95512, 95524, 95525, 95526, 95527, 95528, 95529, 95676, 95677, 95678, 95679, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95734, 95735, 95736, 95737, 95738, 95766, 97365, 97612, 97613, 97614, 97850, 97851, 97852, 97891, 97892, 97893, 97894, 97895, 97896, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98167, 98174, 98174, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592) AND `item_rank` <> 3 | 1 | 1 | 2 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95233) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1300-008'))))) OR (((`item_id2` = 95233) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1300-008'))))) OR (((`item_id3` = 95233) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1300-008')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95233 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98549) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-011'))))) OR (((`item_id2` = 98549) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-011'))))) OR (((`item_id3` = 98549) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-011')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98549 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98167) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36108'))))) OR (((`item_id2` = 98167) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36108'))))) OR (((`item_id3` = 98167) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36108')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98167 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98548) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-009'))))) OR (((`item_id2` = 98548) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-009'))))) OR (((`item_id3` = 98548) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98548 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84580) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1023-009'))))) OR (((`item_id2` = 84580) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1023-009'))))) OR (((`item_id3` = 84580) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1023-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 84580 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84547) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1038-002'))))) OR (((`item_id2` = 84547) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1038-002'))))) OR (((`item_id3` = 84547) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1038-002')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 84547 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98592) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-044'))))) OR (((`item_id2` = 98592) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-044'))))) OR (((`item_id3` = 98592) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98592 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98547) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-006'))))) OR (((`item_id2` = 98547) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-006'))))) OR (((`item_id3` = 98547) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98547 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98591) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-030'))))) OR (((`item_id2` = 98591) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-030'))))) OR (((`item_id3` = 98591) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-030')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98591 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98546) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-045'))))) OR (((`item_id2` = 98546) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-045'))))) OR (((`item_id3` = 98546) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-045')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98546 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98590) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-009'))))) OR (((`item_id2` = 98590) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-009'))))) OR (((`item_id3` = 98590) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98590 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98545) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-044'))))) OR (((`item_id2` = 98545) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-044'))))) OR (((`item_id3` = 98545) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98545 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98589) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-006'))))) OR (((`item_id2` = 98589) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-006'))))) OR (((`item_id3` = 98589) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98589 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98544) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0020-011'))))) OR (((`item_id2` = 98544) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0020-011'))))) OR (((`item_id3` = 98544) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0020-011')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98544 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98588) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0032-044'))))) OR (((`item_id2` = 98588) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0032-044'))))) OR (((`item_id3` = 98588) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0032-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 98588 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |