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 | 508 | 508 | 207 | 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 (6064, 35163, 35166, 35169, 35192, 35198, 35209, 35231, 35233, 35260, 35261, 35263, 35269, 35270, 35271, 35274, 35294, 35303, 35312, 35388, 35593, 35624, 35699, 38489, 38489, 54036, 58222, 64676, 65033, 65033, 65358, 65366, 65373, 65374, 73767, 73832, 73833, 73835, 73836, 73837, 73838, 73845, 73845, 73847, 73848, 73850, 73851, 74446, 74450, 77142, 77146, 77150, 77162, 77164, 77166, 77166, 77202, 77203, 77226, 77228, 77271, 77642, 77642, 77645, 77648, 77651, 77658, 77658, 77660, 77660, 77707, 77712, 77717, 77722, 80648, 80653, 80658, 80663, 80665, 80669, 80673, 80673, 80678, 80680, 80682, 80686, 80734, 80735, 80736, 80737, 80760, 80764, 80781, 80787, 80798, 81216, 81216, 81229, 81585, 81590, 81590, 81595, 81598, 81603, 81608, 81609, 81610, 81621, 81621, 81624, 81628, 81636, 82070, 83861, 83866, 83885, 83888, 83891, 83894, 83897, 83900, 84174, 84442, 84444, 84453, 84454, 84455, 84456, 84460, 84464, 84476, 84477, 84478, 84480, 84480, 84484, 84485, 84486, 84487, 84506, 84507, 84517, 84557, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84591, 84592, 84593, 84593, 84612, 84616, 84620, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85035, 85039, 85039, 85042, 85045, 85048, 85051, 85071, 85071, 85074, 85079, 85084, 85106, 85106, 85111, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85139, 85210, 85333, 85334, 85537, 85538, 85642, 85643, 85644, 85645, 85662, 85664, 85664, 85666, 85668, 85670, 85672, 85673, 85674, 85694, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 87332, 87332, 87338, 87338, 87338, 87343, 87348, 87353, 87353, 87394, 87395, 87860, 87860, 87862, 87862, 87864, 87864, 87925, 88183, 88183, 88188, 88188, 88194, 88197, 88214, 88228, 88228, 88229, 88229, 88230, 88230, 88234, 88234, 90370, 90372, 90374, 90376, 90378, 90380, 90382, 90384, 90386, 90388, 90390, 90391, 90392, 90393, 90394, 90398, 90399, 90674, 90678, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90815, 90822, 90829, 90836, 90843, 90850, 90889, 90961, 90964, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 90996, 91005, 91022, 91120, 91120, 91328, 91328, 91481, 91490, 91507, 91507, 91608, 91609, 91610, 91611, 91612, 91614, 91664, 91711, 91711, 91712, 91712, 91713, 91713, 91714, 91714, 91715, 91715, 91716, 91716, 93300, 93301, 93820, 94253, 94253, 94280, 94281, 94318, 94318, 94319, 94319, 94436, 94437, 94438, 94563, 94564, 94602, 94602, 94661, 94665, 94668, 94674, 94704, 94707, 94827, 94827, 95205, 95207, 95210, 95213, 95216, 95219, 95222, 95225, 95228, 95231, 95233, 95235, 95248, 95250, 95252, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95270, 95272, 95274, 95347, 95348, 95349, 95439, 95443, 95447, 95451, 95455, 95459, 95461, 95463, 95466, 95469, 95513, 95515, 95517, 95519, 95521, 95523, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 96014, 96097, 96098, 96149, 96229, 96230, 96231, 96337, 96514, 96661, 96684, 97038, 97240, 97292, 97612, 97613, 97614, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97686, 97687, 97728, 97735, 97742, 97749, 97756, 97763, 97770, 97777, 97790, 97792, 97805, 97808, 97856, 97862, 97877, 97910, 97915, 97919, 97982, 97985, 97985, 97993, 97993, 97997, 98004, 98012, 98019, 98021, 98029, 98503, 98504, 98505, 98506, 98523, 98530, 98532, 98533, 98535, 98540, 98545, 98550, 98555, 98594, 98600, 98629, 98669, 98910, 99224, 99225, 99226, 99731) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15, 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 (6064, 35163, 35166, 35169, 35192, 35198, 35209, 35231, 35233, 35260, 35261, 35263, 35269, 35270, 35271, 35274, 35294, 35303, 35312, 35388, 35593, 35624, 35699, 38489, 38489, 54036, 58222, 64676, 65033, 65033, 65358, 65366, 65373, 65374, 73767, 73832, 73833, 73835, 73836, 73837, 73838, 73845, 73845, 73847, 73848, 73850, 73851, 74446, 74450, 77142, 77146, 77150, 77162, 77164, 77166, 77166, 77202, 77203, 77226, 77228, 77271, 77642, 77642, 77645, 77648, 77651, 77658, 77658, 77660, 77660, 77707, 77712, 77717, 77722, 80648, 80653, 80658, 80663, 80665, 80669, 80673, 80673, 80678, 80680, 80682, 80686, 80734, 80735, 80736, 80737, 80760, 80764, 80781, 80787, 80798, 81216, 81216, 81229, 81585, 81590, 81590, 81595, 81598, 81603, 81608, 81609, 81610, 81621, 81621, 81624, 81628, 81636, 82070, 83861, 83866, 83885, 83888, 83891, 83894, 83897, 83900, 84174, 84442, 84444, 84453, 84454, 84455, 84456, 84460, 84464, 84476, 84477, 84478, 84480, 84480, 84484, 84485, 84486, 84487, 84506, 84507, 84517, 84557, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84591, 84592, 84593, 84593, 84612, 84616, 84620, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85035, 85039, 85039, 85042, 85045, 85048, 85051, 85071, 85071, 85074, 85079, 85084, 85106, 85106, 85111, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85139, 85210, 85333, 85334, 85537, 85538, 85642, 85643, 85644, 85645, 85662, 85664, 85664, 85666, 85668, 85670, 85672, 85673, 85674, 85694, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85701, 85701, 87332, 87332, 87338, 87338, 87338, 87343, 87348, 87353, 87353, 87394, 87395, 87860, 87860, 87862, 87862, 87864, 87864, 87925, 88183, 88183, 88188, 88188, 88194, 88197, 88214, 88228, 88228, 88229, 88229, 88230, 88230, 88234, 88234, 90370, 90372, 90374, 90376, 90378, 90380, 90382, 90384, 90386, 90388, 90390, 90391, 90392, 90393, 90394, 90398, 90399, 90674, 90678, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90815, 90822, 90829, 90836, 90843, 90850, 90889, 90961, 90964, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 90996, 91005, 91022, 91120, 91120, 91328, 91328, 91481, 91490, 91507, 91507, 91608, 91609, 91610, 91611, 91612, 91614, 91664, 91711, 91711, 91712, 91712, 91713, 91713, 91714, 91714, 91715, 91715, 91716, 91716, 93300, 93301, 93820, 94253, 94253, 94280, 94281, 94318, 94318, 94319, 94319, 94436, 94437, 94438, 94563, 94564, 94602, 94602, 94661, 94665, 94668, 94674, 94704, 94707, 94827, 94827, 95205, 95207, 95210, 95213, 95216, 95219, 95222, 95225, 95228, 95231, 95233, 95235, 95248, 95250, 95252, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95270, 95272, 95274, 95347, 95348, 95349, 95439, 95443, 95447, 95451, 95455, 95459, 95461, 95463, 95466, 95469, 95513, 95515, 95517, 95519, 95521, 95523, 95689, 95696, 95703, 95710, 95721, 95732, 95738, 96014, 96097, 96098, 96149, 96229, 96230, 96231, 96337, 96514, 96661, 96684, 97038, 97240, 97292, 97612, 97613, 97614, 97675, 97676, 97677, 97678, 97679, 97680, 97681, 97686, 97687, 97728, 97735, 97742, 97749, 97756, 97763, 97770, 97777, 97790, 97792, 97805, 97808, 97856, 97862, 97877, 97910, 97915, 97919, 97982, 97985, 97985, 97993, 97993, 97997, 98004, 98012, 98019, 98021, 98029, 98503, 98504, 98505, 98506, 98523, 98530, 98532, 98533, 98535, 98540, 98545, 98550, 98555, 98594, 98600, 98629, 98669, 98910, 99224, 99225, 99226, 99731) 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` = 98530) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0146-008'))))) OR (((`item_id2` = 98530) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0146-008'))))) OR (((`item_id3` = 98530) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0146-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` = 98530 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 98545 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94318) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-293641'))))) OR (((`item_id2` = 94318) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-293641'))))) OR (((`item_id3` = 94318) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-293641')))))) 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` = 94318 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98600) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1367-008'))))) OR (((`item_id2` = 98600) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1367-008'))))) OR (((`item_id3` = 98600) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1367-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` = 98600 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98540) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0019-044'))))) OR (((`item_id2` = 98540) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0019-044'))))) OR (((`item_id3` = 98540) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0019-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` = 98540 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98555) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0022-044'))))) OR (((`item_id2` = 98555) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0022-044'))))) OR (((`item_id3` = 98555) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0022-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` = 98555 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95225) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1296-008'))))) OR (((`item_id2` = 95225) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1296-008'))))) OR (((`item_id3` = 95225) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1296-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` = 95225 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98506) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-034'))))) OR (((`item_id2` = 98506) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-034'))))) OR (((`item_id3` = 98506) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-034')))))) 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` = 98506 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98505) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-030'))))) OR (((`item_id2` = 98505) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-030'))))) OR (((`item_id3` = 98505) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-030')))))) 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` = 98505 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98535) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0156-008'))))) OR (((`item_id2` = 98535) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0156-008'))))) OR (((`item_id3` = 98535) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0156-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` = 98535 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98550) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-044'))))) OR (((`item_id2` = 98550) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-044'))))) OR (((`item_id3` = 98550) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-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` = 98550 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84444) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1012-008'))))) OR (((`item_id2` = 84444) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1012-008'))))) OR (((`item_id3` = 84444) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1012-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` = 84444 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85139) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1055-008'))))) OR (((`item_id2` = 85139) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1055-008'))))) OR (((`item_id3` = 85139) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1055-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` = 85139 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6064) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h015-030246'))))) OR (((`item_id2` = 6064) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h015-030246'))))) OR (((`item_id3` = 6064) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h015-030246')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 6064 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97792) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374971'))))) OR (((`item_id2` = 97792) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374971'))))) OR (((`item_id3` = 97792) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374971')))))) 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` = 97792 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 | |