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 | 503 | 503 | 224 | 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 (34936, 34936, 35536, 35537, 35555, 35556, 35625, 35626, 35638, 35639, 35640, 44760, 44760, 44794, 44794, 44794, 57695, 57696, 57697, 57714, 57715, 64470, 64471, 64472, 64473, 64473, 64475, 64475, 64476, 64481, 64547, 64547, 64604, 64605, 64606, 64686, 65204, 65334, 65335, 71525, 71526, 73613, 73614, 77075, 77668, 77668, 77669, 77670, 77695, 77696, 78142, 80537, 81150, 81150, 81177, 81721, 83873, 83874, 83875, 84112, 84113, 84116, 84121, 84121, 84122, 84122, 84155, 84157, 84158, 84165, 84169, 84173, 84174, 84343, 84343, 84344, 84344, 84345, 84345, 85012, 85012, 85019, 85020, 85021, 85022, 85023, 85024, 85441, 85442, 85491, 85505, 85639, 85640, 85641, 85723, 85723, 85794, 85794, 86033, 86034, 86035, 86036, 86037, 86097, 87263, 87413, 87821, 87822, 88685, 89033, 89034, 89980, 90329, 90436, 90437, 90438, 90439, 90682, 90682, 90683, 90683, 90684, 90684, 91029, 91030, 91037, 91122, 91133, 91134, 91322, 91322, 91323, 91387, 91481, 91500, 91501, 91502, 91503, 91504, 91517, 91586, 91586, 91608, 91609, 91610, 91611, 91612, 91613, 91614, 91615, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91631, 91631, 91632, 91632, 91633, 91633, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91667, 91668, 91669, 91670, 91671, 91672, 91673, 91719, 91720, 91754, 91904, 91923, 91924, 91925, 91937, 91941, 91942, 91943, 92180, 92181, 92182, 92183, 92185, 92186, 92300, 92389, 92390, 92391, 92395, 92396, 92397, 92511, 92646, 92804, 92880, 92884, 92885, 92890, 92933, 92934, 93054, 93598, 93631, 93636, 93955, 94342, 94342, 94359, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94455, 94456, 94457, 94458, 94600, 94600, 94601, 94601, 94653, 94654, 94655, 94656, 94657, 94658, 94721, 94722, 94723, 94724, 94743, 94755, 94756, 94761, 94830, 94830, 94847, 94848, 94849, 95156, 95159, 95185, 95346, 95349, 95353, 95354, 95356, 95359, 95359, 95591, 95592, 95593, 95594, 95595, 95596, 95597, 95598, 95599, 95600, 95601, 95611, 95614, 95615, 95668, 95669, 95670, 95671, 95746, 95759, 95767, 95772, 95774, 95774, 95778, 95778, 95788, 95845, 95846, 95847, 95863, 95864, 95865, 95940, 95952, 95953, 96210, 96211, 96212, 96213, 96215, 96356, 96379, 96381, 96425, 96437, 96450, 96454, 96485, 96486, 96487, 96504, 96550, 96551, 96552, 96562, 96659, 96660, 96671, 96731, 96743, 96852, 96853, 96854, 96855, 96929, 96932, 96933, 96935, 96937, 96938, 96968, 97360, 97360, 97362, 97376, 97388, 97674, 97797, 97798, 97808, 97840, 97841, 97842, 98108, 98109, 98110, 98111, 98112, 98113, 98114, 98115, 98118, 98118, 98120, 98123, 98126, 98127, 98136, 98137, 98138, 98167, 98169, 98169, 98179, 98424, 98434, 98525, 98526, 98527, 98528, 98605, 98606, 98607, 98608, 98638, 98640, 98641, 98642, 98643, 98644, 98645, 98657, 98659, 98660, 98661, 98665, 98698, 98731, 98732, 98733, 98734, 98751, 98752, 98753, 98754, 98765, 98766, 98772, 98773, 98824, 98836, 98840, 98841, 98842, 98843, 98844, 98848, 98882, 98883, 98884, 98885, 98886, 98887, 98889, 98890, 98891, 98892, 98894, 98895, 98896, 98897, 98917, 98918, 98955, 98956, 99021, 99022, 99023, 99024, 99025, 99026, 99038, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99053, 99054, 99055, 99056, 99057, 99058, 99299, 99364, 99365, 99366, 99367, 99368, 99403, 99404, 99405, 99406, 99421, 99444, 99476, 99489, 99547, 99548, 99550, 99565, 99568, 99569, 99570, 99571, 99633, 99634, 99635, 99636, 99652, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99776, 99777, 99778, 99779) 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 (34936, 34936, 35536, 35537, 35555, 35556, 35625, 35626, 35638, 35639, 35640, 44760, 44760, 44794, 44794, 44794, 57695, 57696, 57697, 57714, 57715, 64470, 64471, 64472, 64473, 64473, 64475, 64475, 64476, 64481, 64547, 64547, 64604, 64605, 64606, 64686, 65204, 65334, 65335, 71525, 71526, 73613, 73614, 77075, 77668, 77668, 77669, 77670, 77695, 77696, 78142, 80537, 81150, 81150, 81177, 81721, 83873, 83874, 83875, 84112, 84113, 84116, 84121, 84121, 84122, 84122, 84155, 84157, 84158, 84165, 84169, 84173, 84174, 84343, 84343, 84344, 84344, 84345, 84345, 85012, 85012, 85019, 85020, 85021, 85022, 85023, 85024, 85441, 85442, 85491, 85505, 85639, 85640, 85641, 85723, 85723, 85794, 85794, 86033, 86034, 86035, 86036, 86037, 86097, 87263, 87413, 87821, 87822, 88685, 89033, 89034, 89980, 90329, 90436, 90437, 90438, 90439, 90682, 90682, 90683, 90683, 90684, 90684, 91029, 91030, 91037, 91122, 91133, 91134, 91322, 91322, 91323, 91387, 91481, 91500, 91501, 91502, 91503, 91504, 91517, 91586, 91586, 91608, 91609, 91610, 91611, 91612, 91613, 91614, 91615, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91631, 91631, 91632, 91632, 91633, 91633, 91660, 91661, 91662, 91663, 91664, 91665, 91666, 91667, 91668, 91669, 91670, 91671, 91672, 91673, 91719, 91720, 91754, 91904, 91923, 91924, 91925, 91937, 91941, 91942, 91943, 92180, 92181, 92182, 92183, 92185, 92186, 92300, 92389, 92390, 92391, 92395, 92396, 92397, 92511, 92646, 92804, 92880, 92884, 92885, 92890, 92933, 92934, 93054, 93598, 93631, 93636, 93955, 94342, 94342, 94359, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94455, 94456, 94457, 94458, 94600, 94600, 94601, 94601, 94653, 94654, 94655, 94656, 94657, 94658, 94721, 94722, 94723, 94724, 94743, 94755, 94756, 94761, 94830, 94830, 94847, 94848, 94849, 95156, 95159, 95185, 95346, 95349, 95353, 95354, 95356, 95359, 95359, 95591, 95592, 95593, 95594, 95595, 95596, 95597, 95598, 95599, 95600, 95601, 95611, 95614, 95615, 95668, 95669, 95670, 95671, 95746, 95759, 95767, 95772, 95774, 95774, 95778, 95778, 95788, 95845, 95846, 95847, 95863, 95864, 95865, 95940, 95952, 95953, 96210, 96211, 96212, 96213, 96215, 96356, 96379, 96381, 96425, 96437, 96450, 96454, 96485, 96486, 96487, 96504, 96550, 96551, 96552, 96562, 96659, 96660, 96671, 96731, 96743, 96852, 96853, 96854, 96855, 96929, 96932, 96933, 96935, 96937, 96938, 96968, 97360, 97360, 97362, 97376, 97388, 97674, 97797, 97798, 97808, 97840, 97841, 97842, 98108, 98109, 98110, 98111, 98112, 98113, 98114, 98115, 98118, 98118, 98120, 98123, 98126, 98127, 98136, 98137, 98138, 98167, 98169, 98169, 98179, 98424, 98434, 98525, 98526, 98527, 98528, 98605, 98606, 98607, 98608, 98638, 98640, 98641, 98642, 98643, 98644, 98645, 98657, 98659, 98660, 98661, 98665, 98698, 98731, 98732, 98733, 98734, 98751, 98752, 98753, 98754, 98765, 98766, 98772, 98773, 98824, 98836, 98840, 98841, 98842, 98843, 98844, 98848, 98882, 98883, 98884, 98885, 98886, 98887, 98889, 98890, 98891, 98892, 98894, 98895, 98896, 98897, 98917, 98918, 98955, 98956, 99021, 99022, 99023, 99024, 99025, 99026, 99038, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99053, 99054, 99055, 99056, 99057, 99058, 99299, 99364, 99365, 99366, 99367, 99368, 99403, 99404, 99405, 99406, 99421, 99444, 99476, 99489, 99547, 99548, 99550, 99565, 99568, 99569, 99570, 99571, 99633, 99634, 99635, 99636, 99652, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99776, 99777, 99778, 99779) 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` = 91941) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25312G7A'))))) OR (((`item_id2` = 91941) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25312G7A'))))) OR (((`item_id3` = 91941) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25312G7A')))))) 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` = 91941 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95774) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35859'))))) OR (((`item_id2` = 95774) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35859'))))) OR (((`item_id3` = 95774) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35859')))))) 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` = 95774 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97360) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325230'))))) OR (((`item_id2` = 97360) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325230'))))) OR (((`item_id3` = 97360) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325230')))))) 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` = 97360 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 | 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` = 98167 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98608) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-028'))))) OR (((`item_id2` = 98608) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-028'))))) OR (((`item_id3` = 98608) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-028')))))) 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` = 98608 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-011'))))) OR (((`item_id2` = 98607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-011'))))) OR (((`item_id3` = 98607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98607 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98606) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-009'))))) OR (((`item_id2` = 98606) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-009'))))) OR (((`item_id3` = 98606) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98606 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98605) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-006'))))) OR (((`item_id2` = 98605) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-006'))))) OR (((`item_id3` = 98605) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-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` = 98605 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98528) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0154-044'))))) OR (((`item_id2` = 98528) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0154-044'))))) OR (((`item_id3` = 98528) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0154-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` = 98528 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98527) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0154-009'))))) OR (((`item_id2` = 98527) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0154-009'))))) OR (((`item_id3` = 98527) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0154-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` = 98527 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98526) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0154-006'))))) OR (((`item_id2` = 98526) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0154-006'))))) OR (((`item_id3` = 98526) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0154-006')))))) 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` = 98526 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98525) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0154-002'))))) OR (((`item_id2` = 98525) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0154-002'))))) OR (((`item_id3` = 98525) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0154-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` = 98525 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98114) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36104'))))) OR (((`item_id2` = 98114) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36104'))))) OR (((`item_id3` = 98114) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36104')))))) 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` = 98114 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98115) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36103'))))) OR (((`item_id2` = 98115) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36103'))))) OR (((`item_id3` = 98115) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36103')))))) 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` = 98115 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98424) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36218'))))) OR (((`item_id2` = 98424) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36218'))))) OR (((`item_id3` = 98424) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36218')))))) 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` = 98424 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 | |