SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001434s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026143s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857910 LIMIT 5 [ RunTime:0.008422s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857910 ORDER BY `minOrder` ASC [ RunTime:0.008156s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857910 ORDER BY `unit` DESC [ RunTime:0.017798s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.035164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857910 LIMIT 2 [ RunTime:0.028744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857910 ORDER BY `minOrder` ASC [ RunTime:0.010290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857879 LIMIT 5 [ RunTime:0.031648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857879 ORDER BY `minOrder` ASC [ RunTime:0.030149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857879 ORDER BY `unit` DESC [ RunTime:0.064128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857879 LIMIT 2 [ RunTime:0.032108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857879 ORDER BY `minOrder` ASC [ RunTime:0.015363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857439 LIMIT 5 [ RunTime:0.059813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857439 ORDER BY `minOrder` ASC [ RunTime:0.017997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857439 ORDER BY `unit` DESC [ RunTime:0.027886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857439 LIMIT 2 [ RunTime:0.037417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857439 ORDER BY `minOrder` ASC [ RunTime:0.019931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857000 LIMIT 5 [ RunTime:0.015793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857000 ORDER BY `minOrder` ASC [ RunTime:0.049345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857000 ORDER BY `unit` DESC [ RunTime:0.007818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857000 LIMIT 2 [ RunTime:0.025924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857000 ORDER BY `minOrder` ASC [ RunTime:0.016652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856987 LIMIT 5 [ RunTime:0.022120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856987 ORDER BY `minOrder` ASC [ RunTime:0.027477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856987 ORDER BY `unit` DESC [ RunTime:0.037788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856987 LIMIT 2 [ RunTime:0.013576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856987 ORDER BY `minOrder` ASC [ RunTime:0.016987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856942 LIMIT 5 [ RunTime:0.025331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856942 ORDER BY `minOrder` ASC [ RunTime:0.019407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856942 ORDER BY `unit` DESC [ RunTime:0.033864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856942 LIMIT 2 [ RunTime:0.026901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856942 ORDER BY `minOrder` ASC [ RunTime:0.010841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856931 LIMIT 5 [ RunTime:0.016885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856931 ORDER BY `minOrder` ASC [ RunTime:0.015217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856931 ORDER BY `unit` DESC [ RunTime:0.011131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856931 LIMIT 2 [ RunTime:0.017145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856931 ORDER BY `minOrder` ASC [ RunTime:0.002011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856830 LIMIT 5 [ RunTime:0.008845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856830 ORDER BY `minOrder` ASC [ RunTime:0.003945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856830 ORDER BY `unit` DESC [ RunTime:0.010847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856830 LIMIT 2 [ RunTime:0.006358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856830 ORDER BY `minOrder` ASC [ RunTime:0.016765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856821 LIMIT 5 [ RunTime:0.030112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856821 ORDER BY `minOrder` ASC [ RunTime:0.034963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856821 ORDER BY `unit` DESC [ RunTime:0.028598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856821 LIMIT 2 [ RunTime:0.013252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856821 ORDER BY `minOrder` ASC [ RunTime:0.007016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856706 LIMIT 5 [ RunTime:0.003671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856706 ORDER BY `minOrder` ASC [ RunTime:0.007718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856706 ORDER BY `unit` DESC [ RunTime:0.003729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856706 LIMIT 2 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856706 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856333 LIMIT 5 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856333 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856333 ORDER BY `unit` DESC [ RunTime:0.012839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856333 LIMIT 2 [ RunTime:0.003068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856333 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856293 LIMIT 5 [ RunTime:0.000961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856293 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856293 ORDER BY `unit` DESC [ RunTime:0.019046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856293 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856293 ORDER BY `minOrder` ASC [ RunTime:0.002704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856283 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856283 ORDER BY `minOrder` ASC [ RunTime:0.005631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856283 ORDER BY `unit` DESC [ RunTime:0.002271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856283 LIMIT 2 [ RunTime:0.002733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856283 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856217 LIMIT 5 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856217 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856217 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856217 LIMIT 2 [ RunTime:0.006129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856217 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856212 LIMIT 5 [ RunTime:0.003327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856212 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856212 ORDER BY `unit` DESC [ RunTime:0.000888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856212 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856212 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025566 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025566 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025566 ORDER BY `unit` DESC [ RunTime:0.002133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025566 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025566 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025328 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025328 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025328 ORDER BY `unit` DESC [ RunTime:0.005119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025328 LIMIT 2 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025328 ORDER BY `minOrder` ASC [ RunTime:0.002946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240473 LIMIT 5 [ RunTime:0.001779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240473 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240473 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240473 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240473 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001470s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471873 LIMIT 5 [ RunTime:0.002223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471873 ORDER BY `minOrder` ASC [ RunTime:0.015583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471873 ORDER BY `unit` DESC [ RunTime:0.008971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471873 LIMIT 2 [ RunTime:0.003302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471873 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002461s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001095s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471873 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.007520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240473 [ RunTime:0.006882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471728 LIMIT 5 [ RunTime:0.005777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471728 ORDER BY `minOrder` ASC [ RunTime:0.003598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471728 ORDER BY `unit` DESC [ RunTime:0.004890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471728 LIMIT 2 [ RunTime:0.001863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471728 ORDER BY `minOrder` ASC [ RunTime:0.005081s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000926s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471728 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857439 [ RunTime:0.003126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470266 LIMIT 5 [ RunTime:0.003128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470266 ORDER BY `minOrder` ASC [ RunTime:0.008552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470266 ORDER BY `unit` DESC [ RunTime:0.003335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470266 LIMIT 2 [ RunTime:0.011110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470266 ORDER BY `minOrder` ASC [ RunTime:0.010200s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008915s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470266 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.022914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856706 [ RunTime:0.013847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470228 LIMIT 5 [ RunTime:0.004999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470228 ORDER BY `minOrder` ASC [ RunTime:0.013760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470228 ORDER BY `unit` DESC [ RunTime:0.001712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470228 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470228 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014624s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470228 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.025763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025328 [ RunTime:0.009789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085229 LIMIT 5 [ RunTime:0.034171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085229 ORDER BY `minOrder` ASC [ RunTime:0.026416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085229 ORDER BY `unit` DESC [ RunTime:0.046430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085229 LIMIT 2 [ RunTime:0.014655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085229 ORDER BY `minOrder` ASC [ RunTime:0.011662s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.027157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022222s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085229 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856942 [ RunTime:0.004591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085216 LIMIT 5 [ RunTime:0.014522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085216 ORDER BY `minOrder` ASC [ RunTime:0.020211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085216 ORDER BY `unit` DESC [ RunTime:0.003118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085216 LIMIT 2 [ RunTime:0.008460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085216 ORDER BY `minOrder` ASC [ RunTime:0.010661s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016133s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085216 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.014683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856931 [ RunTime:0.005093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084443 LIMIT 5 [ RunTime:0.016353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084443 ORDER BY `minOrder` ASC [ RunTime:0.031547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084443 ORDER BY `unit` DESC [ RunTime:0.012897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084443 LIMIT 2 [ RunTime:0.009788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084443 ORDER BY `minOrder` ASC [ RunTime:0.010917s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.011068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012333s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084443 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856333 [ RunTime:0.013806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084281 LIMIT 5 [ RunTime:0.006825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084281 ORDER BY `minOrder` ASC [ RunTime:0.023191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084281 ORDER BY `unit` DESC [ RunTime:0.014751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084281 LIMIT 2 [ RunTime:0.011453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084281 ORDER BY `minOrder` ASC [ RunTime:0.010324s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.012474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009897s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084281 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856293 [ RunTime:0.017521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084265 LIMIT 5 [ RunTime:0.005171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084265 ORDER BY `minOrder` ASC [ RunTime:0.019556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084265 ORDER BY `unit` DESC [ RunTime:0.020087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084265 LIMIT 2 [ RunTime:0.014188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084265 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013226s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084265 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.019123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856283 [ RunTime:0.007765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084156 LIMIT 5 [ RunTime:0.008840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084156 ORDER BY `minOrder` ASC [ RunTime:0.011249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084156 ORDER BY `unit` DESC [ RunTime:0.014933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084156 LIMIT 2 [ RunTime:0.016594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084156 ORDER BY `minOrder` ASC [ RunTime:0.002998s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003420s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084156 AND `partno` = '40-901-6000-psi/kg/cm2-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856217 [ RunTime:0.011318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084151 LIMIT 5 [ RunTime:0.004983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084151 ORDER BY `minOrder` ASC [ RunTime:0.008454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084151 ORDER BY `unit` DESC [ RunTime:0.017205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084151 LIMIT 2 [ RunTime:0.005215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084151 ORDER BY `minOrder` ASC [ RunTime:0.004711s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009096s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084151 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856212 [ RunTime:0.002072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472935 LIMIT 5 [ RunTime:0.009657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472935 ORDER BY `minOrder` ASC [ RunTime:0.023205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472935 ORDER BY `unit` DESC [ RunTime:0.003193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472935 LIMIT 2 [ RunTime:0.018226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472935 ORDER BY `minOrder` ASC [ RunTime:0.005635s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.018492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023367s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472935 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.037494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025566 [ RunTime:0.018196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470942 LIMIT 5 [ RunTime:0.025658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470942 ORDER BY `minOrder` ASC [ RunTime:0.000971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470942 ORDER BY `unit` DESC [ RunTime:0.001026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470942 LIMIT 2 [ RunTime:0.001837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470942 ORDER BY `minOrder` ASC [ RunTime:0.009425s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008152s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470942 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857000 [ RunTime:0.000702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470911 LIMIT 5 [ RunTime:0.010687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470911 ORDER BY `minOrder` ASC [ RunTime:0.020433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470911 ORDER BY `unit` DESC [ RunTime:0.004667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470911 LIMIT 2 [ RunTime:0.012742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470911 ORDER BY `minOrder` ASC [ RunTime:0.009403s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016638s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470911 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856987 [ RunTime:0.014020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086865 LIMIT 5 [ RunTime:0.011671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086865 ORDER BY `minOrder` ASC [ RunTime:0.021643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086865 ORDER BY `unit` DESC [ RunTime:0.004135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086865 LIMIT 2 [ RunTime:0.014031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086865 ORDER BY `minOrder` ASC [ RunTime:0.014570s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017271s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086865 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.021885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857910 [ RunTime:0.005833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086825 LIMIT 5 [ RunTime:0.002617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086825 ORDER BY `minOrder` ASC [ RunTime:0.067396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086825 ORDER BY `unit` DESC [ RunTime:0.035662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086825 LIMIT 2 [ RunTime:0.030461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086825 ORDER BY `minOrder` ASC [ RunTime:0.013346s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.039319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033279s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086825 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.018129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857879 [ RunTime:0.030850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084982 LIMIT 5 [ RunTime:0.046601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084982 ORDER BY `minOrder` ASC [ RunTime:0.045346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084982 ORDER BY `unit` DESC [ RunTime:0.037172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084982 LIMIT 2 [ RunTime:0.031121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084982 ORDER BY `minOrder` ASC [ RunTime:0.030391s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.017850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027030s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084982 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.029216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856830 [ RunTime:0.044494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084972 LIMIT 5 [ RunTime:0.019771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084972 ORDER BY `minOrder` ASC [ RunTime:0.025044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084972 ORDER BY `unit` DESC [ RunTime:0.044174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084972 LIMIT 2 [ RunTime:0.039055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084972 ORDER BY `minOrder` ASC [ RunTime:0.003452s ]
select * from pdf where partno='40-901-6000-psi/kg/cm2-1/2-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.020784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004500s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084972 AND `partno` = '40-901-6000-psi/kg/cm2-1/2-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.018118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856821 [ RunTime:0.028394s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010816s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008105s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009758s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008227s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002532s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016848s ]
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-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016110s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-6000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-6000-psi/kg/cm2-1/2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001069s ]