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 | 706 | 706 | 284 | 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 (3829, 3829, 35191, 35192, 35193, 35261, 35262, 35416, 35417, 35420, 35577, 44174, 44174, 44794, 44794, 44794, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 58324, 64547, 64547, 64673, 64686, 68606, 68607, 73051, 73051, 73056, 73187, 73187, 74215, 74217, 74219, 74220, 74256, 74257, 74259, 74262, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74357, 74359, 74360, 74375, 74376, 74377, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74948, 75898, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 80470, 80471, 80550, 80588, 80589, 80593, 80595, 80692, 80692, 80693, 80693, 80717, 80717, 80718, 80718, 80719, 80720, 80810, 80811, 81244, 81244, 81568, 81568, 81568, 81731, 83385, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83841, 83842, 83843, 83851, 83852, 83860, 83900, 83902, 83927, 83936, 84081, 84148, 84353, 84354, 84355, 84450, 84451, 84452, 84519, 84520, 84521, 84522, 84523, 84528, 84529, 84530, 84531, 84532, 84593, 84593, 84594, 84594, 84612, 84613, 84616, 84618, 84620, 84622, 84907, 84908, 84941, 85042, 85043, 85044, 85051, 85052, 85053, 85066, 85067, 85068, 85136, 85137, 85154, 85155, 85156, 85157, 85158, 85159, 85455, 85531, 85534, 85535, 85536, 85537, 85647, 85647, 85668, 85669, 85768, 85815, 86047, 86078, 86421, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87347, 87348, 87349, 87350, 87351, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87748, 87749, 87750, 87751, 87760, 87796, 87925, 88157, 88158, 88159, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88192, 88193, 88194, 88201, 88202, 88203, 88228, 88228, 88251, 88252, 89011, 89089, 89295, 89578, 89766, 89766, 90376, 90377, 90461, 90461, 90462, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 91045, 91329, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91484, 91631, 91631, 91632, 91632, 91633, 91633, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91829, 91830, 92060, 92065, 92073, 92309, 92318, 92334, 92359, 92471, 92496, 92517, 92518, 92519, 92520, 92522, 92524, 92535, 92536, 92539, 92547, 92548, 92550, 92552, 92553, 92583, 92659, 92771, 92772, 92880, 92893, 92961, 93506, 93682, 93683, 93945, 93955, 93989, 94036, 94264, 94264, 94269, 94270, 94272, 94275, 94281, 94282, 94283, 94360, 94361, 94368, 94560, 94561, 94562, 94762, 94763, 94818, 95071, 95071, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95083, 95120, 95170, 95171, 95172, 95173, 95174, 95175, 95176, 95177, 95178, 95179, 95187, 95210, 95211, 95212, 95243, 95246, 95251, 95252, 95347, 95348, 95349, 95356, 95377, 95399, 95412, 95574, 95610, 95613, 95621, 95638, 95639, 95640, 95641, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95772, 95774, 95774, 95786, 95794, 95952, 95953, 95984, 95985, 95986, 95987, 95988, 95998, 95999, 96027, 96028, 96029, 96030, 96031, 96034, 96038, 96043, 96046, 96066, 96067, 96121, 96122, 96271, 96275, 96311, 96355, 96403, 96404, 96431, 96432, 96570, 96579, 96628, 96640, 96664, 96671, 96747, 96761, 96763, 96767, 96784, 96812, 96819, 96955, 96957, 96960, 96965, 96970, 97001, 97023, 97036, 97042, 97048, 97103, 97151, 97163, 97217, 97218, 97219, 97358, 97359, 97368, 97368, 97378, 97394, 97429, 97612, 97668, 97668, 97669, 97669, 97670, 97670, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97788, 97806, 97850, 97851, 97852, 97876, 97877, 97878, 97879, 97880, 97881, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97997, 97998, 97999, 98000, 98001, 98002, 98108, 98116, 98118, 98118, 98162, 98168, 98169, 98169, 98177, 98177, 98223, 98433, 98433, 98444, 98471, 98503, 98504, 98505, 98506, 98529, 98530, 98531, 98532, 98569, 98570, 98571, 98572, 98581, 98582, 98583, 98584, 98630, 98637, 98653, 98666, 98701, 98724, 98763, 98790, 98797, 98868, 98869, 98870, 98880, 98881, 98882, 98883, 98884, 98885, 98906, 98907, 98971, 98972, 98973, 99002, 99003, 99004, 99005, 99006, 99209, 99210, 99211, 99274, 99275, 99287, 99288, 99289, 99290, 99300, 99318, 99327, 99328, 99329, 99340, 99341, 99342, 99343, 99344, 99345, 99410, 99412, 99427, 99459, 99460, 99461, 99462, 99474, 99569, 99583, 99618, 99619, 99652, 99708, 99717, 99718) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` asc LIMIT 15 | 15 | 15 | 6 | 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 (3829, 3829, 35191, 35192, 35193, 35261, 35262, 35416, 35417, 35420, 35577, 44174, 44174, 44794, 44794, 44794, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 58324, 64547, 64547, 64673, 64686, 68606, 68607, 73051, 73051, 73056, 73187, 73187, 74215, 74217, 74219, 74220, 74256, 74257, 74259, 74262, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74312, 74313, 74314, 74315, 74316, 74317, 74318, 74319, 74320, 74321, 74322, 74323, 74324, 74325, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74341, 74343, 74357, 74359, 74360, 74375, 74376, 74377, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74948, 75898, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 80470, 80471, 80550, 80588, 80589, 80593, 80595, 80692, 80692, 80693, 80693, 80717, 80717, 80718, 80718, 80719, 80720, 80810, 80811, 81244, 81244, 81568, 81568, 81568, 81731, 83385, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83841, 83842, 83843, 83851, 83852, 83860, 83900, 83902, 83927, 83936, 84081, 84148, 84353, 84354, 84355, 84450, 84451, 84452, 84519, 84520, 84521, 84522, 84523, 84528, 84529, 84530, 84531, 84532, 84593, 84593, 84594, 84594, 84612, 84613, 84616, 84618, 84620, 84622, 84907, 84908, 84941, 85042, 85043, 85044, 85051, 85052, 85053, 85066, 85067, 85068, 85136, 85137, 85154, 85155, 85156, 85157, 85158, 85159, 85455, 85531, 85534, 85535, 85536, 85537, 85647, 85647, 85668, 85669, 85768, 85815, 86047, 86078, 86421, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87347, 87348, 87349, 87350, 87351, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87748, 87749, 87750, 87751, 87760, 87796, 87925, 88157, 88158, 88159, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88192, 88193, 88194, 88201, 88202, 88203, 88228, 88228, 88251, 88252, 89011, 89089, 89295, 89578, 89766, 89766, 90376, 90377, 90461, 90461, 90462, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 91045, 91329, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91484, 91631, 91631, 91632, 91632, 91633, 91633, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91829, 91830, 92060, 92065, 92073, 92309, 92318, 92334, 92359, 92471, 92496, 92517, 92518, 92519, 92520, 92522, 92524, 92535, 92536, 92539, 92547, 92548, 92550, 92552, 92553, 92583, 92659, 92771, 92772, 92880, 92893, 92961, 93506, 93682, 93683, 93945, 93955, 93989, 94036, 94264, 94264, 94269, 94270, 94272, 94275, 94281, 94282, 94283, 94360, 94361, 94368, 94560, 94561, 94562, 94762, 94763, 94818, 95071, 95071, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95083, 95120, 95170, 95171, 95172, 95173, 95174, 95175, 95176, 95177, 95178, 95179, 95187, 95210, 95211, 95212, 95243, 95246, 95251, 95252, 95347, 95348, 95349, 95356, 95377, 95399, 95412, 95574, 95610, 95613, 95621, 95638, 95639, 95640, 95641, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95772, 95774, 95774, 95786, 95794, 95952, 95953, 95984, 95985, 95986, 95987, 95988, 95998, 95999, 96027, 96028, 96029, 96030, 96031, 96034, 96038, 96043, 96046, 96066, 96067, 96121, 96122, 96271, 96275, 96311, 96355, 96403, 96404, 96431, 96432, 96570, 96579, 96628, 96640, 96664, 96671, 96747, 96761, 96763, 96767, 96784, 96812, 96819, 96955, 96957, 96960, 96965, 96970, 97001, 97023, 97036, 97042, 97048, 97103, 97151, 97163, 97217, 97218, 97219, 97358, 97359, 97368, 97368, 97378, 97394, 97429, 97612, 97668, 97668, 97669, 97669, 97670, 97670, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97788, 97806, 97850, 97851, 97852, 97876, 97877, 97878, 97879, 97880, 97881, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97997, 97998, 97999, 98000, 98001, 98002, 98108, 98116, 98118, 98118, 98162, 98168, 98169, 98169, 98177, 98177, 98223, 98433, 98433, 98444, 98471, 98503, 98504, 98505, 98506, 98529, 98530, 98531, 98532, 98569, 98570, 98571, 98572, 98581, 98582, 98583, 98584, 98630, 98637, 98653, 98666, 98701, 98724, 98763, 98790, 98797, 98868, 98869, 98870, 98880, 98881, 98882, 98883, 98884, 98885, 98906, 98907, 98971, 98972, 98973, 99002, 99003, 99004, 99005, 99006, 99209, 99210, 99211, 99274, 99275, 99287, 99288, 99289, 99290, 99300, 99318, 99327, 99328, 99329, 99340, 99341, 99342, 99343, 99344, 99345, 99410, 99412, 99427, 99459, 99460, 99461, 99462, 99474, 99569, 99583, 99618, 99619, 99652, 99708, 99717, 99718) AND `item_rank` <> 3 | 1 | 1 | 4 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74284) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0910AB'))))) OR (((`item_id2` = 74284) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0910AB'))))) OR (((`item_id3` = 74284) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0910AB')))))) 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` = 74284 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74285) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0910AD'))))) OR (((`item_id2` = 74285) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0910AD'))))) OR (((`item_id3` = 74285) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0910AD')))))) 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` = 74285 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74286) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0910AK'))))) OR (((`item_id2` = 74286) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0910AK'))))) OR (((`item_id3` = 74286) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0910AK')))))) 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` = 74286 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89295) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25333G5'))))) OR (((`item_id2` = 89295) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25333G5'))))) OR (((`item_id3` = 89295) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25333G5')))))) 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` = 89295 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74291) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0911AB'))))) OR (((`item_id2` = 74291) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0911AB'))))) OR (((`item_id3` = 74291) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0911AB')))))) 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` = 74291 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74292) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0911AD'))))) OR (((`item_id2` = 74292) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0911AD'))))) OR (((`item_id3` = 74292) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0911AD')))))) 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` = 74292 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74297) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0911AL'))))) OR (((`item_id2` = 74297) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0911AL'))))) OR (((`item_id3` = 74297) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0911AL')))))) 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` = 74297 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89089) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G9'))))) OR (((`item_id2` = 89089) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G9'))))) OR (((`item_id3` = 89089) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G9')))))) 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` = 89089 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92553) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G7'))))) OR (((`item_id2` = 92553) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G7'))))) OR (((`item_id3` = 92553) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G7')))))) 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` = 92553 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92552) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G3'))))) OR (((`item_id2` = 92552) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G3'))))) OR (((`item_id3` = 92552) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G3')))))) 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` = 92552 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99318) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25331G2'))))) OR (((`item_id2` = 99318) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25331G2'))))) OR (((`item_id3` = 99318) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25331G2')))))) 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` = 99318 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74424) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-042348FC'))))) OR (((`item_id2` = 74424) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-042348FC'))))) OR (((`item_id3` = 74424) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-042348FC')))))) 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` = 74424 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54049) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h14-100543'))))) OR (((`item_id2` = 54049) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h14-100543'))))) OR (((`item_id3` = 54049) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h14-100543')))))) 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` = 54049 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54050) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h14-100444'))))) OR (((`item_id2` = 54050) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h14-100444'))))) OR (((`item_id3` = 54050) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h14-100444')))))) 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` = 54050 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54051) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h14-100741'))))) OR (((`item_id2` = 54051) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h14-100741'))))) OR (((`item_id3` = 54051) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h14-100741')))))) 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` = 54051 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 | |