SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001238s ]
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=61&search=1' [ RunTime:0.010993s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002569s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003118s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003652s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.012960s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002863s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013209s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002269s ]
SELECT * FROM `stock_search` WHERE `partno` = '61' LIMIT 1 [ RunTime:0.027394s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-09 06:49:29' WHERE `partno` = '61' [ RunTime:0.009086s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001569s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.432799s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517382 LIMIT 5 [ RunTime:0.001922s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517382 ORDER BY `minOrder` ASC [ RunTime:0.002874s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517382 ORDER BY `unit` DESC [ RunTime:0.008773s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517382 LIMIT 2 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517382 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19746999 LIMIT 5 [ RunTime:0.011907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19746999 ORDER BY `minOrder` ASC [ RunTime:0.000788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19746999 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19746999 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19746999 ORDER BY `minOrder` ASC [ RunTime:0.003415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182330 LIMIT 5 [ RunTime:0.001221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182330 ORDER BY `minOrder` ASC [ RunTime:0.008424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182330 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182330 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182330 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481260 LIMIT 5 [ RunTime:0.000848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481260 ORDER BY `minOrder` ASC [ RunTime:0.002464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481260 ORDER BY `unit` DESC [ RunTime:0.008890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481260 LIMIT 2 [ RunTime:0.006636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481260 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518738 LIMIT 5 [ RunTime:0.000984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518738 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518738 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518738 LIMIT 2 [ RunTime:0.004828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518738 ORDER BY `minOrder` ASC [ RunTime:0.008196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517394 LIMIT 5 [ RunTime:0.011529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517394 ORDER BY `minOrder` ASC [ RunTime:0.010304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517394 ORDER BY `unit` DESC [ RunTime:0.002820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517394 LIMIT 2 [ RunTime:0.005756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517394 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518946 LIMIT 5 [ RunTime:0.000828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518946 ORDER BY `minOrder` ASC [ RunTime:0.004076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518946 ORDER BY `unit` DESC [ RunTime:0.001375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518946 LIMIT 2 [ RunTime:0.002346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518946 ORDER BY `minOrder` ASC [ RunTime:0.002125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19586577 LIMIT 5 [ RunTime:0.006979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19586577 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19586577 ORDER BY `unit` DESC [ RunTime:0.000453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19586577 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19586577 ORDER BY `minOrder` ASC [ RunTime:0.002022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747011 LIMIT 5 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747011 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19747011 ORDER BY `unit` DESC [ RunTime:0.003098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19747011 LIMIT 2 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747011 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417779 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417779 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417779 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417779 LIMIT 2 [ RunTime:0.001850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417779 ORDER BY `minOrder` ASC [ RunTime:0.004359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585701 LIMIT 5 [ RunTime:0.009034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585701 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585701 ORDER BY `unit` DESC [ RunTime:0.001696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585701 LIMIT 2 [ RunTime:0.003645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585701 ORDER BY `minOrder` ASC [ RunTime:0.004755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482113 LIMIT 5 [ RunTime:0.001279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482113 ORDER BY `minOrder` ASC [ RunTime:0.009131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482113 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482113 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482113 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583182 LIMIT 5 [ RunTime:0.000773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583182 ORDER BY `minOrder` ASC [ RunTime:0.003580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583182 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583182 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583182 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518088 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518088 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518088 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518088 LIMIT 2 [ RunTime:0.006858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518088 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418266 LIMIT 5 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418266 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418266 ORDER BY `unit` DESC [ RunTime:0.001689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418266 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418266 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577861 LIMIT 5 [ RunTime:0.002131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577861 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577861 ORDER BY `unit` DESC [ RunTime:0.006612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577861 LIMIT 2 [ RunTime:0.005180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577861 ORDER BY `minOrder` ASC [ RunTime:0.003242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418255 LIMIT 5 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418255 ORDER BY `minOrder` ASC [ RunTime:0.003676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418255 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418255 LIMIT 2 [ RunTime:0.001993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418255 ORDER BY `minOrder` ASC [ RunTime:0.001684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442241 LIMIT 5 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442241 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15442241 ORDER BY `unit` DESC [ RunTime:0.006917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15442241 LIMIT 2 [ RunTime:0.001293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442241 ORDER BY `minOrder` ASC [ RunTime:0.003288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513368 LIMIT 5 [ RunTime:0.001034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513368 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513368 ORDER BY `unit` DESC [ RunTime:0.006208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513368 LIMIT 2 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513368 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19590191 LIMIT 5 [ RunTime:0.001798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19590191 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19590191 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19590191 LIMIT 2 [ RunTime:0.002126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19590191 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281985 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281985 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281985 ORDER BY `unit` DESC [ RunTime:0.006896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281985 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281985 ORDER BY `minOrder` ASC [ RunTime:0.005827s ]
select * from pdf where partno='61299-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.014138s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61299-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002243s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281985 AND `partno` = '61299-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281575 [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281575 LIMIT 5 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281575 ORDER BY `minOrder` ASC [ RunTime:0.006487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281575 ORDER BY `unit` DESC [ RunTime:0.008017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281575 LIMIT 2 [ RunTime:0.006580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281575 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
select * from pdf where partno='61299-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61299-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003150s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281575 AND `partno` = '61299-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281985 [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281383 LIMIT 5 [ RunTime:0.002930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281383 ORDER BY `minOrder` ASC [ RunTime:0.003465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281383 ORDER BY `unit` DESC [ RunTime:0.006033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281383 LIMIT 2 [ RunTime:0.002242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281383 ORDER BY `minOrder` ASC [ RunTime:0.006298s ]
select * from pdf where partno='61939-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.002491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61939-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003837s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281383 AND `partno` = '61939-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281898 LIMIT 5 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281898 ORDER BY `minOrder` ASC [ RunTime:0.001024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281898 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281898 LIMIT 2 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281898 ORDER BY `minOrder` ASC [ RunTime:0.004347s ]
select * from pdf where partno='61291-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61291-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001006s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281898 AND `partno` = '61291-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281294 LIMIT 5 [ RunTime:0.004793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281294 ORDER BY `minOrder` ASC [ RunTime:0.007986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281294 ORDER BY `unit` DESC [ RunTime:0.001418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281294 LIMIT 2 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281294 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='61505-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61505-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004930s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281294 AND `partno` = '61505-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281131 LIMIT 5 [ RunTime:0.002507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281131 ORDER BY `minOrder` ASC [ RunTime:0.009370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281131 ORDER BY `unit` DESC [ RunTime:0.003177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281131 LIMIT 2 [ RunTime:0.001640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281131 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='61118-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61118-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280297 LIMIT 5 [ RunTime:0.002290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280297 ORDER BY `minOrder` ASC [ RunTime:0.015578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280297 ORDER BY `unit` DESC [ RunTime:0.007041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280297 LIMIT 2 [ RunTime:0.003054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280297 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='61117-4' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61117-4' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002402s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280297 AND `partno` = '61117-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282410 LIMIT 5 [ RunTime:0.005446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282410 ORDER BY `minOrder` ASC [ RunTime:0.001511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282410 ORDER BY `unit` DESC [ RunTime:0.005377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282410 LIMIT 2 [ RunTime:0.003040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282410 ORDER BY `minOrder` ASC [ RunTime:0.001071s ]
select * from pdf where partno='61818-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61818-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.012542s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282410 AND `partno` = '61818-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.010072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280296 LIMIT 5 [ RunTime:0.001815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280296 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280296 ORDER BY `unit` DESC [ RunTime:0.005373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280296 LIMIT 2 [ RunTime:0.001806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280296 ORDER BY `minOrder` ASC [ RunTime:0.001604s ]
select * from pdf where partno='61116-4' and brandshort='te connectivity' limit 1 [ RunTime:0.001635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61116-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.019204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280120 LIMIT 5 [ RunTime:0.001664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280120 ORDER BY `minOrder` ASC [ RunTime:0.001129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280120 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280120 LIMIT 2 [ RunTime:0.001776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280120 ORDER BY `minOrder` ASC [ RunTime:0.002785s ]
select * from pdf where partno='61117-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.007522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61117-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003414s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280120 AND `partno` = '61117-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.019552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282116 LIMIT 5 [ RunTime:0.002380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282116 ORDER BY `minOrder` ASC [ RunTime:0.004856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282116 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282116 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282116 ORDER BY `minOrder` ASC [ RunTime:0.001469s ]
select * from pdf where partno='61988-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61988-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003428s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282116 AND `partno` = '61988-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.006882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280059 LIMIT 5 [ RunTime:0.017754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280059 ORDER BY `minOrder` ASC [ RunTime:0.002659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280059 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280059 LIMIT 2 [ RunTime:0.006337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280059 ORDER BY `minOrder` ASC [ RunTime:0.002213s ]
select * from pdf where partno='61626-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.007116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61626-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.008090s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280059 AND `partno` = '61626-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280007 LIMIT 5 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280007 ORDER BY `minOrder` ASC [ RunTime:0.001551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280007 ORDER BY `unit` DESC [ RunTime:0.004135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280007 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280007 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='61314-5' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61314-5' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003958s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280007 AND `partno` = '61314-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281336 LIMIT 5 [ RunTime:0.005694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281336 ORDER BY `minOrder` ASC [ RunTime:0.003409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281336 ORDER BY `unit` DESC [ RunTime:0.000320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281336 LIMIT 2 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281336 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='61795-3' and brandshort='te connectivity' limit 1 [ RunTime:0.000938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61795-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.014029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259033 LIMIT 5 [ RunTime:0.002611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259033 ORDER BY `minOrder` ASC [ RunTime:0.011869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259033 ORDER BY `unit` DESC [ RunTime:0.001318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259033 LIMIT 2 [ RunTime:0.001844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259033 ORDER BY `minOrder` ASC [ RunTime:0.002389s ]
select * from pdf where partno='61668-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.004263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61668-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.005660s ]
SELECT `id` FROM `stock` WHERE `id` <> 32259033 AND `partno` = '61668-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280092 LIMIT 5 [ RunTime:0.003545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280092 ORDER BY `minOrder` ASC [ RunTime:0.002494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280092 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280092 LIMIT 2 [ RunTime:0.006376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280092 ORDER BY `minOrder` ASC [ RunTime:0.007457s ]
select * from pdf where partno='61086-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.009390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61086-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004911s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280092 AND `partno` = '61086-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.007374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282114 LIMIT 5 [ RunTime:0.010858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282114 ORDER BY `minOrder` ASC [ RunTime:0.004055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282114 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282114 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282114 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
select * from pdf where partno='61283-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.005421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61283-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.014270s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282114 AND `partno` = '61283-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.003056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280020 LIMIT 5 [ RunTime:0.003492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280020 ORDER BY `minOrder` ASC [ RunTime:0.000746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280020 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280020 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280020 ORDER BY `minOrder` ASC [ RunTime:0.002358s ]
select * from pdf where partno='61117-5' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61117-5' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002705s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280020 AND `partno` = '61117-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.005166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258052 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258052 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258052 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258052 LIMIT 2 [ RunTime:0.002853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258052 ORDER BY `minOrder` ASC [ RunTime:0.005579s ]
select * from pdf where partno='61400413321' and brandshort='wurth elektronik' limit 1 [ RunTime:0.004765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61400413321' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.001095s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258052 AND `partno` = '61400413321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932622 [ RunTime:0.001056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282115 LIMIT 5 [ RunTime:0.006584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282115 ORDER BY `minOrder` ASC [ RunTime:0.001736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282115 ORDER BY `unit` DESC [ RunTime:0.005768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282115 LIMIT 2 [ RunTime:0.004107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282115 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='61454-1' and brandshort='te connectivity' limit 1 [ RunTime:0.003833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61454-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.022250s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:1.184125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639006 LIMIT 5 [ RunTime:0.002142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639006 ORDER BY `minOrder` ASC [ RunTime:0.002362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639006 ORDER BY `unit` DESC [ RunTime:0.004083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639006 LIMIT 2 [ RunTime:0.001323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639006 ORDER BY `minOrder` ASC [ RunTime:0.001411s ]
select * from pdf where partno='61818-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61818-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000920s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639006 AND `partno` = '61818-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517382 [ RunTime:0.002735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433646 LIMIT 5 [ RunTime:0.004235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433646 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433646 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433646 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433646 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='61300211121' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61300211121' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000340s ]
SELECT `id` FROM `stock` WHERE `id` <> 59433646 AND `partno` = '61300211121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6658 [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19746999 [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433647 LIMIT 5 [ RunTime:0.001408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433647 ORDER BY `minOrder` ASC [ RunTime:0.000917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433647 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433647 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433647 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='61300311121' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61300311121' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000328s ]
SELECT `id` FROM `stock` WHERE `id` <> 59433647 AND `partno` = '61300311121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182330 [ RunTime:0.000257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639327 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639327 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639327 ORDER BY `unit` DESC [ RunTime:0.001599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639327 LIMIT 2 [ RunTime:0.006631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639327 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
select * from pdf where partno='61177-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61177-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001787s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639327 AND `partno` = '61177-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639087 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639087 ORDER BY `minOrder` ASC [ RunTime:0.001422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639087 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639087 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639087 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='61813-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61813-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002466s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639087 AND `partno` = '61813-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518738 [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344230 LIMIT 5 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344230 ORDER BY `minOrder` ASC [ RunTime:0.000742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344230 ORDER BY `unit` DESC [ RunTime:0.003283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344230 LIMIT 2 [ RunTime:0.016884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344230 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
select * from pdf where partno='61314-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61314-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60650736 LIMIT 5 [ RunTime:0.004122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60650736 ORDER BY `minOrder` ASC [ RunTime:0.001489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60650736 ORDER BY `unit` DESC [ RunTime:0.002872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60650736 LIMIT 2 [ RunTime:0.005256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60650736 ORDER BY `minOrder` ASC [ RunTime:0.003976s ]
select * from pdf where partno='61653-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61653-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003065s ]
SELECT `id` FROM `stock` WHERE `id` <> 60650736 AND `partno` = '61653-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19586577 [ RunTime:0.002436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639030 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639030 ORDER BY `minOrder` ASC [ RunTime:0.002136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639030 ORDER BY `unit` DESC [ RunTime:0.007328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639030 LIMIT 2 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639030 ORDER BY `minOrder` ASC [ RunTime:0.006132s ]
select * from pdf where partno='61400-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61400-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007951s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639030 AND `partno` = '61400-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517394 [ RunTime:0.008169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348153 LIMIT 5 [ RunTime:0.012321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348153 ORDER BY `minOrder` ASC [ RunTime:0.016885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348153 ORDER BY `unit` DESC [ RunTime:0.000925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348153 LIMIT 2 [ RunTime:0.005173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348153 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='61492-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61492-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001566s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348153 AND `partno` = '61492-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583185 [ RunTime:0.007672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433721 LIMIT 5 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433721 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433721 ORDER BY `unit` DESC [ RunTime:0.003759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433721 LIMIT 2 [ RunTime:0.002985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433721 ORDER BY `minOrder` ASC [ RunTime:0.012958s ]
select * from pdf where partno='61300611121' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61300611121' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000442s ]
SELECT `id` FROM `stock` WHERE `id` <> 59433721 AND `partno` = '61300611121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182352 [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643997 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643997 ORDER BY `minOrder` ASC [ RunTime:0.014124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643997 ORDER BY `unit` DESC [ RunTime:0.004285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643997 LIMIT 2 [ RunTime:0.007124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643997 ORDER BY `minOrder` ASC [ RunTime:0.004773s ]
select * from pdf where partno='61386-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61386-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005637s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643997 AND `partno` = '61386-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11414210 [ RunTime:0.001110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639382 LIMIT 5 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639382 ORDER BY `minOrder` ASC [ RunTime:0.008038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639382 ORDER BY `unit` DESC [ RunTime:0.002079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639382 LIMIT 2 [ RunTime:0.002955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639382 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
select * from pdf where partno='61687-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61687-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000713s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639382 AND `partno` = '61687-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518946 [ RunTime:0.002301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644189 LIMIT 5 [ RunTime:0.005916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644189 ORDER BY `minOrder` ASC [ RunTime:0.008093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644189 ORDER BY `unit` DESC [ RunTime:0.026757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644189 LIMIT 2 [ RunTime:0.009135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644189 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
select * from pdf where partno='61795-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61795-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002639s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644189 AND `partno` = '61795-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512923 [ RunTime:0.004494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60939626 LIMIT 5 [ RunTime:0.003992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939626 ORDER BY `minOrder` ASC [ RunTime:0.004325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60939626 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60939626 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939626 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
select * from pdf where partno='61765-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61765-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000890s ]
SELECT `id` FROM `stock` WHERE `id` <> 60939626 AND `partno` = '61765-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585701 [ RunTime:0.001859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354859 LIMIT 5 [ RunTime:0.005673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354859 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354859 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354859 LIMIT 2 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354859 ORDER BY `minOrder` ASC [ RunTime:0.007407s ]
select * from pdf where partno='61062-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61062-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010641s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354859 AND `partno` = '61062-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577861 [ RunTime:0.003012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60939618 LIMIT 5 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939618 ORDER BY `minOrder` ASC [ RunTime:0.001657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60939618 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60939618 LIMIT 2 [ RunTime:0.001112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939618 ORDER BY `minOrder` ASC [ RunTime:0.003633s ]
select * from pdf where partno='61045-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61045-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005241s ]
SELECT `id` FROM `stock` WHERE `id` <> 60939618 AND `partno` = '61045-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585696 [ RunTime:0.002240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639425 LIMIT 5 [ RunTime:0.005541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639425 ORDER BY `minOrder` ASC [ RunTime:0.006604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639425 ORDER BY `unit` DESC [ RunTime:0.013079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639425 LIMIT 2 [ RunTime:0.004906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639425 ORDER BY `minOrder` ASC [ RunTime:0.004770s ]
select * from pdf where partno='61988-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61988-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006394s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639425 AND `partno` = '61988-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418266 [ RunTime:0.004917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348164 LIMIT 5 [ RunTime:0.004181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348164 ORDER BY `minOrder` ASC [ RunTime:0.003706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348164 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348164 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348164 ORDER BY `minOrder` ASC [ RunTime:0.001657s ]
select * from pdf where partno='61769-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61769-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002305s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348164 AND `partno` = '61769-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583182 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60636955 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636955 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60636955 ORDER BY `unit` DESC [ RunTime:0.002781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60636955 LIMIT 2 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636955 ORDER BY `minOrder` ASC [ RunTime:0.004841s ]
select * from pdf where partno='61498-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61498-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001179s ]
SELECT `id` FROM `stock` WHERE `id` <> 60636955 AND `partno` = '61498-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581239 [ RunTime:0.005134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433668 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433668 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433668 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433668 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433668 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
select * from pdf where partno='61300411121' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61300411121' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000444s ]
SELECT `id` FROM `stock` WHERE `id` <> 59433668 AND `partno` = '61300411121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747011 [ RunTime:0.000418s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002916s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002947s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001191s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003701s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009068s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013001s ]
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 '61%' OR `brand` LIKE '61%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58027472 LIMIT 5 [ RunTime:0.011072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58027472 ORDER BY `minOrder` ASC [ RunTime:0.002102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58027472 ORDER BY `unit` DESC [ RunTime:0.000672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58027472 LIMIT 2 [ RunTime:0.002072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58027472 ORDER BY `minOrder` ASC [ RunTime:0.002242s ]
select * from pdf where partno='6124B104K500NT' and brandshort='FH' limit 1 [ RunTime:0.001424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6124B104K500NT' OR `brand` LIKE 'FH(风华)%' ) ) LIMIT 1 [ RunTime:0.006623s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '61%' OR `brand` LIKE '61%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.072726s ]