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 '%目もとひんやりシート1枚%') OR (`Item`.`item_name` Like '%目もとひんやりシート1枚%') OR (`Item`.`item_figure` Like '%目もとひんやりシート1枚%') OR (`Item`.`item_color` Like '%目もとひんやりシート1枚%') OR (`Item`.`item_materials` Like '%目もとひんやりシート1枚%') OR (`Item`.`item_note` Like '%目もとひんやりシート1枚%') 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 | 242 | 242 | 431 | 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`.`item_rank` = 1 AND `Item`.`id` IN (35169, 58154, 58156, 58156, 58157, 58158, 76977, 76977, 77244, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 78159, 83891, 83892, 83892, 83893, 86833, 86834, 86835, 86836, 89931, 89932, 89933, 91430, 91431, 91432, 91433, 91434, 91465, 91466, 91467, 91468, 91469, 91470, 93185, 93592, 93594, 94279, 94280, 94281, 94282, 94283, 94284, 94285, 94286, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94317, 94318, 94318, 94319, 94319, 94321, 94321, 94322, 94322, 94323, 94324, 94325, 94326, 94335, 94336, 94550, 94551, 94552, 94553, 94554, 94555, 94556, 94557, 94558, 94559, 94560, 94561, 94562, 94563, 94564, 94565, 94566, 94567, 94568, 94569, 94570, 94571, 94572, 94573, 94574, 94854, 94855, 94856, 95205, 95206, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95415, 95416, 95418, 95419, 95420, 95421, 95422, 95423, 95760, 96209, 96365, 96749, 96771, 97186, 97187, 97188, 97189, 97605, 97606, 97607, 97608, 97609, 97610, 97611, 97612, 97613, 97614, 97615, 97615, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97674, 97677, 97678, 97679, 97680, 97681, 97682, 97683, 97684, 97685, 97838, 98492, 98492, 98493, 98493, 98533, 98534, 98535, 98536, 98626, 98718, 98719, 98760, 99262, 99263, 99362, 99363, 99511, 99512) 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`.`item_rank` = 1 AND `Item`.`id` IN (35169, 58154, 58156, 58156, 58157, 58158, 76977, 76977, 77244, 77246, 77246, 77247, 77248, 77249, 77250, 77250, 77251, 77251, 77252, 77253, 78159, 83891, 83892, 83892, 83893, 86833, 86834, 86835, 86836, 89931, 89932, 89933, 91430, 91431, 91432, 91433, 91434, 91465, 91466, 91467, 91468, 91469, 91470, 93185, 93592, 93594, 94279, 94280, 94281, 94282, 94283, 94284, 94285, 94286, 94287, 94288, 94289, 94290, 94290, 94291, 94291, 94292, 94292, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94317, 94318, 94318, 94319, 94319, 94321, 94321, 94322, 94322, 94323, 94324, 94325, 94326, 94335, 94336, 94550, 94551, 94552, 94553, 94554, 94555, 94556, 94557, 94558, 94559, 94560, 94561, 94562, 94563, 94564, 94565, 94566, 94567, 94568, 94569, 94570, 94571, 94572, 94573, 94574, 94854, 94855, 94856, 95205, 95206, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95415, 95416, 95418, 95419, 95420, 95421, 95422, 95423, 95760, 96209, 96365, 96749, 96771, 97186, 97187, 97188, 97189, 97605, 97606, 97607, 97608, 97609, 97610, 97611, 97612, 97613, 97614, 97615, 97615, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97646, 97647, 97648, 97649, 97650, 97651, 97652, 97653, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97674, 97677, 97678, 97679, 97680, 97681, 97682, 97683, 97684, 97685, 97838, 98492, 98492, 98493, 98493, 98533, 98534, 98535, 98536, 98626, 98718, 98719, 98760, 99262, 99263, 99362, 99363, 99511, 99512) 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` = 97650) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-317149'))))) OR (((`item_id2` = 97650) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-317149'))))) OR (((`item_id3` = 97650) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-317149')))))) 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` = 97650 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97651) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-317248'))))) OR (((`item_id2` = 97651) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-317248'))))) OR (((`item_id3` = 97651) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-317248')))))) 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` = 97651 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-317347'))))) OR (((`item_id2` = 97652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-317347'))))) OR (((`item_id3` = 97652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-317347')))))) 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` = 97652 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97653) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-317446'))))) OR (((`item_id2` = 97653) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-317446'))))) OR (((`item_id3` = 97653) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-317446')))))) 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` = 97653 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94568) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-296345'))))) OR (((`item_id2` = 94568) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-296345'))))) OR (((`item_id3` = 94568) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-296345')))))) 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` = 94568 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94569) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-296444'))))) OR (((`item_id2` = 94569) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-296444'))))) OR (((`item_id3` = 94569) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-296444')))))) 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` = 94569 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94570) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-296543'))))) OR (((`item_id2` = 94570) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-296543'))))) OR (((`item_id3` = 94570) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-296543')))))) 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` = 94570 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97642) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-303845'))))) OR (((`item_id2` = 97642) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-303845'))))) OR (((`item_id3` = 97642) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-303845')))))) 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` = 97642 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97643) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-303944'))))) OR (((`item_id2` = 97643) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-303944'))))) OR (((`item_id3` = 97643) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-303944')))))) 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` = 97643 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97644) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-304040'))))) OR (((`item_id2` = 97644) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-304040'))))) OR (((`item_id3` = 97644) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-304040')))))) 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` = 97644 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-304149'))))) OR (((`item_id2` = 97645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-304149'))))) OR (((`item_id3` = 97645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-304149')))))) 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` = 97645 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97646) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-316746'))))) OR (((`item_id2` = 97646) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-316746'))))) OR (((`item_id3` = 97646) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-316746')))))) 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` = 97646 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97647) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-316845'))))) OR (((`item_id2` = 97647) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-316845'))))) OR (((`item_id3` = 97647) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-316845')))))) 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` = 97647 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97648) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-316944'))))) OR (((`item_id2` = 97648) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-316944'))))) OR (((`item_id3` = 97648) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-316944')))))) 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` = 97648 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97649) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-317040'))))) OR (((`item_id2` = 97649) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-317040'))))) OR (((`item_id3` = 97649) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-317040')))))) 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` = 97649 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 | |