SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002562s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010406s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857514 LIMIT 5 [ RunTime:0.004388s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857514 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857514 ORDER BY `unit` DESC [ RunTime:0.006897s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857514 LIMIT 2 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857514 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857447 LIMIT 5 [ RunTime:0.004142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857447 ORDER BY `minOrder` ASC [ RunTime:0.008024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857447 ORDER BY `unit` DESC [ RunTime:0.004641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857447 LIMIT 2 [ RunTime:0.011777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857447 ORDER BY `minOrder` ASC [ RunTime:0.006680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856951 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856951 ORDER BY `minOrder` ASC [ RunTime:0.005920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856951 ORDER BY `unit` DESC [ RunTime:0.005210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856951 LIMIT 2 [ RunTime:0.005986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856951 ORDER BY `minOrder` ASC [ RunTime:0.002676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856939 LIMIT 5 [ RunTime:0.002853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856939 ORDER BY `minOrder` ASC [ RunTime:0.002700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856939 ORDER BY `unit` DESC [ RunTime:0.004711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856939 LIMIT 2 [ RunTime:0.010753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856939 ORDER BY `minOrder` ASC [ RunTime:0.006212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856719 LIMIT 5 [ RunTime:0.017081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856719 ORDER BY `minOrder` ASC [ RunTime:0.035834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856719 ORDER BY `unit` DESC [ RunTime:0.031499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856719 LIMIT 2 [ RunTime:0.017051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856719 ORDER BY `minOrder` ASC [ RunTime:0.025691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856698 LIMIT 5 [ RunTime:0.012792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856698 ORDER BY `minOrder` ASC [ RunTime:0.034063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856698 ORDER BY `unit` DESC [ RunTime:0.022962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856698 LIMIT 2 [ RunTime:0.024696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856698 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856338 LIMIT 5 [ RunTime:0.008276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856338 ORDER BY `minOrder` ASC [ RunTime:0.009946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856338 ORDER BY `unit` DESC [ RunTime:0.013568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856338 LIMIT 2 [ RunTime:0.003998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856338 ORDER BY `minOrder` ASC [ RunTime:0.001932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856299 LIMIT 5 [ RunTime:0.010973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856299 ORDER BY `minOrder` ASC [ RunTime:0.005601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856299 ORDER BY `unit` DESC [ RunTime:0.001946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856299 LIMIT 2 [ RunTime:0.005058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856299 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856238 LIMIT 5 [ RunTime:0.008327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856238 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856238 ORDER BY `unit` DESC [ RunTime:0.012141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856238 LIMIT 2 [ RunTime:0.012308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856238 ORDER BY `minOrder` ASC [ RunTime:0.007806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856236 LIMIT 5 [ RunTime:0.006055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856236 ORDER BY `minOrder` ASC [ RunTime:0.016077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856236 ORDER BY `unit` DESC [ RunTime:0.010357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856236 LIMIT 2 [ RunTime:0.009819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856236 ORDER BY `minOrder` ASC [ RunTime:0.004980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025156 LIMIT 5 [ RunTime:0.013826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025156 ORDER BY `minOrder` ASC [ RunTime:0.015359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025156 ORDER BY `unit` DESC [ RunTime:0.009394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025156 LIMIT 2 [ RunTime:0.021432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025156 ORDER BY `minOrder` ASC [ RunTime:0.023968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240343 LIMIT 5 [ RunTime:0.020464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240343 ORDER BY `minOrder` ASC [ RunTime:0.030299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240343 ORDER BY `unit` DESC [ RunTime:0.048980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240343 LIMIT 2 [ RunTime:0.042944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240343 ORDER BY `minOrder` ASC [ RunTime:0.016059s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015834s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471874 LIMIT 5 [ RunTime:0.003318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471874 ORDER BY `minOrder` ASC [ RunTime:0.008406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471874 ORDER BY `unit` DESC [ RunTime:0.007040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471874 LIMIT 2 [ RunTime:0.019641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471874 ORDER BY `minOrder` ASC [ RunTime:0.008792s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.026711s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013600s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471874 AND `partno` = '40-901-5000-psi-1/2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.034359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857514 [ RunTime:0.035387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471730 LIMIT 5 [ RunTime:0.031598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471730 ORDER BY `minOrder` ASC [ RunTime:0.028133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471730 ORDER BY `unit` DESC [ RunTime:0.029513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471730 LIMIT 2 [ RunTime:0.010053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471730 ORDER BY `minOrder` ASC [ RunTime:0.007668s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020692s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471730 AND `partno` = '40-901-5000-psi-1/2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.039258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857447 [ RunTime:0.009146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470271 LIMIT 5 [ RunTime:0.004151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470271 ORDER BY `minOrder` ASC [ RunTime:0.010539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470271 ORDER BY `unit` DESC [ RunTime:0.011714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470271 LIMIT 2 [ RunTime:0.017116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470271 ORDER BY `minOrder` ASC [ RunTime:0.006704s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.028581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012149s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470271 AND `partno` = '40-901-5000-psi-1/2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856719 [ RunTime:0.027483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470232 LIMIT 5 [ RunTime:0.028009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470232 ORDER BY `minOrder` ASC [ RunTime:0.016177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470232 ORDER BY `unit` DESC [ RunTime:0.031454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470232 LIMIT 2 [ RunTime:0.009101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470232 ORDER BY `minOrder` ASC [ RunTime:0.011506s ]
select * from pdf where partno='40-901-5000-psi-1/2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004921s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470232 AND `partno` = '40-901-5000-psi-1/2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.025506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856698 [ RunTime:0.040230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085239 LIMIT 5 [ RunTime:0.036037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085239 ORDER BY `minOrder` ASC [ RunTime:0.039242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085239 ORDER BY `unit` DESC [ RunTime:0.012487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085239 LIMIT 2 [ RunTime:0.018225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085239 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='40-901-5000-psi-1/2-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021629s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085239 AND `partno` = '40-901-5000-psi-1/2-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.026393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856951 [ RunTime:0.011201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085226 LIMIT 5 [ RunTime:0.004226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085226 ORDER BY `minOrder` ASC [ RunTime:0.006598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085226 ORDER BY `unit` DESC [ RunTime:0.015320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085226 LIMIT 2 [ RunTime:0.014178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085226 ORDER BY `minOrder` ASC [ RunTime:0.007200s ]
select * from pdf where partno='40-901-5000-psi-1/2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014574s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085226 AND `partno` = '40-901-5000-psi-1/2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856939 [ RunTime:0.008676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084993 LIMIT 5 [ RunTime:0.001454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084993 ORDER BY `minOrder` ASC [ RunTime:0.005873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084993 ORDER BY `unit` DESC [ RunTime:0.004757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084993 LIMIT 2 [ RunTime:0.006223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084993 ORDER BY `minOrder` ASC [ RunTime:0.008103s ]
select * from pdf where partno='40-901-5000-psi-1/2-DRY-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.021750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-DRY-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004220s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084993 AND `partno` = '40-901-5000-psi-1/2-DRY-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240343 [ RunTime:0.012246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084456 LIMIT 5 [ RunTime:0.011804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084456 ORDER BY `minOrder` ASC [ RunTime:0.027161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084456 ORDER BY `unit` DESC [ RunTime:0.027016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084456 LIMIT 2 [ RunTime:0.001202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084456 ORDER BY `minOrder` ASC [ RunTime:0.010428s ]
select * from pdf where partno='40-901-5000-psi-1/2-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004121s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084456 AND `partno` = '40-901-5000-psi-1/2-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856338 [ RunTime:0.027957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084292 LIMIT 5 [ RunTime:0.009544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084292 ORDER BY `minOrder` ASC [ RunTime:0.024664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084292 ORDER BY `unit` DESC [ RunTime:0.002507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084292 LIMIT 2 [ RunTime:0.004358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084292 ORDER BY `minOrder` ASC [ RunTime:0.017256s ]
select * from pdf where partno='40-901-5000-psi-1/2-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016449s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084292 AND `partno` = '40-901-5000-psi-1/2-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856299 [ RunTime:0.016043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084276 LIMIT 5 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084276 ORDER BY `minOrder` ASC [ RunTime:0.010490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084276 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084276 LIMIT 2 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084276 ORDER BY `minOrder` ASC [ RunTime:0.016416s ]
select * from pdf where partno='40-901-5000-psi-1/2-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006539s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084276 AND `partno` = '40-901-5000-psi-1/2-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025156 [ RunTime:0.006571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084179 LIMIT 5 [ RunTime:0.001991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084179 ORDER BY `minOrder` ASC [ RunTime:0.002718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084179 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084179 LIMIT 2 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084179 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
select * from pdf where partno='40-901-5000-psi-1/2-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002464s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084179 AND `partno` = '40-901-5000-psi-1/2-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856238 [ RunTime:0.001737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084175 LIMIT 5 [ RunTime:0.005507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084175 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084175 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084175 LIMIT 2 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084175 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='40-901-5000-psi-1/2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi-1/2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007907s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084175 AND `partno` = '40-901-5000-psi-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856236 [ RunTime:0.006692s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018961s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006795s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ 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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002230s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009759s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005791s ]
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 '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008448s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-5000-psi-1/2%' OR `brand` LIKE '40-901-5000-psi-1/2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026787s ]