SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002271s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.25' , `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=1315&search=1' [ RunTime:0.003569s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001467s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001124s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001940s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.25' ) [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001077s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001999s ]
SELECT * FROM `stock_search` WHERE `partno` = '1315' LIMIT 1 [ RunTime:0.001393s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-10-23 19:07:47' WHERE `partno` = '1315' [ RunTime:0.003685s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001156s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010928s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044695 LIMIT 5 [ RunTime:0.002222s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044695 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044695 ORDER BY `unit` DESC [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044695 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044695 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866635 LIMIT 5 [ RunTime:0.002831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866635 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18866635 ORDER BY `unit` DESC [ RunTime:0.000273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18866635 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866635 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234706 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234706 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16234706 ORDER BY `unit` DESC [ RunTime:0.000216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16234706 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234706 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828665 LIMIT 5 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828665 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828665 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828665 LIMIT 2 [ RunTime:0.000251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828665 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828664 LIMIT 5 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828664 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828664 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828664 LIMIT 2 [ RunTime:0.000206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828664 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536831 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536831 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536831 ORDER BY `unit` DESC [ RunTime:0.000253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536831 LIMIT 2 [ RunTime:0.000239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536831 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234440 LIMIT 5 [ RunTime:0.002561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234440 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234440 ORDER BY `unit` DESC [ RunTime:0.000210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234440 LIMIT 2 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234440 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828652 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828652 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828652 ORDER BY `unit` DESC [ RunTime:0.000215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828652 LIMIT 2 [ RunTime:0.000214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828652 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828654 LIMIT 5 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828654 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828654 ORDER BY `unit` DESC [ RunTime:0.000210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828654 LIMIT 2 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828654 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17019790 LIMIT 5 [ RunTime:0.002779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17019790 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17019790 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17019790 LIMIT 2 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17019790 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234436 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234436 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234436 ORDER BY `unit` DESC [ RunTime:0.000211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234436 LIMIT 2 [ RunTime:0.000211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234436 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716321 LIMIT 5 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716321 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18716321 ORDER BY `unit` DESC [ RunTime:0.000220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18716321 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716321 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687377 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687377 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687377 ORDER BY `unit` DESC [ RunTime:0.000210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687377 LIMIT 2 [ RunTime:0.000216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687377 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687316 LIMIT 5 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687316 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687316 ORDER BY `unit` DESC [ RunTime:0.000207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687316 LIMIT 2 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687316 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828698 LIMIT 5 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828698 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828698 ORDER BY `unit` DESC [ RunTime:0.000217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828698 LIMIT 2 [ RunTime:0.000211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828698 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687313 LIMIT 5 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687313 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687313 ORDER BY `unit` DESC [ RunTime:0.000223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687313 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687313 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687343 LIMIT 5 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687343 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687343 ORDER BY `unit` DESC [ RunTime:0.000223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687343 LIMIT 2 [ RunTime:0.000207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687343 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828693 LIMIT 5 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828693 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828693 ORDER BY `unit` DESC [ RunTime:0.000253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828693 LIMIT 2 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828693 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687319 LIMIT 5 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687319 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687319 ORDER BY `unit` DESC [ RunTime:0.000257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687319 LIMIT 2 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687319 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687317 LIMIT 5 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687317 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687317 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687317 LIMIT 2 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687317 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651614 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651614 ORDER BY `minOrder` ASC [ RunTime:0.002077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651614 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651614 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651614 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='1315200000' and brandshort='weidmuller' limit 1 [ RunTime:0.000810s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315200000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651614 AND `partno` = '1315200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234436 [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820303 LIMIT 5 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820303 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820303 ORDER BY `unit` DESC [ RunTime:0.000355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820303 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820303 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='131567' and brandshort='wakefield thermal' limit 1 [ RunTime:0.000790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131567' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.000533s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820303 AND `partno` = '131567' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.000541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65330010 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820392 LIMIT 5 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820392 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820392 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820392 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820392 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='131565' and brandshort='wakefield thermal' limit 1 [ RunTime:0.000711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131565' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.000508s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820392 AND `partno` = '131565' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65329990 [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820393 LIMIT 5 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820393 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820393 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820393 LIMIT 2 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820393 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='131566' and brandshort='wakefield thermal' limit 1 [ RunTime:0.000726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131566' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.000506s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820393 AND `partno` = '131566' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65330094 [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71667292 LIMIT 5 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71667292 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71667292 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71667292 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71667292 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='13154' and brandshort='aim solder' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13154' OR `brand` LIKE 'aim solder%' ) ) LIMIT 1 [ RunTime:0.000662s ]
SELECT `id` FROM `stock` WHERE `id` <> 71667292 AND `partno` = '13154' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aim solder%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71667556 LIMIT 5 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71667556 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71667556 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71667556 LIMIT 2 [ RunTime:0.000227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71667556 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='13158' and brandshort='aim solder' limit 1 [ RunTime:0.000396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13158' OR `brand` LIKE 'aim solder%' ) ) LIMIT 1 [ RunTime:0.000367s ]
SELECT `id` FROM `stock` WHERE `id` <> 71667556 AND `partno` = '13158' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aim solder%' ) [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651615 LIMIT 5 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651615 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651615 ORDER BY `unit` DESC [ RunTime:0.000260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651615 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651615 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='1315620000' and brandshort='weidmuller' limit 1 [ RunTime:0.000337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315620000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000631s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651615 AND `partno` = '1315620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828697 [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651790 LIMIT 5 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651790 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651790 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651790 LIMIT 2 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651790 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='1315240000' and brandshort='weidmuller' limit 1 [ RunTime:0.000502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315240000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000634s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651790 AND `partno` = '1315240000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828652 [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173753 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173753 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32173753 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32173753 LIMIT 2 [ RunTime:0.000257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173753 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1315550000' and brandshort='weidmuller' limit 1 [ RunTime:0.000375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315550000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000635s ]
SELECT `id` FROM `stock` WHERE `id` <> 32173753 AND `partno` = '1315550000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828694 [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651791 LIMIT 5 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651791 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651791 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651791 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651791 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1315250000' and brandshort='weidmuller' limit 1 [ RunTime:0.000341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315250000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000634s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651791 AND `partno` = '1315250000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828693 [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651789 LIMIT 5 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651789 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651789 ORDER BY `unit` DESC [ RunTime:0.000263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651789 LIMIT 2 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651789 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='1315230000' and brandshort='weidmuller' limit 1 [ RunTime:0.000330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315230000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000620s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651789 AND `partno` = '1315230000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828665 [ RunTime:0.000265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651792 LIMIT 5 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651792 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651792 ORDER BY `unit` DESC [ RunTime:0.000264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651792 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651792 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1315350000' and brandshort='weidmuller' limit 1 [ RunTime:0.000471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315350000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000626s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651792 AND `partno` = '1315350000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17019791 [ RunTime:0.000280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651798 LIMIT 5 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651798 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651798 ORDER BY `unit` DESC [ RunTime:0.000260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651798 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651798 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
select * from pdf where partno='1315710000' and brandshort='weidmuller' limit 1 [ RunTime:0.000347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315710000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000624s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651798 AND `partno` = '1315710000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234446 [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651796 LIMIT 5 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651796 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651796 ORDER BY `unit` DESC [ RunTime:0.000288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651796 LIMIT 2 [ RunTime:0.000240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651796 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='1315680000' and brandshort='weidmuller' limit 1 [ RunTime:0.000346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315680000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000591s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651796 AND `partno` = '1315680000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828698 [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651282 LIMIT 5 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651282 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651282 ORDER BY `unit` DESC [ RunTime:0.000261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651282 LIMIT 2 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651282 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='1315700000' and brandshort='weidmuller' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315700000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000833s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651282 AND `partno` = '1315700000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17019790 [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651793 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651793 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651793 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651793 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651793 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='1315390000' and brandshort='weidmuller' limit 1 [ RunTime:0.000544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315390000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000901s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651793 AND `partno` = '1315390000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828664 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820331 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820331 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820331 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820331 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820331 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='131569' and brandshort='wakefield thermal' limit 1 [ RunTime:0.000576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131569' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.000515s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820331 AND `partno` = '131569' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65329975 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651797 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651797 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651797 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651797 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651797 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='1315690000' and brandshort='weidmuller' limit 1 [ RunTime:0.000601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315690000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.001041s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651797 AND `partno` = '1315690000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828712 [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71651794 LIMIT 5 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651794 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71651794 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71651794 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71651794 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='1315440000' and brandshort='weidmuller' limit 1 [ RunTime:0.000509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315440000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000910s ]
SELECT `id` FROM `stock` WHERE `id` <> 71651794 AND `partno` = '1315440000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838835 [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820330 LIMIT 5 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820330 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820330 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820330 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820330 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='131568' and brandshort='wakefield thermal' limit 1 [ RunTime:0.000489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131568' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820330 AND `partno` = '131568' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65330009 [ RunTime:0.000311s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64984043 LIMIT 5 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64984043 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64984043 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64984043 LIMIT 2 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64984043 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='1315050930002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315050930002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000395s ]
SELECT `id` FROM `stock` WHERE `id` <> 64984043 AND `partno` = '1315050930002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044695 [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64984055 LIMIT 5 [ RunTime:0.000271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64984055 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64984055 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64984055 LIMIT 2 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64984055 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='1315050930246' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315050930246' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000352s ]
SELECT `id` FROM `stock` WHERE `id` <> 64984055 AND `partno` = '1315050930246' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70886267 LIMIT 5 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70886267 ORDER BY `minOrder` ASC [ RunTime:0.003057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70886267 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70886267 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70886267 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='131520-000' and brandshort='WEC' limit 1 [ RunTime:0.000458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131520-000' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.003915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66344114 LIMIT 5 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66344114 ORDER BY `minOrder` ASC [ RunTime:0.001532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66344114 ORDER BY `unit` DESC [ RunTime:0.000275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66344114 LIMIT 2 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66344114 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='1315850000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315850000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000719s ]
SELECT `id` FROM `stock` WHERE `id` <> 66344114 AND `partno` = '1315850000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234706 [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70886251 LIMIT 5 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70886251 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70886251 ORDER BY `unit` DESC [ RunTime:0.000271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70886251 LIMIT 2 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70886251 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='131520-000' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131520-000' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000355s ]
SELECT `id` FROM `stock` WHERE `id` <> 70886251 AND `partno` = '131520-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866635 [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67798958 LIMIT 5 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67798958 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67798958 ORDER BY `unit` DESC [ RunTime:0.000270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67798958 LIMIT 2 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67798958 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='1315870000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315870000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000718s ]
SELECT `id` FROM `stock` WHERE `id` <> 67798958 AND `partno` = '1315870000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838332 LIMIT 5 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838332 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838332 ORDER BY `unit` DESC [ RunTime:0.000275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838332 LIMIT 2 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838332 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
select * from pdf where partno='1315230000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315230000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838332 AND `partno` = '1315230000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828665 [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838333 LIMIT 5 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838333 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838333 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838333 LIMIT 2 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838333 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='1315390000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315390000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000756s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838333 AND `partno` = '1315390000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828664 [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838311 LIMIT 5 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838311 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838311 ORDER BY `unit` DESC [ RunTime:0.000268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838311 LIMIT 2 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838311 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='1315180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000722s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838311 AND `partno` = '1315180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234440 [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838331 LIMIT 5 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838331 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838331 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838331 LIMIT 2 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838331 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='1315240000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315240000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000908s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838331 AND `partno` = '1315240000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828652 [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838297 LIMIT 5 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838297 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838297 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838297 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838297 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='1315200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001366s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838297 AND `partno` = '1315200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234436 [ RunTime:0.000567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65329990 LIMIT 5 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65329990 ORDER BY `minOrder` ASC [ RunTime:0.001056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65329990 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65329990 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65329990 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='131565' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.000708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131565' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.000656s ]
SELECT `id` FROM `stock` WHERE `id` <> 65329990 AND `partno` = '131565' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.000688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838335 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838335 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838335 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838335 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838335 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='1315750000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315750000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001300s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838335 AND `partno` = '1315750000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828654 [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838317 LIMIT 5 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838317 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838317 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838317 LIMIT 2 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838317 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='1315700000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315700000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001333s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838317 AND `partno` = '1315700000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17019790 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67277054 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67277054 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67277054 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67277054 LIMIT 2 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67277054 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='1315243' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315243' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838299 LIMIT 5 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838299 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838299 ORDER BY `unit` DESC [ RunTime:0.000516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838299 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838299 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='1315250000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315250000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001289s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838299 AND `partno` = '1315250000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828693 [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65329975 LIMIT 5 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65329975 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65329975 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65329975 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65329975 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='131569' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.000753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131569' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.000643s ]
SELECT `id` FROM `stock` WHERE `id` <> 65329975 AND `partno` = '131569' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838314 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838314 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838314 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838314 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838314 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
select * from pdf where partno='1315620000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315620000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001322s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838314 AND `partno` = '1315620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828697 [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70838391 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838391 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70838391 ORDER BY `unit` DESC [ RunTime:0.000539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70838391 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70838391 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='1315680000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1315680000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001315s ]
SELECT `id` FROM `stock` WHERE `id` <> 70838391 AND `partno` = '1315680000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828698 [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65330014 LIMIT 5 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65330014 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65330014 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65330014 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65330014 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
select * from pdf where partno='131570' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.000848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131570' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.000677s ]
SELECT `id` FROM `stock` WHERE `id` <> 65330014 AND `partno` = '131570' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.000889s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001214s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001057s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001059s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001048s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001025s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001042s ]
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 '1315%' OR `brand` LIKE '1315%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001092s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1315%' OR `brand` LIKE '1315%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002273s ]