SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003206s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=A122&search=1' [ RunTime:0.003275s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002296s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003380s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002530s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002426s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010454s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002158s ]
SELECT * FROM `stock_search` WHERE `partno` = 'A122' LIMIT 1 [ RunTime:0.008787s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 22:22:28' WHERE `partno` = 'A122' [ RunTime:0.022073s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002372s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038045s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180180 LIMIT 5 [ RunTime:0.011550s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180180 ORDER BY `minOrder` ASC [ RunTime:0.013617s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19180180 ORDER BY `unit` DESC [ RunTime:0.015026s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19180180 LIMIT 2 [ RunTime:0.017926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180180 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19177977 LIMIT 5 [ RunTime:0.006763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19177977 ORDER BY `minOrder` ASC [ RunTime:0.002735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19177977 ORDER BY `unit` DESC [ RunTime:0.007861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19177977 LIMIT 2 [ RunTime:0.019211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19177977 ORDER BY `minOrder` ASC [ RunTime:0.001890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17105403 LIMIT 5 [ RunTime:0.011394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105403 ORDER BY `minOrder` ASC [ RunTime:0.013840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17105403 ORDER BY `unit` DESC [ RunTime:0.005564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17105403 LIMIT 2 [ RunTime:0.019919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105403 ORDER BY `minOrder` ASC [ RunTime:0.007163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180158 LIMIT 5 [ RunTime:0.007527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180158 ORDER BY `minOrder` ASC [ RunTime:0.014624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19180158 ORDER BY `unit` DESC [ RunTime:0.009518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19180158 LIMIT 2 [ RunTime:0.025355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180158 ORDER BY `minOrder` ASC [ RunTime:0.011515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19177980 LIMIT 5 [ RunTime:0.003169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19177980 ORDER BY `minOrder` ASC [ RunTime:0.012213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19177980 ORDER BY `unit` DESC [ RunTime:0.011205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19177980 LIMIT 2 [ RunTime:0.006905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19177980 ORDER BY `minOrder` ASC [ RunTime:0.001848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180417 LIMIT 5 [ RunTime:0.003285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180417 ORDER BY `minOrder` ASC [ RunTime:0.003497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19180417 ORDER BY `unit` DESC [ RunTime:0.018881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19180417 LIMIT 2 [ RunTime:0.022871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180417 ORDER BY `minOrder` ASC [ RunTime:0.007602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17105832 LIMIT 5 [ RunTime:0.028967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105832 ORDER BY `minOrder` ASC [ RunTime:0.011113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17105832 ORDER BY `unit` DESC [ RunTime:0.008914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17105832 LIMIT 2 [ RunTime:0.011489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105832 ORDER BY `minOrder` ASC [ RunTime:0.011300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19179490 LIMIT 5 [ RunTime:0.002359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19179490 ORDER BY `minOrder` ASC [ RunTime:0.011347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19179490 ORDER BY `unit` DESC [ RunTime:0.004936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19179490 LIMIT 2 [ RunTime:0.005471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19179490 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180407 LIMIT 5 [ RunTime:0.000946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180407 ORDER BY `minOrder` ASC [ RunTime:0.003099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19180407 ORDER BY `unit` DESC [ RunTime:0.006087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19180407 LIMIT 2 [ RunTime:0.009696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180407 ORDER BY `minOrder` ASC [ RunTime:0.006108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180430 LIMIT 5 [ RunTime:0.002321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180430 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19180430 ORDER BY `unit` DESC [ RunTime:0.001206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19180430 LIMIT 2 [ RunTime:0.003661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19180430 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234786 LIMIT 5 [ RunTime:0.002984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234786 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14234786 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14234786 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234786 ORDER BY `minOrder` ASC [ RunTime:0.003598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17105835 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105835 ORDER BY `minOrder` ASC [ RunTime:0.010770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17105835 ORDER BY `unit` DESC [ RunTime:0.004960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17105835 LIMIT 2 [ RunTime:0.025080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105835 ORDER BY `minOrder` ASC [ RunTime:0.006844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15326213 LIMIT 5 [ RunTime:0.001443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15326213 ORDER BY `minOrder` ASC [ RunTime:0.010644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15326213 ORDER BY `unit` DESC [ RunTime:0.005259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15326213 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15326213 ORDER BY `minOrder` ASC [ RunTime:0.003139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17105848 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105848 ORDER BY `minOrder` ASC [ RunTime:0.004604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17105848 ORDER BY `unit` DESC [ RunTime:0.002646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17105848 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17105848 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19179500 LIMIT 5 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19179500 ORDER BY `minOrder` ASC [ RunTime:0.010450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19179500 ORDER BY `unit` DESC [ RunTime:0.003342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19179500 LIMIT 2 [ RunTime:0.023992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19179500 ORDER BY `minOrder` ASC [ RunTime:0.018103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19178224 LIMIT 5 [ RunTime:0.004488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19178224 ORDER BY `minOrder` ASC [ RunTime:0.014094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19178224 ORDER BY `unit` DESC [ RunTime:0.037717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19178224 LIMIT 2 [ RunTime:0.013571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19178224 ORDER BY `minOrder` ASC [ RunTime:0.009627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13884079 LIMIT 5 [ RunTime:0.013339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13884079 ORDER BY `minOrder` ASC [ RunTime:0.038037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13884079 ORDER BY `unit` DESC [ RunTime:0.022780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13884079 LIMIT 2 [ RunTime:0.010211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13884079 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14757752 LIMIT 5 [ RunTime:0.006796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14757752 ORDER BY `minOrder` ASC [ RunTime:0.007262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14757752 ORDER BY `unit` DESC [ RunTime:0.002608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14757752 LIMIT 2 [ RunTime:0.017130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14757752 ORDER BY `minOrder` ASC [ RunTime:0.001894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14757708 LIMIT 5 [ RunTime:0.020896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14757708 ORDER BY `minOrder` ASC [ RunTime:0.007572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14757708 ORDER BY `unit` DESC [ RunTime:0.003770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14757708 LIMIT 2 [ RunTime:0.021567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14757708 ORDER BY `minOrder` ASC [ RunTime:0.016964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19178146 LIMIT 5 [ RunTime:0.010655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19178146 ORDER BY `minOrder` ASC [ RunTime:0.017094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19178146 ORDER BY `unit` DESC [ RunTime:0.007724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19178146 LIMIT 2 [ RunTime:0.008282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19178146 ORDER BY `minOrder` ASC [ RunTime:0.012019s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32250895 LIMIT 5 [ RunTime:0.016222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32250895 ORDER BY `minOrder` ASC [ RunTime:0.030276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32250895 ORDER BY `unit` DESC [ RunTime:0.009931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32250895 LIMIT 2 [ RunTime:0.009011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32250895 ORDER BY `minOrder` ASC [ RunTime:0.009168s ]
select * from pdf where partno='a1220llhlx-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.007919s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1220llhlx-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.006799s ]
SELECT `id` FROM `stock` WHERE `id` <> 32250895 AND `partno` = 'a1220llhlx-t' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.017098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19179490 [ RunTime:0.002910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251541 LIMIT 5 [ RunTime:0.001784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251541 ORDER BY `minOrder` ASC [ RunTime:0.004875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251541 ORDER BY `unit` DESC [ RunTime:0.006009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251541 LIMIT 2 [ RunTime:0.004100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251541 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
select * from pdf where partno='a1220lua-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.003747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1220lua-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.020312s ]
SELECT `id` FROM `stock` WHERE `id` <> 32251541 AND `partno` = 'a1220lua-t' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.016648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19177980 [ RunTime:0.007852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251107 LIMIT 5 [ RunTime:0.015767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251107 ORDER BY `minOrder` ASC [ RunTime:0.008959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251107 ORDER BY `unit` DESC [ RunTime:0.029592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251107 LIMIT 2 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251107 ORDER BY `minOrder` ASC [ RunTime:0.004532s ]
select * from pdf where partno='a1221llhlx-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.015320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1221llhlx-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.007966s ]
SELECT `id` FROM `stock` WHERE `id` <> 32251107 AND `partno` = 'a1221llhlx-t' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.018650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180417 [ RunTime:0.015393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251741 LIMIT 5 [ RunTime:0.003985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251741 ORDER BY `minOrder` ASC [ RunTime:0.001412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251741 ORDER BY `unit` DESC [ RunTime:0.001637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251741 LIMIT 2 [ RunTime:0.003608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251741 ORDER BY `minOrder` ASC [ RunTime:0.004564s ]
select * from pdf where partno='a1221elhlt-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.000738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1221elhlt-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.015442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251609 LIMIT 5 [ RunTime:0.009003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251609 ORDER BY `minOrder` ASC [ RunTime:0.003495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251609 ORDER BY `unit` DESC [ RunTime:0.001546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251609 LIMIT 2 [ RunTime:0.008247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251609 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
select * from pdf where partno='a1220elhlt-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.003958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1220elhlt-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251053 LIMIT 5 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251053 ORDER BY `minOrder` ASC [ RunTime:0.001093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251053 ORDER BY `unit` DESC [ RunTime:0.002303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251053 LIMIT 2 [ RunTime:0.010994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251053 ORDER BY `minOrder` ASC [ RunTime:0.008324s ]
select * from pdf where partno='a1221llhlt-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.002179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1221llhlt-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.001247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251035 LIMIT 5 [ RunTime:0.001410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251035 ORDER BY `minOrder` ASC [ RunTime:0.006150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251035 ORDER BY `unit` DESC [ RunTime:0.011473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251035 LIMIT 2 [ RunTime:0.015722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251035 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
select * from pdf where partno='a1222lua-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.003759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1222lua-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.001097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251280 LIMIT 5 [ RunTime:0.001883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251280 ORDER BY `minOrder` ASC [ RunTime:0.008750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251280 ORDER BY `unit` DESC [ RunTime:0.005123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251280 LIMIT 2 [ RunTime:0.015104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251280 ORDER BY `minOrder` ASC [ RunTime:0.002673s ]
select * from pdf where partno='a1223elhlt-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.006019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1223elhlt-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.009145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251245 LIMIT 5 [ RunTime:0.010657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251245 ORDER BY `minOrder` ASC [ RunTime:0.021694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251245 ORDER BY `unit` DESC [ RunTime:0.006467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251245 LIMIT 2 [ RunTime:0.015130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251245 ORDER BY `minOrder` ASC [ RunTime:0.004666s ]
select * from pdf where partno='a1221lua-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.007538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1221lua-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.007405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32251890 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251890 ORDER BY `minOrder` ASC [ RunTime:0.003115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32251890 ORDER BY `unit` DESC [ RunTime:0.001765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32251890 LIMIT 2 [ RunTime:0.001530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32251890 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='a1220eua-t' and brandshort='allegro microsystems' limit 1 [ RunTime:0.001073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1220eua-t' OR `brand` LIKE 'allegro microsystems%' ) ) LIMIT 1 [ RunTime:0.003254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088182 LIMIT 5 [ RunTime:0.002421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088182 ORDER BY `minOrder` ASC [ RunTime:0.004054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088182 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088182 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088182 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
select * from pdf where partno='a1225e' and brandshort='crydom' limit 1 [ RunTime:0.007750s ]
select foldpath,foldpath2,filename from pdf_file where id=1204186 limit 1 [ RunTime:0.005152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a1225e' OR `brand` LIKE 'crydom%' ) ) LIMIT 1 [ RunTime:0.005926s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088182 AND `partno` = 'a1225e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%crydom%' ) [ RunTime:0.028334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17150668 [ RunTime:0.026043s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351777 LIMIT 5 [ RunTime:0.005566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351777 ORDER BY `minOrder` ASC [ RunTime:0.013834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351777 ORDER BY `unit` DESC [ RunTime:0.004885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351777 LIMIT 2 [ RunTime:0.011104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351777 ORDER BY `minOrder` ASC [ RunTime:0.023209s ]
select * from pdf where partno='A1221LLHLT-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.007566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1221LLHLT-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.020987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351763 LIMIT 5 [ RunTime:0.013616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351763 ORDER BY `minOrder` ASC [ RunTime:0.011947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351763 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351763 LIMIT 2 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351763 ORDER BY `minOrder` ASC [ RunTime:0.002905s ]
select * from pdf where partno='A1221ELHLT-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.006112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1221ELHLT-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.018176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351590 LIMIT 5 [ RunTime:0.025432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351590 ORDER BY `minOrder` ASC [ RunTime:0.037173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351590 ORDER BY `unit` DESC [ RunTime:0.040415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351590 LIMIT 2 [ RunTime:0.027103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351590 ORDER BY `minOrder` ASC [ RunTime:0.008302s ]
select * from pdf where partno='A1220LLHLT-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.042066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1220LLHLT-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.030199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351764 LIMIT 5 [ RunTime:0.031324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351764 ORDER BY `minOrder` ASC [ RunTime:0.022531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351764 ORDER BY `unit` DESC [ RunTime:0.028935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351764 LIMIT 2 [ RunTime:0.015609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351764 ORDER BY `minOrder` ASC [ RunTime:0.028477s ]
select * from pdf where partno='A1220ELHLT-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.004175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1220ELHLT-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.037377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351592 LIMIT 5 [ RunTime:0.025716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351592 ORDER BY `minOrder` ASC [ RunTime:0.008172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351592 ORDER BY `unit` DESC [ RunTime:0.025842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351592 LIMIT 2 [ RunTime:0.018130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351592 ORDER BY `minOrder` ASC [ RunTime:0.023035s ]
select * from pdf where partno='A1220LUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.011669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1220LUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.017676s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351592 AND `partno` = 'A1220LUA-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.030488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19177980 [ RunTime:0.020286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351979 LIMIT 5 [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351979 ORDER BY `minOrder` ASC [ RunTime:0.016004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351979 ORDER BY `unit` DESC [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351979 LIMIT 2 [ RunTime:0.009291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351979 ORDER BY `minOrder` ASC [ RunTime:0.004279s ]
select * from pdf where partno='A1220LLHLX-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.004100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1220LLHLX-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.013357s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351979 AND `partno` = 'A1220LLHLX-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.018504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19179490 [ RunTime:0.013307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63330528 LIMIT 5 [ RunTime:0.003715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330528 ORDER BY `minOrder` ASC [ RunTime:0.020779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63330528 ORDER BY `unit` DESC [ RunTime:0.032350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63330528 LIMIT 2 [ RunTime:0.031130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330528 ORDER BY `minOrder` ASC [ RunTime:0.027406s ]
select * from pdf where partno='A1221EUATC-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.013978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1221EUATC-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.014421s ]
SELECT `id` FROM `stock` WHERE `id` <> 63330528 AND `partno` = 'A1221EUATC-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.020322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63352203 LIMIT 5 [ RunTime:0.025620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352203 ORDER BY `minOrder` ASC [ RunTime:0.034727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63352203 ORDER BY `unit` DESC [ RunTime:0.024138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63352203 LIMIT 2 [ RunTime:0.011877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352203 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
select * from pdf where partno='A1221LLHLX-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.003861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1221LLHLX-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.001439s ]
SELECT `id` FROM `stock` WHERE `id` <> 63352203 AND `partno` = 'A1221LLHLX-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.010918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19180417 [ RunTime:0.008697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351989 LIMIT 5 [ RunTime:0.008561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351989 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351989 ORDER BY `unit` DESC [ RunTime:0.011275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351989 LIMIT 2 [ RunTime:0.011038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351989 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='A1222LLHLT-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.000916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1222LLHLT-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.002185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63352169 LIMIT 5 [ RunTime:0.010672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352169 ORDER BY `minOrder` ASC [ RunTime:0.000838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63352169 ORDER BY `unit` DESC [ RunTime:0.003890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63352169 LIMIT 2 [ RunTime:0.001409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352169 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='A1223ELHLT-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1223ELHLT-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.005784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351980 LIMIT 5 [ RunTime:0.002107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351980 ORDER BY `minOrder` ASC [ RunTime:0.000842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351980 ORDER BY `unit` DESC [ RunTime:0.006676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351980 LIMIT 2 [ RunTime:0.012709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351980 ORDER BY `minOrder` ASC [ RunTime:0.005015s ]
select * from pdf where partno='A1220EUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.001877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1220EUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.021821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63352238 LIMIT 5 [ RunTime:0.008987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352238 ORDER BY `minOrder` ASC [ RunTime:0.008160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63352238 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63352238 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352238 ORDER BY `minOrder` ASC [ RunTime:0.003076s ]
select * from pdf where partno='A1229LUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.023151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1229LUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.004971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351990 LIMIT 5 [ RunTime:0.010586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351990 ORDER BY `minOrder` ASC [ RunTime:0.019129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351990 ORDER BY `unit` DESC [ RunTime:0.003917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351990 LIMIT 2 [ RunTime:0.011600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351990 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='A1223LUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1223LUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.001280s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351990 AND `partno` = 'A1223LUA-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.003919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17105835 [ RunTime:0.008331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63352000 LIMIT 5 [ RunTime:0.008657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352000 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63352000 ORDER BY `unit` DESC [ RunTime:0.012499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63352000 LIMIT 2 [ RunTime:0.001059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352000 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='A1222LUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.003865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1222LUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.004342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63352239 LIMIT 5 [ RunTime:0.013298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352239 ORDER BY `minOrder` ASC [ RunTime:0.010716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63352239 ORDER BY `unit` DESC [ RunTime:0.007022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63352239 LIMIT 2 [ RunTime:0.026533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352239 ORDER BY `minOrder` ASC [ RunTime:0.008397s ]
select * from pdf where partno='A1227LUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.005540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1227LUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.034337s ]
SELECT `id` FROM `stock` WHERE `id` <> 63352239 AND `partno` = 'A1227LUA-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.014759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15326213 [ RunTime:0.013263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63352204 LIMIT 5 [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352204 ORDER BY `minOrder` ASC [ RunTime:0.000914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63352204 ORDER BY `unit` DESC [ RunTime:0.021096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63352204 LIMIT 2 [ RunTime:0.014670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63352204 ORDER BY `minOrder` ASC [ RunTime:0.003738s ]
select * from pdf where partno='A1221EUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.015515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1221EUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.013142s ]
SELECT `id` FROM `stock` WHERE `id` <> 63352204 AND `partno` = 'A1221EUA-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.026473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234786 [ RunTime:0.016985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351991 LIMIT 5 [ RunTime:0.010419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351991 ORDER BY `minOrder` ASC [ RunTime:0.061247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351991 ORDER BY `unit` DESC [ RunTime:0.021683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351991 LIMIT 2 [ RunTime:0.022464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351991 ORDER BY `minOrder` ASC [ RunTime:0.008983s ]
select * from pdf where partno='A1221LUA-T' and brandshort='Allegro MicroSystems' limit 1 [ RunTime:0.005468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1221LUA-T' OR `brand` LIKE 'Allegro MicroSystems%' ) ) LIMIT 1 [ RunTime:0.026950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64308336 LIMIT 5 [ RunTime:0.026644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64308336 ORDER BY `minOrder` ASC [ RunTime:0.023547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64308336 ORDER BY `unit` DESC [ RunTime:0.003793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64308336 LIMIT 2 [ RunTime:0.016336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64308336 ORDER BY `minOrder` ASC [ RunTime:0.013721s ]
select * from pdf where partno='A1224S-2WR3' and brandshort='Mornsun America, LLC' limit 1 [ RunTime:0.030211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1224S-2WR3' OR `brand` LIKE 'Mornsun America, LLC%' ) ) LIMIT 1 [ RunTime:0.012780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64308402 LIMIT 5 [ RunTime:0.015615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64308402 ORDER BY `minOrder` ASC [ RunTime:0.004676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64308402 ORDER BY `unit` DESC [ RunTime:0.002957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64308402 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64308402 ORDER BY `minOrder` ASC [ RunTime:0.004723s ]
select * from pdf where partno='A1224D-2WR3' and brandshort='Mornsun America, LLC' limit 1 [ RunTime:0.015940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1224D-2WR3' OR `brand` LIKE 'Mornsun America, LLC%' ) ) LIMIT 1 [ RunTime:0.003698s ]
SELECT `id` FROM `stock` WHERE `id` <> 64308402 AND `partno` = 'A1224D-2WR3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mornsun america, llc%' ) [ RunTime:0.021973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14757752 [ RunTime:0.021359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64308306 LIMIT 5 [ RunTime:0.015381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64308306 ORDER BY `minOrder` ASC [ RunTime:0.023091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64308306 ORDER BY `unit` DESC [ RunTime:0.017991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64308306 LIMIT 2 [ RunTime:0.004310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64308306 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='A1224D-1WR3' and brandshort='Mornsun America, LLC' limit 1 [ RunTime:0.002838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1224D-1WR3' OR `brand` LIKE 'Mornsun America, LLC%' ) ) LIMIT 1 [ RunTime:0.021777s ]
SELECT `id` FROM `stock` WHERE `id` <> 64308306 AND `partno` = 'A1224D-1WR3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mornsun america, llc%' ) [ RunTime:0.017873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14757708 [ RunTime:0.022407s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007168s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014395s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020132s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017011s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005281s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001889s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010539s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A122%' OR `brand` LIKE 'A122%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007649s ]