SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002666s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052361s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18861357 LIMIT 5 [ RunTime:0.023013s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18861357 ORDER BY `minOrder` ASC [ RunTime:0.027362s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18861357 ORDER BY `unit` DESC [ RunTime:0.030880s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18861357 LIMIT 2 [ RunTime:0.046282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18861357 ORDER BY `minOrder` ASC [ RunTime:0.040593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857801 LIMIT 5 [ RunTime:0.059044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857801 ORDER BY `minOrder` ASC [ RunTime:0.040141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857801 ORDER BY `unit` DESC [ RunTime:0.064131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857801 LIMIT 2 [ RunTime:0.163457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857801 ORDER BY `minOrder` ASC [ RunTime:0.056440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857702 LIMIT 5 [ RunTime:0.056054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857702 ORDER BY `minOrder` ASC [ RunTime:0.087571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857702 ORDER BY `unit` DESC [ RunTime:0.077523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857702 LIMIT 2 [ RunTime:0.060792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857702 ORDER BY `minOrder` ASC [ RunTime:0.022264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857578 LIMIT 5 [ RunTime:0.064919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857578 ORDER BY `minOrder` ASC [ RunTime:0.062698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857578 ORDER BY `unit` DESC [ RunTime:0.175542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857578 LIMIT 2 [ RunTime:0.057063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857578 ORDER BY `minOrder` ASC [ RunTime:0.041209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857381 LIMIT 5 [ RunTime:0.080340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857381 ORDER BY `minOrder` ASC [ RunTime:0.132303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857381 ORDER BY `unit` DESC [ RunTime:0.259241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857381 LIMIT 2 [ RunTime:0.054650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857381 ORDER BY `minOrder` ASC [ RunTime:0.012546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857348 LIMIT 5 [ RunTime:0.086254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857348 ORDER BY `minOrder` ASC [ RunTime:0.050885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857348 ORDER BY `unit` DESC [ RunTime:0.022354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857348 LIMIT 2 [ RunTime:0.074718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857348 ORDER BY `minOrder` ASC [ RunTime:0.040781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856073 LIMIT 5 [ RunTime:0.078948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856073 ORDER BY `minOrder` ASC [ RunTime:0.068360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856073 ORDER BY `unit` DESC [ RunTime:0.046639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856073 LIMIT 2 [ RunTime:0.043902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856073 ORDER BY `minOrder` ASC [ RunTime:0.068989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855893 LIMIT 5 [ RunTime:0.065549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855893 ORDER BY `minOrder` ASC [ RunTime:0.035856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18855893 ORDER BY `unit` DESC [ RunTime:0.024069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18855893 LIMIT 2 [ RunTime:0.062894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855893 ORDER BY `minOrder` ASC [ RunTime:0.029575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855832 LIMIT 5 [ RunTime:0.039140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855832 ORDER BY `minOrder` ASC [ RunTime:0.037219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18855832 ORDER BY `unit` DESC [ RunTime:0.067811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18855832 LIMIT 2 [ RunTime:0.099499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855832 ORDER BY `minOrder` ASC [ RunTime:0.053287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025140 LIMIT 5 [ RunTime:0.059507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025140 ORDER BY `minOrder` ASC [ RunTime:0.100659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025140 ORDER BY `unit` DESC [ RunTime:0.069015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025140 LIMIT 2 [ RunTime:0.035667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025140 ORDER BY `minOrder` ASC [ RunTime:0.035590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15241054 LIMIT 5 [ RunTime:0.063824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15241054 ORDER BY `minOrder` ASC [ RunTime:0.038286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15241054 ORDER BY `unit` DESC [ RunTime:0.022104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15241054 LIMIT 2 [ RunTime:0.018004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15241054 ORDER BY `minOrder` ASC [ RunTime:0.007655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240526 LIMIT 5 [ RunTime:0.045644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240526 ORDER BY `minOrder` ASC [ RunTime:0.127238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240526 ORDER BY `unit` DESC [ RunTime:0.048092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240526 LIMIT 2 [ RunTime:0.022221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240526 ORDER BY `minOrder` ASC [ RunTime:0.044578s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.122408s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086665 LIMIT 5 [ RunTime:0.037123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086665 ORDER BY `minOrder` ASC [ RunTime:0.045174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086665 ORDER BY `unit` DESC [ RunTime:0.060834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086665 LIMIT 2 [ RunTime:0.029031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086665 ORDER BY `minOrder` ASC [ RunTime:0.027701s ]
select * from pdf where partno='25-911-100-psi/bar-SG-BP3-SPMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.108706s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-BP3-SPMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.086966s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086665 AND `partno` = '25-911-100-psi/bar-SG-BP3-SPMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.051737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857801 [ RunTime:0.037114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086625 LIMIT 5 [ RunTime:0.105869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086625 ORDER BY `minOrder` ASC [ RunTime:0.062396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086625 ORDER BY `unit` DESC [ RunTime:0.035405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086625 LIMIT 2 [ RunTime:0.028963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086625 ORDER BY `minOrder` ASC [ RunTime:0.006054s ]
select * from pdf where partno='25-911-100-psi/bar-SG-SPMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.080366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-SPMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000980s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086625 AND `partno` = '25-911-100-psi/bar-SG-SPMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.093678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857702 [ RunTime:0.073194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086458 LIMIT 5 [ RunTime:0.069097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086458 ORDER BY `minOrder` ASC [ RunTime:0.102899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086458 ORDER BY `unit` DESC [ RunTime:0.044591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086458 LIMIT 2 [ RunTime:0.055741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086458 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
select * from pdf where partno='25-911-100-psi/bar-SG-BP3-PMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.031205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-BP3-PMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036726s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086458 AND `partno` = '25-911-100-psi/bar-SG-BP3-PMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.031673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857578 [ RunTime:0.029825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086364 LIMIT 5 [ RunTime:0.039297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086364 ORDER BY `minOrder` ASC [ RunTime:0.006474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086364 ORDER BY `unit` DESC [ RunTime:0.007967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086364 LIMIT 2 [ RunTime:0.018075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086364 ORDER BY `minOrder` ASC [ RunTime:0.003533s ]
select * from pdf where partno='25-911-100-psi/bar-SG-PMC-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-PMC-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004370s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086364 AND `partno` = '25-911-100-psi/bar-SG-PMC-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240526 [ RunTime:0.021264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085991 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085991 ORDER BY `minOrder` ASC [ RunTime:0.017986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085991 ORDER BY `unit` DESC [ RunTime:0.002556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085991 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085991 ORDER BY `minOrder` ASC [ RunTime:0.005078s ]
select * from pdf where partno='25-911-100-psi/bar-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000695s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085991 AND `partno` = '25-911-100-psi/bar-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857381 [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085941 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085941 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085941 ORDER BY `unit` DESC [ RunTime:0.002983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085941 LIMIT 2 [ RunTime:0.001220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085941 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='25-911-100-psi/bar-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002549s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085941 AND `partno` = '25-911-100-psi/bar-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857348 [ RunTime:0.002775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083928 LIMIT 5 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083928 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083928 ORDER BY `unit` DESC [ RunTime:0.019221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083928 LIMIT 2 [ RunTime:0.002094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083928 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
select * from pdf where partno='25-911-100-psi/bar-SG-BP3-SPMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-BP3-SPMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003180s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083928 AND `partno` = '25-911-100-psi/bar-SG-BP3-SPMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856073 [ RunTime:0.001195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083837 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083837 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083837 ORDER BY `unit` DESC [ RunTime:0.004804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083837 LIMIT 2 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083837 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
select * from pdf where partno='25-911-100-psi/bar-SG-SPMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-SPMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000463s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083837 AND `partno` = '25-911-100-psi/bar-SG-SPMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025140 [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083633 LIMIT 5 [ RunTime:0.006052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083633 ORDER BY `minOrder` ASC [ RunTime:0.001627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083633 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083633 LIMIT 2 [ RunTime:0.006818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083633 ORDER BY `minOrder` ASC [ RunTime:0.008642s ]
select * from pdf where partno='25-911-100-psi/bar-SG-BP3-PMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-BP3-PMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006340s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083633 AND `partno` = '25-911-100-psi/bar-SG-BP3-PMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.007775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855893 [ RunTime:0.004810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083527 LIMIT 5 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083527 ORDER BY `minOrder` ASC [ RunTime:0.006789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083527 ORDER BY `unit` DESC [ RunTime:0.001629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083527 LIMIT 2 [ RunTime:0.002808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083527 ORDER BY `minOrder` ASC [ RunTime:0.010456s ]
select * from pdf where partno='25-911-100-psi/bar-SG-PMC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-PMC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009779s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083527 AND `partno` = '25-911-100-psi/bar-SG-PMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855832 [ RunTime:0.013862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083081 LIMIT 5 [ RunTime:0.020254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083081 ORDER BY `minOrder` ASC [ RunTime:0.015760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083081 ORDER BY `unit` DESC [ RunTime:0.021772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083081 LIMIT 2 [ RunTime:0.004290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083081 ORDER BY `minOrder` ASC [ RunTime:0.011829s ]
select * from pdf where partno='25-911-100-psi/bar-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.034961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011185s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083081 AND `partno` = '25-911-100-psi/bar-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.030360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18861357 [ RunTime:0.006826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083011 LIMIT 5 [ RunTime:0.049777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083011 ORDER BY `minOrder` ASC [ RunTime:0.021115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083011 ORDER BY `unit` DESC [ RunTime:0.044175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083011 LIMIT 2 [ RunTime:0.031930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083011 ORDER BY `minOrder` ASC [ RunTime:0.026163s ]
select * from pdf where partno='25-911-100-psi/bar-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.024471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-911-100-psi/bar-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.047167s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083011 AND `partno` = '25-911-100-psi/bar-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.026155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15241054 [ RunTime:0.001472s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049584s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028617s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036672s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033258s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044614s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040442s ]
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-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054575s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-911-100-psi/bar-SG%' OR `brand` LIKE '25-911-100-psi/bar-SG%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.079924s ]