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 | 241 | 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 (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 `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 1 | 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 (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 | 1 | |
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` = 98426) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36209'))))) OR (((`item_id2` = 98426) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36209'))))) OR (((`item_id3` = 98426) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36209')))))) 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` = 98426 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98430) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36237'))))) OR (((`item_id2` = 98430) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36237'))))) OR (((`item_id3` = 98430) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36237')))))) 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` = 98430 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98431) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36199'))))) OR (((`item_id2` = 98431) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36199'))))) OR (((`item_id3` = 98431) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36199')))))) 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` = 98431 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98438) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36212'))))) OR (((`item_id2` = 98438) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36212'))))) OR (((`item_id3` = 98438) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36212')))))) 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` = 98438 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98425) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36220'))))) OR (((`item_id2` = 98425) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36220'))))) OR (((`item_id3` = 98425) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36220')))))) 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` = 98425 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 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98161) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36090'))))) OR (((`item_id2` = 98161) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36090'))))) OR (((`item_id3` = 98161) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36090')))))) 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` = 98161 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98160) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36091'))))) OR (((`item_id2` = 98160) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36091'))))) OR (((`item_id3` = 98160) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36091')))))) 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` = 98160 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98178) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36131'))))) OR (((`item_id2` = 98178) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36131'))))) OR (((`item_id3` = 98178) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36131')))))) 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` = 98178 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98123) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36120'))))) OR (((`item_id2` = 98123) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36120'))))) OR (((`item_id3` = 98123) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36120')))))) 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` = 98123 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98159) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36092WH'))))) OR (((`item_id2` = 98159) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36092WH'))))) OR (((`item_id3` = 98159) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36092WH')))))) 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` = 98159 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98122) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35978'))))) OR (((`item_id2` = 98122) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35978'))))) OR (((`item_id3` = 98122) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35978')))))) 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` = 98122 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98158) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36092BK'))))) OR (((`item_id2` = 98158) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36092BK'))))) OR (((`item_id3` = 98158) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36092BK')))))) 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` = 98158 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 82877) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2598G8'))))) OR (((`item_id2` = 82877) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2598G8'))))) OR (((`item_id3` = 82877) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2598G8')))))) 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` = 82877 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 | |