SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001643s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.120014s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13224966 LIMIT 5 [ RunTime:0.034288s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.026286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13224966 ORDER BY `minOrder` ASC [ RunTime:0.052175s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13224966 ORDER BY `unit` DESC [ RunTime:0.070637s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.038581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13224966 LIMIT 2 [ RunTime:0.003402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13224966 ORDER BY `minOrder` ASC [ RunTime:0.024297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203668 LIMIT 5 [ RunTime:0.013813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203668 ORDER BY `minOrder` ASC [ RunTime:0.019392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14203668 ORDER BY `unit` DESC [ RunTime:0.013951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14203668 LIMIT 2 [ RunTime:0.018902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203668 ORDER BY `minOrder` ASC [ RunTime:0.001659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418943 LIMIT 5 [ RunTime:0.020366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418943 ORDER BY `minOrder` ASC [ RunTime:0.045958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14418943 ORDER BY `unit` DESC [ RunTime:0.021006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14418943 LIMIT 2 [ RunTime:0.022618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418943 ORDER BY `minOrder` ASC [ RunTime:0.009056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028121 LIMIT 5 [ RunTime:0.120627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19028121 ORDER BY `minOrder` ASC [ RunTime:0.047900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19028121 ORDER BY `unit` DESC [ RunTime:0.051844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19028121 LIMIT 2 [ RunTime:0.054879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19028121 ORDER BY `minOrder` ASC [ RunTime:0.051697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033856 LIMIT 5 [ RunTime:0.028773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033856 ORDER BY `minOrder` ASC [ RunTime:0.043710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19033856 ORDER BY `unit` DESC [ RunTime:0.030323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19033856 LIMIT 2 [ RunTime:0.058435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033856 ORDER BY `minOrder` ASC [ RunTime:0.017700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16432474 LIMIT 5 [ RunTime:0.016068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16432474 ORDER BY `minOrder` ASC [ RunTime:0.007808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16432474 ORDER BY `unit` DESC [ RunTime:0.008843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16432474 LIMIT 2 [ RunTime:0.009671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16432474 ORDER BY `minOrder` ASC [ RunTime:0.036966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276823 LIMIT 5 [ RunTime:0.027093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276823 ORDER BY `minOrder` ASC [ RunTime:0.021224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15276823 ORDER BY `unit` DESC [ RunTime:0.016700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15276823 LIMIT 2 [ RunTime:0.001676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276823 ORDER BY `minOrder` ASC [ RunTime:0.029902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13548619 LIMIT 5 [ RunTime:0.005849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13548619 ORDER BY `minOrder` ASC [ RunTime:0.008352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13548619 ORDER BY `unit` DESC [ RunTime:0.004616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13548619 LIMIT 2 [ RunTime:0.028745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13548619 ORDER BY `minOrder` ASC [ RunTime:0.005946s ]
select * from pdf where partno='SE75PSFR-CR0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034384 LIMIT 5 [ RunTime:0.014259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034384 ORDER BY `minOrder` ASC [ RunTime:0.017770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034384 ORDER BY `unit` DESC [ RunTime:0.015843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034384 LIMIT 2 [ RunTime:0.010448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034384 ORDER BY `minOrder` ASC [ RunTime:0.005747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418963 LIMIT 5 [ RunTime:0.009051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418963 ORDER BY `minOrder` ASC [ RunTime:0.011440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14418963 ORDER BY `unit` DESC [ RunTime:0.047007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14418963 LIMIT 2 [ RunTime:0.011941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418963 ORDER BY `minOrder` ASC [ RunTime:0.003525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14204558 LIMIT 5 [ RunTime:0.003678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14204558 ORDER BY `minOrder` ASC [ RunTime:0.005740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14204558 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14204558 LIMIT 2 [ RunTime:0.015581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14204558 ORDER BY `minOrder` ASC [ RunTime:0.010663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419077 LIMIT 5 [ RunTime:0.007844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419077 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14419077 ORDER BY `unit` DESC [ RunTime:0.013163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14419077 LIMIT 2 [ RunTime:0.023012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419077 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036644 LIMIT 5 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036644 ORDER BY `minOrder` ASC [ RunTime:0.022318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036644 ORDER BY `unit` DESC [ RunTime:0.012301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036644 LIMIT 2 [ RunTime:0.004246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036644 ORDER BY `minOrder` ASC [ RunTime:0.001443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036642 LIMIT 5 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036642 ORDER BY `minOrder` ASC [ RunTime:0.012623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036642 ORDER BY `unit` DESC [ RunTime:0.013320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036642 LIMIT 2 [ RunTime:0.008491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036642 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036344 LIMIT 5 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036344 ORDER BY `minOrder` ASC [ RunTime:0.005816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036344 ORDER BY `unit` DESC [ RunTime:0.006780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036344 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036344 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036292 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036292 ORDER BY `minOrder` ASC [ RunTime:0.007145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036292 ORDER BY `unit` DESC [ RunTime:0.004057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036292 LIMIT 2 [ RunTime:0.014930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036292 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277518 LIMIT 5 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277518 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277518 ORDER BY `unit` DESC [ RunTime:0.001536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277518 LIMIT 2 [ RunTime:0.005774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277518 ORDER BY `minOrder` ASC [ RunTime:0.011883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277517 LIMIT 5 [ RunTime:0.008798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277517 ORDER BY `minOrder` ASC [ RunTime:0.003431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277517 ORDER BY `unit` DESC [ RunTime:0.013807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277517 LIMIT 2 [ RunTime:0.038323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277517 ORDER BY `minOrder` ASC [ RunTime:0.016784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419133 LIMIT 5 [ RunTime:0.004987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419133 ORDER BY `minOrder` ASC [ RunTime:0.012025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14419133 ORDER BY `unit` DESC [ RunTime:0.021159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14419133 LIMIT 2 [ RunTime:0.012474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419133 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='SE75PSC-CR0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14204890 LIMIT 5 [ RunTime:0.002564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14204890 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14204890 ORDER BY `unit` DESC [ RunTime:0.003578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14204890 LIMIT 2 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14204890 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292622 LIMIT 5 [ RunTime:0.002439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292622 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32292622 ORDER BY `unit` DESC [ RunTime:0.000320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32292622 LIMIT 2 [ RunTime:0.007181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292622 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='se77aaa' and brandshort='bourns' limit 1 [ RunTime:0.003351s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se77aaa' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.002821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292621 LIMIT 5 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292621 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32292621 ORDER BY `unit` DESC [ RunTime:0.005847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32292621 LIMIT 2 [ RunTime:0.003388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292621 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='se72aaa' and brandshort='bourns' limit 1 [ RunTime:0.004303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se72aaa' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.016040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094791 LIMIT 5 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094791 ORDER BY `minOrder` ASC [ RunTime:0.016709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094791 ORDER BY `unit` DESC [ RunTime:0.051139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094791 LIMIT 2 [ RunTime:0.051627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094791 ORDER BY `minOrder` ASC [ RunTime:0.027224s ]
select * from pdf where partno='se720f,bk' and brandshort='serpac' limit 1 [ RunTime:0.062460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se720f,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.052077s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094791 AND `partno` = 'se720f,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.032487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028121 [ RunTime:0.005169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094800 LIMIT 5 [ RunTime:0.001913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094800 ORDER BY `minOrder` ASC [ RunTime:0.009780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094800 ORDER BY `unit` DESC [ RunTime:0.014896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094800 LIMIT 2 [ RunTime:0.008611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094800 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
select * from pdf where partno='se710,yl' and brandshort='serpac' limit 1 [ RunTime:0.004847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se710,yl' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.001336s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094800 AND `partno` = 'se710,yl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.004674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14204890 [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094743 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094743 ORDER BY `minOrder` ASC [ RunTime:0.002616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094743 ORDER BY `unit` DESC [ RunTime:0.000742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094743 LIMIT 2 [ RunTime:0.002686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094743 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
select * from pdf where partno='se720fpl,bk' and brandshort='serpac' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se720fpl,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.000934s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094743 AND `partno` = 'se720fpl,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.002311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026026 [ RunTime:0.002745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218605 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218605 ORDER BY `minOrder` ASC [ RunTime:0.002871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218605 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218605 LIMIT 2 [ RunTime:0.002405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218605 ORDER BY `minOrder` ASC [ RunTime:0.001554s ]
select * from pdf where partno='se710f,bk' and brandshort='serpac' limit 1 [ RunTime:0.005014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se710f,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.000764s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218605 AND `partno` = 'se710f,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.002220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277517 [ RunTime:0.001691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32185661 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185661 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32185661 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32185661 LIMIT 2 [ RunTime:0.004247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185661 ORDER BY `minOrder` ASC [ RunTime:0.006956s ]
select * from pdf where partno='se710f,bk' and brandshort='serpac' limit 1 [ RunTime:0.001529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se710f,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT `id` FROM `stock` WHERE `id` <> 32185661 AND `partno` = 'se710f,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277517 [ RunTime:0.002973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094799 LIMIT 5 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094799 ORDER BY `minOrder` ASC [ RunTime:0.002487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094799 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094799 LIMIT 2 [ RunTime:0.002240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094799 ORDER BY `minOrder` ASC [ RunTime:0.001482s ]
select * from pdf where partno='se710,bk' and brandshort='serpac' limit 1 [ RunTime:0.000756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se710,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.000793s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094799 AND `partno` = 'se710,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.002721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033856 [ RunTime:0.001821s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088175 LIMIT 5 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088175 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088175 ORDER BY `unit` DESC [ RunTime:0.001548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088175 LIMIT 2 [ RunTime:0.002617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088175 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
select * from pdf where partno='SE70PJHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE70PJHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003302s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088175 AND `partno` = 'SE70PJHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088176 LIMIT 5 [ RunTime:0.009144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088176 ORDER BY `minOrder` ASC [ RunTime:0.003284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088176 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088176 LIMIT 2 [ RunTime:0.007119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088176 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
select * from pdf where partno='SE70PJHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE70PJHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000811s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088176 AND `partno` = 'SE70PJHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51330819 LIMIT 5 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51330819 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51330819 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51330819 LIMIT 2 [ RunTime:0.002102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51330819 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='SE72AAA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE72AAA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001611s ]
SELECT `id` FROM `stock` WHERE `id` <> 51330819 AND `partno` = 'SE72AAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656334 [ RunTime:0.001867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51330818 LIMIT 5 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51330818 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51330818 ORDER BY `unit` DESC [ RunTime:0.001727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51330818 LIMIT 2 [ RunTime:0.001265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51330818 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='SE77AAA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE77AAA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001559s ]
SELECT `id` FROM `stock` WHERE `id` <> 51330818 AND `partno` = 'SE77AAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.001201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794858 [ RunTime:0.001118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088178 LIMIT 5 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088178 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088178 ORDER BY `unit` DESC [ RunTime:0.001037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088178 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088178 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='SE70PGHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE70PGHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002325s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088178 AND `partno` = 'SE70PGHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088028 LIMIT 5 [ RunTime:0.002372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088028 ORDER BY `minOrder` ASC [ RunTime:0.001431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088028 ORDER BY `unit` DESC [ RunTime:0.002139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088028 LIMIT 2 [ RunTime:0.011923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088028 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
select * from pdf where partno='SE70PJ-M3/86A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE70PJ-M3/86A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006955s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088028 AND `partno` = 'SE70PJ-M3/86A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49608019 LIMIT 5 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49608019 ORDER BY `minOrder` ASC [ RunTime:0.005108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49608019 ORDER BY `unit` DESC [ RunTime:0.002829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49608019 LIMIT 2 [ RunTime:0.004439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49608019 ORDER BY `minOrder` ASC [ RunTime:0.005898s ]
select * from pdf where partno='SE720F,BK' and brandshort='Serpac' limit 1 [ RunTime:0.001354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE720F,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000885s ]
SELECT `id` FROM `stock` WHERE `id` <> 49608019 AND `partno` = 'SE720F,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.008441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028121 [ RunTime:0.008037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36801187 LIMIT 5 [ RunTime:0.001736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36801187 ORDER BY `minOrder` ASC [ RunTime:0.009707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36801187 ORDER BY `unit` DESC [ RunTime:0.002026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36801187 LIMIT 2 [ RunTime:0.008347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36801187 ORDER BY `minOrder` ASC [ RunTime:0.007289s ]
select * from pdf where partno='SE720F,BK' and brandshort='Serpac' limit 1 [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE720F,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000308s ]
SELECT `id` FROM `stock` WHERE `id` <> 36801187 AND `partno` = 'SE720F,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028121 [ RunTime:0.007701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56358364 LIMIT 5 [ RunTime:0.010632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56358364 ORDER BY `minOrder` ASC [ RunTime:0.007905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56358364 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56358364 LIMIT 2 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56358364 ORDER BY `minOrder` ASC [ RunTime:0.008575s ]
select * from pdf where partno='SE75PSC-CR0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE75PSC-CR0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000793s ]
SELECT `id` FROM `stock` WHERE `id` <> 56358364 AND `partno` = 'SE75PSC-CR0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419133 [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49609608 LIMIT 5 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49609608 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49609608 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49609608 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49609608 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='SE720,GM' and brandshort='Serpac' limit 1 [ RunTime:0.000814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE720,GM' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000634s ]
SELECT `id` FROM `stock` WHERE `id` <> 49609608 AND `partno` = 'SE720,GM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276823 [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49609568 LIMIT 5 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49609568 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49609568 ORDER BY `unit` DESC [ RunTime:0.000360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49609568 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49609568 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='SE710,BK' and brandshort='Serpac' limit 1 [ RunTime:0.000568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE710,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.002003s ]
SELECT `id` FROM `stock` WHERE `id` <> 49609568 AND `partno` = 'SE710,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033856 [ RunTime:0.000254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36802755 LIMIT 5 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36802755 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36802755 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36802755 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36802755 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
select * from pdf where partno='SE720,GM' and brandshort='Serpac' limit 1 [ RunTime:0.000365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE720,GM' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000249s ]
SELECT `id` FROM `stock` WHERE `id` <> 36802755 AND `partno` = 'SE720,GM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276823 [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36802715 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36802715 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36802715 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36802715 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36802715 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
select * from pdf where partno='SE710,BK' and brandshort='Serpac' limit 1 [ RunTime:0.000374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE710,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000253s ]
SELECT `id` FROM `stock` WHERE `id` <> 36802715 AND `partno` = 'SE710,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033856 [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49609590 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49609590 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49609590 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49609590 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49609590 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='SE720,YL' and brandshort='Serpac' limit 1 [ RunTime:0.000864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE720,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.002631s ]
SELECT `id` FROM `stock` WHERE `id` <> 49609590 AND `partno` = 'SE720,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14204558 [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36802737 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36802737 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36802737 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36802737 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36802737 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
select * from pdf where partno='SE720,YL' and brandshort='Serpac' limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE720,YL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000265s ]
SELECT `id` FROM `stock` WHERE `id` <> 36802737 AND `partno` = 'SE720,YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14204558 [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56358357 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56358357 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56358357 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56358357 LIMIT 2 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56358357 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='SE75PFR-CR0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE75PFR-CR0' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003023s ]
SELECT `id` FROM `stock` WHERE `id` <> 56358357 AND `partno` = 'SE75PFR-CR0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16432474 [ RunTime:0.001631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56360461 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56360461 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56360461 ORDER BY `unit` DESC [ RunTime:0.007541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56360461 LIMIT 2 [ RunTime:0.002214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56360461 ORDER BY `minOrder` ASC [ RunTime:0.001032s ]
select * from pdf where partno='SE75P-DR10' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE75P-DR10' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003504s ]
SELECT `id` FROM `stock` WHERE `id` <> 56360461 AND `partno` = 'SE75P-DR10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.006153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13548607 [ RunTime:0.002053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56360034 LIMIT 5 [ RunTime:0.004764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56360034 ORDER BY `minOrder` ASC [ RunTime:0.005792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56360034 ORDER BY `unit` DESC [ RunTime:0.007905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56360034 LIMIT 2 [ RunTime:0.003007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56360034 ORDER BY `minOrder` ASC [ RunTime:0.001297s ]
select * from pdf where partno='SE75P-CR8' and brandshort='Panduit Corp' limit 1 [ RunTime:0.003790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE75P-CR8' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003362s ]
SELECT `id` FROM `stock` WHERE `id` <> 56360034 AND `partno` = 'SE75P-CR8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.003332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419077 [ RunTime:0.004734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56359075 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56359075 ORDER BY `minOrder` ASC [ RunTime:0.004000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56359075 ORDER BY `unit` DESC [ RunTime:0.002291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56359075 LIMIT 2 [ RunTime:0.002995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56359075 ORDER BY `minOrder` ASC [ RunTime:0.006659s ]
select * from pdf where partno='SE75PFR-CR8' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE75PFR-CR8' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.002128s ]
SELECT `id` FROM `stock` WHERE `id` <> 56359075 AND `partno` = 'SE75PFR-CR8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547892 [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50329323 LIMIT 5 [ RunTime:0.004817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50329323 ORDER BY `minOrder` ASC [ RunTime:0.001266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50329323 ORDER BY `unit` DESC [ RunTime:0.003753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50329323 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50329323 ORDER BY `minOrder` ASC [ RunTime:0.001561s ]
select * from pdf where partno='SE7C' and brandshort='Astrodyne TDI' limit 1 [ RunTime:0.003957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE7C' OR `brand` LIKE 'Astrodyne TDI%' ) ) LIMIT 1 [ RunTime:0.004472s ]
SELECT `id` FROM `stock` WHERE `id` <> 50329323 AND `partno` = 'SE7C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astrodyne tdi%' ) [ RunTime:0.001437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11935105 [ RunTime:0.001409s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008426s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003322s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002950s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003096s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005824s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007462s ]
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 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003722s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SE7%' OR `brand` LIKE 'SE7%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001798s ]