SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002406s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=SE120&search=1' [ RunTime:0.004839s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001166s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002015s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001005s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001086s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001180s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SE120' LIMIT 1 [ RunTime:0.005408s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-23 09:24:49' WHERE `partno` = 'SE120' [ RunTime:0.003303s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001397s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015736s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060213 LIMIT 5 [ RunTime:0.000784s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060213 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17060213 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17060213 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060213 ORDER BY `minOrder` ASC [ RunTime:0.000179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026142 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026142 ORDER BY `minOrder` ASC [ RunTime:0.002013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026142 ORDER BY `unit` DESC [ RunTime:0.002530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026142 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026142 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033606 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033606 ORDER BY `minOrder` ASC [ RunTime:0.005452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19033606 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19033606 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033606 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035872 LIMIT 5 [ RunTime:0.004214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035872 ORDER BY `minOrder` ASC [ RunTime:0.003504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035872 ORDER BY `unit` DESC [ RunTime:0.005960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035872 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035872 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
select * from pdf where partno='SE120,YL' and brandshort='Serpac' limit 1 [ RunTime:0.001530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035924 LIMIT 5 [ RunTime:0.026642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035924 ORDER BY `minOrder` ASC [ RunTime:0.005909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035924 ORDER BY `unit` DESC [ RunTime:0.007522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035924 LIMIT 2 [ RunTime:0.002063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035924 ORDER BY `minOrder` ASC [ RunTime:0.000239s ]
select * from pdf where partno='SE120F,OR' and brandshort='Serpac' limit 1 [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035873 LIMIT 5 [ RunTime:0.002403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035873 ORDER BY `minOrder` ASC [ RunTime:0.014478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035873 ORDER BY `unit` DESC [ RunTime:0.010577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035873 LIMIT 2 [ RunTime:0.002240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035873 ORDER BY `minOrder` ASC [ RunTime:0.007594s ]
select * from pdf where partno='SE120,OR' and brandshort='Serpac' limit 1 [ RunTime:0.007107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032572 LIMIT 5 [ RunTime:0.027984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032572 ORDER BY `minOrder` ASC [ RunTime:0.012463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032572 ORDER BY `unit` DESC [ RunTime:0.009504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032572 LIMIT 2 [ RunTime:0.003089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032572 ORDER BY `minOrder` ASC [ RunTime:0.008386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032571 LIMIT 5 [ RunTime:0.016454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032571 ORDER BY `minOrder` ASC [ RunTime:0.013423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032571 ORDER BY `unit` DESC [ RunTime:0.006402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032571 LIMIT 2 [ RunTime:0.016381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032571 ORDER BY `minOrder` ASC [ RunTime:0.009090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024295 LIMIT 5 [ RunTime:0.005268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024295 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024295 ORDER BY `unit` DESC [ RunTime:0.005491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024295 LIMIT 2 [ RunTime:0.021008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024295 ORDER BY `minOrder` ASC [ RunTime:0.002916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024294 LIMIT 5 [ RunTime:0.005067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024294 ORDER BY `minOrder` ASC [ RunTime:0.006017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024294 ORDER BY `unit` DESC [ RunTime:0.004245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024294 LIMIT 2 [ RunTime:0.006030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024294 ORDER BY `minOrder` ASC [ RunTime:0.005863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024293 LIMIT 5 [ RunTime:0.020297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024293 ORDER BY `minOrder` ASC [ RunTime:0.019787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024293 ORDER BY `unit` DESC [ RunTime:0.023523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024293 LIMIT 2 [ RunTime:0.012424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024293 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024243 LIMIT 5 [ RunTime:0.010086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024243 ORDER BY `minOrder` ASC [ RunTime:0.003314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024243 ORDER BY `unit` DESC [ RunTime:0.001895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024243 LIMIT 2 [ RunTime:0.032984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024243 ORDER BY `minOrder` ASC [ RunTime:0.006465s ]
select * from pdf where partno='SE120ML,OR' and brandshort='Serpac' limit 1 [ RunTime:0.025877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024242 LIMIT 5 [ RunTime:0.019013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024242 ORDER BY `minOrder` ASC [ RunTime:0.009427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024242 ORDER BY `unit` DESC [ RunTime:0.023828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024242 LIMIT 2 [ RunTime:0.006831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024242 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='SE120ML,YL' and brandshort='Serpac' limit 1 [ RunTime:0.000561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024241 LIMIT 5 [ RunTime:0.003477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024241 ORDER BY `minOrder` ASC [ RunTime:0.016151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024241 ORDER BY `unit` DESC [ RunTime:0.020811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024241 LIMIT 2 [ RunTime:0.009148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024241 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='SE120ML,BK' and brandshort='Serpac' limit 1 [ RunTime:0.004085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024159 LIMIT 5 [ RunTime:0.006242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024159 ORDER BY `minOrder` ASC [ RunTime:0.008700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024159 ORDER BY `unit` DESC [ RunTime:0.014716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024159 LIMIT 2 [ RunTime:0.003279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024159 ORDER BY `minOrder` ASC [ RunTime:0.005716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024158 LIMIT 5 [ RunTime:0.004130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024158 ORDER BY `minOrder` ASC [ RunTime:0.013428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024158 ORDER BY `unit` DESC [ RunTime:0.005345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024158 LIMIT 2 [ RunTime:0.000888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024158 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024157 LIMIT 5 [ RunTime:0.001450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024157 ORDER BY `minOrder` ASC [ RunTime:0.018443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024157 ORDER BY `unit` DESC [ RunTime:0.031409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024157 LIMIT 2 [ RunTime:0.027703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024157 ORDER BY `minOrder` ASC [ RunTime:0.007665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024081 LIMIT 5 [ RunTime:0.001767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024081 ORDER BY `minOrder` ASC [ RunTime:0.005080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024081 ORDER BY `unit` DESC [ RunTime:0.007433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024081 LIMIT 2 [ RunTime:0.005179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024081 ORDER BY `minOrder` ASC [ RunTime:0.007626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024080 LIMIT 5 [ RunTime:0.001757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024080 ORDER BY `minOrder` ASC [ RunTime:0.003277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024080 ORDER BY `unit` DESC [ RunTime:0.002778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024080 LIMIT 2 [ RunTime:0.003717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024080 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024079 LIMIT 5 [ RunTime:0.007779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024079 ORDER BY `minOrder` ASC [ RunTime:0.012909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024079 ORDER BY `unit` DESC [ RunTime:0.001734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024079 LIMIT 2 [ RunTime:0.004648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024079 ORDER BY `minOrder` ASC [ RunTime:0.002099s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094788 LIMIT 5 [ RunTime:0.010494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094788 ORDER BY `minOrder` ASC [ RunTime:0.001653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094788 ORDER BY `unit` DESC [ RunTime:0.002212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094788 LIMIT 2 [ RunTime:0.005726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094788 ORDER BY `minOrder` ASC [ RunTime:0.003668s ]
select * from pdf where partno='se120f,bk' and brandshort='serpac' limit 1 [ RunTime:0.000870s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se120f,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.001078s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094788 AND `partno` = 'se120f,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.004168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060213 [ RunTime:0.014358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094793 LIMIT 5 [ RunTime:0.008530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094793 ORDER BY `minOrder` ASC [ RunTime:0.002223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094793 ORDER BY `unit` DESC [ RunTime:0.012360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094793 LIMIT 2 [ RunTime:0.004789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094793 ORDER BY `minOrder` ASC [ RunTime:0.022729s ]
select * from pdf where partno='se120,or' and brandshort='serpac' limit 1 [ RunTime:0.014491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se120,or' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.002233s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094793 AND `partno` = 'se120,or' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.014861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035873 [ RunTime:0.020135s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089689 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089689 ORDER BY `minOrder` ASC [ RunTime:0.003046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089689 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089689 LIMIT 2 [ RunTime:0.007173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089689 ORDER BY `minOrder` ASC [ RunTime:0.004340s ]
select * from pdf where partno='SE120N6JHM3/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120N6JHM3/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009655s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089689 AND `partno` = 'SE120N6JHM3/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089688 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089688 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089688 ORDER BY `unit` DESC [ RunTime:0.000954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089688 LIMIT 2 [ RunTime:0.004544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089688 ORDER BY `minOrder` ASC [ RunTime:0.005951s ]
select * from pdf where partno='SE120N6GHM3/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120N6GHM3/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016227s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089688 AND `partno` = 'SE120N6GHM3/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.013047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089687 LIMIT 5 [ RunTime:0.003113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089687 ORDER BY `minOrder` ASC [ RunTime:0.005725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089687 ORDER BY `unit` DESC [ RunTime:0.006453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089687 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089687 ORDER BY `minOrder` ASC [ RunTime:0.005097s ]
select * from pdf where partno='SE120N6DHM3/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120N6DHM3/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000849s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089687 AND `partno` = 'SE120N6DHM3/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089622 LIMIT 5 [ RunTime:0.009356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089622 ORDER BY `minOrder` ASC [ RunTime:0.012660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089622 ORDER BY `unit` DESC [ RunTime:0.021862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089622 LIMIT 2 [ RunTime:0.025989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089622 ORDER BY `minOrder` ASC [ RunTime:0.011918s ]
select * from pdf where partno='SE120N6J-M3/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120N6J-M3/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013986s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089622 AND `partno` = 'SE120N6J-M3/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089621 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089621 ORDER BY `minOrder` ASC [ RunTime:0.015120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089621 ORDER BY `unit` DESC [ RunTime:0.016425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089621 LIMIT 2 [ RunTime:0.009124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089621 ORDER BY `minOrder` ASC [ RunTime:0.012319s ]
select * from pdf where partno='SE120N6D-M3/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120N6D-M3/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011701s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089621 AND `partno` = 'SE120N6D-M3/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089620 LIMIT 5 [ RunTime:0.004306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089620 ORDER BY `minOrder` ASC [ RunTime:0.006411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089620 ORDER BY `unit` DESC [ RunTime:0.022641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089620 LIMIT 2 [ RunTime:0.003825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089620 ORDER BY `minOrder` ASC [ RunTime:0.002671s ]
select * from pdf where partno='SE120N6G-M3/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120N6G-M3/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001914s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089620 AND `partno` = 'SE120N6G-M3/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63421196 LIMIT 5 [ RunTime:0.001938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63421196 ORDER BY `minOrder` ASC [ RunTime:0.003919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63421196 ORDER BY `unit` DESC [ RunTime:0.009495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63421196 LIMIT 2 [ RunTime:0.003569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63421196 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
select * from pdf where partno='SE120F,BK' and brandshort='Serpac' limit 1 [ RunTime:0.008925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120F,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.007233s ]
SELECT `id` FROM `stock` WHERE `id` <> 63421196 AND `partno` = 'SE120F,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.007812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060213 [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423368 LIMIT 5 [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423368 ORDER BY `minOrder` ASC [ RunTime:0.028855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423368 ORDER BY `unit` DESC [ RunTime:0.001872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423368 LIMIT 2 [ RunTime:0.008717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423368 ORDER BY `minOrder` ASC [ RunTime:0.012785s ]
select * from pdf where partno='SE120,BK' and brandshort='Serpac' limit 1 [ RunTime:0.003142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.009391s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423368 AND `partno` = 'SE120,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.003963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026142 [ RunTime:0.009456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63424698 LIMIT 5 [ RunTime:0.027835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63424698 ORDER BY `minOrder` ASC [ RunTime:0.019836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63424698 ORDER BY `unit` DESC [ RunTime:0.006092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63424698 LIMIT 2 [ RunTime:0.012309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63424698 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='SE120F,YL' and brandshort='Serpac' limit 1 [ RunTime:0.000997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120F,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.005303s ]
SELECT `id` FROM `stock` WHERE `id` <> 63424698 AND `partno` = 'SE120F,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.003399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033606 [ RunTime:0.017718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423369 LIMIT 5 [ RunTime:0.006062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423369 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423369 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423369 LIMIT 2 [ RunTime:0.010962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423369 ORDER BY `minOrder` ASC [ RunTime:0.007502s ]
select * from pdf where partno='SE120,YL' and brandshort='Serpac' limit 1 [ RunTime:0.000963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.002021s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423369 AND `partno` = 'SE120,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.004456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035872 [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63430580 LIMIT 5 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63430580 ORDER BY `minOrder` ASC [ RunTime:0.002872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63430580 ORDER BY `unit` DESC [ RunTime:0.000273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63430580 LIMIT 2 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63430580 ORDER BY `minOrder` ASC [ RunTime:0.012174s ]
select * from pdf where partno='SE120,OR' and brandshort='Serpac' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120,OR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.003004s ]
SELECT `id` FROM `stock` WHERE `id` <> 63430580 AND `partno` = 'SE120,OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.014009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035873 [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63430622 LIMIT 5 [ RunTime:0.003853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63430622 ORDER BY `minOrder` ASC [ RunTime:0.010359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63430622 ORDER BY `unit` DESC [ RunTime:0.008280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63430622 LIMIT 2 [ RunTime:0.002345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63430622 ORDER BY `minOrder` ASC [ RunTime:0.007742s ]
select * from pdf where partno='SE120F,OR' and brandshort='Serpac' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120F,OR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.001459s ]
SELECT `id` FROM `stock` WHERE `id` <> 63430622 AND `partno` = 'SE120F,OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.019388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035924 [ RunTime:0.022614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63437150 LIMIT 5 [ RunTime:0.005442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437150 ORDER BY `minOrder` ASC [ RunTime:0.006608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63437150 ORDER BY `unit` DESC [ RunTime:0.003147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63437150 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437150 ORDER BY `minOrder` ASC [ RunTime:0.002549s ]
select * from pdf where partno='SE120FML,OR' and brandshort='Serpac' limit 1 [ RunTime:0.004061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120FML,OR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.007333s ]
SELECT `id` FROM `stock` WHERE `id` <> 63437150 AND `partno` = 'SE120FML,OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.008202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024295 [ RunTime:0.008212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63437149 LIMIT 5 [ RunTime:0.005168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437149 ORDER BY `minOrder` ASC [ RunTime:0.021510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63437149 ORDER BY `unit` DESC [ RunTime:0.006359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63437149 LIMIT 2 [ RunTime:0.003335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437149 ORDER BY `minOrder` ASC [ RunTime:0.004500s ]
select * from pdf where partno='SE120FML,YL' and brandshort='Serpac' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120FML,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.001611s ]
SELECT `id` FROM `stock` WHERE `id` <> 63437149 AND `partno` = 'SE120FML,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024294 [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63437148 LIMIT 5 [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437148 ORDER BY `minOrder` ASC [ RunTime:0.005391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63437148 ORDER BY `unit` DESC [ RunTime:0.006060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63437148 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437148 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
select * from pdf where partno='SE120FML,BK' and brandshort='Serpac' limit 1 [ RunTime:0.004791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120FML,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000927s ]
SELECT `id` FROM `stock` WHERE `id` <> 63437148 AND `partno` = 'SE120FML,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024293 [ RunTime:0.002337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63437075 LIMIT 5 [ RunTime:0.007562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437075 ORDER BY `minOrder` ASC [ RunTime:0.002508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63437075 ORDER BY `unit` DESC [ RunTime:0.004955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63437075 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437075 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='SE120ML,OR' and brandshort='Serpac' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120ML,OR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.002406s ]
SELECT `id` FROM `stock` WHERE `id` <> 63437075 AND `partno` = 'SE120ML,OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.001420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024243 [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63437074 LIMIT 5 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437074 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63437074 ORDER BY `unit` DESC [ RunTime:0.011070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63437074 LIMIT 2 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437074 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='SE120ML,YL' and brandshort='Serpac' limit 1 [ RunTime:0.002641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120ML,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.005159s ]
SELECT `id` FROM `stock` WHERE `id` <> 63437074 AND `partno` = 'SE120ML,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.009833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024242 [ RunTime:0.001016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63437073 LIMIT 5 [ RunTime:0.002627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437073 ORDER BY `minOrder` ASC [ RunTime:0.017153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63437073 ORDER BY `unit` DESC [ RunTime:0.003147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63437073 LIMIT 2 [ RunTime:0.006141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63437073 ORDER BY `minOrder` ASC [ RunTime:0.008925s ]
select * from pdf where partno='SE120ML,BK' and brandshort='Serpac' limit 1 [ RunTime:0.002383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120ML,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.004040s ]
SELECT `id` FROM `stock` WHERE `id` <> 63437073 AND `partno` = 'SE120ML,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.010826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024241 [ RunTime:0.011196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63436965 LIMIT 5 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63436965 ORDER BY `minOrder` ASC [ RunTime:0.007255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63436965 ORDER BY `unit` DESC [ RunTime:0.011295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63436965 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63436965 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='SE120FPL,OR' and brandshort='Serpac' limit 1 [ RunTime:0.002938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120FPL,OR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000856s ]
SELECT `id` FROM `stock` WHERE `id` <> 63436965 AND `partno` = 'SE120FPL,OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.004115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024159 [ RunTime:0.012650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63436964 LIMIT 5 [ RunTime:0.003769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63436964 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63436964 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63436964 LIMIT 2 [ RunTime:0.011964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63436964 ORDER BY `minOrder` ASC [ RunTime:0.002525s ]
select * from pdf where partno='SE120FPL,YL' and brandshort='Serpac' limit 1 [ RunTime:0.000876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE120FPL,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.001484s ]
SELECT `id` FROM `stock` WHERE `id` <> 63436964 AND `partno` = 'SE120FPL,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024158 [ RunTime:0.000589s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016422s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002380s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004344s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006607s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001150s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002517s ]
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 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009622s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SE120%' OR `brand` LIKE 'SE120%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001454s ]