SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001543s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=25-901-250-bar%2Fpsi-G1%2F4&search=1' [ RunTime:0.001756s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002718s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002618s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003019s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.002384s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002498s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002764s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002457s ]
SELECT * FROM `stock_search` WHERE `partno` = '25-901-250-bar/psi-G1/4' LIMIT 1 [ RunTime:0.006814s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 16:11:48' WHERE `partno` = '25-901-250-bar/psi-G1/4' [ RunTime:0.014484s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002428s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007504s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860399 LIMIT 5 [ RunTime:0.006399s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860399 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860399 ORDER BY `unit` DESC [ RunTime:0.002579s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860399 LIMIT 2 [ RunTime:0.005120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860399 ORDER BY `minOrder` ASC [ RunTime:0.001211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860351 LIMIT 5 [ RunTime:0.012332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860351 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860351 ORDER BY `unit` DESC [ RunTime:0.001196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860351 LIMIT 2 [ RunTime:0.010600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860351 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860285 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860285 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860285 ORDER BY `unit` DESC [ RunTime:0.002670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860285 LIMIT 2 [ RunTime:0.004506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860285 ORDER BY `minOrder` ASC [ RunTime:0.003572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859769 LIMIT 5 [ RunTime:0.002173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859769 ORDER BY `minOrder` ASC [ RunTime:0.001123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859769 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859769 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859769 ORDER BY `minOrder` ASC [ RunTime:0.010641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858886 LIMIT 5 [ RunTime:0.003555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858886 ORDER BY `minOrder` ASC [ RunTime:0.007555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858886 ORDER BY `unit` DESC [ RunTime:0.003069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858886 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858886 ORDER BY `minOrder` ASC [ RunTime:0.003984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858861 LIMIT 5 [ RunTime:0.010574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858861 ORDER BY `minOrder` ASC [ RunTime:0.018030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858861 ORDER BY `unit` DESC [ RunTime:0.014989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858861 LIMIT 2 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858861 ORDER BY `minOrder` ASC [ RunTime:0.001108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858722 LIMIT 5 [ RunTime:0.004343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858722 ORDER BY `minOrder` ASC [ RunTime:0.003369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858722 ORDER BY `unit` DESC [ RunTime:0.024116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858722 LIMIT 2 [ RunTime:0.012983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858722 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858686 LIMIT 5 [ RunTime:0.000939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858686 ORDER BY `minOrder` ASC [ RunTime:0.007230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858686 ORDER BY `unit` DESC [ RunTime:0.009659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858686 LIMIT 2 [ RunTime:0.021991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858686 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858678 LIMIT 5 [ RunTime:0.007114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858678 ORDER BY `minOrder` ASC [ RunTime:0.013796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858678 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858678 LIMIT 2 [ RunTime:0.009993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858678 ORDER BY `minOrder` ASC [ RunTime:0.005386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858674 LIMIT 5 [ RunTime:0.008272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858674 ORDER BY `minOrder` ASC [ RunTime:0.011275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858674 ORDER BY `unit` DESC [ RunTime:0.000824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858674 LIMIT 2 [ RunTime:0.003447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858674 ORDER BY `minOrder` ASC [ RunTime:0.008002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858640 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858640 ORDER BY `minOrder` ASC [ RunTime:0.007833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858640 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858640 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858640 ORDER BY `minOrder` ASC [ RunTime:0.006290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026010 LIMIT 5 [ RunTime:0.009540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026010 ORDER BY `minOrder` ASC [ RunTime:0.006703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026010 ORDER BY `unit` DESC [ RunTime:0.006053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026010 LIMIT 2 [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026010 ORDER BY `minOrder` ASC [ RunTime:0.008977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026005 LIMIT 5 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026005 ORDER BY `minOrder` ASC [ RunTime:0.010106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026005 ORDER BY `unit` DESC [ RunTime:0.021693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026005 LIMIT 2 [ RunTime:0.021586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026005 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025788 LIMIT 5 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025788 ORDER BY `minOrder` ASC [ RunTime:0.003596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025788 ORDER BY `unit` DESC [ RunTime:0.003983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025788 LIMIT 2 [ RunTime:0.005400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025788 ORDER BY `minOrder` ASC [ RunTime:0.003781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025679 LIMIT 5 [ RunTime:0.005780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025679 ORDER BY `minOrder` ASC [ RunTime:0.008267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025679 ORDER BY `unit` DESC [ RunTime:0.018307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025679 LIMIT 2 [ RunTime:0.006564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025679 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15241004 LIMIT 5 [ RunTime:0.014778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15241004 ORDER BY `minOrder` ASC [ RunTime:0.002147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15241004 ORDER BY `unit` DESC [ RunTime:0.006738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15241004 LIMIT 2 [ RunTime:0.004249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15241004 ORDER BY `minOrder` ASC [ RunTime:0.002528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860733 LIMIT 5 [ RunTime:0.016732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860733 ORDER BY `minOrder` ASC [ RunTime:0.003035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860733 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860733 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860733 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859415 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859415 ORDER BY `minOrder` ASC [ RunTime:0.004818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859415 ORDER BY `unit` DESC [ RunTime:0.013378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859415 LIMIT 2 [ RunTime:0.016021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859415 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025801 LIMIT 5 [ RunTime:0.007352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025801 ORDER BY `minOrder` ASC [ RunTime:0.011522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025801 ORDER BY `unit` DESC [ RunTime:0.002621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025801 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025801 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001464s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086720 LIMIT 5 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086720 ORDER BY `minOrder` ASC [ RunTime:0.014093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086720 ORDER BY `unit` DESC [ RunTime:0.004574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086720 LIMIT 2 [ RunTime:0.009868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086720 ORDER BY `minOrder` ASC [ RunTime:0.009196s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002422s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001597s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086720 AND `partno` = '25-901-250-bar/psi-G1/4-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026010 [ RunTime:0.003790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086655 LIMIT 5 [ RunTime:0.001672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086655 ORDER BY `minOrder` ASC [ RunTime:0.005553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086655 ORDER BY `unit` DESC [ RunTime:0.013374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086655 LIMIT 2 [ RunTime:0.006597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086655 ORDER BY `minOrder` ASC [ RunTime:0.006192s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002302s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086655 AND `partno` = '25-901-250-bar/psi-G1/4-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026005 [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086397 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086397 ORDER BY `minOrder` ASC [ RunTime:0.020842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086397 ORDER BY `unit` DESC [ RunTime:0.012776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086397 LIMIT 2 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086397 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-GY40-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-GY40-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003356s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086397 AND `partno` = '25-901-250-bar/psi-G1/4-GY40-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860399 [ RunTime:0.002839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086250 LIMIT 5 [ RunTime:0.003201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086250 ORDER BY `minOrder` ASC [ RunTime:0.007194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086250 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086250 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086250 ORDER BY `minOrder` ASC [ RunTime:0.007763s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-GY40-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-GY40-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005952s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086250 AND `partno` = '25-901-250-bar/psi-G1/4-GY40-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15241004 [ RunTime:0.012533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086224 LIMIT 5 [ RunTime:0.010390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086224 ORDER BY `minOrder` ASC [ RunTime:0.009764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086224 ORDER BY `unit` DESC [ RunTime:0.009666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086224 LIMIT 2 [ RunTime:0.002574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086224 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.011846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009130s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086224 AND `partno` = '25-901-250-bar/psi-G1/4-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860351 [ RunTime:0.022490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086093 LIMIT 5 [ RunTime:0.006193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086093 ORDER BY `minOrder` ASC [ RunTime:0.013919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086093 ORDER BY `unit` DESC [ RunTime:0.013605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086093 LIMIT 2 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086093 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.022049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005071s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086093 AND `partno` = '25-901-250-bar/psi-G1/4-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.007192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860285 [ RunTime:0.003820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084004 LIMIT 5 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084004 ORDER BY `minOrder` ASC [ RunTime:0.006404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084004 ORDER BY `unit` DESC [ RunTime:0.026700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084004 LIMIT 2 [ RunTime:0.010712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084004 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013468s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084004 AND `partno` = '25-901-250-bar/psi-G1/4-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.015283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858861 [ RunTime:0.006144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083873 LIMIT 5 [ RunTime:0.003638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083873 ORDER BY `minOrder` ASC [ RunTime:0.011519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083873 ORDER BY `unit` DESC [ RunTime:0.003782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083873 LIMIT 2 [ RunTime:0.018749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083873 ORDER BY `minOrder` ASC [ RunTime:0.002116s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001047s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083873 AND `partno` = '25-901-250-bar/psi-G1/4-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025679 [ RunTime:0.001824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083565 LIMIT 5 [ RunTime:0.004361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083565 ORDER BY `minOrder` ASC [ RunTime:0.003055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083565 ORDER BY `unit` DESC [ RunTime:0.007377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083565 LIMIT 2 [ RunTime:0.009507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083565 ORDER BY `minOrder` ASC [ RunTime:0.003219s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-GY40-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-GY40-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007216s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083565 AND `partno` = '25-901-250-bar/psi-G1/4-GY40-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858722 [ RunTime:0.005540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083403 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083403 ORDER BY `minOrder` ASC [ RunTime:0.023918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083403 ORDER BY `unit` DESC [ RunTime:0.012165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083403 LIMIT 2 [ RunTime:0.008023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083403 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003312s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083403 AND `partno` = '25-901-250-bar/psi-G1/4-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858686 [ RunTime:0.006715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083376 LIMIT 5 [ RunTime:0.017628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083376 ORDER BY `minOrder` ASC [ RunTime:0.002626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083376 ORDER BY `unit` DESC [ RunTime:0.001974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083376 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083376 ORDER BY `minOrder` ASC [ RunTime:0.003709s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-BT3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-BT3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.045910s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083376 AND `partno` = '25-901-250-bar/psi-G1/4-BT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.034920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858678 [ RunTime:0.002480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083362 LIMIT 5 [ RunTime:0.003228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083362 ORDER BY `minOrder` ASC [ RunTime:0.017714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083362 ORDER BY `unit` DESC [ RunTime:0.000825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083362 LIMIT 2 [ RunTime:0.006268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083362 ORDER BY `minOrder` ASC [ RunTime:0.006598s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011807s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083362 AND `partno` = '25-901-250-bar/psi-G1/4-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858674 [ RunTime:0.000750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083215 LIMIT 5 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083215 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083215 ORDER BY `unit` DESC [ RunTime:0.002726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083215 LIMIT 2 [ RunTime:0.005638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083215 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.012231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013063s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083215 AND `partno` = '25-901-250-bar/psi-G1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.018302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858640 [ RunTime:0.001752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085194 LIMIT 5 [ RunTime:0.004086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085194 ORDER BY `minOrder` ASC [ RunTime:0.002312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085194 ORDER BY `unit` DESC [ RunTime:0.015597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085194 LIMIT 2 [ RunTime:0.028092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085194 ORDER BY `minOrder` ASC [ RunTime:0.009398s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-DRY-RCP-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-DRY-RCP-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012703s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085194 AND `partno` = '25-901-250-bar/psi-G1/4-DRY-RCP-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859769 [ RunTime:0.004203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084718 LIMIT 5 [ RunTime:0.011762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084718 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084718 ORDER BY `unit` DESC [ RunTime:0.001065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084718 LIMIT 2 [ RunTime:0.003484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084718 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-DRY-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-DRY-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005557s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084718 AND `partno` = '25-901-250-bar/psi-G1/4-DRY-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025788 [ RunTime:0.003575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084082 LIMIT 5 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084082 ORDER BY `minOrder` ASC [ RunTime:0.002318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084082 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084082 LIMIT 2 [ RunTime:0.003543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084082 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005207s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084082 AND `partno` = '25-901-250-bar/psi-G1/4-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858886 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57279242 LIMIT 5 [ RunTime:0.001537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279242 ORDER BY `minOrder` ASC [ RunTime:0.009393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57279242 ORDER BY `unit` DESC [ RunTime:0.002217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57279242 LIMIT 2 [ RunTime:0.003519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279242 ORDER BY `minOrder` ASC [ RunTime:0.006151s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014291s ]
SELECT `id` FROM `stock` WHERE `id` <> 57279242 AND `partno` = '25-901-250-bar/psi-G1/4-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860733 [ RunTime:0.006697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276930 LIMIT 5 [ RunTime:0.013542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276930 ORDER BY `minOrder` ASC [ RunTime:0.003245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276930 ORDER BY `unit` DESC [ RunTime:0.008199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276930 LIMIT 2 [ RunTime:0.012927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276930 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002975s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276930 AND `partno` = '25-901-250-bar/psi-G1/4-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859415 [ RunTime:0.003846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276925 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276925 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276925 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276925 LIMIT 2 [ RunTime:0.014245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276925 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
select * from pdf where partno='25-901-250-bar/psi-G1/4-SP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-250-bar/psi-G1/4-SP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004645s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276925 AND `partno` = '25-901-250-bar/psi-G1/4-SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.017576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025801 [ RunTime:0.004086s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006648s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012355s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004599s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002548s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005818s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018904s ]
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-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011603s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-901-250-bar/psi-G1/4%' OR `brand` LIKE '25-901-250-bar/psi-G1/4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018051s ]