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 | 256 | 256 | 215 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_speed` = 1 AND `Item`.`id` IN (48175, 48176, 57650, 57650, 57651, 57651, 57652, 57652, 64604, 64605, 64606, 73667, 73667, 77213, 77214, 77616, 77616, 77617, 77617, 77634, 77635, 77636, 77637, 79415, 82873, 82877, 83515, 83584, 85171, 85171, 85172, 85172, 85275, 85276, 85277, 85288, 85290, 86079, 86109, 86110, 86345, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88278, 88279, 88280, 88884, 88885, 88886, 88887, 89501, 90319, 90992, 90993, 90994, 90995, 91120, 91120, 91121, 91121, 91122, 91393, 91394, 91395, 91396, 91397, 91744, 91745, 91937, 91941, 91942, 91943, 91949, 91950, 92282, 92695, 92696, 92697, 92698, 92699, 92724, 92725, 92728, 92729, 92730, 92731, 92732, 92884, 92885, 93016, 93939, 93942, 93945, 93949, 93968, 94347, 94348, 94349, 94350, 94352, 94353, 94359, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94518, 94519, 94520, 94521, 94571, 94572, 94573, 94574, 94746, 94821, 94830, 94830, 94850, 94851, 95086, 95336, 95337, 95418, 95419, 95420, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95654, 95655, 95781, 95782, 95820, 95821, 95822, 95924, 96485, 96486, 96487, 96647, 96779, 96893, 96894, 96895, 96896, 96897, 96898, 96899, 96900, 96901, 96902, 97366, 97366, 97395, 97668, 97668, 97669, 97669, 97670, 97670, 97671, 97671, 97672, 97672, 97673, 97673, 98122, 98123, 98152, 98153, 98158, 98159, 98160, 98161, 98178, 98425, 98426, 98430, 98431, 98438, 98647, 98648, 98679, 98680, 98681, 98721, 98757, 98758, 98848, 98866, 98890, 98891, 98892, 98894, 98895, 98896, 98897, 98898, 98955, 98956, 98967, 98968, 98990, 98991, 99362, 99363, 99533, 99540, 99541, 99542, 99562, 99563, 99564, 99568, 99569, 99570, 99576) AND `item_rank` <> 3 ORDER BY `Cnt`.`pagecnt` desc LIMIT 15, 15 | 15 | 15 | 3 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_speed` = 1 AND `Item`.`id` IN (48175, 48176, 57650, 57650, 57651, 57651, 57652, 57652, 64604, 64605, 64606, 73667, 73667, 77213, 77214, 77616, 77616, 77617, 77617, 77634, 77635, 77636, 77637, 79415, 82873, 82877, 83515, 83584, 85171, 85171, 85172, 85172, 85275, 85276, 85277, 85288, 85290, 86079, 86109, 86110, 86345, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88278, 88279, 88280, 88884, 88885, 88886, 88887, 89501, 90319, 90992, 90993, 90994, 90995, 91120, 91120, 91121, 91121, 91122, 91393, 91394, 91395, 91396, 91397, 91744, 91745, 91937, 91941, 91942, 91943, 91949, 91950, 92282, 92695, 92696, 92697, 92698, 92699, 92724, 92725, 92728, 92729, 92730, 92731, 92732, 92884, 92885, 93016, 93939, 93942, 93945, 93949, 93968, 94347, 94348, 94349, 94350, 94352, 94353, 94359, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94518, 94519, 94520, 94521, 94571, 94572, 94573, 94574, 94746, 94821, 94830, 94830, 94850, 94851, 95086, 95336, 95337, 95418, 95419, 95420, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95654, 95655, 95781, 95782, 95820, 95821, 95822, 95924, 96485, 96486, 96487, 96647, 96779, 96893, 96894, 96895, 96896, 96897, 96898, 96899, 96900, 96901, 96902, 97366, 97366, 97395, 97668, 97668, 97669, 97669, 97670, 97670, 97671, 97671, 97672, 97672, 97673, 97673, 98122, 98123, 98152, 98153, 98158, 98159, 98160, 98161, 98178, 98425, 98426, 98430, 98431, 98438, 98647, 98648, 98679, 98680, 98681, 98721, 98757, 98758, 98848, 98866, 98890, 98891, 98892, 98894, 98895, 98896, 98897, 98898, 98955, 98956, 98967, 98968, 98990, 98991, 99362, 99363, 99533, 99540, 99541, 99542, 99562, 99563, 99564, 99568, 99569, 99570, 99576) 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` = 88232) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1693-044'))))) OR (((`item_id2` = 88232) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1693-044'))))) OR (((`item_id3` = 88232) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1693-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` = 88232 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87902) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1655-044'))))) OR (((`item_id2` = 87902) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1655-044'))))) OR (((`item_id3` = 87902) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1655-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` = 87902 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88235) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1692-044'))))) OR (((`item_id2` = 88235) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1692-044'))))) OR (((`item_id3` = 88235) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1692-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` = 88235 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87901) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1655-009'))))) OR (((`item_id2` = 87901) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1655-009'))))) OR (((`item_id3` = 87901) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1655-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` = 87901 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87900) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1655-006'))))) OR (((`item_id2` = 87900) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1655-006'))))) OR (((`item_id3` = 87900) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1655-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` = 87900 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88230) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1693-008'))))) OR (((`item_id2` = 88230) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1693-008'))))) OR (((`item_id3` = 88230) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1693-008')))))) 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` = 88230 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87898) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1654-044'))))) OR (((`item_id2` = 87898) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1654-044'))))) OR (((`item_id3` = 87898) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1654-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` = 87898 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87899) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1655-002'))))) OR (((`item_id2` = 87899) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1655-002'))))) OR (((`item_id3` = 87899) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1655-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` = 87899 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87896) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1654-006'))))) OR (((`item_id2` = 87896) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1654-006'))))) OR (((`item_id3` = 87896) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1654-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` = 87896 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1811-007'))))) OR (((`item_id2` = 94432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1811-007'))))) OR (((`item_id3` = 94432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1811-007')))))) 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` = 94432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88234) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1692-008'))))) OR (((`item_id2` = 88234) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1692-008'))))) OR (((`item_id3` = 88234) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1692-008')))))) 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` = 88234 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90992) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1692-030'))))) OR (((`item_id2` = 90992) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1692-030'))))) OR (((`item_id3` = 90992) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1692-030')))))) 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` = 90992 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90994) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1693-030'))))) OR (((`item_id2` = 90994) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1693-030'))))) OR (((`item_id3` = 90994) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1693-030')))))) 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` = 90994 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90995) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1693-034'))))) OR (((`item_id2` = 90995) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1693-034'))))) OR (((`item_id3` = 90995) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1693-034')))))) 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` = 90995 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90993) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1692-034'))))) OR (((`item_id2` = 90993) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1692-034'))))) OR (((`item_id3` = 90993) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1692-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` = 90993 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | |