SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002542s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081353s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.046807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857905 LIMIT 5 [ RunTime:0.185428s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.031603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857905 ORDER BY `minOrder` ASC [ RunTime:0.159561s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857905 ORDER BY `unit` DESC [ RunTime:0.086671s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857905 LIMIT 2 [ RunTime:0.039349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857905 ORDER BY `minOrder` ASC [ RunTime:0.093706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857830 LIMIT 5 [ RunTime:0.027054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857830 ORDER BY `minOrder` ASC [ RunTime:0.019834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857830 ORDER BY `unit` DESC [ RunTime:0.051094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857830 LIMIT 2 [ RunTime:0.047260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857830 ORDER BY `minOrder` ASC [ RunTime:0.020680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857794 LIMIT 5 [ RunTime:0.071544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857794 ORDER BY `minOrder` ASC [ RunTime:0.028928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857794 ORDER BY `unit` DESC [ RunTime:0.021570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857794 LIMIT 2 [ RunTime:0.138963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857794 ORDER BY `minOrder` ASC [ RunTime:0.052347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857573 LIMIT 5 [ RunTime:0.094939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857573 ORDER BY `minOrder` ASC [ RunTime:0.085789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857573 ORDER BY `unit` DESC [ RunTime:0.033642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857573 LIMIT 2 [ RunTime:0.075073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857573 ORDER BY `minOrder` ASC [ RunTime:0.105287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856123 LIMIT 5 [ RunTime:0.022862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856123 ORDER BY `minOrder` ASC [ RunTime:0.011508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856123 ORDER BY `unit` DESC [ RunTime:0.027755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856123 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856123 ORDER BY `minOrder` ASC [ RunTime:0.046356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856049 LIMIT 5 [ RunTime:0.057866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856049 ORDER BY `minOrder` ASC [ RunTime:0.071481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856049 ORDER BY `unit` DESC [ RunTime:0.056034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856049 LIMIT 2 [ RunTime:0.053638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856049 ORDER BY `minOrder` ASC [ RunTime:0.008695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855932 LIMIT 5 [ RunTime:0.006215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855932 ORDER BY `minOrder` ASC [ RunTime:0.020515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18855932 ORDER BY `unit` DESC [ RunTime:0.012124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18855932 LIMIT 2 [ RunTime:0.005792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855932 ORDER BY `minOrder` ASC [ RunTime:0.039540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855889 LIMIT 5 [ RunTime:0.034275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855889 ORDER BY `minOrder` ASC [ RunTime:0.020378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18855889 ORDER BY `unit` DESC [ RunTime:0.010609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18855889 LIMIT 2 [ RunTime:0.028854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855889 ORDER BY `minOrder` ASC [ RunTime:0.018143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025546 LIMIT 5 [ RunTime:0.010558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025546 ORDER BY `minOrder` ASC [ RunTime:0.026599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025546 ORDER BY `unit` DESC [ RunTime:0.023892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025546 LIMIT 2 [ RunTime:0.035544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025546 ORDER BY `minOrder` ASC [ RunTime:0.022535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025188 LIMIT 5 [ RunTime:0.011575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025188 ORDER BY `minOrder` ASC [ RunTime:0.009965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025188 ORDER BY `unit` DESC [ RunTime:0.019003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025188 LIMIT 2 [ RunTime:0.009730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025188 ORDER BY `minOrder` ASC [ RunTime:0.036932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025163 LIMIT 5 [ RunTime:0.040216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025163 ORDER BY `minOrder` ASC [ RunTime:0.039077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025163 ORDER BY `unit` DESC [ RunTime:0.001671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025163 LIMIT 2 [ RunTime:0.047551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025163 ORDER BY `minOrder` ASC [ RunTime:0.011803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240578 LIMIT 5 [ RunTime:0.008164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240578 ORDER BY `minOrder` ASC [ RunTime:0.015173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240578 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240578 LIMIT 2 [ RunTime:0.003220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240578 ORDER BY `minOrder` ASC [ RunTime:0.020447s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028702s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086916 LIMIT 5 [ RunTime:0.014588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086916 ORDER BY `minOrder` ASC [ RunTime:0.007929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086916 ORDER BY `unit` DESC [ RunTime:0.012339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086916 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086916 ORDER BY `minOrder` ASC [ RunTime:0.004875s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-BP3-SPMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006526s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-SPMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032676s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086916 AND `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-SPMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025546 [ RunTime:0.016811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086859 LIMIT 5 [ RunTime:0.040973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086859 ORDER BY `minOrder` ASC [ RunTime:0.018974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086859 ORDER BY `unit` DESC [ RunTime:0.036950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086859 LIMIT 2 [ RunTime:0.090598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086859 ORDER BY `minOrder` ASC [ RunTime:0.026665s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-SPMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.058317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-SPMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018960s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086859 AND `partno` = '25-911-10-bar/psi-G1/4-SG-SPMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.073374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857905 [ RunTime:0.015152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086723 LIMIT 5 [ RunTime:0.031770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086723 ORDER BY `minOrder` ASC [ RunTime:0.010816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086723 ORDER BY `unit` DESC [ RunTime:0.022107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086723 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086723 ORDER BY `minOrder` ASC [ RunTime:0.016689s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-BP3-PMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.024052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-PMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.047501s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086723 AND `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-PMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.021823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857830 [ RunTime:0.057205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086658 LIMIT 5 [ RunTime:0.060520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086658 ORDER BY `minOrder` ASC [ RunTime:0.045576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086658 ORDER BY `unit` DESC [ RunTime:0.060016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086658 LIMIT 2 [ RunTime:0.062985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086658 ORDER BY `minOrder` ASC [ RunTime:0.016013s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-PMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.026299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-PMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.091236s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086658 AND `partno` = '25-911-10-bar/psi-G1/4-SG-PMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.071008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857794 [ RunTime:0.028923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086525 LIMIT 5 [ RunTime:0.039284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086525 ORDER BY `minOrder` ASC [ RunTime:0.019975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086525 ORDER BY `unit` DESC [ RunTime:0.024143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086525 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086525 ORDER BY `minOrder` ASC [ RunTime:0.016148s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012603s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086525 AND `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240578 [ RunTime:0.016449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086451 LIMIT 5 [ RunTime:0.058007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086451 ORDER BY `minOrder` ASC [ RunTime:0.070454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086451 ORDER BY `unit` DESC [ RunTime:0.015207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086451 LIMIT 2 [ RunTime:0.044934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086451 ORDER BY `minOrder` ASC [ RunTime:0.033276s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.044535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018007s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086451 AND `partno` = '25-911-10-bar/psi-G1/4-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857573 [ RunTime:0.051949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084374 LIMIT 5 [ RunTime:0.019106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084374 ORDER BY `minOrder` ASC [ RunTime:0.005344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084374 ORDER BY `unit` DESC [ RunTime:0.007984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084374 LIMIT 2 [ RunTime:0.030618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084374 ORDER BY `minOrder` ASC [ RunTime:0.015939s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-BP3-SPMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.029296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-SPMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007115s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084374 AND `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-SPMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.024453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025188 [ RunTime:0.023601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084296 LIMIT 5 [ RunTime:0.022326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084296 ORDER BY `minOrder` ASC [ RunTime:0.004068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084296 ORDER BY `unit` DESC [ RunTime:0.008274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084296 LIMIT 2 [ RunTime:0.009209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084296 ORDER BY `minOrder` ASC [ RunTime:0.011183s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-SPMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-SPMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005249s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084296 AND `partno` = '25-911-10-bar/psi-G1/4-SG-SPMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025163 [ RunTime:0.005512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084007 LIMIT 5 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084007 ORDER BY `minOrder` ASC [ RunTime:0.003655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084007 ORDER BY `unit` DESC [ RunTime:0.007204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084007 LIMIT 2 [ RunTime:0.003339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084007 ORDER BY `minOrder` ASC [ RunTime:0.007379s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-BP3-PMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-PMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007772s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084007 AND `partno` = '25-911-10-bar/psi-G1/4-SG-BP3-PMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856123 [ RunTime:0.002454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083877 LIMIT 5 [ RunTime:0.031817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083877 ORDER BY `minOrder` ASC [ RunTime:0.029545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083877 ORDER BY `unit` DESC [ RunTime:0.044366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083877 LIMIT 2 [ RunTime:0.045875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083877 ORDER BY `minOrder` ASC [ RunTime:0.018207s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-PMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.030743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-PMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025544s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083877 AND `partno` = '25-911-10-bar/psi-G1/4-SG-PMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.029884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856049 [ RunTime:0.010673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083721 LIMIT 5 [ RunTime:0.009635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083721 ORDER BY `minOrder` ASC [ RunTime:0.018292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083721 ORDER BY `unit` DESC [ RunTime:0.016459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083721 LIMIT 2 [ RunTime:0.004127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083721 ORDER BY `minOrder` ASC [ RunTime:0.005551s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.016860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031429s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083721 AND `partno` = '25-911-10-bar/psi-G1/4-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855932 [ RunTime:0.011551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083628 LIMIT 5 [ RunTime:0.038217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083628 ORDER BY `minOrder` ASC [ RunTime:0.022982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083628 ORDER BY `unit` DESC [ RunTime:0.012466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083628 LIMIT 2 [ RunTime:0.106558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083628 ORDER BY `minOrder` ASC [ RunTime:0.014194s ]
select * from pdf where partno='25-911-10-bar/psi-G1/4-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-10-bar/psi-G1/4-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.055121s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083628 AND `partno` = '25-911-10-bar/psi-G1/4-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.032070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855889 [ RunTime:0.049261s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033768s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041497s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054847s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094095s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061382s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032074s ]
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 '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032929s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-911-10-bar/psi-G1/4-SG%' OR `brand` LIKE '25-911-10-bar/psi-G1/4-SG%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.088506s ]