SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001051s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035707s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781624 LIMIT 5 [ RunTime:0.018241s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781624 ORDER BY `minOrder` ASC [ RunTime:0.021917s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781624 ORDER BY `unit` DESC [ RunTime:0.011398s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781624 LIMIT 2 [ RunTime:0.017837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781624 ORDER BY `minOrder` ASC [ RunTime:0.009346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178383 LIMIT 5 [ RunTime:0.013006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178383 ORDER BY `minOrder` ASC [ RunTime:0.010869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11178383 ORDER BY `unit` DESC [ RunTime:0.033059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11178383 LIMIT 2 [ RunTime:0.009536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178383 ORDER BY `minOrder` ASC [ RunTime:0.003058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793734 LIMIT 5 [ RunTime:0.007005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793734 ORDER BY `minOrder` ASC [ RunTime:0.008400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793734 ORDER BY `unit` DESC [ RunTime:0.011595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793734 LIMIT 2 [ RunTime:0.009352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793734 ORDER BY `minOrder` ASC [ RunTime:0.005296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11410701 LIMIT 5 [ RunTime:0.015707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11410701 ORDER BY `minOrder` ASC [ RunTime:0.039936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11410701 ORDER BY `unit` DESC [ RunTime:0.047012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11410701 LIMIT 2 [ RunTime:0.001969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11410701 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
select * from pdf where partno='2033701347' and brandshort='Molex' limit 1 [ RunTime:0.004750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509501 LIMIT 5 [ RunTime:0.007108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509501 ORDER BY `minOrder` ASC [ RunTime:0.017318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509501 ORDER BY `unit` DESC [ RunTime:0.023663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509501 LIMIT 2 [ RunTime:0.001450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509501 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655547 LIMIT 5 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655547 ORDER BY `minOrder` ASC [ RunTime:0.004942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16655547 ORDER BY `unit` DESC [ RunTime:0.008407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16655547 LIMIT 2 [ RunTime:0.004742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655547 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409538 LIMIT 5 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409538 ORDER BY `minOrder` ASC [ RunTime:0.005835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11409538 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11409538 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409538 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='2033691347' and brandshort='Molex' limit 1 [ RunTime:0.003156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409523 LIMIT 5 [ RunTime:0.027761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409523 ORDER BY `minOrder` ASC [ RunTime:0.015072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11409523 ORDER BY `unit` DESC [ RunTime:0.020910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11409523 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409523 ORDER BY `minOrder` ASC [ RunTime:0.001512s ]
select * from pdf where partno='2033691253' and brandshort='Molex' limit 1 [ RunTime:0.001004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504978 LIMIT 5 [ RunTime:0.005373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504978 ORDER BY `minOrder` ASC [ RunTime:0.008218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504978 ORDER BY `unit` DESC [ RunTime:0.006359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504978 LIMIT 2 [ RunTime:0.028093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504978 ORDER BY `minOrder` ASC [ RunTime:0.002265s ]
select * from pdf where partno='2033701253' and brandshort='Molex' limit 1 [ RunTime:0.009431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13628078 LIMIT 5 [ RunTime:0.005149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13628078 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13628078 ORDER BY `unit` DESC [ RunTime:0.005188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13628078 LIMIT 2 [ RunTime:0.003201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13628078 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12866707 LIMIT 5 [ RunTime:0.000964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12866707 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12866707 ORDER BY `unit` DESC [ RunTime:0.001923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12866707 LIMIT 2 [ RunTime:0.002580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12866707 ORDER BY `minOrder` ASC [ RunTime:0.005594s ]
select * from pdf where partno='203346-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.006984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198579 LIMIT 5 [ RunTime:0.003440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198579 ORDER BY `minOrder` ASC [ RunTime:0.005665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198579 ORDER BY `unit` DESC [ RunTime:0.001647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198579 LIMIT 2 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198579 ORDER BY `minOrder` ASC [ RunTime:0.003403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207445 LIMIT 5 [ RunTime:0.003795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207445 ORDER BY `minOrder` ASC [ RunTime:0.003723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207445 ORDER BY `unit` DESC [ RunTime:0.002756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207445 LIMIT 2 [ RunTime:0.001672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207445 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198712 LIMIT 5 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198712 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198712 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198712 LIMIT 2 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198712 ORDER BY `minOrder` ASC [ RunTime:0.004076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194102 LIMIT 5 [ RunTime:0.004678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194102 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194102 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194102 LIMIT 2 [ RunTime:0.001984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194102 ORDER BY `minOrder` ASC [ RunTime:0.005329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20075075 LIMIT 5 [ RunTime:0.004060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20075075 ORDER BY `minOrder` ASC [ RunTime:0.003799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20075075 ORDER BY `unit` DESC [ RunTime:0.009940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20075075 LIMIT 2 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20075075 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074983 LIMIT 5 [ RunTime:0.001515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074983 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074983 ORDER BY `unit` DESC [ RunTime:0.008048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074983 LIMIT 2 [ RunTime:0.003964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074983 ORDER BY `minOrder` ASC [ RunTime:0.002317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074939 LIMIT 5 [ RunTime:0.011183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074939 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074939 ORDER BY `unit` DESC [ RunTime:0.008269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074939 LIMIT 2 [ RunTime:0.001630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074939 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='203344-E' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074890 LIMIT 5 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074890 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074890 ORDER BY `unit` DESC [ RunTime:0.011067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074890 LIMIT 2 [ RunTime:0.005196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074890 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074887 LIMIT 5 [ RunTime:0.002779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074887 ORDER BY `minOrder` ASC [ RunTime:0.002127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074887 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074887 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074887 ORDER BY `minOrder` ASC [ RunTime:0.017413s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255140 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255140 ORDER BY `minOrder` ASC [ RunTime:0.003261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255140 ORDER BY `unit` DESC [ RunTime:0.000395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255140 LIMIT 2 [ RunTime:0.012760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255140 ORDER BY `minOrder` ASC [ RunTime:0.015333s ]
select * from pdf where partno='203316-2200' and brandshort='molex' limit 1 [ RunTime:0.009957s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203316-2200' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.034350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254686 LIMIT 5 [ RunTime:0.000828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254686 ORDER BY `minOrder` ASC [ RunTime:0.007064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254686 ORDER BY `unit` DESC [ RunTime:0.002472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254686 LIMIT 2 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254686 ORDER BY `minOrder` ASC [ RunTime:0.000964s ]
select * from pdf where partno='203371-1347' and brandshort='molex' limit 1 [ RunTime:0.003398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203371-1347' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254783 LIMIT 5 [ RunTime:0.016753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254783 ORDER BY `minOrder` ASC [ RunTime:0.008587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254783 ORDER BY `unit` DESC [ RunTime:0.001127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254783 LIMIT 2 [ RunTime:0.003002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254783 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='203369-1253' and brandshort='molex' limit 1 [ RunTime:0.010212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203369-1253' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254687 LIMIT 5 [ RunTime:0.011445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254687 ORDER BY `minOrder` ASC [ RunTime:0.013191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254687 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254687 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254687 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='203372-1253' and brandshort='molex' limit 1 [ RunTime:0.003319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203372-1253' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254664 LIMIT 5 [ RunTime:0.001510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254664 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254664 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254664 LIMIT 2 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254664 ORDER BY `minOrder` ASC [ RunTime:0.006593s ]
select * from pdf where partno='203372-1347' and brandshort='molex' limit 1 [ RunTime:0.004307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203372-1347' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.025690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254648 LIMIT 5 [ RunTime:0.004904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254648 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254648 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254648 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254648 ORDER BY `minOrder` ASC [ RunTime:0.002862s ]
select * from pdf where partno='203369-1347' and brandshort='molex' limit 1 [ RunTime:0.004120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203369-1347' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.020697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279055 LIMIT 5 [ RunTime:0.009138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279055 ORDER BY `minOrder` ASC [ RunTime:0.005684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279055 ORDER BY `unit` DESC [ RunTime:0.002132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279055 LIMIT 2 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279055 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='203323-e' and brandshort='te connectivity / erni' limit 1 [ RunTime:0.001347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203323-e' OR `brand` LIKE 'te connectivity / erni%' ) ) LIMIT 1 [ RunTime:0.009693s ]
SELECT `id` FROM `stock` WHERE `id` <> 32279055 AND `partno` = '203323-e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / erni%' ) [ RunTime:0.008999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32278982 [ RunTime:0.009306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32278982 LIMIT 5 [ RunTime:0.015315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32278982 ORDER BY `minOrder` ASC [ RunTime:0.012030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32278982 ORDER BY `unit` DESC [ RunTime:0.001125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32278982 LIMIT 2 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32278982 ORDER BY `minOrder` ASC [ RunTime:0.010625s ]
select * from pdf where partno='203323-e' and brandshort='te connectivity / erni' limit 1 [ RunTime:0.013981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203323-e' OR `brand` LIKE 'te connectivity / erni%' ) ) LIMIT 1 [ RunTime:0.000540s ]
SELECT `id` FROM `stock` WHERE `id` <> 32278982 AND `partno` = '203323-e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / erni%' ) [ RunTime:0.008977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279055 [ RunTime:0.035364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255663 LIMIT 5 [ RunTime:0.001791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255663 ORDER BY `minOrder` ASC [ RunTime:0.012190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255663 ORDER BY `unit` DESC [ RunTime:0.004108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255663 LIMIT 2 [ RunTime:0.007141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255663 ORDER BY `minOrder` ASC [ RunTime:0.008199s ]
select * from pdf where partno='203370-1253' and brandshort='molex' limit 1 [ RunTime:0.007608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203370-1253' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.015676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218803 LIMIT 5 [ RunTime:0.013704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218803 ORDER BY `minOrder` ASC [ RunTime:0.019394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218803 ORDER BY `unit` DESC [ RunTime:0.005289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218803 LIMIT 2 [ RunTime:0.017485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218803 ORDER BY `minOrder` ASC [ RunTime:0.018429s ]
select * from pdf where partno='2033' and brandshort='adafruit' limit 1 [ RunTime:0.007966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001653s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59947699 LIMIT 5 [ RunTime:0.005572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947699 ORDER BY `minOrder` ASC [ RunTime:0.023141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59947699 ORDER BY `unit` DESC [ RunTime:0.013686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59947699 LIMIT 2 [ RunTime:0.014976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947699 ORDER BY `minOrder` ASC [ RunTime:0.006584s ]
select * from pdf where partno='203390-0321' and brandshort='Molex' limit 1 [ RunTime:0.002675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203390-0321' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362124 LIMIT 5 [ RunTime:0.003999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362124 ORDER BY `minOrder` ASC [ RunTime:0.006243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362124 ORDER BY `unit` DESC [ RunTime:0.005785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362124 LIMIT 2 [ RunTime:0.004775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362124 ORDER BY `minOrder` ASC [ RunTime:0.007884s ]
select * from pdf where partno='203389-0361' and brandshort='WEC' limit 1 [ RunTime:0.003651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203389-0361' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.006150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355188 LIMIT 5 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355188 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355188 ORDER BY `unit` DESC [ RunTime:0.001821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355188 LIMIT 2 [ RunTime:0.008521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355188 ORDER BY `minOrder` ASC [ RunTime:0.010604s ]
select * from pdf where partno='2033890323' and brandshort='Molex' limit 1 [ RunTime:0.008763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033890323' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943912 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943912 ORDER BY `minOrder` ASC [ RunTime:0.001010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943912 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943912 LIMIT 2 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943912 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
select * from pdf where partno='203316-2206' and brandshort='Molex' limit 1 [ RunTime:0.002940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203316-2206' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59948298 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948298 ORDER BY `minOrder` ASC [ RunTime:0.000887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59948298 ORDER BY `unit` DESC [ RunTime:0.004498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59948298 LIMIT 2 [ RunTime:0.009211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948298 ORDER BY `minOrder` ASC [ RunTime:0.001553s ]
select * from pdf where partno='203341-0002' and brandshort='Molex' limit 1 [ RunTime:0.001930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203341-0002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568241 LIMIT 5 [ RunTime:0.004587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568241 ORDER BY `minOrder` ASC [ RunTime:0.015439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568241 ORDER BY `unit` DESC [ RunTime:0.000727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568241 LIMIT 2 [ RunTime:0.014492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568241 ORDER BY `minOrder` ASC [ RunTime:0.003381s ]
select * from pdf where partno='20330' and brandshort='Excel Blades' limit 1 [ RunTime:0.010798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20330' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.014801s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568241 AND `partno` = '20330' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.031125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178383 [ RunTime:0.017030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58205168 LIMIT 5 [ RunTime:0.001941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58205168 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58205168 ORDER BY `unit` DESC [ RunTime:0.004911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58205168 LIMIT 2 [ RunTime:0.022264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58205168 ORDER BY `minOrder` ASC [ RunTime:0.007076s ]
select * from pdf where partno='2033-80-G5-T1LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033-80-G5-T1LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003162s ]
SELECT `id` FROM `stock` WHERE `id` <> 58205168 AND `partno` = '2033-80-G5-T1LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.009768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655547 [ RunTime:0.004744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63495561 LIMIT 5 [ RunTime:0.020910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63495561 ORDER BY `minOrder` ASC [ RunTime:0.016013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63495561 ORDER BY `unit` DESC [ RunTime:0.012671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63495561 LIMIT 2 [ RunTime:0.008298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63495561 ORDER BY `minOrder` ASC [ RunTime:0.014625s ]
select * from pdf where partno='2033-1' and brandshort='Techspray' limit 1 [ RunTime:0.030097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033-1' OR `brand` LIKE 'Techspray%' ) ) LIMIT 1 [ RunTime:0.013754s ]
SELECT `id` FROM `stock` WHERE `id` <> 63495561 AND `partno` = '2033-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%techspray%' ) [ RunTime:0.031132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509501 [ RunTime:0.031269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62421107 LIMIT 5 [ RunTime:0.013885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421107 ORDER BY `minOrder` ASC [ RunTime:0.009282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62421107 ORDER BY `unit` DESC [ RunTime:0.011687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62421107 LIMIT 2 [ RunTime:0.008401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421107 ORDER BY `minOrder` ASC [ RunTime:0.022775s ]
select * from pdf where partno='203387-9313' and brandshort='WEC' limit 1 [ RunTime:0.019681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9313' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.030868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944038 LIMIT 5 [ RunTime:0.008341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944038 ORDER BY `minOrder` ASC [ RunTime:0.005083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944038 ORDER BY `unit` DESC [ RunTime:0.003854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944038 LIMIT 2 [ RunTime:0.013623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944038 ORDER BY `minOrder` ASC [ RunTime:0.011434s ]
select * from pdf where partno='2033991-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.030824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033991-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.074485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60412271 LIMIT 5 [ RunTime:0.059109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412271 ORDER BY `minOrder` ASC [ RunTime:0.022796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60412271 ORDER BY `unit` DESC [ RunTime:0.022188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60412271 LIMIT 2 [ RunTime:0.022469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412271 ORDER BY `minOrder` ASC [ RunTime:0.006118s ]
select * from pdf where partno='203346-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.025358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203346-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.013004s ]
SELECT `id` FROM `stock` WHERE `id` <> 60412271 AND `partno` = '203346-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.013106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12866707 [ RunTime:0.016916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62421106 LIMIT 5 [ RunTime:0.012505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421106 ORDER BY `minOrder` ASC [ RunTime:0.017238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62421106 ORDER BY `unit` DESC [ RunTime:0.038405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62421106 LIMIT 2 [ RunTime:0.008342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421106 ORDER BY `minOrder` ASC [ RunTime:0.041487s ]
select * from pdf where partno='203387-9311' and brandshort='WEC' limit 1 [ RunTime:0.041199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9311' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.058733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121027 LIMIT 5 [ RunTime:0.027389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121027 ORDER BY `minOrder` ASC [ RunTime:0.063523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121027 ORDER BY `unit` DESC [ RunTime:0.107342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121027 LIMIT 2 [ RunTime:0.022869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121027 ORDER BY `minOrder` ASC [ RunTime:0.033322s ]
select * from pdf where partno='2033691347' and brandshort='Molex' limit 1 [ RunTime:0.032742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033691347' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.061349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121691 LIMIT 5 [ RunTime:0.039772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121691 ORDER BY `minOrder` ASC [ RunTime:0.048079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121691 ORDER BY `unit` DESC [ RunTime:0.022834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121691 LIMIT 2 [ RunTime:0.073784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121691 ORDER BY `minOrder` ASC [ RunTime:0.047395s ]
select * from pdf where partno='2033691253' and brandshort='Molex' limit 1 [ RunTime:0.048500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033691253' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.060527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944032 LIMIT 5 [ RunTime:0.058989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944032 ORDER BY `minOrder` ASC [ RunTime:0.021686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944032 ORDER BY `unit` DESC [ RunTime:0.073929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944032 LIMIT 2 [ RunTime:0.019855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944032 ORDER BY `minOrder` ASC [ RunTime:0.020569s ]
select * from pdf where partno='203387-9010' and brandshort='Molex' limit 1 [ RunTime:0.046519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9010' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944029 LIMIT 5 [ RunTime:0.033929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944029 ORDER BY `minOrder` ASC [ RunTime:0.025104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944029 ORDER BY `unit` DESC [ RunTime:0.014192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944029 LIMIT 2 [ RunTime:0.018276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944029 ORDER BY `minOrder` ASC [ RunTime:0.016244s ]
select * from pdf where partno='203387-9011' and brandshort='Molex' limit 1 [ RunTime:0.023985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9011' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.064253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62421900 LIMIT 5 [ RunTime:0.084299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421900 ORDER BY `minOrder` ASC [ RunTime:0.025375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62421900 ORDER BY `unit` DESC [ RunTime:0.011625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62421900 LIMIT 2 [ RunTime:0.046690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421900 ORDER BY `minOrder` ASC [ RunTime:0.013317s ]
select * from pdf where partno='203387-9317' and brandshort='WEC' limit 1 [ RunTime:0.007492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9317' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.020592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62120994 LIMIT 5 [ RunTime:0.014761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62120994 ORDER BY `minOrder` ASC [ RunTime:0.022439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62120994 ORDER BY `unit` DESC [ RunTime:0.044679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62120994 LIMIT 2 [ RunTime:0.060995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62120994 ORDER BY `minOrder` ASC [ RunTime:0.020666s ]
select * from pdf where partno='2033701253' and brandshort='Molex' limit 1 [ RunTime:0.034643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2033701253' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.053600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62987083 LIMIT 5 [ RunTime:0.022172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62987083 ORDER BY `minOrder` ASC [ RunTime:0.089874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62987083 ORDER BY `unit` DESC [ RunTime:0.060411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62987083 LIMIT 2 [ RunTime:0.044852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62987083 ORDER BY `minOrder` ASC [ RunTime:0.017211s ]
select * from pdf where partno='203387-9001' and brandshort='Molex' limit 1 [ RunTime:0.013684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.044143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62421899 LIMIT 5 [ RunTime:0.048618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421899 ORDER BY `minOrder` ASC [ RunTime:0.054448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62421899 ORDER BY `unit` DESC [ RunTime:0.003938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62421899 LIMIT 2 [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421899 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='203387-9316' and brandshort='WEC' limit 1 [ RunTime:0.026984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203387-9316' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.008181s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010322s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013780s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011006s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009464s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015764s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009552s ]
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 '2033%' OR `brand` LIKE '2033%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023990s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2033%' OR `brand` LIKE '2033%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.061023s ]