SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001528s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=5695&search=1' [ RunTime:0.002913s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002683s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000714s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001688s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.000377s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001406s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001729s ]
SELECT * FROM `stock_search` WHERE `partno` = '5695' LIMIT 1 [ RunTime:0.014768s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-22 15:50:15' WHERE `partno` = '5695' [ RunTime:0.013137s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002566s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018052s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377030 LIMIT 5 [ RunTime:0.003084s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377030 ORDER BY `minOrder` ASC [ RunTime:0.002070s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377030 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377030 LIMIT 2 [ RunTime:0.001707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377030 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266128 LIMIT 5 [ RunTime:0.001019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266128 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14266128 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14266128 LIMIT 2 [ RunTime:0.009904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266128 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377038 LIMIT 5 [ RunTime:0.005918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377038 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377038 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377038 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377038 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377062 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377062 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377062 ORDER BY `unit` DESC [ RunTime:0.000850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377062 LIMIT 2 [ RunTime:0.003224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377062 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260541 LIMIT 5 [ RunTime:0.002990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260541 ORDER BY `minOrder` ASC [ RunTime:0.004713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260541 ORDER BY `unit` DESC [ RunTime:0.001903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260541 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260541 ORDER BY `minOrder` ASC [ RunTime:0.003651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260622 LIMIT 5 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260622 ORDER BY `minOrder` ASC [ RunTime:0.002330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260622 ORDER BY `unit` DESC [ RunTime:0.001135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260622 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260622 ORDER BY `minOrder` ASC [ RunTime:0.003634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064165 LIMIT 5 [ RunTime:0.011898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064165 ORDER BY `minOrder` ASC [ RunTime:0.007424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12064165 ORDER BY `unit` DESC [ RunTime:0.001128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12064165 LIMIT 2 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064165 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387351 LIMIT 5 [ RunTime:0.001036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387351 ORDER BY `minOrder` ASC [ RunTime:0.002791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387351 ORDER BY `unit` DESC [ RunTime:0.002981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387351 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387351 ORDER BY `minOrder` ASC [ RunTime:0.007309s ]
select * from pdf where partno='5695 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335871 LIMIT 5 [ RunTime:0.004723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335871 ORDER BY `minOrder` ASC [ RunTime:0.007625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335871 ORDER BY `unit` DESC [ RunTime:0.013414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335871 LIMIT 2 [ RunTime:0.004722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335871 ORDER BY `minOrder` ASC [ RunTime:0.003362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073716 LIMIT 5 [ RunTime:0.001914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073716 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073716 ORDER BY `unit` DESC [ RunTime:0.006319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073716 LIMIT 2 [ RunTime:0.004790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073716 ORDER BY `minOrder` ASC [ RunTime:0.001498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394583 LIMIT 5 [ RunTime:0.012528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394583 ORDER BY `minOrder` ASC [ RunTime:0.002338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394583 ORDER BY `unit` DESC [ RunTime:0.000987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394583 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394583 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379559 LIMIT 5 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379559 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379559 ORDER BY `unit` DESC [ RunTime:0.011909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379559 LIMIT 2 [ RunTime:0.006972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379559 ORDER BY `minOrder` ASC [ RunTime:0.005897s ]
select * from pdf where partno='5695 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523212 LIMIT 5 [ RunTime:0.003470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523212 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523212 ORDER BY `unit` DESC [ RunTime:0.001393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523212 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523212 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505839 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505839 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505839 ORDER BY `unit` DESC [ RunTime:0.002522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505839 LIMIT 2 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505839 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='5695 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505638 LIMIT 5 [ RunTime:0.002879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505638 ORDER BY `minOrder` ASC [ RunTime:0.001197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505638 ORDER BY `unit` DESC [ RunTime:0.002008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505638 LIMIT 2 [ RunTime:0.001254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505638 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
select * from pdf where partno='5695 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502469 LIMIT 5 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13502469 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13502469 ORDER BY `unit` DESC [ RunTime:0.001478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13502469 LIMIT 2 [ RunTime:0.008449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13502469 ORDER BY `minOrder` ASC [ RunTime:0.005700s ]
select * from pdf where partno='5695 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13479231 LIMIT 5 [ RunTime:0.006549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479231 ORDER BY `minOrder` ASC [ RunTime:0.006004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13479231 ORDER BY `unit` DESC [ RunTime:0.008042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13479231 LIMIT 2 [ RunTime:0.018175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479231 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13479230 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479230 ORDER BY `minOrder` ASC [ RunTime:0.010196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13479230 ORDER BY `unit` DESC [ RunTime:0.001730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13479230 LIMIT 2 [ RunTime:0.022068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479230 ORDER BY `minOrder` ASC [ RunTime:0.010279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13479229 LIMIT 5 [ RunTime:0.008249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479229 ORDER BY `minOrder` ASC [ RunTime:0.002733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13479229 ORDER BY `unit` DESC [ RunTime:0.004207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13479229 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13479229 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377396 LIMIT 5 [ RunTime:0.002140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377396 ORDER BY `minOrder` ASC [ RunTime:0.003595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377396 ORDER BY `unit` DESC [ RunTime:0.001588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377396 LIMIT 2 [ RunTime:0.001757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377396 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126552 LIMIT 5 [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126552 ORDER BY `minOrder` ASC [ RunTime:0.001126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126552 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126552 LIMIT 2 [ RunTime:0.002662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126552 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='5695110821' and brandshort='fair-rite' limit 1 [ RunTime:0.001957s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695110821' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.005744s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126552 AND `partno` = '5695110821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.003705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113931 [ RunTime:0.002386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377030 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113931 LIMIT 5 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113931 ORDER BY `minOrder` ASC [ RunTime:0.004022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113931 ORDER BY `unit` DESC [ RunTime:0.007646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113931 LIMIT 2 [ RunTime:0.002677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113931 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='5695110821' and brandshort='fair-rite' limit 1 [ RunTime:0.000372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695110821' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000241s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113931 AND `partno` = '5695110821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126552 [ RunTime:0.002033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377030 [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126608 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126608 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126608 ORDER BY `unit` DESC [ RunTime:0.003119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126608 LIMIT 2 [ RunTime:0.009277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126608 ORDER BY `minOrder` ASC [ RunTime:0.001494s ]
select * from pdf where partno='5695362321' and brandshort='fair-rite' limit 1 [ RunTime:0.003652s ]
select foldpath,foldpath2,filename from pdf_file where id=2074734 limit 1 [ RunTime:0.001110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695362321' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.001237s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126608 AND `partno` = '5695362321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114024 [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260622 [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114024 LIMIT 5 [ RunTime:0.008108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114024 ORDER BY `minOrder` ASC [ RunTime:0.015146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114024 ORDER BY `unit` DESC [ RunTime:0.008020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114024 LIMIT 2 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114024 ORDER BY `minOrder` ASC [ RunTime:0.006056s ]
select * from pdf where partno='5695362321' and brandshort='fair-rite' limit 1 [ RunTime:0.002758s ]
select foldpath,foldpath2,filename from pdf_file where id=2074734 limit 1 [ RunTime:0.004837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695362321' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000387s ]
SELECT `id` FROM `stock` WHERE `id` <> 51114024 AND `partno` = '5695362321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.004365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126608 [ RunTime:0.006552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260622 [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32186845 LIMIT 5 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32186845 ORDER BY `minOrder` ASC [ RunTime:0.000945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32186845 ORDER BY `unit` DESC [ RunTime:0.004957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32186845 LIMIT 2 [ RunTime:0.013910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32186845 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
select * from pdf where partno='5695' and brandshort='adafruit' limit 1 [ RunTime:0.004571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001516s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37911485 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37911485 ORDER BY `minOrder` ASC [ RunTime:0.001542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37911485 ORDER BY `unit` DESC [ RunTime:0.007993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37911485 LIMIT 2 [ RunTime:0.011858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37911485 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='5695181221' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.011372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695181221' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002835s ]
SELECT `id` FROM `stock` WHERE `id` <> 37911485 AND `partno` = '5695181221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.003917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260541 [ RunTime:0.007622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50595622 LIMIT 5 [ RunTime:0.004679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50595622 ORDER BY `minOrder` ASC [ RunTime:0.007017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50595622 ORDER BY `unit` DESC [ RunTime:0.000738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50595622 LIMIT 2 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50595622 ORDER BY `minOrder` ASC [ RunTime:0.005978s ]
select * from pdf where partno='5695181221' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.003018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695181221' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.008773s ]
SELECT `id` FROM `stock` WHERE `id` <> 50595622 AND `partno` = '5695181221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.003229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260541 [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50595603 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50595603 ORDER BY `minOrder` ASC [ RunTime:0.003566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50595603 ORDER BY `unit` DESC [ RunTime:0.006493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50595603 LIMIT 2 [ RunTime:0.015899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50595603 ORDER BY `minOrder` ASC [ RunTime:0.003271s ]
select * from pdf where partno='5695090621' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.001823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695090621' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.021279s ]
SELECT `id` FROM `stock` WHERE `id` <> 50595603 AND `partno` = '5695090621' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.003755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377038 [ RunTime:0.001484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37911466 LIMIT 5 [ RunTime:0.006081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37911466 ORDER BY `minOrder` ASC [ RunTime:0.003670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37911466 ORDER BY `unit` DESC [ RunTime:0.003596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37911466 LIMIT 2 [ RunTime:0.025085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37911466 ORDER BY `minOrder` ASC [ RunTime:0.011187s ]
select * from pdf where partno='5695090621' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.005771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695090621' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.006798s ]
SELECT `id` FROM `stock` WHERE `id` <> 37911466 AND `partno` = '5695090621' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.001507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377038 [ RunTime:0.007439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50596445 LIMIT 5 [ RunTime:0.001834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50596445 ORDER BY `minOrder` ASC [ RunTime:0.009273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50596445 ORDER BY `unit` DESC [ RunTime:0.003278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50596445 LIMIT 2 [ RunTime:0.006917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50596445 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
select * from pdf where partno='5695110821' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.001095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695110821' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000876s ]
SELECT `id` FROM `stock` WHERE `id` <> 50596445 AND `partno` = '5695110821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.004705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377030 [ RunTime:0.005461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37912808 LIMIT 5 [ RunTime:0.009922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37912808 ORDER BY `minOrder` ASC [ RunTime:0.007551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37912808 ORDER BY `unit` DESC [ RunTime:0.010222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37912808 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37912808 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='5695110821' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.006250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695110821' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000422s ]
SELECT `id` FROM `stock` WHERE `id` <> 37912808 AND `partno` = '5695110821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.008025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377030 [ RunTime:0.009151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50596447 LIMIT 5 [ RunTime:0.005710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50596447 ORDER BY `minOrder` ASC [ RunTime:0.012342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50596447 ORDER BY `unit` DESC [ RunTime:0.014968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50596447 LIMIT 2 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50596447 ORDER BY `minOrder` ASC [ RunTime:0.019730s ]
select * from pdf where partno='5695140921' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.032066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695140921' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.011925s ]
SELECT `id` FROM `stock` WHERE `id` <> 50596447 AND `partno` = '5695140921' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.006168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266128 [ RunTime:0.007878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50596873 LIMIT 5 [ RunTime:0.026613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50596873 ORDER BY `minOrder` ASC [ RunTime:0.013874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50596873 ORDER BY `unit` DESC [ RunTime:0.029987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50596873 LIMIT 2 [ RunTime:0.007157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50596873 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='5695302021' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.001499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695302021' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.013082s ]
SELECT `id` FROM `stock` WHERE `id` <> 50596873 AND `partno` = '5695302021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.018037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377396 [ RunTime:0.011674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37913538 LIMIT 5 [ RunTime:0.026457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37913538 ORDER BY `minOrder` ASC [ RunTime:0.029017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37913538 ORDER BY `unit` DESC [ RunTime:0.000793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37913538 LIMIT 2 [ RunTime:0.015500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37913538 ORDER BY `minOrder` ASC [ RunTime:0.001049s ]
select * from pdf where partno='5695302021' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.004032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695302021' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.017769s ]
SELECT `id` FROM `stock` WHERE `id` <> 37913538 AND `partno` = '5695302021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.015188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377396 [ RunTime:0.014948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50595733 LIMIT 5 [ RunTime:0.005082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50595733 ORDER BY `minOrder` ASC [ RunTime:0.004930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50595733 ORDER BY `unit` DESC [ RunTime:0.024538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50595733 LIMIT 2 [ RunTime:0.020402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50595733 ORDER BY `minOrder` ASC [ RunTime:0.004089s ]
select * from pdf where partno='5695362321' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.028486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695362321' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.013318s ]
SELECT `id` FROM `stock` WHERE `id` <> 50595733 AND `partno` = '5695362321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.023127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260622 [ RunTime:0.001518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37913539 LIMIT 5 [ RunTime:0.028879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37913539 ORDER BY `minOrder` ASC [ RunTime:0.002842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37913539 ORDER BY `unit` DESC [ RunTime:0.027013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37913539 LIMIT 2 [ RunTime:0.018739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37913539 ORDER BY `minOrder` ASC [ RunTime:0.025417s ]
select * from pdf where partno='5695362321' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695362321' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.001572s ]
SELECT `id` FROM `stock` WHERE `id` <> 37913539 AND `partno` = '5695362321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.013856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260622 [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56186367 LIMIT 5 [ RunTime:0.006266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186367 ORDER BY `minOrder` ASC [ RunTime:0.005468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56186367 ORDER BY `unit` DESC [ RunTime:0.004517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56186367 LIMIT 2 [ RunTime:0.003738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186367 ORDER BY `minOrder` ASC [ RunTime:0.001812s ]
select * from pdf where partno='5695 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003259s ]
SELECT `id` FROM `stock` WHERE `id` <> 56186367 AND `partno` = '5695 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.015761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387351 [ RunTime:0.017574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50240549 LIMIT 5 [ RunTime:0.006936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50240549 ORDER BY `minOrder` ASC [ RunTime:0.003065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50240549 ORDER BY `unit` DESC [ RunTime:0.031436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50240549 LIMIT 2 [ RunTime:0.021105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50240549 ORDER BY `minOrder` ASC [ RunTime:0.022220s ]
select * from pdf where partno='5695' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.015108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.003778s ]
SELECT `id` FROM `stock` WHERE `id` <> 50240549 AND `partno` = '5695' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.014623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335871 [ RunTime:0.045075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56209089 LIMIT 5 [ RunTime:0.048353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56209089 ORDER BY `minOrder` ASC [ RunTime:0.041048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56209089 ORDER BY `unit` DESC [ RunTime:0.013197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56209089 LIMIT 2 [ RunTime:0.006775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56209089 ORDER BY `minOrder` ASC [ RunTime:0.008917s ]
select * from pdf where partno='5695 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.012771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.049786s ]
SELECT `id` FROM `stock` WHERE `id` <> 56209089 AND `partno` = '5695 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.026161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379559 [ RunTime:0.033211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56207544 LIMIT 5 [ RunTime:0.018241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56207544 ORDER BY `minOrder` ASC [ RunTime:0.017457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56207544 ORDER BY `unit` DESC [ RunTime:0.028060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56207544 LIMIT 2 [ RunTime:0.027218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56207544 ORDER BY `minOrder` ASC [ RunTime:0.018900s ]
select * from pdf where partno='5695 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.024660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.040540s ]
SELECT `id` FROM `stock` WHERE `id` <> 56207544 AND `partno` = '5695 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.013907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505839 [ RunTime:0.009496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56207214 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56207214 ORDER BY `minOrder` ASC [ RunTime:0.011634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56207214 ORDER BY `unit` DESC [ RunTime:0.014987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56207214 LIMIT 2 [ RunTime:0.035621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56207214 ORDER BY `minOrder` ASC [ RunTime:0.024072s ]
select * from pdf where partno='5695 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.009448s ]
SELECT `id` FROM `stock` WHERE `id` <> 56207214 AND `partno` = '5695 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.030879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505638 [ RunTime:0.010143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56203791 LIMIT 5 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56203791 ORDER BY `minOrder` ASC [ RunTime:0.004438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56203791 ORDER BY `unit` DESC [ RunTime:0.004640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56203791 LIMIT 2 [ RunTime:0.013892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56203791 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
select * from pdf where partno='5695 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.017305s ]
SELECT `id` FROM `stock` WHERE `id` <> 56203791 AND `partno` = '5695 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502469 [ RunTime:0.015764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53602361 LIMIT 5 [ RunTime:0.008138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602361 ORDER BY `minOrder` ASC [ RunTime:0.006899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53602361 ORDER BY `unit` DESC [ RunTime:0.006149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53602361 LIMIT 2 [ RunTime:0.010406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602361 ORDER BY `minOrder` ASC [ RunTime:0.003287s ]
select * from pdf where partno='569564-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '569564-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008712s ]
SELECT `id` FROM `stock` WHERE `id` <> 53602361 AND `partno` = '569564-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073716 [ RunTime:0.007179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50694657 LIMIT 5 [ RunTime:0.005109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50694657 ORDER BY `minOrder` ASC [ RunTime:0.006730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50694657 ORDER BY `unit` DESC [ RunTime:0.010306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50694657 LIMIT 2 [ RunTime:0.007615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50694657 ORDER BY `minOrder` ASC [ RunTime:0.009938s ]
select * from pdf where partno='5695-II' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695-II' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013898s ]
SELECT `id` FROM `stock` WHERE `id` <> 50694657 AND `partno` = '5695-II' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523212 [ RunTime:0.064703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50694074 LIMIT 5 [ RunTime:0.030851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50694074 ORDER BY `minOrder` ASC [ RunTime:0.007964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50694074 ORDER BY `unit` DESC [ RunTime:0.006055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50694074 LIMIT 2 [ RunTime:0.016354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50694074 ORDER BY `minOrder` ASC [ RunTime:0.017019s ]
select * from pdf where partno='5695-I' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5695-I' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022065s ]
SELECT `id` FROM `stock` WHERE `id` <> 50694074 AND `partno` = '5695-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394583 [ RunTime:0.004997s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007256s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001279s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005033s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004557s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004470s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019170s ]
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 '5695%' OR `brand` LIKE '5695%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006087s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5695%' OR `brand` LIKE '5695%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004614s ]