商品ID:89171 |
![]() |
![]() |
![]() |
アイテムNo: |
25310G4 |
商品名: |
ライト付ボールペン ハンディー |
参考価格: |
180円 |
卸売り価格: |
106円 |
注文最小数量: |
★ 複数ロットは更にお得 200個 |
パッケージ/荷姿: |
化粧箱(添) |
パッケージサイズ: |
|
名入れ印刷について: |
名入れできるノベルティ素材商品です ※印刷費用は別途お見積り 名入れ最小数量:200個 ※最小数量未満は一括計算にてお見積り
|
重量/容量/サイズ: |
13g φ13×130mm |
カラー: |
|
主な素材/内容: |
ABS |
特徴/備考: |
リーズナブルで機能的、洗練されたデザインのライト付ボールペンです。LR41×3(内/交換不可) |
色違い/モデル違い: |
|
掲載カテゴリ: |
|
友達に教える: |
![]() |
![]() |
![]() |
<アウトレット売切廃盤> <お得なインクジェット> スリップインペン 白 卸価格:75円 ⇒ 15円 |
卸価格:87円 ⇒ 26円
|
卸価格:2,250円 ⇒ 1,125円
|
卸価格:5,500円 ⇒ 3,644円
|
[ダイナモライト] スマホ対応ダイナモFMラジオLEDライト ホワイト 卸価格:3,800円 ⇒ 1,900円
|
<アウトレット売切廃盤> ラペルツイストボールペン 3C レッド 卸価格:160円 ⇒ 80円
|
卸価格:1,550円 ⇒ 775円
|
卸価格:1,800円 ⇒ 900円
|
[保冷バッグ] クルリト クーラービッグマルシェバッグ スモークピンク 卸価格:2,680円 ⇒ 1,528円
|
卸価格:320円 ⇒ 192円
|
フェアトレードコットンキャンバスファスナーポーチ(L) スモークピンク 卸価格:900円 ⇒ 450円
|
卸価格:3,500円 ⇒ 2,057円
|
[お探しの検索ワードはコチラですか?]
ボールペン&シャープペン | シャープペン | 非常灯 | メタルペン | ラペルボールペン | ソーラーライト | 4色ボールペン | 筆ペン | ケース入り筆記具 | ランタン | ハンディライト | トーチ [特集] 特急7営業日!名入れスピード印刷、お急ぎのお客様は諦めずにご相談ください [特集] 写真も綺麗に印刷!フルカラー対応ノベルティ インクジェット、昇華転写など |
⇒ 人気ノベルティ:ボールペン・筆記具(ノンブランド品) ≪ベスト10≫
⇒ 人気ノベルティ:LEDライト・ダイナモライト・ランタン ≪ベスト10≫
後払い・送料0円・名入れデータ作成0円 |
|
名入れ!エコバッグ・マグカップ・ボトルなど |
|
冷やし中華、うどん、調味料。最短翌日出荷! |
|
オリジナルラベル対応!33円~送料無料 |
|
時節柄を問わない新アイテム 粗品・ご挨拶 |
|
お手頃で優しい風合い |
|
名入れ対応!非常用ライト・救急セットなど |
|
クリアファイル、ウェットティッシュ、付箋など |
|
ご相談下さい!名入れ印刷、特急7営業日 |
|
厚生労働省推進!思いやりグッズで好感度アップ |
|
注目!スタンド、チャージャー、ポーチ... |
|
写真も綺麗に印刷!フルカラー対応ノベルティ |
値引き商品 リスト|人気ランキング リスト|検索キーワード リスト|お取引について|名入れについて
販促レポート|名入れ制作事例|新着レビュー|オリジナルグッズ制作|会社案内|お問合せ
真面目にひた向きに、おかげ様で20周年
Copyright (C) 1998-2025 SeasonSolution All rights reserved.
No post data.
No querystring data.
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 `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified`, `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` 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` = 89171 AND `Item`.`item_rank` <> 9999 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` = (89171) | 2 | 2 | 13 | maybe slow |
SELECT count(DISTINCT Questionnaire.id) as q_cnt FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` INNER JOIN `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` ON (`Questionnaire`.`id`=`QuestionnaireItem`.`questionnaire_id` AND `QuestionnaireItem`.`item_id`=89171) WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89171) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25310G4'))))) OR (((`item_id2` = 89171) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25310G4'))))) OR (((`item_id3` = 89171) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25310G4')))))) ORDER BY `issue_date` desc LIMIT 100 | 0 | 0 | 0 | |
SELECT `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `id` = 31 AND `Category`.`flg_hidden` = 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `id` = 43 AND `Category`.`flg_hidden` = 0 LIMIT 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 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` IN (31, 43) AND `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 2 | 2 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_color`, `Item`.`file1_name`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_rank`, `Campaign`.`id`, `Campaign`.`campaign_price` 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` <> 89171 AND `Item`.`item_rank` = 1 AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 4 | 4 | 4 | 54 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94390) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1208-030'))))) OR (((`item_id2` = 94390) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1208-030'))))) OR (((`item_id3` = 94390) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1208-030')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 94390 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 99475) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25294G6'))))) OR (((`item_id2` = 99475) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25294G6'))))) OR (((`item_id3` = 99475) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25294G6')))))) 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` = 99475 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90880) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0015-030'))))) OR (((`item_id2` = 90880) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0015-030'))))) OR (((`item_id3` = 90880) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0015-030')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 90880 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91977) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25122G2'))))) OR (((`item_id2` = 91977) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25122G2'))))) OR (((`item_id3` = 91977) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25122G2')))))) 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` = 91977 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`category_id` IN (31, 43) | 2220 | 2220 | 13 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_color`, `Item`.`file1_name`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_rank`, `Campaign`.`id`, `Campaign`.`campaign_price` 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` <> 89171 AND `Item`.`id` IN (34689, 34690, 34691, 34693, 34694, 34695, 34696, 34697, 34698, 34699, 34700, 34701, 34702, 34703, 34704, 34705, 34706, 34707, 34708, 34709, 34712, 34713, 34714, 34715, 34716, 34717, 34719, 34720, 34721, 34723, 34724, 34726, 34727, 34730, 34733, 34740, 34741, 34742, 34743, 34744, 34745, 34746, 34748, 34749, 34750, 34751, 34752, 5650, 5790, 5779, 5801, 5696, 5781, 5697, 5789, 5768, 5703, 5691, 5780, 5783, 5753, 5784, 5757, 5693, 5751, 5766, 5707, 5695, 5786, 5799, 5778, 5714, 5704, 4996, 5694, 4969, 4997, 5064, 4963, 5793, 4968, 5062, 5770, 4965, 5795, 5800, 5769, 5797, 5706, 5802, 4967, 5794, 5708, 5692, 4964, 5702, 5063, 4966, 5796, 5705, 5767, 5752, 5785, 5782, 5788, 5774, 5787, 5773, 5772, 5771, 5798, 5759, 32806, 32814, 32813, 32812, 32811, 32810, 32809, 32808, 32807, 34710, 5701, 34718, 34725, 34735, 34738, 34737, 34755, 32744, 32743, 34739, 32916, 32917, 32918, 32919, 34729, 34728, 34731, 35736, 34734, 34736, 34732, 35734, 34692, 34722, 35739, 34747, 5712, 5713, 5737, 5738, 5736, 5709, 5710, 5711, 34753, 35405, 35733, 32843, 32844, 32845, 34754, 34711, 35756, 35755, 35735, 42740, 42741, 42743, 42746, 42747, 42748, 42751, 42752, 42753, 42754, 42755, 42756, 42757, 42758, 42759, 42760, 42761, 42762, 42763, 42764, 42765, 42766, 42767, 42768, 42769, 42770, 42771, 42772, 42773, 42774, 42775, 42776, 42777, 42778, 42779, 42780, 42781, 42782, 42783, 42784, 42785, 42786, 42789, 42790, 42791, 42792, 42797, 42798, 42799, 42800, 42801, 42802, 42803, 42804, 42805, 42806, 42807, 42808, 42809, 42810, 42811, 42812, 42813, 42814, 42815, 42816, 42817, 42904, 42905, 42796, 42795, 42818, 42788, 41287, 41283, 41281, 41280, 41277, 42787, 42750, 42745, 35746, 42749, 42744, 35778, 35757, 35758, 35708, 44582, 44583, 44584, 44585, 44586, 44587, 44588, 44589, 44590, 44591, 44592, 44593, 44594, 44595, 44596, 44597, 44598, 44599, 44600, 44601, 44602, 44603, 44604, 44605, 44606, 44607, 44608, 44609, 44610, 44611, 44612, 44613, 44614, 44615, 44616, 44617, 44618, 44619, 44620, 44621, 44622, 35741, 35728, 42742, 35740, 35744, 35750, 35780, 35753, 35782, 5791, 5792, 42641, 53201, 53202, 53203, 53204, 53205, 53207, 53208, 53209, 53210, 53211, 53212, 53213, 53214, 53215, 53216, 53217, 53218, 53219, 53220, 53221, 53222, 53223, 53224, 53225, 53227, 53228, 53229, 53230, 53231, 53232, 53233, 53234, 53235, 53236, 53237, 53238, 53239, 53241, 53243, 53245, 53246, 53247, 53248, 53249, 53250, 53251, 53252, 53253, 53254, 53255, 53256, 53258, 53260, 53261, 53262, 53263, 53265, 53266, 53267, 53268, 53269, 53270, 53272, 53273, 53275, 53276, 53277, 53278, 53279, 53280, 53281, 53282, 53283, 53284, 53285, 53286, 53287, 53288, 53289, 53290, 53291, 53292, 53293, 53294, 53295, 53296, 53297, 53298, 53300, 53301, 53302, 53303, 53304, 53306, 53307, 53308, 53309, 53310, 53311, 53313, 53314, 53315, 53316, 53317, 53318, 53319, 53320, 53321, 53322, 53323, 53324, 53325, 53327, 53328, 53329, 53330, 53815, 53816, 53817, 53818, 53819, 53820, 53821, 53822, 53823, 53824, 53825, 53826, 53827, 53828, 53829, 53830, 53831, 53832, 53833, 53834, 53835, 53836, 53837, 53838, 53839, 53840, 53841, 53842, 53843, 53844, 53845, 53846, 53848, 53849, 53850, 53851, 53852, 53853, 53854, 53855, 53856, 53857, 53858, 53859, 53860, 53861, 53862, 53863, 53864, 53865, 53866, 53867, 53868, 53869, 53870, 53871, 53872, 53873, 53874, 53876, 53877, 53878, 53879, 53880, 53881, 53882, 53883, 53884, 53885, 53886, 53887, 53888, 53889, 53890, 53891, 53892, 53893, 53894, 53895, 53896, 53897, 53898, 53899, 53900, 53901, 53902, 53903, 53904, 53905, 53906, 53907, 53908, 53909, 53911, 53912, 53913, 53914, 53915, 53916, 53917, 53918, 53919, 53920, 53921, 53922, 53923, 53925, 53926, 53927, 53928, 53929, 53930, 53931, 53932, 53933, 53934, 53935, 53936, 53937, 53938, 53939, 53940, 53941, 53942, 53943, 53944, 53945, 53949, 53950, 53951, 53952, 53959, 53960, 53961, 53962, 53963, 53964, 53965, 53966, 53967, 53968, 53970, 53971, 53972, 53973, 53974, 53976, 53977, 53978, 53979, 53980, 53981, 53982, 53983, 53984, 53985, 53986, 53987, 53988, 53989, 53990, 53991, 53992, 53994, 53996, 53997, 53998, 53999, 54000, 54002, 54003, 54004, 48445, 49274, 49207, 49154, 53958, 53957, 53956, 53955, 53954, 53953, 53948, 53947, 53946, 53995, 53993, 53975, 53326, 53226, 53271, 53299, 51400, 53242, 53305, 53312, 53206, 53244, 53924, 38529, 38528, 53875, 35712, 35713, 35714, 35718, 35716, 35720, 35721, 35737, 35738, 35772, 35774, 35775, 35776, 35777, 5756, 35742, 35789, 53259, 53264, 53257, 54070, 53969, 35715, 44765, 44767, 35717, 35773, 35535, 35784, 35727, 38479, 38478, 38481, 35467, 35709, 53240, 53847, 53274, 35711, 35707, 35710, 35747, 38502, 59324, 59325, 59334, 59336, 59337, 59340, 59353, 59357, 59358, 59361, 59363, 59367, 59368, 59369, 59371, 59373, 59374, 59375, 59378, 59382, 59384, 59385, 59387, 59388, 59389, 59392, 61089, 61090, 61091, 61094, 61095, 61096, 61097, 61098, 61099, 61101, 61102, 61103, 61105, 61106, 61110, 61111, 61114, 61116, 61117, 61119, 61120, 61121, 61122, 61123, 61124, 61125, 61126, 61127, 61128, 61129, 61130, 61131, 61132, 61134, 61136, 61137, 61138, 61139, 61140, 61141, 61142, 61143, 61144, 61145, 61146, 61147, 61148, 61149, 61150, 61151, 61152, 61153, 61154, 61155, 61156, 61157, 61158, 61159, 61160, 61161, 61162, 61163, 61164, 61166, 61169, 61170, 61171, 61173, 61174, 61175, 61176, 61178, 61179, 61181, 61182, 61183, 61184, 61185, 61188, 61189, 61190, 61198, 61199, 61201, 61202, 61203, 61205, 61206, 61207, 61210, 61211, 61212, 61214, 61215, 61216, 61219, 61220, 61221, 61222, 61223, 61225, 61226, 61227, 61228, 61229, 61230, 61231, 61233, 59377, 59351, 59390, 59386, 59338, 63866, 63864, 63862, 63861, 63860, 63901, 63857, 63856, 63851, 63912, 63829, 63867, 63891, 61340, 59354, 59333, 59391, 34922, 61218, 35779, 61177, 59352, 12997, 12998, 6792, 38522, 38523, 38524, 59379, 38500, 61187, 61213, 61587, 59383, 61107, 61108, 38501, 59343, 59344, 59345, 59348, 59393, 59394, 59395, 59396, 59397, 59364, 59365, 61104, 6793, 59339, 61186, 61217, 61196, 59360, 59332, 59331, 59330, 59329, 59328, 59327, 59326, 35748, 35745, 61232, 35743, 35749, 59362, 59376, 59381, 61197, 61204, 61209, 61200, 59341, 59349, 59359, 59356, 61109, 59372, 59366, 61167, 61224, 64998, 64999, 35754, 61208, 59350, 59335, 59342, 35731, 35729, 35790, 35761, 34926, 57689, 58216, 59370, 59380, 35752, 61610, 61168, 61133, 59346, 61180, 61135, 35751, 65161, 61165, 65169, 61172, 59355, 65122, 65160, 59347, 64429, 67311, 67312, 67313, 67314, 67315, 67316, 67317, 67318, 67319, 67320, 67321, 67322, 67323, 67324, 67325, 67326, 67327, 67328, 67329, 67330, 67331, 67332, 67333, 67334, 68397, 69883, 69884, 69891, 69892, 69894, 69898, 69899, 69900, 69901, 69902, 69903, 69905, 69906, 69909, 69910, 69912, 69913, 69915, 69916, 69917, 69920, 69921, 69922, 69923, 69924, 69925, 69926, 69927, 69928, 69929, 69930, 69931, 69932, 69934, 69938, 69939, 69944, 69947, 69949, 69950, 69951, 69952, 69953, 69954, 69955, 69957, 69958, 69959, 69960, 69961, 69964, 69965, 69972, 69981, 69982, 69983, 69984, 69985, 69986, 69987, 69988, 69989, 69992, 69994, 68401, 68428, 68413, 72547, 69895, 69701, 70166, 69889, 69897, 69885, 69971, 35770, 69968, 68394, 35723, 68410, 58271, 58272, 35722, 69976, 69978, 35732, 68391, 34935, 64992, 64993, 64994, 64995, 64996, 64997, 65000, 65164, 69945, 69820, 69907, 70699, 70700, 70701, 70702, 70163, 70164, 70695, 70696, 70697, 70698, 69700, 69966, 69956, 69946, 69937, 69936, 69935, 69080, 69086, 69896, 35759, 69908, 69980, 68389, 68412, 68405, 68406, 68425, 68381, 68380, 68377, 68376, 68372, 68371, 68370, 68369, 68427, 35781, 34924, 35767, 35719, 44766, 69893, 57712, 57713, 34918, 35771, 34927, 35769, 34917, 34925, 35768, 35494, 65284, 34931, 34929, 34919, 34921, 68388, 65002, 65001, 69990, 69993, 69991, 68385, 68387, 68407, 69963, 69962, 57711, 75186, 75187, 75188, 75189, 75190, 75191, 75192, 75193, 75195, 75196, 75197, 75198, 75199, 75200, 75201, 75202, 75204, 75205, 75208, 75209, 75210, 75212, 75213, 75215, 75216, 75217, 75218, 75219, 75220, 75221, 75222, 75223, 75224, 75228, 75229, 75230, 75231, 75235, 69882, 65003, 65004, 34916, 38480, 69702, 69904, 58206, 65367, 57693, 57694, 57692, 58217, 34923, 58205, 35730, 65162, 34934, 65159, 69948, 65006, 65007, 65009, 69941, 69977, 69967, 65008, 65005, 69975, 69973, 69974, 75214, 58218, 69881, 57691, 73503, 69890, 69888, 75310, 75311, 68392, 75313, 68393, 75312, 75315, 68398, 74186, 74187, 68400, 75314, 68403, 64450, 68404, 68408, 68409, 68415, 68416, 64448, 75316, 75317, 75318, 75319, 75320, 75321, 68423, 75322, 68421, 68418, 75323, 68386, 68384, 68379, 68378, 68373, 68374, 68375, 75324, 75325, 75326, 75232, 68368, 73597, 76386, 78142, 65167, 65800, 65369, 65354, 70198, 69911, 68382, 68383, 68419, 68420, 68395, 78664, 78684, 78659, 78660, 78661, 78662, 78663, 78665, 78666, 78699, 78687, 78688, 78689, 78690, 78691, 78692, 78693, 78694, 78695, 78696, 78697, 78698, 78671, 78672, 78673, 78674, 78675, 78676, 78677, 78678, 78679, 78680, 78681, 78682, 78683, 78685, 78686, 78667, 78668, 78669, 78670, 78700, 78701, 78702, 78703, 78704, 78705, 78706, 78707, 78710, 78719, 78720, 78721, 78722, 78723, 78724, 78726, 78727, 78737, 78738, 78739, 78740, 78713, 78714, 78715, 78716, 78717, 78729, 78730, 78731, 78734, 78735, 78736, 78733, 78732, 79075, 79076, 79077, 79078, 79079, 79080, 79081, 79082, 79083, 79084, 79085, 79086, 79088, 79091, 79092, 79093, 79094, 79095, 79096, 79098, 79099, 79100, 79101, 79103, 79105, 79106, 79107, 79108, 79109, 79110, 79112, 79113, 79114, 79115, 79116, 79117, 79118, 79119, 79120, 79121, 79122, 79104, 79123, 70103, 75233, 75203, 75227, 75226, 75225, 79788, 79796, 79790, 79089, 79102, 64616, 36382, 68429, 64546, 65168, 74189, 77077, 64451, 64439, 64452, 64446, 64449, 64441, 64445, 68422, 64447, 78711, 74188, 81109, 64642, 57690, 78027, 74173, 65793, 74827, 74174, 74825, 64617, 69979, 57716, 76366, 68701, 78028, 78029, 77239, 77241, 78143, 77574, 79097, 65792, 73646, 82299, 82300, 82301, 82302, 82304, 82305, 82306, 82308, 82309, 82310, 82311, 82312, 82313, 82314, 82315, 82316, 82318, 82319, 82320, 82321, 82322, 82323, 82324, 82325, 82326, 82327, 82329, 82330, 82331, 82333, 82336, 82337, 82340, 82342, 82344, 82345, 82332, 82518, 82519, 82522, 82523, 82525, 82527, 82528, 82529, 82534, 82535, 82536, 82540, 82545, 82547, 82548, 82549, 77238, 81190, 81191, 81137, 78718, 83258, 83300, 83293, 83299, 83291, 83310, 83259, 83255, 72689, 72660, 78712, 68414, 68417, 64443, 82538, 82541, 82537, 78728, 82298, 79111, 82303, 82335, 78136, 77240, 77689, 81139, 34936, 72722, 82524, 82542, 64620, 65197, 65195, 65196, 64444, 82543, 69970, 82334, 83996, 83997, 83998, 64619, 35534, 80620, 82544, 81136, 78725, 68402, 82539, 81105, 79087, 68396, 82521, 68424, 82526, 83941, 77690, 64621, 78708, 78709, 81734, 64478, 77076, 84248, 57649, 77693, 77694, 77688, 77687, 74176, 85749, 69886, 69940, 75234, 82338, 82343, 82341, 82339, 79090, 69942, 75206, 69914, 82317, 68399, 69969, 85579, 85580, 85581, 82307, 65794, 84223, 86085, 86084, 86777, 86778, 86779, 86780, 86781, 86782, 86783, 86784, 86785, 86910, 86911, 86912, 86913, 86914, 86915, 86916, 86917, 86918, 86919, 86922, 86923, 84029, 87016, 87017, 87018, 87019, 87020, 68390, 77692, 77691, 83999, 84000, 84001, 85397, 84034, 65150, 77568, 77749, 77571, 77754, 81104, 79789, 82546, 82520, 84137, 77078, 88277, 85533, 84959, 74175, 77570, 77567, 88618, 88619, 88635, 89147, 89148, 89149, 89150, 89151, 89152, 89153, 89154, 89156, 89157, 89159, 89160, 89161, 89162, 89163, 89165, 89172, 89173, 89174, 89175, 89176, 89178, 89180, 89181, 89182, 89183, 89184, 89188, 89189, 89190, 89192, 89193, 89194, 89195, 89196, 89197, 89198, 89201, 89203, 89205, 88349, 88484, 88623, 88636, 88634, 88633, 88632, 88630, 88629, 88628, 88627, 88626, 88625, 88624, 88622, 88621, 88620, 88617, 88701, 88702, 88705, 88706, 88707, 88713, 88714, 89164, 89171, 89170, 89177, 89185, 89186, 89187, 89766, 88604, 88605, 88606, 88607, 88608, 88609, 88610, 88611, 88612, 88613, 88614, 88615, 80603, 80606, 80601, 80605, 80599, 80600, 80602, 80604, 88482, 88481, 69919, 69918, 79073, 79074, 69933, 75207, 69943, 75211, 69033, 70165, 88637, 88480, 88483, 88616, 64738, 64737, 64643, 35787, 35404, 35402, 86054, 58116, 58118, 58121, 58117, 58119, 58120, 77573, 84139, 84028, 84920, 89200, 58269, 58270, 88631, 91323, 91401, 89169, 57695, 57696, 57697, 83752, 85718, 85717, 77698, 77697, 91008, 91007, 85712, 85711, 80539, 80540, 80538, 64430, 85445, 91473, 91472, 91471, 91479, 91478, 91477, 91476, 91475, 91474, 88148, 84284, 84285, 89199, 87674, 87673, 87675, 36230, 86921, 86920, 91484, 36231, 91753, 91882, 91883, 91884, 91885, 91886, 91887, 91888, 91889, 91891, 91892, 91893, 91894, 91895, 91896, 91897, 91898, 91899, 91900, 91901, 91902, 91903, 91904, 91905, 91906, 91907, 91908, 91909, 91910, 91911, 91912, 91913, 91914, 91915, 91916, 91917, 91918, 91919, 91920, 91921, 91922, 91923, 91924, 91925, 91927, 91928, 91929, 91930, 91931, 91932, 91934, 91936, 91937, 91940, 91941, 91942, 91943, 91944, 91946, 91948, 91949, 91950, 91951, 91953, 91954, 91956, 91957, 88149, 93934, 93933, 65029, 65163, 65795, 74409, 77108, 81096, 81097, 84224, 84937, 86101, 91721, 91722, 87825, 87824, 89158, 91933, 91935, 91938, 89166, 89167, 89168, 89179, 91945, 91947, 91926, 91952, 89202, 89204, 81116, 81138, 91939, 94366, 94365, 73781, 35760, 35764, 94561, 94560, 87302, 85180, 85182, 85178, 85179, 85181, 35783, 35786, 35788, 35785, 35403, 77236, 77235, 77234, 85177, 77237, 88274, 89155, 90454, 90327, 68510, 64440, 74424, 6777, 94727, 94728, 94726, 94725, 94760, 83938, 64438, 80586, 85715, 85716, 87375, 87374, 85186, 85188, 85183, 85184, 85185, 85187, 57686, 57685, 57688, 57687, 57684, 95183, 95187, 85176, 89191, 77075, 95200, 95204, 95203, 95202, 95201, 95190, 95191, 95193, 95194, 95195, 95196, 95197, 95198, 95199, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95310, 95311, 95312, 95313, 95314, 95315, 95316, 95317, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 90456, 91316, 91315, 95369, 95368, 95367, 95365, 95364, 91890, 95186, 95192, 85175, 74190, 95649, 95648, 95633, 95647, 95632, 95646, 95631, 95645, 95630, 95644, 95629, 95643, 95642, 95653, 95652, 95651, 95650, 6778, 6779, 95775, 95771, 95785, 90326, 93973, 93974, 93975, 90455, 95795, 95796, 95797, 95798, 95799, 95841, 95842, 95843, 95844, 95845, 95846, 95847, 95848, 95849, 95850, 96440, 96441, 96442, 96443, 96444, 96445, 96446, 96447, 96448, 96449, 96450, 96451, 96452, 96453, 96454, 96548, 96549, 96550, 96551, 96552, 96553, 96554, 96555, 96556, 96557, 96558, 96559, 96560, 96561, 96562, 96563, 96564, 96565, 96566, 96567, 97366, 97377, 97375, 87937, 87938, 85714, 85713, 84138, 97799, 81236, 84958, 84956, 77569, 98124, 98118, 98117, 98186, 98125, 91955, 35724, 35725, 35726, 65202, 65203, 64618, 35555, 35556, 35536, 35537, 57714, 57715, 77696, 77695, 85214, 85215, 98430, 98440, 98437, 94367, 87814, 88258, 85519, 57701, 57699, 57702, 57698, 57700, 57679, 57680, 57682, 57683, 57681, 35762, 35765, 73782, 73783, 35766, 35763, 73784, 94770, 98504, 98519, 98503, 98518, 98502, 98517, 98501, 98516, 98500, 98515, 98499, 98514, 98498, 98513, 98528, 98497, 98512, 98527, 98496, 98511, 98526, 98495, 98510, 98525, 98494, 98509, 98524, 98508, 98523, 98507, 98522, 98506, 98505, 98520, 81721, 94562, 98679, 98680, 98681, 98682, 98683, 98684, 98685, 98686, 98687, 98709, 98710, 98711, 98712, 98713, 98714, 98715, 98716, 98717, 98718, 98719, 98720, 99279, 99280, 99281, 99282, 99283, 99284, 99285, 99286) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 10 | maybe slow |
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 | 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` = 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` = 35786) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0706-009'))))) OR (((`item_id2` = 35786) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0706-009'))))) OR (((`item_id3` = 35786) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0706-009')))))) 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` = 35786 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85214) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1562-009'))))) OR (((`item_id2` = 85214) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1562-009'))))) OR (((`item_id3` = 85214) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1562-009')))))) 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` = 85214 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96445) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25151G9'))))) OR (((`item_id2` = 96445) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25151G9'))))) OR (((`item_id3` = 96445) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25151G9')))))) 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` = 96445 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85445) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'BE-50900'))))) OR (((`item_id2` = 85445) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'BE-50900'))))) OR (((`item_id3` = 85445) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'BE-50900')))))) 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` = 85445 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85180) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1557-002'))))) OR (((`item_id2` = 85180) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1557-002'))))) OR (((`item_id3` = 85180) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1557-002')))))) 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` = 85180 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77697) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1332-009'))))) OR (((`item_id2` = 77697) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1332-009'))))) OR (((`item_id3` = 77697) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1332-009')))))) 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` = 77697 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94726) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1822-009'))))) OR (((`item_id2` = 94726) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1822-009'))))) OR (((`item_id3` = 94726) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1822-009')))))) 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` = 94726 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Cnt`.`id`, `Cnt`.`item_id`, `Cnt`.`pagecnt`, `Cnt`.`listcnt`, `Cnt`.`estimatecnt`, `Cnt`.`created`, `Cnt`.`modified`, `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Cnt`.`item_id` = 89171 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` WHERE `Cnt`.`id` = 76776 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` WHERE `Cnt`.`id` = 76776 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` WHERE `Cnt`.`id` = 76776 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_cnts` SET `id` = 76776, `item_id` = 89171, `pagecnt` = 1770, `listcnt` = 1355, `estimatecnt` = 0, `created` = '2022-02-08 19:10:07', `modified` = '2022-02-08 19:10:07' WHERE `witinc_pqnavi_test`.`md_cnts`.`id` = '76776' | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
SELECT `Cntym`.`id`, `Cntym`.`yearmonth`, `Cntym`.`item_id`, `Cntym`.`pagecnt`, `Cntym`.`listcnt`, `Cntym`.`estimatecnt`, `Cntym`.`created`, `Cntym`.`modified`, `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`Cntym`.`item_id` = `Item`.`id`) WHERE `Cntym`.`yearmonth` = '202506' AND `Cntym`.`item_id` = 89171 LIMIT 1 | 1 | 1 | 353 | maybe slow |
BEGIN | 1 | 1 | 353 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` WHERE `Cntym`.`id` = 5475950 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` WHERE `Cntym`.`id` = 5475950 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` WHERE `Cntym`.`id` = 5475950 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_cntyms` SET `id` = 5475950, `yearmonth` = '202506', `item_id` = 89171, `pagecnt` = 2, `listcnt` = 1, `estimatecnt` = 0, `created` = '2025-06-15 17:28:01', `modified` = '2025-06-15 17:28:01' WHERE `witinc_pqnavi_test`.`md_cntyms`.`id` = '5475950' | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
SELECT `Cntym`.`id`, `Cntym`.`yearmonth`, `Cntym`.`item_id`, `Cntym`.`pagecnt`, `Cntym`.`listcnt`, `Cntym`.`estimatecnt`, `Cntym`.`created`, `Cntym`.`modified`, `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`Cntym`.`item_id` = `Item`.`id`) WHERE `item_id` = 89171 AND `yearmonth` like '2025%' | 5 | 5 | 293 | maybe slow |
SELECT `Campaigntt`.`id`, `Campaigntt`.`name`, `Campaigntt`.`description`, `Campaigntt`.`toyear`, `Campaigntt`.`tomonth`, `Campaigntt`.`todate`, `Campaigntt`.`created`, `Campaigntt`.`modified` FROM `witinc_pqnavi_test`.`md_campaigntts` AS `Campaigntt` WHERE `Campaigntt`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ItemsReport`.`id`, `ItemsReport`.`item_id`, `ItemsReport`.`report_id`, `ItemsReport`.`created`, `ItemsReport`.`modified`, `Report`.`id`, `Report`.`title`, `Report`.`summary`, `Report`.`url`, `Report`.`seitekiurl`, `Report`.`content`, `Report`.`item_code1`, `Report`.`item_code2`, `Report`.`item_code3`, `Report`.`item_id1`, `Report`.`item_id2`, `Report`.`item_id3`, `Report`.`access`, `Report`.`created`, `Report`.`modified` FROM `witinc_pqnavi_test`.`md_items_reports` AS `ItemsReport` LEFT JOIN `witinc_pqnavi_test`.`md_reports` AS `Report` ON (`ItemsReport`.`report_id` = `Report`.`id`) WHERE `ItemsReport`.`item_id` = 89171 ORDER BY `Report`.`created` DESC, `Report`.`id` DESC | 0 | 0 | 1 | maybe slow |
6 duplicate queries run.
Peak Memory Use 10.55 MB
Message | Memory use |
---|---|
Component initialization | 3.68 MB |
Controller action start | 5.10 MB |
Controller render start | 6.09 MB |
View render complete | 7.62 MB |
Total Request Time: 849 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 29.29 | |
Event: Controller.initialize | 7.42 | |
Event: Controller.startup | 0.31 | |
Controller action | 767.06 | |
Event: Controller.beforeRender | 5.99 | |
» Processing toolbar data | 5.91 | |
Rendering View | 14.94 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Items/view.ctp | 14.17 | |
» » Rendering APP/View/Elements/Head_menu.ctp | 0.06 | |
» » Rendering APP/View/Elements/Head_txt.ctp | 0.05 | |
» » Rendering APP/View/Elements/items_view_category_link.ctp | 0.08 | |
» » Rendering APP/View/Elements/Snsbuttonlink.ctp | 0.05 | |
» » Rendering APP/View/Elements/guidelink.ctp | 0.06 | |
» » Rendering APP/View/Elements/price.ctp | 0.09 | |
» » Rendering APP/View/Elements/icon_set.ctp | 0.11 | |
» » Rendering APP/View/Elements/price.ctp #2 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #2 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #3 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #3 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #4 | 0.09 | |
» » Rendering APP/View/Elements/icon_set.ctp #4 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #5 | 0.09 | |
» » Rendering APP/View/Elements/icon_set.ctp #5 | 0.09 | |
» » Rendering APP/View/Elements/price.ctp #6 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #6 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #7 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #7 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #8 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #8 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #9 | 0.09 | |
» » Rendering APP/View/Elements/icon_set.ctp #9 | 0.09 | |
» » Rendering APP/View/Elements/price.ctp #10 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #10 | 0.08 | |
» » Rendering APP/View/Elements/price.ctp #11 | 0.08 | |
» » Rendering APP/View/Elements/icon_set.ctp #11 | 0.10 | |
» » Rendering APP/View/Elements/price.ctp #12 | 0.16 | |
» » Rendering APP/View/Elements/icon_set.ctp #12 | 0.14 | |
» » Rendering APP/View/Elements/icon.ctp | 0.08 | |
» » Rendering APP/View/Elements/prlink.ctp | 0.38 | |
» » Rendering APP/View/Elements/Area_left.ctp | 5.39 | |
» » » Rendering APP/View/Elements/serchlink.ctp | 1.52 | |
» » » Rendering APP/View/Elements/speciallink.ctp | 0.19 | |
» » » Rendering APP/View/Elements/pricelink.ctp | 0.85 | |
» » » Rendering APP/View/Elements/cataloglink.ctp | 0.08 | |
» » Rendering APP/View/Elements/footlink.ctp | 0.45 | |
» » Rendering APP/View/Elements/Analyticslink.ctp | 0.08 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 0.09 | |
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=b7opkjqa2daddqlt1d3jam6ub1; CakeCookie[mode]=Q2FrZQ%3D%3D.iw%3D%3D; CakeCookie[viewids]=Q2FrZQ%3D%3D.wQJEGK6vacB63LHxMqri3379ToRNE4Ws9saqfEN%2B1GUnYNLd9FdcmUYKDMOhiVv8fMALth5d2f2EmVK4f%2BWxKRDlLWLAQg93EmB7WnT%2FAJEi1%2Fe99XlHoJIlaEzXtUTnACtRWSpl7EnWy5iG5R9yPe2CkNCsXJUacw%3D%3D |
Http Accept Encoding | gzip, br, zstd, deflate |
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=259200 |
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 | 39759 |
Redirect Url | /app/webroot/items/view/89171 |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | /items/view/89171 |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1750848635.621 |
Request Time | 1750848635 |