<アウトレット売切廃盤> キャンバスベルトライントート(S) ビビッドピンク 300円 ⇒ 150円 注文最小数量:100
|
[名入れタオル] コットンWフェイス ハンドタオル 昇華転写対応 ホワイト 280円 ⇒ 140円 注文最小数量:400
|
130円 ⇒ 注文最小数量:100 お得な値引は06月末日まで |
1,880円 ⇒ 940円 注文最小数量:50
|
480円 ⇒ 240円 注文最小数量:30
|
1,980円 ⇒ 990円 注文最小数量:30
|
250円 ⇒ 100円 注文最小数量:100 |
640円 ⇒ 320円 注文最小数量:100 |
530円 ⇒ 265円 注文最小数量:100 |
250円 ⇒ 125円 注文最小数量:300 |
980円 ⇒ 注文最小数量:30
お得な値引は06月末日まで |
600円 ⇒ 188円 注文最小数量:100
|
750円 ⇒ 375円 注文最小数量:50 |
460円 ⇒ 注文最小数量:200
お得な値引は06月末日まで |
<アウトレット売切廃盤> [コスメポーチ] ユーティリティスクエアポーチ(S) ネイビーブルー 490円 ⇒ 150円 注文最小数量:200
|
1,020円 ⇒ 注文最小数量:60 お得な値引は06月末日まで |
320円 ⇒ 160円 注文最小数量:300
|
<アウトレット売切廃盤> [事務用品/オフィス用品] コンパクトブラシ&ダストパン ブラック 300円 ⇒ 75円 注文最小数量:50
|
<アウトレット売切廃盤> [事務用品/オフィス用品] コンパクトブラシ&ダストパン ホワイト 300円 ⇒ 75円 注文最小数量:50
|
350円 ⇒ 175円 注文最小数量:200
|
250円 ⇒ 100円 注文最小数量:100 |
55円 ⇒ 28円 注文最小数量:2,000
|
65円 ⇒ 33円 注文最小数量:1,000
|
60円 ⇒ 30円 注文最小数量:1,000
|
2,550円 ⇒ 1,275円 注文最小数量:60
|
180円 ⇒ 90円 注文最小数量:200
|
500円 ⇒ 注文最小数量:60 お得な値引は06月末日まで |
620円 ⇒ 310円 注文最小数量:80
|
100円 ⇒ 50円 注文最小数量:1,000
|
880円 ⇒ 440円 注文最小数量:200
|
380円 ⇒ 190円 注文最小数量:300
|
260円 ⇒ 130円 注文最小数量:400
|
[お探しの検索ワードはコチラですか?]
温湿度計 | 手ぬぐい | のぼり旗 | 知育玩具 | 修正テープ | センサーライト | バスクリン | 火災対策 | アクリル
| 折りたたみ | コスメ | サコッシュ [特集] 特急7営業日!名入れスピード印刷、お急ぎのお客様は諦めずにご相談ください [特集] 写真も綺麗に印刷!フルカラー対応ノベルティ インクジェット、昇華転写など |
後払い・送料0円・名入れデータ作成0円 |
|
名入れ!エコバッグ・マグカップ・ボトルなど |
|
冷やし中華、うどん、調味料。最短翌日出荷! |
|
オリジナルラベル対応!33円~送料無料 |
|
時節柄を問わない新アイテム 粗品・ご挨拶 |
|
お手頃で優しい風合い |
|
名入れ対応!非常用ライト・救急セットなど |
|
クリアファイル、ウェットティッシュ、付箋など |
|
ご相談下さい!名入れ印刷、特急7営業日 |
|
厚生労働省推進!思いやりグッズで好感度アップ |
|
注目!スタンド、チャージャー、ポーチ... |
|
写真も綺麗に印刷!フルカラー対応ノベルティ |
値引き商品 リスト|人気ランキング リスト|検索キーワード リスト|お取引について|名入れについて
販促レポート|名入れ制作事例|新着レビュー|オリジナルグッズ制作|会社案内|お問合せ
真面目にひた向きに、おかげ様で20周年
Copyright (C) 1998-2025 SeasonSolution All rights reserved.
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 | 2929 | 2929 | 254 | 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 (6030, 6030, 6031, 6031, 6064, 6163, 6164, 6173, 6272, 6272, 6273, 6273, 6274, 6274, 6775, 6776, 12965, 34866, 34874, 34875, 34885, 34886, 34907, 34908, 34909, 34936, 34936, 34960, 34961, 34962, 34963, 34965, 34968, 34969, 34969, 34970, 34970, 34971, 34971, 34972, 34974, 35016, 35017, 35018, 35134, 35135, 35157, 35161, 35162, 35163, 35164, 35166, 35167, 35169, 35170, 35178, 35179, 35180, 35188, 35189, 35190, 35191, 35192, 35193, 35198, 35209, 35210, 35243, 35244, 35245, 35252, 35254, 35255, 35260, 35261, 35262, 35263, 35264, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 35304, 35305, 35306, 35307, 35310, 35310, 35311, 35312, 35402, 35403, 35403, 35404, 35416, 35417, 35420, 35536, 35537, 35555, 35556, 35572, 35574, 35574, 35576, 35577, 35593, 35665, 35673, 35674, 35675, 35699, 36242, 36243, 36244, 36245, 36246, 36308, 36308, 36334, 36770, 38489, 38489, 44682, 44683, 44685, 44689, 44693, 44707, 44708, 44709, 45144, 45144, 45501, 45516, 45516, 45518, 45518, 45522, 45529, 45529, 45539, 45539, 54069, 54082, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 57632, 57708, 57709, 57714, 57715, 57730, 57731, 57732, 57733, 57746, 57747, 57748, 58128, 58129, 58130, 58131, 58215, 58227, 58229, 58230, 58324, 64430, 64439, 64443, 64443, 64445, 64445, 64446, 64446, 64447, 64447, 64451, 64486, 64486, 64486, 64542, 64547, 64547, 64549, 64550, 64561, 64561, 64596, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 64672, 64672, 64673, 64676, 64681, 64686, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 73665, 73666, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73719, 73720, 73830, 73842, 74201, 74215, 74221, 74242, 74243, 74256, 74257, 74263, 74264, 74291, 74291, 74292, 74292, 74305, 74306, 74312, 74313, 74368, 74369, 77070, 77075, 77077, 77590, 77590, 77601, 77604, 77604, 77604, 77610, 77611, 77614, 77614, 77615, 77615, 77642, 77642, 77643, 77643, 77644, 77644, 77645, 77646, 77647, 77648, 77649, 77650, 77651, 77652, 77653, 77654, 77654, 77655, 77655, 77658, 77658, 77660, 77660, 77695, 77696, 77697, 77698, 77707, 77708, 77710, 77710, 77712, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 77733, 77733, 77736, 77736, 77743, 77743, 78017, 78018, 78019, 78053, 78054, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 81150, 81150, 81215, 81216, 81216, 81229, 81667, 81667, 81721, 81722, 81723, 81730, 81731, 83936, 83938, 83938, 84019, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85019, 85020, 85021, 85022, 85023, 85024, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85034, 85035, 85036, 85037, 85039, 85039, 85040, 85040, 85041, 85041, 85042, 85043, 85044, 85045, 85046, 85046, 85047, 85048, 85049, 85050, 85051, 85052, 85053, 85062, 85063, 85064, 85064, 85065, 85065, 85066, 85067, 85068, 85069, 85069, 85070, 85070, 85071, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85109, 85110, 85111, 85112, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85136, 85137, 85139, 85140, 85141, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85154, 85155, 85156, 85157, 85158, 85159, 85160, 85161, 85162, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85202, 85208, 85208, 85209, 85209, 85210, 85211, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85226, 85267, 85268, 85269, 85270, 85288, 85290, 85342, 85534, 85535, 85536, 85537, 85538, 85539, 85540, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85642, 85643, 85644, 85645, 85647, 85647, 85658, 85662, 85663, 85664, 85664, 85665, 85665, 85666, 85667, 85668, 85669, 85670, 85671, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85704, 85709, 85709, 85710, 85711, 85711, 85712, 85712, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85717, 85718, 85719, 85720, 85721, 85722, 85723, 85723, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87315, 87317, 87317, 87318, 87318, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87327, 87328, 87329, 87330, 87331, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87347, 87348, 87349, 87350, 87351, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87364, 87364, 87371, 87372, 87373, 87374, 87374, 87375, 87375, 87376, 87377, 87378, 87379, 87380, 87381, 87382, 87382, 87383, 87383, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87396, 87397, 87398, 87399, 87400, 87401, 87402, 87403, 87404, 87405, 87406, 87407, 87408, 87844, 87845, 87851, 87851, 87851, 87852, 87853, 87854, 87855, 87855, 87856, 87856, 87857, 87858, 87859, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87892, 87894, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87917, 87918, 87919, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88191, 88192, 88193, 88194, 88195, 88196, 88197, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88205, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88214, 88215, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88228, 88228, 88229, 88229, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88236, 88236, 88237, 88237, 88238, 88238, 88238, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88249, 88250, 88251, 88252, 88253, 88254, 90361, 90362, 90363, 90364, 90365, 90366, 90367, 90368, 90369, 90370, 90371, 90372, 90373, 90374, 90375, 90376, 90377, 90378, 90379, 90380, 90381, 90382, 90383, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90392, 90393, 90394, 90397, 90397, 90398, 90399, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90411, 90412, 90413, 90414, 90414, 90415, 90415, 90416, 90417, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90427, 90428, 90429, 90429, 90430, 90430, 90431, 90432, 90433, 90434, 90435, 90436, 90437, 90438, 90439, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90705, 90706, 90707, 90708, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90745, 90746, 90746, 90747, 90748, 90749, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90754, 90755, 90756, 90757, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90765, 90766, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90775, 90776, 90777, 90778, 90779, 90780, 90781, 90782, 90783, 90784, 90785, 90786, 90787, 90788, 90789, 90790, 90791, 90792, 90793, 90794, 90795, 90796, 90797, 90798, 90799, 90800, 90801, 90802, 90803, 90804, 90805, 90806, 90807, 90808, 90809, 90810, 90811, 90812, 90813, 90814, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90827, 90828, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 90836, 90837, 90838, 90839, 90840, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90869, 90870, 90871, 90872, 90873, 90874, 90875, 90876, 90877, 90878, 90879, 90880, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90889, 90890, 90891, 90892, 90893, 90894, 90895, 90896, 90897, 90898, 90899, 90900, 90901, 90902, 90903, 90904, 90905, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 90992, 90993, 90994, 90995, 90996, 90997, 90998, 90999, 91000, 91001, 91001, 91002, 91003, 91003, 91003, 91004, 91004, 91004, 91005, 91006, 91007, 91008, 91009, 91010, 91011, 91012, 91013, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91022, 91023, 91024, 91025, 91026, 91027, 91028, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91420, 91421, 91422, 91423, 91424, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94396, 94397, 94398, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94509, 94510, 94511, 94512, 94513, 94514, 94515, 94516, 94517, 94518, 94519, 94520, 94521, 94595, 94595, 94596, 94596, 94597, 94597, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94602, 94602, 94603, 94603, 94604, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94613, 94614, 94615, 94616, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94629, 94630, 94631, 94632, 94633, 94634, 94635, 94636, 94637, 94638, 94639, 94640, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94659, 94660, 94661, 94662, 94663, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94703, 94704, 94705, 94706, 94707, 94708, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95122, 95123, 95124, 95125, 95126, 95127, 95128, 95129, 95130, 95131, 95132, 95133, 95134, 95135, 95135, 95136, 95136, 95137, 95137, 95138, 95138, 95139, 95140, 95141, 95142, 95143, 95144, 95145, 95146, 95147, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95205, 95206, 95207, 95208, 95209, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95219, 95220, 95221, 95222, 95223, 95224, 95225, 95226, 95227, 95228, 95229, 95230, 95231, 95232, 95233, 95234, 95235, 95236, 95237, 95238, 95239, 95247, 95248, 95249, 95250, 95251, 95252, 95253, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 95275, 95276, 95277, 95278, 95279, 95280, 95281, 95282, 95283, 95284, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95309, 95310, 95310, 95311, 95311, 95312, 95312, 95313, 95314, 95315, 95316, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95338, 95339, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95433, 95433, 95434, 95435, 95436, 95437, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95471, 95472, 95473, 95474, 95475, 95476, 95477, 95478, 95479, 95480, 95481, 95482, 95483, 95484, 95485, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95494, 95495, 95496, 95497, 95498, 95499, 95500, 95501, 95502, 95503, 95504, 95505, 95506, 95507, 95508, 95509, 95510, 95511, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95524, 95525, 95526, 95527, 95528, 95529, 95530, 95530, 95531, 95531, 95531, 95532, 95532, 95532, 95533, 95533, 95534, 95534, 95535, 95535, 95536, 95536, 95537, 95537, 95538, 95538, 95539, 95539, 95540, 95540, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95551, 95552, 95553, 95554, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95569, 95570, 95571, 95572, 95573, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95587, 95588, 95589, 95590, 95591, 95592, 95593, 95594, 95595, 95596, 95597, 95598, 95599, 95600, 95601, 95602, 95603, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95629, 95630, 95631, 95632, 95633, 95634, 95635, 95636, 95637, 95638, 95639, 95640, 95641, 95642, 95643, 95644, 95645, 95646, 95647, 95648, 95649, 95650, 95651, 95652, 95653, 95654, 95655, 95656, 95657, 95658, 95659, 95660, 95661, 95662, 95663, 95664, 95665, 95666, 95667, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97727, 97727, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97840, 97841, 97842, 97843, 97844, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98052, 98052, 98052, 98057, 98057, 98057, 98058, 98058, 98058, 98059, 98059, 98059, 98060, 98060, 98060, 98061, 98061, 98061, 98062, 98062, 98062, 98063, 98063, 98063, 98064, 98064, 98064, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98490, 98491, 98492, 98492, 98493, 98493, 98494, 98495, 98496, 98497, 98498, 98499, 98500, 98501, 98502, 98503, 98504, 98505, 98506, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98517, 98518, 98519, 98520, 98521, 98522, 98523, 98524, 98525, 98526, 98527, 98528, 98529, 98530, 98531, 98532, 98533, 98534, 98535, 98536, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98593, 98594, 98595, 98596, 98597, 98598, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98622, 98623, 98624, 98625) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 32 | 32 | 32 | 14 | 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 (6030, 6030, 6031, 6031, 6064, 6163, 6164, 6173, 6272, 6272, 6273, 6273, 6274, 6274, 6775, 6776, 12965, 34866, 34874, 34875, 34885, 34886, 34907, 34908, 34909, 34936, 34936, 34960, 34961, 34962, 34963, 34965, 34968, 34969, 34969, 34970, 34970, 34971, 34971, 34972, 34974, 35016, 35017, 35018, 35134, 35135, 35157, 35161, 35162, 35163, 35164, 35166, 35167, 35169, 35170, 35178, 35179, 35180, 35188, 35189, 35190, 35191, 35192, 35193, 35198, 35209, 35210, 35243, 35244, 35245, 35252, 35254, 35255, 35260, 35261, 35262, 35263, 35264, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 35304, 35305, 35306, 35307, 35310, 35310, 35311, 35312, 35402, 35403, 35403, 35404, 35416, 35417, 35420, 35536, 35537, 35555, 35556, 35572, 35574, 35574, 35576, 35577, 35593, 35665, 35673, 35674, 35675, 35699, 36242, 36243, 36244, 36245, 36246, 36308, 36308, 36334, 36770, 38489, 38489, 44682, 44683, 44685, 44689, 44693, 44707, 44708, 44709, 45144, 45144, 45501, 45516, 45516, 45518, 45518, 45522, 45529, 45529, 45539, 45539, 54069, 54082, 54083, 54083, 54085, 54085, 54086, 54086, 54087, 54089, 54090, 57632, 57708, 57709, 57714, 57715, 57730, 57731, 57732, 57733, 57746, 57747, 57748, 58128, 58129, 58130, 58131, 58215, 58227, 58229, 58230, 58324, 64430, 64439, 64443, 64443, 64445, 64445, 64446, 64446, 64447, 64447, 64451, 64486, 64486, 64486, 64542, 64547, 64547, 64549, 64550, 64561, 64561, 64596, 64630, 64630, 64631, 64631, 64637, 64637, 64638, 64638, 64639, 64639, 64672, 64672, 64673, 64676, 64681, 64686, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 73665, 73666, 73683, 73684, 73686, 73687, 73692, 73693, 73695, 73696, 73697, 73697, 73719, 73720, 73830, 73842, 74201, 74215, 74221, 74242, 74243, 74256, 74257, 74263, 74264, 74291, 74291, 74292, 74292, 74305, 74306, 74312, 74313, 74368, 74369, 77070, 77075, 77077, 77590, 77590, 77601, 77604, 77604, 77604, 77610, 77611, 77614, 77614, 77615, 77615, 77642, 77642, 77643, 77643, 77644, 77644, 77645, 77646, 77647, 77648, 77649, 77650, 77651, 77652, 77653, 77654, 77654, 77655, 77655, 77658, 77658, 77660, 77660, 77695, 77696, 77697, 77698, 77707, 77708, 77710, 77710, 77712, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 77733, 77733, 77736, 77736, 77743, 77743, 78017, 78018, 78019, 78053, 78054, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 81150, 81150, 81215, 81216, 81216, 81229, 81667, 81667, 81721, 81722, 81723, 81730, 81731, 83936, 83938, 83938, 84019, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85019, 85020, 85021, 85022, 85023, 85024, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85034, 85035, 85036, 85037, 85039, 85039, 85040, 85040, 85041, 85041, 85042, 85043, 85044, 85045, 85046, 85046, 85047, 85048, 85049, 85050, 85051, 85052, 85053, 85062, 85063, 85064, 85064, 85065, 85065, 85066, 85067, 85068, 85069, 85069, 85070, 85070, 85071, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85109, 85110, 85111, 85112, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85136, 85137, 85139, 85140, 85141, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85154, 85155, 85156, 85157, 85158, 85159, 85160, 85161, 85162, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85202, 85208, 85208, 85209, 85209, 85210, 85211, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85226, 85267, 85268, 85269, 85270, 85288, 85290, 85342, 85534, 85535, 85536, 85537, 85538, 85539, 85540, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85642, 85643, 85644, 85645, 85647, 85647, 85658, 85662, 85663, 85664, 85664, 85665, 85665, 85666, 85667, 85668, 85669, 85670, 85671, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85701, 85701, 85702, 85702, 85703, 85703, 85704, 85709, 85709, 85710, 85711, 85711, 85712, 85712, 85713, 85713, 85714, 85714, 85715, 85715, 85716, 85716, 85717, 85718, 85719, 85720, 85721, 85722, 85723, 85723, 87301, 87301, 87302, 87302, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87315, 87317, 87317, 87318, 87318, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87327, 87328, 87329, 87330, 87331, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87347, 87348, 87349, 87350, 87351, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87364, 87364, 87371, 87372, 87373, 87374, 87374, 87375, 87375, 87376, 87377, 87378, 87379, 87380, 87381, 87382, 87382, 87383, 87383, 87384, 87384, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87396, 87397, 87398, 87399, 87400, 87401, 87402, 87403, 87404, 87405, 87406, 87407, 87408, 87844, 87845, 87851, 87851, 87851, 87852, 87853, 87854, 87855, 87855, 87856, 87856, 87857, 87858, 87859, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87892, 87894, 87895, 87896, 87897, 87898, 87899, 87899, 87900, 87901, 87902, 87909, 87910, 87911, 87912, 87913, 87913, 87913, 87914, 87914, 87914, 87915, 87915, 87916, 87916, 87917, 87918, 87919, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88191, 88192, 88193, 88194, 88195, 88196, 88197, 88198, 88199, 88200, 88201, 88202, 88203, 88204, 88205, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88214, 88215, 88216, 88217, 88218, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88228, 88228, 88229, 88229, 88230, 88230, 88231, 88231, 88232, 88232, 88233, 88233, 88234, 88234, 88235, 88235, 88236, 88236, 88237, 88237, 88238, 88238, 88238, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88249, 88250, 88251, 88252, 88253, 88254, 90361, 90362, 90363, 90364, 90365, 90366, 90367, 90368, 90369, 90370, 90371, 90372, 90373, 90374, 90375, 90376, 90377, 90378, 90379, 90380, 90381, 90382, 90383, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90392, 90393, 90394, 90397, 90397, 90398, 90399, 90400, 90401, 90402, 90403, 90404, 90405, 90406, 90407, 90408, 90409, 90410, 90411, 90412, 90413, 90414, 90414, 90415, 90415, 90416, 90417, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90427, 90428, 90429, 90429, 90430, 90430, 90431, 90432, 90433, 90434, 90435, 90436, 90437, 90438, 90439, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90682, 90683, 90683, 90684, 90684, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90705, 90706, 90707, 90708, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90738, 90739, 90740, 90741, 90742, 90743, 90744, 90745, 90745, 90746, 90746, 90747, 90748, 90749, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90754, 90755, 90756, 90757, 90758, 90759, 90760, 90761, 90762, 90763, 90764, 90765, 90766, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90775, 90776, 90777, 90778, 90779, 90780, 90781, 90782, 90783, 90784, 90785, 90786, 90787, 90788, 90789, 90790, 90791, 90792, 90793, 90794, 90795, 90796, 90797, 90798, 90799, 90800, 90801, 90802, 90803, 90804, 90805, 90806, 90807, 90808, 90809, 90810, 90811, 90812, 90813, 90814, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90827, 90828, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 90836, 90837, 90838, 90839, 90840, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90869, 90870, 90871, 90872, 90873, 90874, 90875, 90876, 90877, 90878, 90879, 90880, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90889, 90890, 90891, 90892, 90893, 90894, 90895, 90896, 90897, 90898, 90899, 90900, 90901, 90902, 90903, 90904, 90905, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 90982, 90983, 90984, 90985, 90986, 90987, 90988, 90989, 90990, 90991, 90992, 90993, 90994, 90995, 90996, 90997, 90998, 90999, 91000, 91001, 91001, 91002, 91003, 91003, 91003, 91004, 91004, 91004, 91005, 91006, 91007, 91008, 91009, 91010, 91011, 91012, 91013, 91015, 91015, 91016, 91016, 91017, 91018, 91018, 91019, 91019, 91020, 91020, 91021, 91021, 91022, 91023, 91024, 91025, 91026, 91027, 91028, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91420, 91421, 91422, 91423, 91424, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91456, 91457, 91458, 91459, 91460, 91461, 91462, 91463, 91464, 91465, 91466, 91467, 91468, 91469, 91470, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94396, 94397, 94398, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94436, 94437, 94438, 94439, 94439, 94440, 94440, 94441, 94441, 94442, 94442, 94443, 94443, 94444, 94444, 94445, 94445, 94446, 94446, 94447, 94448, 94449, 94450, 94451, 94452, 94453, 94454, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94493, 94495, 94496, 94497, 94498, 94498, 94499, 94500, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94509, 94510, 94511, 94512, 94513, 94514, 94515, 94516, 94517, 94518, 94519, 94520, 94521, 94595, 94595, 94596, 94596, 94597, 94597, 94598, 94598, 94599, 94599, 94600, 94600, 94601, 94601, 94602, 94602, 94603, 94603, 94604, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94613, 94614, 94615, 94616, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94629, 94630, 94631, 94632, 94633, 94634, 94635, 94636, 94637, 94638, 94639, 94640, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94659, 94660, 94661, 94662, 94663, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94703, 94704, 94705, 94706, 94707, 94708, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95122, 95123, 95124, 95125, 95126, 95127, 95128, 95129, 95130, 95131, 95132, 95133, 95134, 95135, 95135, 95136, 95136, 95137, 95137, 95138, 95138, 95139, 95140, 95141, 95142, 95143, 95144, 95145, 95146, 95147, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 95205, 95206, 95207, 95208, 95209, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95219, 95220, 95221, 95222, 95223, 95224, 95225, 95226, 95227, 95228, 95229, 95230, 95231, 95232, 95233, 95234, 95235, 95236, 95237, 95238, 95239, 95247, 95248, 95249, 95250, 95251, 95252, 95253, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 95275, 95276, 95277, 95278, 95279, 95280, 95281, 95282, 95283, 95284, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95309, 95310, 95310, 95311, 95311, 95312, 95312, 95313, 95314, 95315, 95316, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95338, 95339, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95433, 95433, 95434, 95435, 95436, 95437, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95471, 95472, 95473, 95474, 95475, 95476, 95477, 95478, 95479, 95480, 95481, 95482, 95483, 95484, 95485, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95494, 95495, 95496, 95497, 95498, 95499, 95500, 95501, 95502, 95503, 95504, 95505, 95506, 95507, 95508, 95509, 95510, 95511, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95524, 95525, 95526, 95527, 95528, 95529, 95530, 95530, 95531, 95531, 95531, 95532, 95532, 95532, 95533, 95533, 95534, 95534, 95535, 95535, 95536, 95536, 95537, 95537, 95538, 95538, 95539, 95539, 95540, 95540, 95541, 95542, 95543, 95544, 95545, 95546, 95547, 95548, 95549, 95550, 95551, 95552, 95553, 95554, 95555, 95556, 95557, 95558, 95560, 95561, 95562, 95563, 95564, 95565, 95566, 95567, 95568, 95569, 95570, 95571, 95572, 95573, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95587, 95588, 95589, 95590, 95591, 95592, 95593, 95594, 95595, 95596, 95597, 95598, 95599, 95600, 95601, 95602, 95603, 95622, 95623, 95624, 95625, 95626, 95627, 95628, 95629, 95630, 95631, 95632, 95633, 95634, 95635, 95636, 95637, 95638, 95639, 95640, 95641, 95642, 95643, 95644, 95645, 95646, 95647, 95648, 95649, 95650, 95651, 95652, 95653, 95654, 95655, 95656, 95657, 95658, 95659, 95660, 95661, 95662, 95663, 95664, 95665, 95666, 95667, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 97719, 97720, 97720, 97721, 97721, 97722, 97723, 97724, 97725, 97727, 97727, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97840, 97841, 97842, 97843, 97844, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98052, 98052, 98052, 98057, 98057, 98057, 98058, 98058, 98058, 98059, 98059, 98059, 98060, 98060, 98060, 98061, 98061, 98061, 98062, 98062, 98062, 98063, 98063, 98063, 98064, 98064, 98064, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98490, 98491, 98492, 98492, 98493, 98493, 98494, 98495, 98496, 98497, 98498, 98499, 98500, 98501, 98502, 98503, 98504, 98505, 98506, 98507, 98507, 98508, 98508, 98509, 98509, 98510, 98510, 98511, 98511, 98512, 98512, 98513, 98513, 98514, 98514, 98515, 98515, 98516, 98516, 98517, 98518, 98519, 98520, 98521, 98522, 98523, 98524, 98525, 98526, 98527, 98528, 98529, 98530, 98531, 98532, 98533, 98534, 98535, 98536, 98537, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98593, 98594, 98595, 98596, 98597, 98598, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98622, 98623, 98624, 98625) AND `item_rank` <> 3 | 1 | 1 | 13 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0890-043'))))) OR (((`item_id2` = 77736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0890-043'))))) OR (((`item_id3` = 77736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0890-043')))))) 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` = 77736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95429) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1318-044'))))) OR (((`item_id2` = 95429) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1318-044'))))) OR (((`item_id3` = 95429) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1318-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` = 95429 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 6173 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1696-040'))))) OR (((`item_id2` = 90736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1696-040'))))) OR (((`item_id3` = 90736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1696-040')))))) 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` = 90736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95575) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1883-044'))))) OR (((`item_id2` = 95575) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1883-044'))))) OR (((`item_id3` = 95575) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1883-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` = 95575 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1824-044'))))) OR (((`item_id2` = 94652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1824-044'))))) OR (((`item_id3` = 94652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1824-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` = 94652 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6776) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h166-041846'))))) OR (((`item_id2` = 6776) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h166-041846'))))) OR (((`item_id3` = 6776) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h166-041846')))))) 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` = 6776 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35170) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-009'))))) OR (((`item_id2` = 35170) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-009'))))) OR (((`item_id3` = 35170) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-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` = 35170 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35169) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-008'))))) OR (((`item_id2` = 35169) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-008'))))) OR (((`item_id3` = 35169) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-008')))))) 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` = 35169 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35166) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0102-008'))))) OR (((`item_id2` = 35166) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0102-008'))))) OR (((`item_id3` = 35166) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0102-008')))))) 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` = 35166 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90703) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1187-028'))))) OR (((`item_id2` = 90703) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1187-028'))))) OR (((`item_id3` = 90703) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1187-028')))))) 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` = 90703 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81667) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-219146'))))) OR (((`item_id2` = 81667) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-219146'))))) OR (((`item_id3` = 81667) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-219146')))))) 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` = 81667 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 12965) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206849'))))) OR (((`item_id2` = 12965) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206849'))))) OR (((`item_id3` = 12965) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206849')))))) 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` = 12965 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95233) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1300-008'))))) OR (((`item_id2` = 95233) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1300-008'))))) OR (((`item_id3` = 95233) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1300-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` = 95233 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85147) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1063-006'))))) OR (((`item_id2` = 85147) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1063-006'))))) OR (((`item_id3` = 85147) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1063-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` = 85147 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35699) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0453-008'))))) OR (((`item_id2` = 35699) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0453-008'))))) OR (((`item_id3` = 35699) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0453-008')))))) 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` = 35699 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85156) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1061-006'))))) OR (((`item_id2` = 85156) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1061-006'))))) OR (((`item_id3` = 85156) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1061-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` = 85156 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87383) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-009'))))) OR (((`item_id2` = 87383) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-009'))))) OR (((`item_id3` = 87383) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87383 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87384) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-044'))))) OR (((`item_id2` = 87384) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-044'))))) OR (((`item_id3` = 87384) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87384 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98529) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0146-001'))))) OR (((`item_id2` = 98529) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0146-001'))))) OR (((`item_id3` = 98529) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0146-001')))))) 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` = 98529 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6775) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h166-041747'))))) OR (((`item_id2` = 6775) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h166-041747'))))) OR (((`item_id3` = 6775) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h166-041747')))))) 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` = 6775 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98523) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0153-008'))))) OR (((`item_id2` = 98523) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0153-008'))))) OR (((`item_id3` = 98523) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0153-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` = 98523 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98502) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0144-044'))))) OR (((`item_id2` = 98502) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0144-044'))))) OR (((`item_id3` = 98502) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0144-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` = 98502 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-044'))))) OR (((`item_id2` = 95645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-044'))))) OR (((`item_id3` = 95645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-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` = 95645 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94599) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1843-044'))))) OR (((`item_id2` = 94599) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1843-044'))))) OR (((`item_id3` = 94599) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1843-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` = 94599 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74242) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0490AB'))))) OR (((`item_id2` = 74242) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0490AB'))))) OR (((`item_id3` = 74242) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0490AB')))))) 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` = 74242 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 34874) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0342-006'))))) OR (((`item_id2` = 34874) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0342-006'))))) OR (((`item_id3` = 34874) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0342-006')))))) 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` = 34874 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95634) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0140-001'))))) OR (((`item_id2` = 95634) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0140-001'))))) OR (((`item_id3` = 95634) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0140-001')))))) 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` = 95634 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95311) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0122-009'))))) OR (((`item_id2` = 95311) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0122-009'))))) OR (((`item_id3` = 95311) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0122-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` = 95311 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98564) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-044'))))) OR (((`item_id2` = 98564) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-044'))))) OR (((`item_id3` = 98564) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-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` = 98564 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98579) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-034'))))) OR (((`item_id2` = 98579) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-034'))))) OR (((`item_id3` = 98579) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-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` = 98579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98594) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-008'))))) OR (((`item_id2` = 98594) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-008'))))) OR (((`item_id3` = 98594) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98594 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 |
Peak Memory Use 10.37 MB
Message | Memory use |
---|---|
Component initialization | 3.68 MB |
Controller action start | 5.12 MB |
Controller render start | 6.13 MB |
View render complete | 7.86 MB |
Total Request Time: 470 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 33.92 | |
Event: Controller.initialize | 11.30 | |
Event: Controller.startup | 0.65 | |
Controller action | 359.58 | |
Event: Controller.beforeRender | 11.40 | |
» Processing toolbar data | 11.28 | |
Rendering View | 23.01 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Items/searchpicture.ctp | 22.28 | |
» » Rendering APP/View/Elements/Head_menu.ctp | 0.07 | |
» » Rendering APP/View/Elements/Head_txt.ctp | 0.05 | |
» » Rendering APP/View/Elements/picturelist.ctp | 14.69 | |
» » » Rendering APP/View/Elements/price.ctp | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp | 0.11 | |
» » » Rendering APP/View/Elements/price.ctp #2 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #2 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #3 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #3 | 0.11 | |
» » » Rendering APP/View/Elements/price.ctp #4 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #4 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #5 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #5 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #6 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #6 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #7 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #7 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #8 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #8 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #9 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #9 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #10 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #10 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #11 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #11 | 0.11 | |
» » » Rendering APP/View/Elements/price.ctp #12 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #12 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #13 | 0.11 | |
» » » Rendering APP/View/Elements/icon_set.ctp #13 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #14 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #14 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #15 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #15 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #16 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #16 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #17 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #17 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #18 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #18 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #19 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #19 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #20 | 0.11 | |
» » » Rendering APP/View/Elements/icon_set.ctp #20 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #21 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #21 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #22 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #22 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #23 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #23 | 0.11 | |
» » » Rendering APP/View/Elements/price.ctp #24 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #24 | 0.11 | |
» » » Rendering APP/View/Elements/price.ctp #25 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #25 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #26 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #26 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #27 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #27 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #28 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #28 | 0.11 | |
» » » Rendering APP/View/Elements/price.ctp #29 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #29 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #30 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #30 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #31 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #31 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #32 | 0.11 | |
» » » Rendering APP/View/Elements/icon_set.ctp #32 | 0.10 | |
» » Rendering APP/View/Elements/icon.ctp | 0.06 | |
» » Rendering APP/View/Elements/prlink.ctp | 0.45 | |
» » Rendering APP/View/Elements/Area_left.ctp | 3.83 | |
» » » Rendering APP/View/Elements/serchlink.ctp | 1.59 | |
» » » Rendering APP/View/Elements/speciallink.ctp | 0.14 | |
» » » Rendering APP/View/Elements/pricelink.ctp | 0.55 | |
» » » Rendering APP/View/Elements/cataloglink.ctp | 0.06 | |
» » Rendering APP/View/Elements/footlink.ctp | 0.30 | |
» » Rendering APP/View/Elements/Analyticslink.ctp | 0.06 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/default.ctp | 0.07 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CAKEPHP2_HOST_NAME_REGEX | (?:[_\p{L}0-9][-_\p{L}0-9]*\.)*(?:[\p{L}0-9][-\p{L}0-9]{0,62})\.(?:(?:[a-z]{2}\.)?[a-z]{2,}) |
CAKEPHP2_EMAIL_REGEX | /^[\p{L}0-9!#$%&'*+\/=?^_`{|}~-]+(?:\.[\p{L}0-9!#$%&'*+\/=?^_`{|}~-]+)*@(?:[_\p{L}0-9][-_\p{L}0-9]*\.)*(?:[\p{L}0-9][-\p{L}0-9]{0,62})\.(?:(?:[a-z]{2}\.)?[a-z]{2,})$/ui |
USER_AGENT_TYPE_DEFAULT | 1 |
USER_AGENT_TYPE_SMART_PHONE | 2 |
QUERY_NAME_VIEW_MODE | viewmode |
VIEW_MODE_DEFAULT | 1 |
VIEW_MODE_SMART_PHONE | 2 |
STATUS_NO | 0 |
STATUS_OK | 2 |
STATUS_PROCESS | 1 |
LISTBYCATEGORY_SEARCH_RANK_TYPE_ALL | 1 |
LISTBYCATEGORY_SEARCH_RANK_TYPE_EXCLUDE_HIDE | 2 |
LISTBYCATEGORY_SEARCH_RANK_TYPE_HIDE_ONLY | 3 |
CAMPAIGNS_ADD_DISCOUNT_TYPE_2 | 2 |
CAMPAIGNS_ADD_DISCOUNT_TYPE_1 | 1 |
CAMPAIGNS_ADD_DISCOUNT_TYPE_DEFAULT | 0 |
ESTIMATE_EXPIRATION_TYPE_30_DAYS | 1 |
ESTIMATE_EXPIRATION_TYPE_60_DAYS | 2 |
ESTIMATE_EXPIRATION_TYPE_90_DAYS | 3 |
ESTIMATE_DELIVERY_LOCATION_TYPE_1 | 1 |
ESTIMATE_DELIVERY_LOCATION_TYPE_2 | 2 |
ESTIMATE_DELIVERY_LOCATION_TYPE_3 | 3 |
ESTIMATE_PAYMENT_TYPE_BANK_SAKI | 1 |
ESTIMATE_PAYMENT_TYPE_BANK_ATO | 2 |
ESTIMATE_PAYMENT_TYPE_BANK | 3 |
ESTIMATE_PAYMENT_TYPE_CASH_ON_DELIVERY | 4 |
ESTIMATE_PAYMENT_TYPE_CREDIT | 5 |
HANKAN_SUBJECT | 販促ノベルティ卸売りセンター |
RECOMMENDED_ITEMS | 8 |
NEW_ARRIVAL_ITEMS | 7 |
CAMPAIGN_ITEMS | 8 |
TEXTCAMPAIGN_ITEMS | 7 |
REPORT_ITEMS | 6 |
ITEMS_SHOW_WIDTH_LIMIT | 4 |
ITEMS_SHOW_WIDTH_LIMIT2 | 4 |
WATCHLIST_ITEMS | 4 |
WATCHLIST_ITEMS2 | 8 |
WATCHLIST_RANK_CONDITION_TYPE | 1 |
WATCHLIST_RANK_CONDITION_TYPE2 | 3 |
GALLARY_RANDOM_ITEMS | 4 |
ITEM_PICS_EXT | .jpg |
WHOLESALE_PRICE_NULL | お見積り |
CANPAIGN_PRICE_NULL | 特価 |
ITEM | item |
ESTIMATE_PDF | estimate_pdf |
IMG_SEARCH_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/img/item/ |
REPORT_SEARCH_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/img/report/ |
REPORT | /img/report |
SENDMAIL_PATH | /user/sbin/sendmail |
URL_ROOT | http://test.pqnavi.com |
ZIP_SEARCH_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/unzip/ |
UNZIP | /usr/bin/unzip |
HTMLMAIL_SIGNATURE_PC | [特別企画] <特急7営業日> 名入れスピード印刷、お急ぎのお客様はご相談を <新着レビュー> 既にご利用になったお客様からの声をご紹介 <SALE品 在庫売切廃盤> 約200商品が追加され更に充実、益々お得 無料サンプル差し上げます!ボールペン・付箋・ウェットティッシュ ━━━━━━━━━━━━━━━━━━━━━━━ 販促ノベルティ卸売りセンター http://www.pqnavi.com/ http://www.twitter.com/pqnavi http://www.facebook.com/pqnavicom ━━━━━━━━━━━━━━━━━━━━━━━ 電子POP卸売りモニター http://www.seasonsolution.jp/pop/ …………………………………………………… 文房具名入れ館 http://www.ccq.jp/ …………………………………………………… エコバッグ制作センター http://www.psps.jp/ …………………………………………………… 販促支援のシーズンソリューション株式会社 http://www.seasonsolution.jp/ 横浜市都筑区茅ヶ崎中央42-21第2佐藤ビル4F TEL:045-949-2557 FAX:045-949-4626 |
EMAIL_SIGNATURE_PC | [特集] <特急7営業日> 名入れスピード印刷、お急ぎのお客様はご相談を http://www.pqnavi.com/items/search?key=スピード印刷 <新着レビュー> 既にご利用になったお客様からの声をご紹介 http://www.pqnavi.com/questionnaires/newlist <SALE品 在庫売切廃盤> 約200商品が追加され更に充実、益々お得 http://www.pqnavi.com/items/categorylist/category_id:36 無料サンプル差し上げます!ボールペン・付箋・ウェットティッシュ http://www.pqnavi.com/reports/view/939 ━━━━━━━━━━━━━━━━━━━━━━━ 販促ノベルティ卸売りセンター http://www.pqnavi.com/ http://www.twitter.com/pqnavi http://www.facebook.com/pqnavicom ━━━━━━━━━━━━━━━━━━━━━━━ 電子POP卸売りセンター http://www.seasonsolution.jp/pop/ …………………………………………………… 文房具名入れ館 http://www.ccq.jp/ …………………………………………………… エコバッグ制作センター http://www.psps.jp/ …………………………………………………… 販促支援のシーズンソリューション株式会社 http://www.seasonsolution.jp/ 横浜市都筑区茅ヶ崎中央42-21第2佐藤ビル4F TEL:045-949-2557 FAX:045-949-4626 |
EMAIL_DOMAIN | localhost |
EMAIL_BCC_ADMIN | fujita@pqnavi.com |
EMAIL_FROM | fujita@pqnavi.com |
EMAIL_FROM_NAME | 販促ノベルティ卸売りセンター |
EMAIL_ESTIMATE_REGIST_SUBJ | [販促ノベルティ卸売りセンター]お見積り依頼 |
EMAIL_SAMPLE_REGIST_SUBJ | [販促ノベルティ卸売りセンター]有料サンプル請求 |
EMAIL_CATALOG_REGIST_SUBJ | [販促ノベルティ卸売りセンター]カタログ請求 |
EMAIL_ESTIMATE_ALL_SUBJ | [販促ノベルティ卸売りセンター]お見積書のお届け |
EMAIL_CLEARFILE_SUBJ | [販促ノベルティ卸売りセンター]お見積り依頼(A4クリアファイル) |
EMAIL_OTOIAWASE_SUBJ | [販促ノベルティ卸売りセンター]お問合わせ |
EMAIL_ESTIMATE_REGIST_SUBJ_ORDER | [販促ノベルティ卸売りセンター]ご注文完了 |
REPORT_BACKNUMBER_LIMIT | 20 |
REPORT_BACKNUMBER_SMART_PHONE_LIMIT | 30 |
USER_LINES_LIMIT | 15 |
USER_SMART_PHONE_LINES_LIMIT | 20 |
ADMIN_LINES_LIMIT | 30 |
ITEMS_SHOW_WIDTH_LIMIT_PICTURE | 4 |
ITEMS_SHOW_HEIGHT_LIMIT_PICTURE | 8 |
LIST_MODE | 1 |
PICTURE_MODE | 0 |
GALLERY_BACKNUMBER_LIMIT | 15 |
GALLARY_ITEMS | 6 |
GALLERY_BACKNUMBER_SMART_PHONE_LIMIT | 30 |
MAIL_RESERVATION_STATUS_WAIT | 1 |
MAIL_RESERVATION_STATUS_SENT | 2 |
MAIL_RESERVATION_STATUS_CANCEL | 3 |
MAIL_SEND_TYPE_TO | 1 |
MAIL_MAX_SEND_COUNT | 30 |
USE_MYSQL | 1 |
UPLOADDIR | /tmp |
EMAIL_QUESTIONNAIRE_SUBJ | [販促ノベルティ卸売りセンター]アンケートのお願い |
EMAIL_QUESTIONNAIRE170_SUBJ | [販促ノベルティ卸売りセンター] ニュースレター |
EMAIL_QUESTIONNAIRE350_SUBJ | [販促ノベルティ卸売りセンター] ニュースレター |
EMAIL_QUESTIONNAIRE710_SUBJ | [販促ノベルティ卸売りセンター] ニュースレター |
APP_NEWICON_SHOW_DAYS | 14 |
QUESTIONNAIRE_ITEMS | 5 |
QUESTIONNAIRE170_ITEMS | 12 |
QUESTIONNAIRE350_ITEMS | 16 |
QUESTIONNAIRE710_ITEMS | 20 |
MAIL_SEND_BY_SMTP | 0 |
RELATE_REPORT_COUNT | 7 |
MAIL_TEST_MAILTO | toyofuku@witinc.co.jp |
MAIL_TEST_MODE | 1 |
DBBACKUP_ON | 1 |
DBUPDATE_ON | ON |
SVNUPDATE_ON | ON |
SVN_CONFIG_DIR | /var/www/vhosts/.subversion/ |
SVN_USERNAME | season |
SVN_PASSWORD | wit150813 |
COOKIE_VIEW_PERIOD | +4 weeks |
RANDOM_CATEGORY | 25 |
Constant | Value |
---|---|
APP | /var/www/vhosts/test.pqnavi.com/httpdocs/app/ |
APP_DIR | app |
APPLIBS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/Lib/ |
CACHE | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/cache/ |
CAKE | /var/www/vhosts/test.pqnavi.com/httpdocs/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/lib |
CORE_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/lib/ |
CAKE_VERSION | 2.8.4 |
CSS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | http://test.pqnavi.com |
IMAGES | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/logs/ |
ROOT | /var/www/vhosts/test.pqnavi.com/httpdocs |
TESTS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/Test/ |
TMP | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/ |
VENDORS | /var/www/vhosts/test.pqnavi.com/httpdocs/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 7.0.7 |
Redirect Redirect Status | 200 |
Redirect Status | 200 |
Http Accept | */* |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Cookie | CAKEPHP=h2hd0kagl4h54084bn15d8agf2; CakeCookie[mode]=Q2FrZQ%3D%3D.ig%3D%3D; CakeCookie[watch_list]=Q2FrZQ%3D%3D.4U4ITfKxf9twyrXxIrPt1n7mRIdPfg%3D%3D |
Http Accept Encoding | gzip, br, zstd, deflate |
Http Referer | http://test.pqnavi.com/items/m_search?key=%E3%82%B9%E3%83%94%E3%83%BC%E3%83%89%E5%8D%B0%E5%88%B7 |
Http Host | test.pqnavi.com |
Http Via | 1.1 squid-proxy-5b5d847c96-pk9s8 (squid/6.10) |
Http X Forwarded For | 10.2.56.69 |
Http Cache Control | max-age=0 |
Http Connection | keep-alive |
Path | /sbin:/usr/sbin:/bin:/usr/bin |
Server Signature | <address>Apache/2.2.15 (CentOS) Server at test.pqnavi.com Port 80</address> |
Server Software | Apache/2.2.15 (CentOS) |
Server Name | test.pqnavi.com |
Server Addr | 153.120.157.97 |
Server Port | 80 |
Remote Addr | 216.73.216.159 |
Document Root | /var/www/vhosts/test.pqnavi.com/httpdocs |
Server Admin | wadmin@pqnavi.com |
Script Filename | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/index.php |
Remote Port | 34943 |
Redirect Query String | key=%E3%82%B9%E3%83%94%E3%83%BC%E3%83%89%E5%8D%B0%E5%88%B7 |
Redirect Url | /app/webroot/items/search |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | key=%E3%82%B9%E3%83%94%E3%83%BC%E3%83%89%E5%8D%B0%E5%88%B7 |
Request Uri | /items/search?key=%E3%82%B9%E3%83%94%E3%83%BC%E3%83%89%E5%8D%B0%E5%88%B7 |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1750679738.37 |
Request Time | 1750679738 |