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 '%エアリナ%') 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 | 168 | 168 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`item_naming` = 1 AND `Item`.`id` IN (6173, 35724, 35724, 35725, 35725, 35726, 35726, 36770, 74432, 76778, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 84019, 84140, 84241, 84241, 84496, 84497, 84499, 84500, 84595, 84595, 84595, 84911, 84911, 85342, 85398, 85811, 86733, 87662, 87664, 87665, 87925, 88216, 88217, 88218, 89539, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90745, 90745, 90746, 90746, 91325, 91335, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91975, 91976, 91977, 92499, 92540, 92772, 92901, 93012, 93123, 93515, 94317, 94511, 94512, 95181, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95297, 95298, 95299, 95300, 95301, 95367, 95413, 95878, 95884, 95887, 95888, 96209, 96386, 96499, 96661, 96677, 96822, 96839, 96840, 96841, 96879, 96999, 97020, 97021, 97022, 97035, 97047, 97049, 97052, 97055, 97056, 97377, 97377, 98162, 98163, 98218, 98776, 98805, 98813, 98849, 98850, 98922, 99059, 99060, 99061, 99062, 99063, 99391, 99733, 99746, 99780, 99781) AND `item_rank` <> 3 ORDER BY `Cnt`.`pagecnt` desc LIMIT 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_naming` = 1 AND `Item`.`id` IN (6173, 35724, 35724, 35725, 35725, 35726, 35726, 36770, 74432, 76778, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 84019, 84140, 84241, 84241, 84496, 84497, 84499, 84500, 84595, 84595, 84595, 84911, 84911, 85342, 85398, 85811, 86733, 87662, 87664, 87665, 87925, 88216, 88217, 88218, 89539, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90745, 90745, 90746, 90746, 91325, 91335, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91975, 91976, 91977, 92499, 92540, 92772, 92901, 93012, 93123, 93515, 94317, 94511, 94512, 95181, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95297, 95298, 95299, 95300, 95301, 95367, 95413, 95878, 95884, 95887, 95888, 96209, 96386, 96499, 96661, 96677, 96822, 96839, 96840, 96841, 96879, 96999, 97020, 97021, 97022, 97035, 97047, 97049, 97052, 97055, 97056, 97377, 97377, 98162, 98163, 98218, 98776, 98805, 98813, 98849, 98850, 98922, 99059, 99060, 99061, 99062, 99063, 99391, 99733, 99746, 99780, 99781) 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` = 6173) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h144-033445'))))) OR (((`item_id2` = 6173) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h144-033445'))))) OR (((`item_id3` = 6173) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h144-033445')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 6173 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-033445FC'))))) OR (((`item_id2` = 74432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-033445FC'))))) OR (((`item_id3` = 74432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-033445FC')))))) 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` = 74432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-ST-A'))))) OR (((`item_id2` = 80609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-ST-A'))))) OR (((`item_id3` = 80609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-ST-A')))))) 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` = 80609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35725) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0068-009'))))) OR (((`item_id2` = 35725) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0068-009'))))) OR (((`item_id3` = 35725) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0068-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 35725 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35726) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0068-044'))))) OR (((`item_id2` = 35726) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0068-044'))))) OR (((`item_id3` = 35726) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0068-044')))))) 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` = 35726 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80597) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-EX-B'))))) OR (((`item_id2` = 80597) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-EX-B'))))) OR (((`item_id3` = 80597) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-EX-B')))))) 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` = 80597 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80588) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-TW-A'))))) OR (((`item_id2` = 80588) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-TW-A'))))) OR (((`item_id3` = 80588) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-TW-A')))))) 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` = 80588 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80613) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-FC-B'))))) OR (((`item_id2` = 80613) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-FC-B'))))) OR (((`item_id3` = 80613) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-FC-B')))))) 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` = 80613 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80612) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-FC-A'))))) OR (((`item_id2` = 80612) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-FC-A'))))) OR (((`item_id3` = 80612) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-FC-A')))))) 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` = 80612 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 36770) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-077449'))))) OR (((`item_id2` = 36770) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-077449'))))) OR (((`item_id3` = 36770) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-077449')))))) 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` = 36770 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 76778) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2539G9'))))) OR (((`item_id2` = 76778) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2539G9'))))) OR (((`item_id3` = 76778) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2539G9')))))) 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` = 76778 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80608) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-NX'))))) OR (((`item_id2` = 80608) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-NX'))))) OR (((`item_id3` = 80608) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-NX')))))) 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` = 80608 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80611) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-ST-C'))))) OR (((`item_id2` = 80611) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-ST-C'))))) OR (((`item_id3` = 80611) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-ST-C')))))) 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` = 80611 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84019) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2267740'))))) OR (((`item_id2` = 84019) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2267740'))))) OR (((`item_id3` = 84019) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2267740')))))) 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` = 84019 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35724) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0068-005'))))) OR (((`item_id2` = 35724) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0068-005'))))) OR (((`item_id3` = 35724) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0068-005')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 35724 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 | |