SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002276s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=TC62&search=1' [ RunTime:0.001808s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003400s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002494s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.001363s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002861s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004313s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002307s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TC62' LIMIT 1 [ RunTime:0.010451s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 10:00:16' WHERE `partno` = 'TC62' [ RunTime:0.019649s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003326s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011458s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19148193 LIMIT 5 [ RunTime:0.002830s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19148193 ORDER BY `minOrder` ASC [ RunTime:0.004827s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19148193 ORDER BY `unit` DESC [ RunTime:0.001129s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19148193 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19148193 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270545 LIMIT 5 [ RunTime:0.004219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270545 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270545 ORDER BY `unit` DESC [ RunTime:0.000263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270545 LIMIT 2 [ RunTime:0.019554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270545 ORDER BY `minOrder` ASC [ RunTime:0.009229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996936 LIMIT 5 [ RunTime:0.002562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996936 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996936 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996936 LIMIT 2 [ RunTime:0.001888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996936 ORDER BY `minOrder` ASC [ RunTime:0.012926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19149862 LIMIT 5 [ RunTime:0.009244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19149862 ORDER BY `minOrder` ASC [ RunTime:0.009090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19149862 ORDER BY `unit` DESC [ RunTime:0.002257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19149862 LIMIT 2 [ RunTime:0.001209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19149862 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19148011 LIMIT 5 [ RunTime:0.000962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19148011 ORDER BY `minOrder` ASC [ RunTime:0.000803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19148011 ORDER BY `unit` DESC [ RunTime:0.005715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19148011 LIMIT 2 [ RunTime:0.000846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19148011 ORDER BY `minOrder` ASC [ RunTime:0.011398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996951 LIMIT 5 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996951 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996951 ORDER BY `unit` DESC [ RunTime:0.009961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996951 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996951 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996923 LIMIT 5 [ RunTime:0.002873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996923 ORDER BY `minOrder` ASC [ RunTime:0.005530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996923 ORDER BY `unit` DESC [ RunTime:0.005649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996923 LIMIT 2 [ RunTime:0.009860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996923 ORDER BY `minOrder` ASC [ RunTime:0.005002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270555 LIMIT 5 [ RunTime:0.008095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270555 ORDER BY `minOrder` ASC [ RunTime:0.002713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270555 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270555 LIMIT 2 [ RunTime:0.010157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270555 ORDER BY `minOrder` ASC [ RunTime:0.012358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270567 LIMIT 5 [ RunTime:0.012897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270567 ORDER BY `minOrder` ASC [ RunTime:0.010287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270567 ORDER BY `unit` DESC [ RunTime:0.007668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270567 LIMIT 2 [ RunTime:0.009320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270567 ORDER BY `minOrder` ASC [ RunTime:0.009074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996934 LIMIT 5 [ RunTime:0.013262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996934 ORDER BY `minOrder` ASC [ RunTime:0.021626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996934 ORDER BY `unit` DESC [ RunTime:0.007296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996934 LIMIT 2 [ RunTime:0.034603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996934 ORDER BY `minOrder` ASC [ RunTime:0.010068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11997059 LIMIT 5 [ RunTime:0.007836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11997059 ORDER BY `minOrder` ASC [ RunTime:0.020198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11997059 ORDER BY `unit` DESC [ RunTime:0.018208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11997059 LIMIT 2 [ RunTime:0.040787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11997059 ORDER BY `minOrder` ASC [ RunTime:0.008772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11997003 LIMIT 5 [ RunTime:0.022481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11997003 ORDER BY `minOrder` ASC [ RunTime:0.023453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11997003 ORDER BY `unit` DESC [ RunTime:0.006684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11997003 LIMIT 2 [ RunTime:0.027606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11997003 ORDER BY `minOrder` ASC [ RunTime:0.007686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11997001 LIMIT 5 [ RunTime:0.003131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11997001 ORDER BY `minOrder` ASC [ RunTime:0.018239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11997001 ORDER BY `unit` DESC [ RunTime:0.025712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11997001 LIMIT 2 [ RunTime:0.006184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11997001 ORDER BY `minOrder` ASC [ RunTime:0.009926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270565 LIMIT 5 [ RunTime:0.026891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270565 ORDER BY `minOrder` ASC [ RunTime:0.006816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270565 ORDER BY `unit` DESC [ RunTime:0.000985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270565 LIMIT 2 [ RunTime:0.007745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270565 ORDER BY `minOrder` ASC [ RunTime:0.011804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996954 LIMIT 5 [ RunTime:0.019235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996954 ORDER BY `minOrder` ASC [ RunTime:0.011264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996954 ORDER BY `unit` DESC [ RunTime:0.024309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996954 LIMIT 2 [ RunTime:0.026954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996954 ORDER BY `minOrder` ASC [ RunTime:0.001309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11508 LIMIT 5 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11508 ORDER BY `minOrder` ASC [ RunTime:0.011707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11508 ORDER BY `unit` DESC [ RunTime:0.013970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11508 LIMIT 2 [ RunTime:0.007411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11508 ORDER BY `minOrder` ASC [ RunTime:0.008009s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC620CVOA' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.022618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996952 LIMIT 5 [ RunTime:0.003811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996952 ORDER BY `minOrder` ASC [ RunTime:0.015445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996952 ORDER BY `unit` DESC [ RunTime:0.041262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996952 LIMIT 2 [ RunTime:0.017506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996952 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996953 LIMIT 5 [ RunTime:0.010253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996953 ORDER BY `minOrder` ASC [ RunTime:0.021038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11996953 ORDER BY `unit` DESC [ RunTime:0.001357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11996953 LIMIT 2 [ RunTime:0.005942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11996953 ORDER BY `minOrder` ASC [ RunTime:0.003847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270566 LIMIT 5 [ RunTime:0.015643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270566 ORDER BY `minOrder` ASC [ RunTime:0.012287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270566 ORDER BY `unit` DESC [ RunTime:0.014066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270566 LIMIT 2 [ RunTime:0.019823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270566 ORDER BY `minOrder` ASC [ RunTime:0.019476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19150857 LIMIT 5 [ RunTime:0.008467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19150857 ORDER BY `minOrder` ASC [ RunTime:0.026038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19150857 ORDER BY `unit` DESC [ RunTime:0.012987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19150857 LIMIT 2 [ RunTime:0.032888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19150857 ORDER BY `minOrder` ASC [ RunTime:0.006210s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291272 LIMIT 5 [ RunTime:0.028036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291272 ORDER BY `minOrder` ASC [ RunTime:0.009928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291272 ORDER BY `unit` DESC [ RunTime:0.003438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291272 LIMIT 2 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291272 ORDER BY `minOrder` ASC [ RunTime:0.001406s ]
select * from pdf where partno='tc622vat' and brandshort='microchip technology' limit 1 [ RunTime:0.016357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc622vat' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.011143s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291272 AND `partno` = 'tc622vat' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.007392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270555 [ RunTime:0.010547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32248614 LIMIT 5 [ RunTime:0.037051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248614 ORDER BY `minOrder` ASC [ RunTime:0.044005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32248614 ORDER BY `unit` DESC [ RunTime:0.034623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32248614 LIMIT 2 [ RunTime:0.016486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248614 ORDER BY `minOrder` ASC [ RunTime:0.011316s ]
select * from pdf where partno='tc622vat' and brandshort='microchip technology' limit 1 [ RunTime:0.003762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc622vat' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.001585s ]
SELECT `id` FROM `stock` WHERE `id` <> 32248614 AND `partno` = 'tc622vat' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.024706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270555 [ RunTime:0.022930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291997 LIMIT 5 [ RunTime:0.039339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291997 ORDER BY `minOrder` ASC [ RunTime:0.016395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291997 ORDER BY `unit` DESC [ RunTime:0.006755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291997 LIMIT 2 [ RunTime:0.010918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291997 ORDER BY `minOrder` ASC [ RunTime:0.010054s ]
select * from pdf where partno='tc622eoa713' and brandshort='microchip technology' limit 1 [ RunTime:0.016461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc622eoa713' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.006436s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291997 AND `partno` = 'tc622eoa713' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.027308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996951 [ RunTime:0.034132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291340 LIMIT 5 [ RunTime:0.026922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291340 ORDER BY `minOrder` ASC [ RunTime:0.049703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291340 ORDER BY `unit` DESC [ RunTime:0.030889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291340 LIMIT 2 [ RunTime:0.011052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291340 ORDER BY `minOrder` ASC [ RunTime:0.003451s ]
select * from pdf where partno='tc620cvoa' and brandshort='microchip technology' limit 1 [ RunTime:0.016110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620cvoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.028195s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291340 AND `partno` = 'tc620cvoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.057075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270566 [ RunTime:0.020764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32248565 LIMIT 5 [ RunTime:0.011142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248565 ORDER BY `minOrder` ASC [ RunTime:0.025228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32248565 ORDER BY `unit` DESC [ RunTime:0.014156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32248565 LIMIT 2 [ RunTime:0.057933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248565 ORDER BY `minOrder` ASC [ RunTime:0.019305s ]
select * from pdf where partno='tc620cvoa' and brandshort='microchip technology' limit 1 [ RunTime:0.010376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620cvoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.004514s ]
SELECT `id` FROM `stock` WHERE `id` <> 32248565 AND `partno` = 'tc620cvoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.030698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270566 [ RunTime:0.013208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028413 LIMIT 5 [ RunTime:0.019743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028413 ORDER BY `minOrder` ASC [ RunTime:0.047430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51028413 ORDER BY `unit` DESC [ RunTime:0.032280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51028413 LIMIT 2 [ RunTime:0.042347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028413 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
select * from pdf where partno='tc6215tg-g' and brandshort='microchip technology' limit 1 [ RunTime:0.010466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc6215tg-g' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.027536s ]
SELECT `id` FROM `stock` WHERE `id` <> 51028413 AND `partno` = 'tc6215tg-g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.019961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58701433 [ RunTime:0.008522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291996 LIMIT 5 [ RunTime:0.007783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291996 ORDER BY `minOrder` ASC [ RunTime:0.013549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291996 ORDER BY `unit` DESC [ RunTime:0.023318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291996 LIMIT 2 [ RunTime:0.012670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291996 ORDER BY `minOrder` ASC [ RunTime:0.007707s ]
select * from pdf where partno='tc620cvoa713' and brandshort='microchip technology' limit 1 [ RunTime:0.012439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620cvoa713' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.027616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291996 AND `partno` = 'tc620cvoa713' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.012525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270545 [ RunTime:0.016976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51053567 LIMIT 5 [ RunTime:0.015472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51053567 ORDER BY `minOrder` ASC [ RunTime:0.021514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51053567 ORDER BY `unit` DESC [ RunTime:0.063900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51053567 LIMIT 2 [ RunTime:0.006012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51053567 ORDER BY `minOrder` ASC [ RunTime:0.005270s ]
select * from pdf where partno='tc62d722cfng,c,el' and brandshort='toshiba' limit 1 [ RunTime:0.042865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc62d722cfng,c,el' OR `brand` LIKE 'toshiba%' ) ) LIMIT 1 [ RunTime:0.052311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51067358 LIMIT 5 [ RunTime:0.031235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51067358 ORDER BY `minOrder` ASC [ RunTime:0.039417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51067358 ORDER BY `unit` DESC [ RunTime:0.046547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51067358 LIMIT 2 [ RunTime:0.018668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51067358 ORDER BY `minOrder` ASC [ RunTime:0.010989s ]
select * from pdf where partno='tc62d722cfng,c,el' and brandshort='toshiba' limit 1 [ RunTime:0.009757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc62d722cfng,c,el' OR `brand` LIKE 'toshiba%' ) ) LIMIT 1 [ RunTime:0.006389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291472 LIMIT 5 [ RunTime:0.023263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291472 ORDER BY `minOrder` ASC [ RunTime:0.015530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291472 ORDER BY `unit` DESC [ RunTime:0.014330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291472 LIMIT 2 [ RunTime:0.042432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291472 ORDER BY `minOrder` ASC [ RunTime:0.011260s ]
select * from pdf where partno='tc620ccoa' and brandshort='microchip technology' limit 1 [ RunTime:0.032041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620ccoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.007272s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291472 AND `partno` = 'tc620ccoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.019732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270835 [ RunTime:0.049128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32248942 LIMIT 5 [ RunTime:0.021974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248942 ORDER BY `minOrder` ASC [ RunTime:0.024016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32248942 ORDER BY `unit` DESC [ RunTime:0.039742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32248942 LIMIT 2 [ RunTime:0.053362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248942 ORDER BY `minOrder` ASC [ RunTime:0.013588s ]
select * from pdf where partno='tc620ccoa' and brandshort='microchip technology' limit 1 [ RunTime:0.006130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620ccoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.015306s ]
SELECT `id` FROM `stock` WHERE `id` <> 32248942 AND `partno` = 'tc620ccoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270835 [ RunTime:0.028933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292398 LIMIT 5 [ RunTime:0.024800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292398 ORDER BY `minOrder` ASC [ RunTime:0.046735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32292398 ORDER BY `unit` DESC [ RunTime:0.046557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32292398 LIMIT 2 [ RunTime:0.045251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292398 ORDER BY `minOrder` ASC [ RunTime:0.021206s ]
select * from pdf where partno='tc621ceoa' and brandshort='microchip technology' limit 1 [ RunTime:0.024721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc621ceoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.006776s ]
SELECT `id` FROM `stock` WHERE `id` <> 32292398 AND `partno` = 'tc621ceoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.038665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996936 [ RunTime:0.024375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291497 LIMIT 5 [ RunTime:0.013951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291497 ORDER BY `minOrder` ASC [ RunTime:0.020834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291497 ORDER BY `unit` DESC [ RunTime:0.041207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291497 LIMIT 2 [ RunTime:0.020949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291497 ORDER BY `minOrder` ASC [ RunTime:0.004519s ]
select * from pdf where partno='tc621ccoa' and brandshort='microchip technology' limit 1 [ RunTime:0.008470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc621ccoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.014069s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291497 AND `partno` = 'tc621ccoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.031148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32248979 [ RunTime:0.015553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351465 [ RunTime:0.032305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32248979 LIMIT 5 [ RunTime:0.024231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248979 ORDER BY `minOrder` ASC [ RunTime:0.009974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32248979 ORDER BY `unit` DESC [ RunTime:0.035520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32248979 LIMIT 2 [ RunTime:0.008864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32248979 ORDER BY `minOrder` ASC [ RunTime:0.008071s ]
select * from pdf where partno='tc621ccoa' and brandshort='microchip technology' limit 1 [ RunTime:0.009918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc621ccoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.010185s ]
SELECT `id` FROM `stock` WHERE `id` <> 32248979 AND `partno` = 'tc621ccoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.014101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291497 [ RunTime:0.015520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351465 [ RunTime:0.014327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292404 LIMIT 5 [ RunTime:0.008140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292404 ORDER BY `minOrder` ASC [ RunTime:0.019311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32292404 ORDER BY `unit` DESC [ RunTime:0.014307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32292404 LIMIT 2 [ RunTime:0.017447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292404 ORDER BY `minOrder` ASC [ RunTime:0.017356s ]
select * from pdf where partno='tc622voa' and brandshort='microchip technology' limit 1 [ RunTime:0.006551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc622voa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.009001s ]
SELECT `id` FROM `stock` WHERE `id` <> 32292404 AND `partno` = 'tc622voa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.009893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996934 [ RunTime:0.015120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291502 LIMIT 5 [ RunTime:0.010988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291502 ORDER BY `minOrder` ASC [ RunTime:0.011752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291502 ORDER BY `unit` DESC [ RunTime:0.012472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291502 LIMIT 2 [ RunTime:0.017276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291502 ORDER BY `minOrder` ASC [ RunTime:0.005509s ]
select * from pdf where partno='tc620hcpa' and brandshort='microchip technology' limit 1 [ RunTime:0.008248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620hcpa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.005665s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291502 AND `partno` = 'tc620hcpa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.026111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270833 [ RunTime:0.036270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32249047 LIMIT 5 [ RunTime:0.003977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32249047 ORDER BY `minOrder` ASC [ RunTime:0.015487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32249047 ORDER BY `unit` DESC [ RunTime:0.025771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32249047 LIMIT 2 [ RunTime:0.036377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32249047 ORDER BY `minOrder` ASC [ RunTime:0.018920s ]
select * from pdf where partno='tc620hcpa' and brandshort='microchip technology' limit 1 [ RunTime:0.005286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc620hcpa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.002840s ]
SELECT `id` FROM `stock` WHERE `id` <> 32249047 AND `partno` = 'tc620hcpa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270833 [ RunTime:0.047430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291524 LIMIT 5 [ RunTime:0.017143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291524 ORDER BY `minOrder` ASC [ RunTime:0.028673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291524 ORDER BY `unit` DESC [ RunTime:0.013355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291524 LIMIT 2 [ RunTime:0.032135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291524 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
select * from pdf where partno='tc623ceoa' and brandshort='microchip technology' limit 1 [ RunTime:0.007659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc623ceoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.012334s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291524 AND `partno` = 'tc623ceoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.034603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270565 [ RunTime:0.008281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32249123 LIMIT 5 [ RunTime:0.017351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32249123 ORDER BY `minOrder` ASC [ RunTime:0.018157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32249123 ORDER BY `unit` DESC [ RunTime:0.013360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32249123 LIMIT 2 [ RunTime:0.022683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32249123 ORDER BY `minOrder` ASC [ RunTime:0.018599s ]
select * from pdf where partno='tc623ceoa' and brandshort='microchip technology' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc623ceoa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.016226s ]
SELECT `id` FROM `stock` WHERE `id` <> 32249123 AND `partno` = 'tc623ceoa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.028101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270565 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291481 LIMIT 5 [ RunTime:0.002700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291481 ORDER BY `minOrder` ASC [ RunTime:0.008081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291481 ORDER BY `unit` DESC [ RunTime:0.005428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291481 LIMIT 2 [ RunTime:0.018918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291481 ORDER BY `minOrder` ASC [ RunTime:0.015356s ]
select * from pdf where partno='tc623ccpa' and brandshort='microchip technology' limit 1 [ RunTime:0.012935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tc623ccpa' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.015225s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291481 AND `partno` = 'tc623ccpa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.013988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270840 [ RunTime:0.011480s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63917830 LIMIT 5 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63917830 ORDER BY `minOrder` ASC [ RunTime:0.008403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63917830 ORDER BY `unit` DESC [ RunTime:0.003410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63917830 LIMIT 2 [ RunTime:0.015755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63917830 ORDER BY `minOrder` ASC [ RunTime:0.003099s ]
select * from pdf where partno='TC62D722CFNG,C,EL' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.005103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC62D722CFNG,C,EL' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.001692s ]
SELECT `id` FROM `stock` WHERE `id` <> 63917830 AND `partno` = 'TC62D722CFNG,C,EL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.016626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19148193 [ RunTime:0.004299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350929 LIMIT 5 [ RunTime:0.027560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350929 ORDER BY `minOrder` ASC [ RunTime:0.013053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350929 ORDER BY `unit` DESC [ RunTime:0.023088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350929 LIMIT 2 [ RunTime:0.023710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350929 ORDER BY `minOrder` ASC [ RunTime:0.023301s ]
select * from pdf where partno='TC620CVOA713' and brandshort='Microchip Technology' limit 1 [ RunTime:0.017541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC620CVOA713' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.017178s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350929 AND `partno` = 'TC620CVOA713' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.026162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270545 [ RunTime:0.021655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350927 LIMIT 5 [ RunTime:0.021691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350927 ORDER BY `minOrder` ASC [ RunTime:0.032332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350927 ORDER BY `unit` DESC [ RunTime:0.028079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350927 LIMIT 2 [ RunTime:0.014080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350927 ORDER BY `minOrder` ASC [ RunTime:0.011670s ]
select * from pdf where partno='TC620CEOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.007410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC620CEOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.027676s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350927 AND `partno` = 'TC620CEOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.018445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996923 [ RunTime:0.005327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350928 LIMIT 5 [ RunTime:0.022833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350928 ORDER BY `minOrder` ASC [ RunTime:0.034005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350928 ORDER BY `unit` DESC [ RunTime:0.010412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350928 LIMIT 2 [ RunTime:0.021473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350928 ORDER BY `minOrder` ASC [ RunTime:0.007965s ]
select * from pdf where partno='TC621CEOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.005388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC621CEOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.018376s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350928 AND `partno` = 'TC621CEOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.016148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996936 [ RunTime:0.004281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350967 LIMIT 5 [ RunTime:0.032960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350967 ORDER BY `minOrder` ASC [ RunTime:0.023255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350967 ORDER BY `unit` DESC [ RunTime:0.055490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350967 LIMIT 2 [ RunTime:0.006126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350967 ORDER BY `minOrder` ASC [ RunTime:0.019289s ]
select * from pdf where partno='TC622EOA713' and brandshort='Microchip Technology' limit 1 [ RunTime:0.013183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622EOA713' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.009790s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350967 AND `partno` = 'TC622EOA713' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.016833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996951 [ RunTime:0.009721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63916709 LIMIT 5 [ RunTime:0.035986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63916709 ORDER BY `minOrder` ASC [ RunTime:0.029246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63916709 ORDER BY `unit` DESC [ RunTime:0.010615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63916709 LIMIT 2 [ RunTime:0.025623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63916709 ORDER BY `minOrder` ASC [ RunTime:0.009561s ]
select * from pdf where partno='TC62D748CFG,EL' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.009034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC62D748CFG,EL' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.007213s ]
SELECT `id` FROM `stock` WHERE `id` <> 63916709 AND `partno` = 'TC62D748CFG,EL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.012915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19149862 [ RunTime:0.059480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350932 LIMIT 5 [ RunTime:0.021119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350932 ORDER BY `minOrder` ASC [ RunTime:0.018993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350932 ORDER BY `unit` DESC [ RunTime:0.050239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350932 LIMIT 2 [ RunTime:0.028789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350932 ORDER BY `minOrder` ASC [ RunTime:0.009797s ]
select * from pdf where partno='TC622VAT' and brandshort='Microchip Technology' limit 1 [ RunTime:0.017813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622VAT' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.023318s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350932 AND `partno` = 'TC622VAT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.015370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270555 [ RunTime:0.003242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350926 LIMIT 5 [ RunTime:0.017596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350926 ORDER BY `minOrder` ASC [ RunTime:0.012573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350926 ORDER BY `unit` DESC [ RunTime:0.021175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350926 LIMIT 2 [ RunTime:0.024155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350926 ORDER BY `minOrder` ASC [ RunTime:0.019884s ]
select * from pdf where partno='TC622VOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.023586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622VOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.051927s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350926 AND `partno` = 'TC622VOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.024542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996934 [ RunTime:0.001734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351081 LIMIT 5 [ RunTime:0.005572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351081 ORDER BY `minOrder` ASC [ RunTime:0.015174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351081 ORDER BY `unit` DESC [ RunTime:0.015541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351081 LIMIT 2 [ RunTime:0.015812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351081 ORDER BY `minOrder` ASC [ RunTime:0.007839s ]
select * from pdf where partno='TC621HCOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.029389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC621HCOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005139s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351081 AND `partno` = 'TC621HCOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.026585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11997059 [ RunTime:0.014740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58701433 LIMIT 5 [ RunTime:0.011329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58701433 ORDER BY `minOrder` ASC [ RunTime:0.018436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58701433 ORDER BY `unit` DESC [ RunTime:0.042048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58701433 LIMIT 2 [ RunTime:0.020942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58701433 ORDER BY `minOrder` ASC [ RunTime:0.021435s ]
select * from pdf where partno='TC6215TG-G' and brandshort='Microchip Technology' limit 1 [ RunTime:0.036083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC6215TG-G' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.025532s ]
SELECT `id` FROM `stock` WHERE `id` <> 58701433 AND `partno` = 'TC6215TG-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.048631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028413 [ RunTime:0.019604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57108152 LIMIT 5 [ RunTime:0.025484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57108152 ORDER BY `minOrder` ASC [ RunTime:0.024920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57108152 ORDER BY `unit` DESC [ RunTime:0.016595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57108152 LIMIT 2 [ RunTime:0.067329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57108152 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
select * from pdf where partno='TC62D723FNG,C,EL' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.009452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC62D723FNG,C,EL' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.025061s ]
SELECT `id` FROM `stock` WHERE `id` <> 57108152 AND `partno` = 'TC62D723FNG,C,EL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.025274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19149060 [ RunTime:0.020142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350968 LIMIT 5 [ RunTime:0.030306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350968 ORDER BY `minOrder` ASC [ RunTime:0.011104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350968 ORDER BY `unit` DESC [ RunTime:0.030087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350968 LIMIT 2 [ RunTime:0.011176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350968 ORDER BY `minOrder` ASC [ RunTime:0.005226s ]
select * from pdf where partno='TC622EOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.028857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622EOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005465s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350968 AND `partno` = 'TC622EOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.022456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996952 [ RunTime:0.019456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351014 LIMIT 5 [ RunTime:0.002980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351014 ORDER BY `minOrder` ASC [ RunTime:0.023624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351014 ORDER BY `unit` DESC [ RunTime:0.017650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351014 LIMIT 2 [ RunTime:0.025795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351014 ORDER BY `minOrder` ASC [ RunTime:0.004519s ]
select * from pdf where partno='TC622VPA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.011193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622VPA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002570s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351014 AND `partno` = 'TC622VPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.023743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11997001 [ RunTime:0.004795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350986 LIMIT 5 [ RunTime:0.004127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350986 ORDER BY `minOrder` ASC [ RunTime:0.013392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350986 ORDER BY `unit` DESC [ RunTime:0.011565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350986 LIMIT 2 [ RunTime:0.009571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350986 ORDER BY `minOrder` ASC [ RunTime:0.006602s ]
select * from pdf where partno='TC620CCPA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC620CCPA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.025809s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350986 AND `partno` = 'TC620CCPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.037058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292394 [ RunTime:0.007429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350970 LIMIT 5 [ RunTime:0.025547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350970 ORDER BY `minOrder` ASC [ RunTime:0.006573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350970 ORDER BY `unit` DESC [ RunTime:0.007090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350970 LIMIT 2 [ RunTime:0.018081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350970 ORDER BY `minOrder` ASC [ RunTime:0.003193s ]
select * from pdf where partno='TC620HEOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.012681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC620HEOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008473s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350970 AND `partno` = 'TC620HEOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.016178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996954 [ RunTime:0.025073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351093 LIMIT 5 [ RunTime:0.011135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351093 ORDER BY `minOrder` ASC [ RunTime:0.028356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351093 ORDER BY `unit` DESC [ RunTime:0.014503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351093 LIMIT 2 [ RunTime:0.016607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351093 ORDER BY `minOrder` ASC [ RunTime:0.010683s ]
select * from pdf where partno='TC623CVOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.005875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC623CVOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.010359s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351093 AND `partno` = 'TC623CVOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.009285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292406 [ RunTime:0.002946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351088 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351088 ORDER BY `minOrder` ASC [ RunTime:0.009847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351088 ORDER BY `unit` DESC [ RunTime:0.003566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351088 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351088 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
select * from pdf where partno='TC623CEOA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.015823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC623CEOA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.021508s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351088 AND `partno` = 'TC623CEOA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.003224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270565 [ RunTime:0.004600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351015 LIMIT 5 [ RunTime:0.011510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351015 ORDER BY `minOrder` ASC [ RunTime:0.022968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351015 ORDER BY `unit` DESC [ RunTime:0.004011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351015 LIMIT 2 [ RunTime:0.032441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351015 ORDER BY `minOrder` ASC [ RunTime:0.014486s ]
select * from pdf where partno='TC622EAT' and brandshort='Microchip Technology' limit 1 [ RunTime:0.006109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622EAT' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.010738s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351015 AND `partno` = 'TC622EAT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.032643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11997003 [ RunTime:0.021698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351133 LIMIT 5 [ RunTime:0.003696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351133 ORDER BY `minOrder` ASC [ RunTime:0.017378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351133 ORDER BY `unit` DESC [ RunTime:0.028645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351133 LIMIT 2 [ RunTime:0.011339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351133 ORDER BY `minOrder` ASC [ RunTime:0.018712s ]
select * from pdf where partno='TC620CEPA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.009709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC620CEPA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002467s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351133 AND `partno` = 'TC620CEPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.023939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270567 [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63351167 LIMIT 5 [ RunTime:0.041333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351167 ORDER BY `minOrder` ASC [ RunTime:0.037964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63351167 ORDER BY `unit` DESC [ RunTime:0.009292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63351167 LIMIT 2 [ RunTime:0.057428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63351167 ORDER BY `minOrder` ASC [ RunTime:0.017367s ]
select * from pdf where partno='TC622EPA' and brandshort='Microchip Technology' limit 1 [ RunTime:0.010520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC622EPA' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.003672s ]
SELECT `id` FROM `stock` WHERE `id` <> 63351167 AND `partno` = 'TC622EPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.025557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11996953 [ RunTime:0.025852s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015058s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033770s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047347s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030201s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054412s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010041s ]
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 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040564s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TC62%' OR `brand` LIKE 'TC62%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020078s ]