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 '%ハロウィン%') OR (`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 | 288 | 288 | 0 | |
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 (35651, 35652, 35665, 54029, 54030, 57706, 57707, 57708, 57709, 65329, 65331, 65331, 65337, 65338, 65338, 69456, 77025, 77213, 77214, 77215, 77216, 77634, 77635, 77636, 77637, 79023, 79023, 81146, 81150, 81150, 81477, 81478, 81479, 81480, 81481, 81482, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81502, 81503, 81504, 81506, 81506, 83787, 83788, 83789, 84488, 84489, 84490, 84491, 84496, 84497, 84499, 84500, 84906, 85275, 85276, 85277, 86110, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 88143, 88216, 88217, 88218, 88278, 88279, 88280, 88853, 88853, 88861, 88862, 88863, 88864, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90460, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90745, 90746, 90746, 90754, 90755, 90756, 90757, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91051, 91052, 91053, 91327, 91327, 91328, 91328, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91465, 91466, 91467, 91468, 91469, 91470, 91745, 92333, 92334, 92336, 92355, 92356, 92358, 92359, 92360, 92361, 92363, 92370, 92371, 92372, 92373, 92381, 92382, 93941, 93951, 94317, 94335, 94336, 94352, 94353, 94357, 94358, 94362, 94363, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94511, 94512, 94518, 94519, 94520, 94521, 94635, 94636, 94637, 94638, 94639, 94640, 94745, 94746, 94747, 94821, 94852, 94853, 95073, 95139, 95140, 95141, 95142, 95143, 95144, 95346, 95417, 95569, 95570, 95571, 95572, 95573, 95604, 95605, 95606, 95607, 95608, 95851, 96568, 96569, 96570, 96577, 96579, 96915, 96916, 96917, 98427, 98428, 98429, 98438, 98785, 98786, 98788, 98789, 98790, 98793, 98794, 98795, 98796, 98995, 98996, 98997, 98998, 99018, 99019, 99020, 99384, 99385, 99386, 99387, 99388, 99389, 99390, 99391, 99393) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` desc LIMIT 15 | 15 | 15 | 1 | 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 (35651, 35652, 35665, 54029, 54030, 57706, 57707, 57708, 57709, 65329, 65331, 65331, 65337, 65338, 65338, 69456, 77025, 77213, 77214, 77215, 77216, 77634, 77635, 77636, 77637, 79023, 79023, 81146, 81150, 81150, 81477, 81478, 81479, 81480, 81481, 81482, 81483, 81484, 81485, 81496, 81497, 81498, 81499, 81499, 81500, 81501, 81502, 81503, 81504, 81506, 81506, 83787, 83788, 83789, 84488, 84489, 84490, 84491, 84496, 84497, 84499, 84500, 84906, 85275, 85276, 85277, 86110, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 88143, 88216, 88217, 88218, 88278, 88279, 88280, 88853, 88853, 88861, 88862, 88863, 88864, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90460, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90745, 90746, 90746, 90754, 90755, 90756, 90757, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 91051, 91052, 91053, 91327, 91327, 91328, 91328, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91465, 91466, 91467, 91468, 91469, 91470, 91745, 92333, 92334, 92336, 92355, 92356, 92358, 92359, 92360, 92361, 92363, 92370, 92371, 92372, 92373, 92381, 92382, 93941, 93951, 94317, 94335, 94336, 94352, 94353, 94357, 94358, 94362, 94363, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94511, 94512, 94518, 94519, 94520, 94521, 94635, 94636, 94637, 94638, 94639, 94640, 94745, 94746, 94747, 94821, 94852, 94853, 95073, 95139, 95140, 95141, 95142, 95143, 95144, 95346, 95417, 95569, 95570, 95571, 95572, 95573, 95604, 95605, 95606, 95607, 95608, 95851, 96568, 96569, 96570, 96577, 96579, 96915, 96916, 96917, 98427, 98428, 98429, 98438, 98785, 98786, 98788, 98789, 98790, 98793, 98794, 98795, 98796, 98995, 98996, 98997, 98998, 99018, 99019, 99020, 99384, 99385, 99386, 99387, 99388, 99389, 99390, 99391, 99393) AND `item_rank` <> 3 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98796) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2581G1'))))) OR (((`item_id2` = 98796) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2581G1'))))) OR (((`item_id3` = 98796) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2581G1')))))) 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` = 98796 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96579) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2580G4'))))) OR (((`item_id2` = 96579) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2580G4'))))) OR (((`item_id3` = 96579) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2580G4')))))) 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` = 96579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92333) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2577G1'))))) OR (((`item_id2` = 92333) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2577G1'))))) OR (((`item_id3` = 92333) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2577G1')))))) 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` = 92333 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92336) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2577G2'))))) OR (((`item_id2` = 92336) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2577G2'))))) OR (((`item_id3` = 92336) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2577G2')))))) 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` = 92336 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99393) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2580G2'))))) OR (((`item_id2` = 99393) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2580G2'))))) OR (((`item_id3` = 99393) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2580G2')))))) 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` = 99393 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92355) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G1'))))) OR (((`item_id2` = 92355) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G1'))))) OR (((`item_id3` = 92355) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G1')))))) 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` = 92355 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92358) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2577G4'))))) OR (((`item_id2` = 92358) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2577G4'))))) OR (((`item_id3` = 92358) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2577G4')))))) 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` = 92358 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98789) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2578G5'))))) OR (((`item_id2` = 98789) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2578G5'))))) OR (((`item_id3` = 98789) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2578G5')))))) 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` = 98789 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92360) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2578G1'))))) OR (((`item_id2` = 92360) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2578G1'))))) OR (((`item_id3` = 92360) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2578G1')))))) 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` = 92360 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92334) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2577G5'))))) OR (((`item_id2` = 92334) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2577G5'))))) OR (((`item_id3` = 92334) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2577G5')))))) 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` = 92334 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92356) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2576G2'))))) OR (((`item_id2` = 92356) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2576G2'))))) OR (((`item_id3` = 92356) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2576G2')))))) 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` = 92356 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92359) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2577G7'))))) OR (((`item_id2` = 92359) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2577G7'))))) OR (((`item_id3` = 92359) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2577G7')))))) 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` = 92359 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98795) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2579G8'))))) OR (((`item_id2` = 98795) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2579G8'))))) OR (((`item_id3` = 98795) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2579G8')))))) 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` = 98795 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96915) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25101G2A'))))) OR (((`item_id2` = 96915) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25101G2A'))))) OR (((`item_id3` = 96915) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25101G2A')))))) 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` = 96915 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96916) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25101G2B'))))) OR (((`item_id2` = 96916) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25101G2B'))))) OR (((`item_id3` = 96916) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25101G2B')))))) 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` = 96916 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 | |