| 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 `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 `ItemsCategory`.`category_id` = 39 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 209 | 209 | 30 | maybe slow |
| SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 39 AND `Category`.`flg_hidden` = 0 LIMIT 1 | 1 | 1 | 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 (72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72923, 72924, 73029, 73030, 73031, 76977, 83753, 83754, 83755, 83756, 84080, 84086, 84087, 86571, 86583, 91570, 92583, 92609, 94021, 94399, 94400, 94401, 94402, 94403, 94404, 94405, 94406, 94407, 94408, 94409, 94410, 94411, 94412, 94413, 94414, 94415, 94416, 94417, 94418, 94421, 94422, 94423, 94424, 94425, 94426, 94427, 94428, 94429, 94430, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94725, 94726, 94727, 94728, 94729, 94730, 94731, 94732, 94733, 94734, 94735, 94736, 94737, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95530, 95531, 95532, 95533, 95534, 95535, 95536, 95537, 95538, 95539, 95540, 96016, 96017, 96018, 96020, 96021, 96022, 96024, 96025, 96026, 96027, 96028, 96029, 96030, 96031, 96033, 96034, 96036, 96037, 96038, 96361, 96362, 96363, 96364, 96365, 97366, 97615, 97616, 97716, 97717, 97718, 98042, 98043, 98044, 98045, 98049, 98050, 98051, 98052, 98053, 98054, 98055, 98056, 98057, 98058, 98059, 98060, 98061, 98062, 98063, 98064, 98185, 98688, 98689, 98690, 98691, 98692, 98693, 98694, 98695, 98696, 98697, 99650, 99651, 99652, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99661, 99662, 99663, 99664, 99665, 99666, 99667, 99668, 99669, 99670, 99671, 99672) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 20 | 20 | 20 | 1 | maybe slow |
| SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` IN (97615, 98185, 98064, 98045, 98063, 98044, 98062, 98043, 98061, 98042, 98060, 98059, 98058, 98057, 98056, 98055, 98054, 98053, 98052, 98051) | 53 | 53 | 24 | 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 (72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72923, 72924, 73029, 73030, 73031, 76977, 83753, 83754, 83755, 83756, 84080, 84086, 84087, 86571, 86583, 91570, 92583, 92609, 94021, 94399, 94400, 94401, 94402, 94403, 94404, 94405, 94406, 94407, 94408, 94409, 94410, 94411, 94412, 94413, 94414, 94415, 94416, 94417, 94418, 94421, 94422, 94423, 94424, 94425, 94426, 94427, 94428, 94429, 94430, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94725, 94726, 94727, 94728, 94729, 94730, 94731, 94732, 94733, 94734, 94735, 94736, 94737, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95530, 95531, 95532, 95533, 95534, 95535, 95536, 95537, 95538, 95539, 95540, 96016, 96017, 96018, 96020, 96021, 96022, 96024, 96025, 96026, 96027, 96028, 96029, 96030, 96031, 96033, 96034, 96036, 96037, 96038, 96361, 96362, 96363, 96364, 96365, 97366, 97615, 97616, 97716, 97717, 97718, 98042, 98043, 98044, 98045, 98049, 98050, 98051, 98052, 98053, 98054, 98055, 98056, 98057, 98058, 98059, 98060, 98061, 98062, 98063, 98064, 98185, 98688, 98689, 98690, 98691, 98692, 98693, 98694, 98695, 98696, 98697, 99650, 99651, 99652, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99661, 99662, 99663, 99664, 99665, 99666, 99667, 99668, 99669, 99670, 99671, 99672) AND `item_rank` <> 3 | 1 | 1 | 1 | |
| 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` = 97615 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97615) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313240'))))) OR (((`item_id2` = 97615) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313240'))))) OR (((`item_id3` = 97615) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313240')))))) 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` = 98185 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98185) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36144'))))) OR (((`item_id2` = 98185) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36144'))))) OR (((`item_id3` = 98185) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36144')))))) 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` = 98064 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98064) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1053-004'))))) OR (((`item_id2` = 98064) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1053-004'))))) OR (((`item_id3` = 98064) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1053-004')))))) 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` = 98045 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98045) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0018-044'))))) OR (((`item_id2` = 98045) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0018-044'))))) OR (((`item_id3` = 98045) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0018-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` = 98063 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98063) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1058-004'))))) OR (((`item_id2` = 98063) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1058-004'))))) OR (((`item_id3` = 98063) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1058-004')))))) 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` = 98044 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98044) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0018-009'))))) OR (((`item_id2` = 98044) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0018-009'))))) OR (((`item_id3` = 98044) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0018-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` = 98062 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98062) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1055-004'))))) OR (((`item_id2` = 98062) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1055-004'))))) OR (((`item_id3` = 98062) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1055-004')))))) 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` = 98043 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98043) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0018-034'))))) OR (((`item_id2` = 98043) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0018-034'))))) OR (((`item_id3` = 98043) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0018-034')))))) 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` = 98061 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98061) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1054-004'))))) OR (((`item_id2` = 98061) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1054-004'))))) OR (((`item_id3` = 98061) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1054-004')))))) 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` = 98042 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98042) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0018-002'))))) OR (((`item_id2` = 98042) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0018-002'))))) OR (((`item_id3` = 98042) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0018-002')))))) 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` = 98060 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98060) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1056-004'))))) OR (((`item_id2` = 98060) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1056-004'))))) OR (((`item_id3` = 98060) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1056-004')))))) 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` = 98059 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98059) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1057-004'))))) OR (((`item_id2` = 98059) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1057-004'))))) OR (((`item_id3` = 98059) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1057-004')))))) 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` = 98058 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98058) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1061-004'))))) OR (((`item_id2` = 98058) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1061-004'))))) OR (((`item_id3` = 98058) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1061-004')))))) 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` = 98057 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98057) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1060-004'))))) OR (((`item_id2` = 98057) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1060-004'))))) OR (((`item_id3` = 98057) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1060-004')))))) 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` = 98056 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98056) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0011-009'))))) OR (((`item_id2` = 98056) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0011-009'))))) OR (((`item_id3` = 98056) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0011-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` = 98055 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98055) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0011-044'))))) OR (((`item_id2` = 98055) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0011-044'))))) OR (((`item_id3` = 98055) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0011-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` = 98054 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98054) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0010-044'))))) OR (((`item_id2` = 98054) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0010-044'))))) OR (((`item_id3` = 98054) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0010-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` = 98053 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98053) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0010-009'))))) OR (((`item_id2` = 98053) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0010-009'))))) OR (((`item_id3` = 98053) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0010-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` = 98052 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98052) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1059-004'))))) OR (((`item_id2` = 98052) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1059-004'))))) OR (((`item_id3` = 98052) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1059-004')))))) 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` = 98051 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98051) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0009-009'))))) OR (((`item_id2` = 98051) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0009-009'))))) OR (((`item_id3` = 98051) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0009-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 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 | |
