SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001302s ]
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=15090&search=1' [ RunTime:0.008132s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001869s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001492s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002572s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.003275s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001646s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002677s ]
SELECT * FROM `stock_search` WHERE `partno` = '15090' LIMIT 1 [ RunTime:0.002443s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 16:14:41' WHERE `partno` = '15090' [ RunTime:0.001793s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002394s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015264s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671687 LIMIT 5 [ RunTime:0.010025s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671687 ORDER BY `minOrder` ASC [ RunTime:0.010553s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671687 ORDER BY `unit` DESC [ RunTime:0.012888s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671687 LIMIT 2 [ RunTime:0.002899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671687 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671677 LIMIT 5 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671677 ORDER BY `minOrder` ASC [ RunTime:0.001870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671677 ORDER BY `unit` DESC [ RunTime:0.001131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671677 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671677 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671598 LIMIT 5 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671598 ORDER BY `minOrder` ASC [ RunTime:0.018261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671598 ORDER BY `unit` DESC [ RunTime:0.005187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671598 LIMIT 2 [ RunTime:0.031896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671598 ORDER BY `minOrder` ASC [ RunTime:0.005221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671590 LIMIT 5 [ RunTime:0.002438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671590 ORDER BY `minOrder` ASC [ RunTime:0.023374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671590 ORDER BY `unit` DESC [ RunTime:0.009587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671590 LIMIT 2 [ RunTime:0.021372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671590 ORDER BY `minOrder` ASC [ RunTime:0.008568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671572 LIMIT 5 [ RunTime:0.004010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671572 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671572 ORDER BY `unit` DESC [ RunTime:0.009171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671572 LIMIT 2 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671572 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671546 LIMIT 5 [ RunTime:0.002574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671546 ORDER BY `minOrder` ASC [ RunTime:0.006902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671546 ORDER BY `unit` DESC [ RunTime:0.005365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671546 LIMIT 2 [ RunTime:0.035717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671546 ORDER BY `minOrder` ASC [ RunTime:0.005274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671545 LIMIT 5 [ RunTime:0.016581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671545 ORDER BY `minOrder` ASC [ RunTime:0.023537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671545 ORDER BY `unit` DESC [ RunTime:0.008904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671545 LIMIT 2 [ RunTime:0.025368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671545 ORDER BY `minOrder` ASC [ RunTime:0.008090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670270 LIMIT 5 [ RunTime:0.016684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670270 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19670270 ORDER BY `unit` DESC [ RunTime:0.014871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19670270 LIMIT 2 [ RunTime:0.005915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670270 ORDER BY `minOrder` ASC [ RunTime:0.008741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670269 LIMIT 5 [ RunTime:0.003034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670269 ORDER BY `minOrder` ASC [ RunTime:0.019702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19670269 ORDER BY `unit` DESC [ RunTime:0.020523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19670269 LIMIT 2 [ RunTime:0.006876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670269 ORDER BY `minOrder` ASC [ RunTime:0.002730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670111 LIMIT 5 [ RunTime:0.014425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670111 ORDER BY `minOrder` ASC [ RunTime:0.008957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19670111 ORDER BY `unit` DESC [ RunTime:0.008484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19670111 LIMIT 2 [ RunTime:0.022230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670111 ORDER BY `minOrder` ASC [ RunTime:0.008740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670107 LIMIT 5 [ RunTime:0.003768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670107 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19670107 ORDER BY `unit` DESC [ RunTime:0.009429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19670107 LIMIT 2 [ RunTime:0.042743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670107 ORDER BY `minOrder` ASC [ RunTime:0.005425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670037 LIMIT 5 [ RunTime:0.006491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670037 ORDER BY `minOrder` ASC [ RunTime:0.013029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19670037 ORDER BY `unit` DESC [ RunTime:0.001780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19670037 LIMIT 2 [ RunTime:0.005570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670037 ORDER BY `minOrder` ASC [ RunTime:0.003449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670026 LIMIT 5 [ RunTime:0.004025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670026 ORDER BY `minOrder` ASC [ RunTime:0.017485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19670026 ORDER BY `unit` DESC [ RunTime:0.019016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19670026 LIMIT 2 [ RunTime:0.018098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19670026 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669992 LIMIT 5 [ RunTime:0.021622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669992 ORDER BY `minOrder` ASC [ RunTime:0.017631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669992 ORDER BY `unit` DESC [ RunTime:0.003360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669992 LIMIT 2 [ RunTime:0.008072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669992 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669799 LIMIT 5 [ RunTime:0.009561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669799 ORDER BY `minOrder` ASC [ RunTime:0.006973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669799 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669799 LIMIT 2 [ RunTime:0.002285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669799 ORDER BY `minOrder` ASC [ RunTime:0.008916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669615 LIMIT 5 [ RunTime:0.005671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669615 ORDER BY `minOrder` ASC [ RunTime:0.002525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669615 ORDER BY `unit` DESC [ RunTime:0.005115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669615 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669615 ORDER BY `minOrder` ASC [ RunTime:0.003559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669445 LIMIT 5 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669445 ORDER BY `minOrder` ASC [ RunTime:0.003761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669445 ORDER BY `unit` DESC [ RunTime:0.000478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669445 LIMIT 2 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669445 ORDER BY `minOrder` ASC [ RunTime:0.001938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669444 LIMIT 5 [ RunTime:0.005899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669444 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669444 ORDER BY `unit` DESC [ RunTime:0.005452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669444 LIMIT 2 [ RunTime:0.006552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669444 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19020108 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020108 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19020108 ORDER BY `unit` DESC [ RunTime:0.004043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19020108 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020108 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19019837 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19019837 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19019837 ORDER BY `unit` DESC [ RunTime:0.001470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19019837 LIMIT 2 [ RunTime:0.006149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19019837 ORDER BY `minOrder` ASC [ RunTime:0.022787s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018704s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63452942 LIMIT 5 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63452942 ORDER BY `minOrder` ASC [ RunTime:0.007092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63452942 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63452942 LIMIT 2 [ RunTime:0.012929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63452942 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
select * from pdf where partno='15090001-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.005812s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090001-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000449s ]
SELECT `id` FROM `stock` WHERE `id` <> 63452942 AND `partno` = '15090001-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.003045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991527 [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63418684 LIMIT 5 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418684 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63418684 ORDER BY `unit` DESC [ RunTime:0.000979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63418684 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418684 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='1509010002-E' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.004335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509010002-E' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000472s ]
SELECT `id` FROM `stock` WHERE `id` <> 63418684 AND `partno` = '1509010002-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15273438 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63418661 LIMIT 5 [ RunTime:0.001843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418661 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63418661 ORDER BY `unit` DESC [ RunTime:0.016667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63418661 LIMIT 2 [ RunTime:0.012351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418661 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
select * from pdf where partno='1509010001-E' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509010001-E' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.005095s ]
SELECT `id` FROM `stock` WHERE `id` <> 63418661 AND `partno` = '1509010001-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.006407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14202702 [ RunTime:0.014730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63418656 LIMIT 5 [ RunTime:0.007549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418656 ORDER BY `minOrder` ASC [ RunTime:0.006821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63418656 ORDER BY `unit` DESC [ RunTime:0.006777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63418656 LIMIT 2 [ RunTime:0.010483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418656 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='1509010000-E' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509010000-E' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012761s ]
SELECT `id` FROM `stock` WHERE `id` <> 63418656 AND `partno` = '1509010000-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.004533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17056487 [ RunTime:0.013046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63418649 LIMIT 5 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418649 ORDER BY `minOrder` ASC [ RunTime:0.002197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63418649 ORDER BY `unit` DESC [ RunTime:0.034745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63418649 LIMIT 2 [ RunTime:0.030007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63418649 ORDER BY `minOrder` ASC [ RunTime:0.012802s ]
select * from pdf where partno='15090200-E' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.003640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090200-E' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.026314s ]
SELECT `id` FROM `stock` WHERE `id` <> 63418649 AND `partno` = '15090200-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.006079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17056483 [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63134501 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63134501 ORDER BY `minOrder` ASC [ RunTime:0.003237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63134501 ORDER BY `unit` DESC [ RunTime:0.011439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63134501 LIMIT 2 [ RunTime:0.008238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63134501 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
select * from pdf where partno='15090' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.011400s ]
SELECT `id` FROM `stock` WHERE `id` <> 63134501 AND `partno` = '15090' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.013228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60636201 LIMIT 5 [ RunTime:0.021277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636201 ORDER BY `minOrder` ASC [ RunTime:0.015333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60636201 ORDER BY `unit` DESC [ RunTime:0.005713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60636201 LIMIT 2 [ RunTime:0.014415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636201 ORDER BY `minOrder` ASC [ RunTime:0.006380s ]
select * from pdf where partno='1509010300-E' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.011051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509010300-E' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.006680s ]
SELECT `id` FROM `stock` WHERE `id` <> 60636201 AND `partno` = '1509010300-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.018985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669615 [ RunTime:0.006093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60635969 LIMIT 5 [ RunTime:0.010719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60635969 ORDER BY `minOrder` ASC [ RunTime:0.006014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60635969 ORDER BY `unit` DESC [ RunTime:0.002086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60635969 LIMIT 2 [ RunTime:0.007163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60635969 ORDER BY `minOrder` ASC [ RunTime:0.001664s ]
select * from pdf where partno='15090501-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.005737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090501-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000812s ]
SELECT `id` FROM `stock` WHERE `id` <> 60635969 AND `partno` = '15090501-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669445 [ RunTime:0.000714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60635968 LIMIT 5 [ RunTime:0.002972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60635968 ORDER BY `minOrder` ASC [ RunTime:0.002792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60635968 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60635968 LIMIT 2 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60635968 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
select * from pdf where partno='15090552-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.008237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090552-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.001913s ]
SELECT `id` FROM `stock` WHERE `id` <> 60635968 AND `partno` = '15090552-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454391 [ RunTime:0.000975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60635967 LIMIT 5 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60635967 ORDER BY `minOrder` ASC [ RunTime:0.003212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60635967 ORDER BY `unit` DESC [ RunTime:0.004707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60635967 LIMIT 2 [ RunTime:0.002707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60635967 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='15090502-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.002774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090502-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000885s ]
SELECT `id` FROM `stock` WHERE `id` <> 60635967 AND `partno` = '15090502-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669444 [ RunTime:0.003210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634652 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634652 ORDER BY `minOrder` ASC [ RunTime:0.001002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634652 ORDER BY `unit` DESC [ RunTime:0.001740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634652 LIMIT 2 [ RunTime:0.003894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634652 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='1509005A-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.000697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509005A-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003457s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634652 AND `partno` = '1509005A-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.001366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670270 [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634651 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634651 ORDER BY `minOrder` ASC [ RunTime:0.001652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634651 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634651 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634651 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='1509005B-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509005B-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003172s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634651 AND `partno` = '1509005B-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.003295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670269 [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634646 LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634646 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634646 ORDER BY `unit` DESC [ RunTime:0.005168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634646 LIMIT 2 [ RunTime:0.001808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634646 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='1509005C-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509005C-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003106s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634646 AND `partno` = '1509005C-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.002055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17314144 [ RunTime:0.003083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634432 LIMIT 5 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634432 ORDER BY `minOrder` ASC [ RunTime:0.005967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634432 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634432 LIMIT 2 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634432 ORDER BY `minOrder` ASC [ RunTime:0.001810s ]
select * from pdf where partno='15090059-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.002185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090059-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.011025s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634432 AND `partno` = '15090059-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670111 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634424 LIMIT 5 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634424 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634424 ORDER BY `unit` DESC [ RunTime:0.000755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634424 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634424 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='15090058-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.001353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090058-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.005082s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634424 AND `partno` = '15090058-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.009601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670107 [ RunTime:0.009588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634343 LIMIT 5 [ RunTime:0.005346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634343 ORDER BY `minOrder` ASC [ RunTime:0.008605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634343 ORDER BY `unit` DESC [ RunTime:0.006816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634343 LIMIT 2 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634343 ORDER BY `minOrder` ASC [ RunTime:0.007961s ]
select * from pdf where partno='1509007A-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.013191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1509007A-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000859s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634343 AND `partno` = '1509007A-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.011148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670037 [ RunTime:0.003109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634329 LIMIT 5 [ RunTime:0.001818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634329 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634329 ORDER BY `unit` DESC [ RunTime:0.002237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634329 LIMIT 2 [ RunTime:0.018076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634329 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
select * from pdf where partno='15090071-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.011042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090071-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.010689s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634329 AND `partno` = '15090071-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.002176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19670026 [ RunTime:0.001971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634273 LIMIT 5 [ RunTime:0.006133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634273 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634273 ORDER BY `unit` DESC [ RunTime:0.002416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634273 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634273 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
select * from pdf where partno='15090078-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.001703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090078-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000780s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634273 AND `partno` = '15090078-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669992 [ RunTime:0.002069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634272 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634272 ORDER BY `minOrder` ASC [ RunTime:0.002673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634272 ORDER BY `unit` DESC [ RunTime:0.004564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634272 LIMIT 2 [ RunTime:0.007519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634272 ORDER BY `minOrder` ASC [ RunTime:0.002630s ]
select * from pdf where partno='15090079-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.007700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15090079-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000712s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634272 AND `partno` = '15090079-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454469 [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60634067 LIMIT 5 [ RunTime:0.015618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634067 ORDER BY `minOrder` ASC [ RunTime:0.003807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60634067 ORDER BY `unit` DESC [ RunTime:0.003457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60634067 LIMIT 2 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60634067 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='150900D1-I' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.000796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150900D1-I' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000779s ]
SELECT `id` FROM `stock` WHERE `id` <> 60634067 AND `partno` = '150900D1-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.004851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671687 [ RunTime:0.005667s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001237s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008515s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005228s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003529s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001209s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009032s ]
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 '15090%' OR `brand` LIKE '15090%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003844s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15090%' OR `brand` LIKE '15090%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001364s ]