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 | 305 | 305 | 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`.`item_naming` = 1 AND `Item`.`id` IN (34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34865, 34866, 35018, 44763, 44764, 64473, 64473, 64547, 64547, 64652, 64654, 65269, 65270, 65271, 65271, 65272, 65272, 65273, 65273, 65274, 65276, 65276, 65277, 65277, 69675, 69846, 73613, 73614, 78159, 80538, 80538, 80646, 80646, 82630, 83754, 83754, 83755, 83755, 83756, 83756, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83860, 84117, 84118, 84119, 84120, 84493, 84493, 84494, 84494, 84495, 84495, 84572, 84573, 84574, 84581, 84582, 85520, 85675, 85676, 85677, 85681, 85682, 85683, 87448, 87809, 87890, 87891, 87925, 88150, 88644, 88645, 88647, 90325, 90326, 90326, 90449, 90450, 90462, 91037, 91120, 91120, 91121, 91121, 91122, 91129, 91129, 91435, 91436, 91437, 91438, 91439, 91892, 92022, 92023, 92583, 92615, 92619, 92625, 92626, 92627, 92630, 92631, 92640, 92641, 92646, 92650, 92652, 92659, 92669, 92670, 92673, 92675, 93178, 93682, 93683, 93976, 93976, 94342, 94342, 94344, 94488, 94489, 94490, 94491, 94492, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94530, 94531, 94532, 94533, 94534, 94535, 94536, 94537, 94538, 94539, 94540, 94541, 94542, 94543, 94544, 94545, 94743, 94755, 94819, 94819, 95251, 95252, 95270, 95271, 95359, 95359, 95361, 95502, 95503, 95504, 95505, 95667, 95774, 95774, 95775, 95775, 95776, 95777, 95778, 95778, 95779, 95779, 95785, 95785, 95937, 95938, 95939, 95940, 95941, 95942, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 96659, 96660, 96661, 96663, 96664, 96666, 96667, 96668, 96669, 96671, 96677, 97362, 97368, 97368, 97369, 97690, 97691, 97692, 97726, 97726, 97796, 98079, 98080, 98081, 98082, 98083, 98084, 98120, 98121, 98122, 98124, 98124, 98125, 98125, 98126, 98127, 98135, 98136, 98137, 98138, 98437, 98437, 98440, 98440, 98440, 98547, 98548, 98549, 98550, 98551, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98605, 98606, 98607, 98608, 98622, 98623, 98624, 98625, 98633, 98634, 98642, 98643, 98644, 98645, 98646, 98751, 98752, 99412, 99413, 99414, 99415, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` desc LIMIT 135, 15 | 15 | 15 | 4 | 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_naming` = 1 AND `Item`.`id` IN (34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34865, 34866, 35018, 44763, 44764, 64473, 64473, 64547, 64547, 64652, 64654, 65269, 65270, 65271, 65271, 65272, 65272, 65273, 65273, 65274, 65276, 65276, 65277, 65277, 69675, 69846, 73613, 73614, 78159, 80538, 80538, 80646, 80646, 82630, 83754, 83754, 83755, 83755, 83756, 83756, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83860, 84117, 84118, 84119, 84120, 84493, 84493, 84494, 84494, 84495, 84495, 84572, 84573, 84574, 84581, 84582, 85520, 85675, 85676, 85677, 85681, 85682, 85683, 87448, 87809, 87890, 87891, 87925, 88150, 88644, 88645, 88647, 90325, 90326, 90326, 90449, 90450, 90462, 91037, 91120, 91120, 91121, 91121, 91122, 91129, 91129, 91435, 91436, 91437, 91438, 91439, 91892, 92022, 92023, 92583, 92615, 92619, 92625, 92626, 92627, 92630, 92631, 92640, 92641, 92646, 92650, 92652, 92659, 92669, 92670, 92673, 92675, 93178, 93682, 93683, 93976, 93976, 94342, 94342, 94344, 94488, 94489, 94490, 94491, 94492, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94530, 94531, 94532, 94533, 94534, 94535, 94536, 94537, 94538, 94539, 94540, 94541, 94542, 94543, 94544, 94545, 94743, 94755, 94819, 94819, 95251, 95252, 95270, 95271, 95359, 95359, 95361, 95502, 95503, 95504, 95505, 95667, 95774, 95774, 95775, 95775, 95776, 95777, 95778, 95778, 95779, 95779, 95785, 95785, 95937, 95938, 95939, 95940, 95941, 95942, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 96659, 96660, 96661, 96663, 96664, 96666, 96667, 96668, 96669, 96671, 96677, 97362, 97368, 97368, 97369, 97690, 97691, 97692, 97726, 97726, 97796, 98079, 98080, 98081, 98082, 98083, 98084, 98120, 98121, 98122, 98124, 98124, 98125, 98125, 98126, 98127, 98135, 98136, 98137, 98138, 98437, 98437, 98440, 98440, 98440, 98547, 98548, 98549, 98550, 98551, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98605, 98606, 98607, 98608, 98622, 98623, 98624, 98625, 98633, 98634, 98642, 98643, 98644, 98645, 98646, 98751, 98752, 99412, 99413, 99414, 99415, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426) 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` = 83843) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0991-028'))))) OR (((`item_id2` = 83843) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0991-028'))))) OR (((`item_id3` = 83843) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0991-028')))))) 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` = 83843 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92673) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25273G10'))))) OR (((`item_id2` = 92673) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25273G10'))))) OR (((`item_id3` = 92673) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25273G10')))))) 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` = 92673 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325320'))))) OR (((`item_id2` = 97362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325320'))))) OR (((`item_id3` = 97362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325320')))))) 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` = 97362 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99417) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25274G10A'))))) OR (((`item_id2` = 99417) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25274G10A'))))) OR (((`item_id3` = 99417) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25274G10A')))))) 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` = 99417 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99418) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25274G10B'))))) OR (((`item_id2` = 99418) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25274G10B'))))) OR (((`item_id3` = 99418) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25274G10B')))))) 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` = 99418 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99419) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25274G10C'))))) OR (((`item_id2` = 99419) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25274G10C'))))) OR (((`item_id3` = 99419) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25274G10C')))))) 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` = 99419 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99420) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25274G10D'))))) OR (((`item_id2` = 99420) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25274G10D'))))) OR (((`item_id3` = 99420) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25274G10D')))))) 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` = 99420 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84117) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'EP-6195A'))))) OR (((`item_id2` = 84117) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'EP-6195A'))))) OR (((`item_id3` = 84117) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'EP-6195A')))))) 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` = 84117 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84118) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'EP-6195B'))))) OR (((`item_id2` = 84118) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'EP-6195B'))))) OR (((`item_id3` = 84118) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'EP-6195B')))))) 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` = 84118 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84119) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'EP-6195C'))))) OR (((`item_id2` = 84119) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'EP-6195C'))))) OR (((`item_id3` = 84119) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'EP-6195C')))))) 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` = 84119 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84120) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'EP-6195D'))))) OR (((`item_id2` = 84120) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'EP-6195D'))))) OR (((`item_id3` = 84120) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'EP-6195D')))))) 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` = 84120 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34865) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0279-009'))))) OR (((`item_id2` = 34865) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0279-009'))))) OR (((`item_id3` = 34865) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0279-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` = 34865 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34866) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0279-012'))))) OR (((`item_id2` = 34866) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0279-012'))))) OR (((`item_id3` = 34866) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0279-012')))))) 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` = 34866 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98565) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0027-009'))))) OR (((`item_id2` = 98565) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0027-009'))))) OR (((`item_id3` = 98565) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0027-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` = 98565 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98566) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0027-028'))))) OR (((`item_id2` = 98566) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0027-028'))))) OR (((`item_id3` = 98566) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0027-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` = 98566 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 | |