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 | 272 | 272 | 695 | 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_naming` = 1 AND `Item`.`id` IN (35536, 35537, 35673, 35674, 35675, 35676, 54042, 54043, 54046, 57650, 57650, 57651, 57651, 57652, 57652, 64453, 64604, 64605, 64606, 64670, 64670, 64671, 64671, 64672, 64672, 68346, 68347, 68348, 68349, 73667, 73667, 73776, 73776, 73776, 77219, 77220, 77225, 77225, 77699, 77699, 77700, 77700, 77700, 80665, 80666, 80666, 80667, 80667, 80764, 80765, 80766, 81109, 81109, 81109, 81215, 81552, 81553, 81554, 81555, 81556, 81558, 81730, 83782, 83783, 83832, 83833, 83834, 83834, 83851, 83852, 83897, 83898, 83898, 83899, 83899, 84019, 84241, 84241, 84911, 84911, 84994, 84995, 84996, 84997, 85042, 85043, 85044, 85171, 85171, 85172, 85172, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85398, 85404, 85794, 85794, 86285, 87376, 87377, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87407, 87408, 87722, 87722, 87723, 87723, 87925, 88144, 88925, 90457, 91335, 91336, 91605, 91606, 91607, 91753, 91785, 91790, 91791, 91795, 91836, 91886, 92363, 92700, 92701, 92702, 92703, 92749, 92988, 93016, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94756, 95135, 95135, 95136, 95136, 95137, 95137, 95138, 95138, 95188, 95233, 95234, 95235, 95236, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95355, 95357, 95627, 95628, 95680, 95681, 95682, 95683, 95734, 95735, 95736, 95737, 95738, 95820, 95821, 95822, 96163, 96164, 96165, 96166, 96167, 96178, 96393, 96395, 96504, 96590, 96593, 96596, 96597, 96641, 96671, 96719, 96720, 96839, 96840, 96841, 97368, 97368, 97392, 97615, 97615, 97616, 97616, 97693, 97694, 97695, 97696, 97794, 97794, 97840, 97841, 97842, 97850, 97851, 97852, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98154, 98609, 98610, 98611, 98654, 98655, 98656, 98757, 98758, 98932, 98935, 98937, 98947, 98948, 99422, 99423, 99424, 99425, 99426, 99551, 99555, 99556, 99735) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` asc LIMIT 15 | 15 | 15 | 10 | 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 (35536, 35537, 35673, 35674, 35675, 35676, 54042, 54043, 54046, 57650, 57650, 57651, 57651, 57652, 57652, 64453, 64604, 64605, 64606, 64670, 64670, 64671, 64671, 64672, 64672, 68346, 68347, 68348, 68349, 73667, 73667, 73776, 73776, 73776, 77219, 77220, 77225, 77225, 77699, 77699, 77700, 77700, 77700, 80665, 80666, 80666, 80667, 80667, 80764, 80765, 80766, 81109, 81109, 81109, 81215, 81552, 81553, 81554, 81555, 81556, 81558, 81730, 83782, 83783, 83832, 83833, 83834, 83834, 83851, 83852, 83897, 83898, 83898, 83899, 83899, 84019, 84241, 84241, 84911, 84911, 84994, 84995, 84996, 84997, 85042, 85043, 85044, 85171, 85171, 85172, 85172, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85398, 85404, 85794, 85794, 86285, 87376, 87377, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87407, 87408, 87722, 87722, 87723, 87723, 87925, 88144, 88925, 90457, 91335, 91336, 91605, 91606, 91607, 91753, 91785, 91790, 91791, 91795, 91836, 91886, 92363, 92700, 92701, 92702, 92703, 92749, 92988, 93016, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94756, 95135, 95135, 95136, 95136, 95137, 95137, 95138, 95138, 95188, 95233, 95234, 95235, 95236, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95355, 95357, 95627, 95628, 95680, 95681, 95682, 95683, 95734, 95735, 95736, 95737, 95738, 95820, 95821, 95822, 96163, 96164, 96165, 96166, 96167, 96178, 96393, 96395, 96504, 96590, 96593, 96596, 96597, 96641, 96671, 96719, 96720, 96839, 96840, 96841, 97368, 97368, 97392, 97615, 97615, 97616, 97616, 97693, 97694, 97695, 97696, 97794, 97794, 97840, 97841, 97842, 97850, 97851, 97852, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98154, 98609, 98610, 98611, 98654, 98655, 98656, 98757, 98758, 98932, 98935, 98937, 98947, 98948, 99422, 99423, 99424, 99425, 99426, 99551, 99555, 99556, 99735) 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` = 91795) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25331G12'))))) OR (((`item_id2` = 91795) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25331G12'))))) OR (((`item_id3` = 91795) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25331G12')))))) 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` = 91795 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57650) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1001-009'))))) OR (((`item_id2` = 57650) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1001-009'))))) OR (((`item_id3` = 57650) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1001-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` = 57650 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57651) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1001-044'))))) OR (((`item_id2` = 57651) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1001-044'))))) OR (((`item_id3` = 57651) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1001-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` = 57651 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1001-006'))))) OR (((`item_id2` = 57652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1001-006'))))) OR (((`item_id3` = 57652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1001-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` = 57652 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73667) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1001-002'))))) OR (((`item_id2` = 73667) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1001-002'))))) OR (((`item_id3` = 73667) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1001-002')))))) 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` = 73667 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99735) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25313G3'))))) OR (((`item_id2` = 99735) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25313G3'))))) OR (((`item_id3` = 99735) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25313G3')))))) 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` = 99735 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` = 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` = 97616) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313349'))))) OR (((`item_id2` = 97616) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313349'))))) OR (((`item_id3` = 97616) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313349')))))) 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` = 97616 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95317) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0124-005'))))) OR (((`item_id2` = 95317) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0124-005'))))) OR (((`item_id3` = 95317) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0124-005')))))) 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` = 95317 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95318) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0124-006'))))) OR (((`item_id2` = 95318) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0124-006'))))) OR (((`item_id3` = 95318) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0124-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` = 95318 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95319) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0124-009'))))) OR (((`item_id2` = 95319) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0124-009'))))) OR (((`item_id3` = 95319) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0124-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` = 95319 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95320) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0124-018'))))) OR (((`item_id2` = 95320) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0124-018'))))) OR (((`item_id3` = 95320) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0124-018')))))) 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` = 95320 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 7 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95321) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0124-044'))))) OR (((`item_id2` = 95321) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0124-044'))))) OR (((`item_id3` = 95321) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0124-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` = 95321 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64453) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'BE-60800'))))) OR (((`item_id2` = 64453) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'BE-60800'))))) OR (((`item_id3` = 64453) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'BE-60800')))))) 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` = 64453 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54042) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h14-101243'))))) OR (((`item_id2` = 54042) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h14-101243'))))) OR (((`item_id3` = 54042) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h14-101243')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 54042 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 | |