SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002509s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=773&search=1' [ RunTime:0.002333s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002207s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000609s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001521s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001189s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001650s ]
SELECT * FROM `stock_search` WHERE `partno` = '773' LIMIT 1 [ RunTime:0.000850s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-29 18:47:26' WHERE `partno` = '773' [ RunTime:0.009469s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004032s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.224138s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796085 LIMIT 5 [ RunTime:0.026493s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796085 ORDER BY `minOrder` ASC [ RunTime:0.027843s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19796085 ORDER BY `unit` DESC [ RunTime:0.028121s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19796085 LIMIT 2 [ RunTime:0.024926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796085 ORDER BY `minOrder` ASC [ RunTime:0.020292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196093 LIMIT 5 [ RunTime:0.034395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196093 ORDER BY `minOrder` ASC [ RunTime:0.019341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196093 ORDER BY `unit` DESC [ RunTime:0.032192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196093 LIMIT 2 [ RunTime:0.016349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196093 ORDER BY `minOrder` ASC [ RunTime:0.014629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16219090 LIMIT 5 [ RunTime:0.019980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16219090 ORDER BY `minOrder` ASC [ RunTime:0.019003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16219090 ORDER BY `unit` DESC [ RunTime:0.010499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16219090 LIMIT 2 [ RunTime:0.023841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16219090 ORDER BY `minOrder` ASC [ RunTime:0.012631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747006 LIMIT 5 [ RunTime:0.028144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747006 ORDER BY `minOrder` ASC [ RunTime:0.020719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19747006 ORDER BY `unit` DESC [ RunTime:0.008559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19747006 LIMIT 2 [ RunTime:0.003699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747006 ORDER BY `minOrder` ASC [ RunTime:0.009643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197461 LIMIT 5 [ RunTime:0.011939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197461 ORDER BY `minOrder` ASC [ RunTime:0.013014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197461 ORDER BY `unit` DESC [ RunTime:0.005758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197461 LIMIT 2 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197461 ORDER BY `minOrder` ASC [ RunTime:0.009148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19814265 LIMIT 5 [ RunTime:0.002390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19814265 ORDER BY `minOrder` ASC [ RunTime:0.005474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19814265 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19814265 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19814265 ORDER BY `minOrder` ASC [ RunTime:0.003389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847948 LIMIT 5 [ RunTime:0.003051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19847948 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19847948 ORDER BY `unit` DESC [ RunTime:0.008963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19847948 LIMIT 2 [ RunTime:0.007349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19847948 ORDER BY `minOrder` ASC [ RunTime:0.007782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234590 LIMIT 5 [ RunTime:0.003956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234590 ORDER BY `minOrder` ASC [ RunTime:0.006299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16234590 ORDER BY `unit` DESC [ RunTime:0.002664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16234590 LIMIT 2 [ RunTime:0.010671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234590 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486209 LIMIT 5 [ RunTime:0.007284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486209 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486209 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486209 LIMIT 2 [ RunTime:0.008733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486209 ORDER BY `minOrder` ASC [ RunTime:0.000824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234608 LIMIT 5 [ RunTime:0.004306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234608 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16234608 ORDER BY `unit` DESC [ RunTime:0.007024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16234608 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234608 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19814317 LIMIT 5 [ RunTime:0.003141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19814317 ORDER BY `minOrder` ASC [ RunTime:0.008917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19814317 ORDER BY `unit` DESC [ RunTime:0.002219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19814317 LIMIT 2 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19814317 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16235275 LIMIT 5 [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16235275 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16235275 ORDER BY `unit` DESC [ RunTime:0.003691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16235275 LIMIT 2 [ RunTime:0.009988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16235275 ORDER BY `minOrder` ASC [ RunTime:0.004622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15488324 LIMIT 5 [ RunTime:0.002154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15488324 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15488324 ORDER BY `unit` DESC [ RunTime:0.005558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15488324 LIMIT 2 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15488324 ORDER BY `minOrder` ASC [ RunTime:0.004199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485287 LIMIT 5 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485287 ORDER BY `minOrder` ASC [ RunTime:0.004012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15485287 ORDER BY `unit` DESC [ RunTime:0.000646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15485287 LIMIT 2 [ RunTime:0.002633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485287 ORDER BY `minOrder` ASC [ RunTime:0.008845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847956 LIMIT 5 [ RunTime:0.006078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19847956 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19847956 ORDER BY `unit` DESC [ RunTime:0.006380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19847956 LIMIT 2 [ RunTime:0.014102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19847956 ORDER BY `minOrder` ASC [ RunTime:0.017518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494020 LIMIT 5 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494020 ORDER BY `minOrder` ASC [ RunTime:0.001078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15494020 ORDER BY `unit` DESC [ RunTime:0.009855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15494020 LIMIT 2 [ RunTime:0.028116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494020 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19813018 LIMIT 5 [ RunTime:0.005589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19813018 ORDER BY `minOrder` ASC [ RunTime:0.018058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19813018 ORDER BY `unit` DESC [ RunTime:0.028036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19813018 LIMIT 2 [ RunTime:0.018267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19813018 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16235271 LIMIT 5 [ RunTime:0.006818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16235271 ORDER BY `minOrder` ASC [ RunTime:0.002193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16235271 ORDER BY `unit` DESC [ RunTime:0.004850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16235271 LIMIT 2 [ RunTime:0.025069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16235271 ORDER BY `minOrder` ASC [ RunTime:0.003574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194143 LIMIT 5 [ RunTime:0.010207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194143 ORDER BY `minOrder` ASC [ RunTime:0.006493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16194143 ORDER BY `unit` DESC [ RunTime:0.003054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16194143 LIMIT 2 [ RunTime:0.016244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194143 ORDER BY `minOrder` ASC [ RunTime:0.006714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19813665 LIMIT 5 [ RunTime:0.001833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19813665 ORDER BY `minOrder` ASC [ RunTime:0.008748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19813665 ORDER BY `unit` DESC [ RunTime:0.011540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19813665 LIMIT 2 [ RunTime:0.015258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19813665 ORDER BY `minOrder` ASC [ RunTime:0.005097s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277355 LIMIT 5 [ RunTime:0.012988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277355 ORDER BY `minOrder` ASC [ RunTime:0.002721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277355 ORDER BY `unit` DESC [ RunTime:0.003119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277355 LIMIT 2 [ RunTime:0.004133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277355 ORDER BY `minOrder` ASC [ RunTime:0.006021s ]
select * from pdf where partno='77311-122-02lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.024429s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-122-02lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.003383s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277355 AND `partno` = '77311-122-02lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277359 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277359 ORDER BY `minOrder` ASC [ RunTime:0.006452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277359 ORDER BY `unit` DESC [ RunTime:0.001002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277359 LIMIT 2 [ RunTime:0.003234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277359 ORDER BY `minOrder` ASC [ RunTime:0.002021s ]
select * from pdf where partno='77315-101-02lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-101-02lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.000782s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277359 AND `partno` = '77315-101-02lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.007062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51074499 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51074499 ORDER BY `minOrder` ASC [ RunTime:0.010511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51074499 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51074499 LIMIT 2 [ RunTime:0.026287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51074499 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
select * from pdf where partno='773592-000' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.009036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '773592-000' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.005306s ]
SELECT `id` FROM `stock` WHERE `id` <> 51074499 AND `partno` = '773592-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.006251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277354 LIMIT 5 [ RunTime:0.013124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277354 ORDER BY `minOrder` ASC [ RunTime:0.003881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277354 ORDER BY `unit` DESC [ RunTime:0.004991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277354 LIMIT 2 [ RunTime:0.003484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277354 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
select * from pdf where partno='77311-102-04lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.013592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-102-04lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.001139s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277354 AND `partno` = '77311-102-04lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277145 LIMIT 5 [ RunTime:0.005053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277145 ORDER BY `minOrder` ASC [ RunTime:0.002847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277145 ORDER BY `unit` DESC [ RunTime:0.005167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277145 LIMIT 2 [ RunTime:0.008426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277145 ORDER BY `minOrder` ASC [ RunTime:0.007004s ]
select * from pdf where partno='77311-124-06lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.009236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-124-06lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.008266s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277145 AND `partno` = '77311-124-06lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.003381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276709 LIMIT 5 [ RunTime:0.014530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276709 ORDER BY `minOrder` ASC [ RunTime:0.004924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276709 ORDER BY `unit` DESC [ RunTime:0.006474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276709 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276709 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
select * from pdf where partno='77311-124-05lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.011113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-124-05lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.005137s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276709 AND `partno` = '77311-124-05lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.006216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276712 LIMIT 5 [ RunTime:0.001110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276712 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276712 ORDER BY `unit` DESC [ RunTime:0.011321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276712 LIMIT 2 [ RunTime:0.007431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276712 ORDER BY `minOrder` ASC [ RunTime:0.006404s ]
select * from pdf where partno='77315-101-04lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-101-04lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.005983s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276712 AND `partno` = '77315-101-04lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.010076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277358 LIMIT 5 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277358 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277358 ORDER BY `unit` DESC [ RunTime:0.004126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277358 LIMIT 2 [ RunTime:0.006712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277358 ORDER BY `minOrder` ASC [ RunTime:0.007650s ]
select * from pdf where partno='77313-124-06lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.019317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-124-06lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.005864s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277358 AND `partno` = '77313-124-06lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.043071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276511 LIMIT 5 [ RunTime:0.033956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276511 ORDER BY `minOrder` ASC [ RunTime:0.028499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276511 ORDER BY `unit` DESC [ RunTime:0.005585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276511 LIMIT 2 [ RunTime:0.019001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276511 ORDER BY `minOrder` ASC [ RunTime:0.006896s ]
select * from pdf where partno='77311-122-04lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.019051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-122-04lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.022611s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276511 AND `partno` = '77311-122-04lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.014131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276708 LIMIT 5 [ RunTime:0.016419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276708 ORDER BY `minOrder` ASC [ RunTime:0.014928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276708 ORDER BY `unit` DESC [ RunTime:0.035112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276708 LIMIT 2 [ RunTime:0.013242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276708 ORDER BY `minOrder` ASC [ RunTime:0.017226s ]
select * from pdf where partno='77311-122-06lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.041714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-122-06lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.024435s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276708 AND `partno` = '77311-122-06lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.014999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277357 LIMIT 5 [ RunTime:0.042818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277357 ORDER BY `minOrder` ASC [ RunTime:0.041830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277357 ORDER BY `unit` DESC [ RunTime:0.047803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277357 LIMIT 2 [ RunTime:0.066269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277357 ORDER BY `minOrder` ASC [ RunTime:0.047861s ]
select * from pdf where partno='77313-101-26lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.029028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-101-26lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.059387s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277357 AND `partno` = '77313-101-26lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.034367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276507 LIMIT 5 [ RunTime:0.039920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276507 ORDER BY `minOrder` ASC [ RunTime:0.061423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276507 ORDER BY `unit` DESC [ RunTime:0.050973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276507 LIMIT 2 [ RunTime:0.020703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276507 ORDER BY `minOrder` ASC [ RunTime:0.039696s ]
select * from pdf where partno='77313-118-28lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.021652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-118-28lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.036004s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276507 AND `partno` = '77313-118-28lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.018643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276710 LIMIT 5 [ RunTime:0.034519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276710 ORDER BY `minOrder` ASC [ RunTime:0.011600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276710 ORDER BY `unit` DESC [ RunTime:0.016937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276710 LIMIT 2 [ RunTime:0.009964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276710 ORDER BY `minOrder` ASC [ RunTime:0.020971s ]
select * from pdf where partno='77311-158-16lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.005442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-158-16lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.036532s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276710 AND `partno` = '77311-158-16lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.030434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277356 LIMIT 5 [ RunTime:0.020870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277356 ORDER BY `minOrder` ASC [ RunTime:0.012763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277356 ORDER BY `unit` DESC [ RunTime:0.007939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277356 LIMIT 2 [ RunTime:0.021902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277356 ORDER BY `minOrder` ASC [ RunTime:0.010481s ]
select * from pdf where partno='77311-824-36lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.017514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-824-36lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.020777s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277356 AND `partno` = '77311-824-36lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.010934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276711 LIMIT 5 [ RunTime:0.058731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276711 ORDER BY `minOrder` ASC [ RunTime:0.010708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276711 ORDER BY `unit` DESC [ RunTime:0.003791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276711 LIMIT 2 [ RunTime:0.031458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276711 ORDER BY `minOrder` ASC [ RunTime:0.007793s ]
select * from pdf where partno='77313-101-72lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.009247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-101-72lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.014202s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276711 AND `partno` = '77313-101-72lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.011172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277360 LIMIT 5 [ RunTime:0.009961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277360 ORDER BY `minOrder` ASC [ RunTime:0.022234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277360 ORDER BY `unit` DESC [ RunTime:0.018655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277360 LIMIT 2 [ RunTime:0.011982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277360 ORDER BY `minOrder` ASC [ RunTime:0.008440s ]
select * from pdf where partno='77317-812-72lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.013260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77317-812-72lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.011937s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277360 AND `partno` = '77317-812-72lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.022526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081476 LIMIT 5 [ RunTime:0.022144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081476 ORDER BY `minOrder` ASC [ RunTime:0.010623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081476 ORDER BY `unit` DESC [ RunTime:0.018647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081476 LIMIT 2 [ RunTime:0.017194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081476 ORDER BY `minOrder` ASC [ RunTime:0.004317s ]
select * from pdf where partno='77342-02.0hg-01' and brandshort='honeywell' limit 1 [ RunTime:0.015064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77342-02.0hg-01' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.023422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221477 LIMIT 5 [ RunTime:0.008176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221477 ORDER BY `minOrder` ASC [ RunTime:0.001009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221477 ORDER BY `unit` DESC [ RunTime:0.012669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221477 LIMIT 2 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221477 ORDER BY `minOrder` ASC [ RunTime:0.002949s ]
select * from pdf where partno='77362-510-000 ps24-150 black kit' and brandshort='pactec' limit 1 [ RunTime:0.004984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77362-510-000 ps24-150 black kit' OR `brand` LIKE 'pactec%' ) ) LIMIT 1 [ RunTime:0.000604s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221477 AND `partno` = '77362-510-000 ps24-150 black kit' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pactec%' ) [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080860 LIMIT 5 [ RunTime:0.006796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080860 ORDER BY `minOrder` ASC [ RunTime:0.007207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080860 ORDER BY `unit` DESC [ RunTime:0.000909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080860 LIMIT 2 [ RunTime:0.006227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080860 ORDER BY `minOrder` ASC [ RunTime:0.004670s ]
select * from pdf where partno='77342-06.0hg-01' and brandshort='honeywell' limit 1 [ RunTime:0.001109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77342-06.0hg-01' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.036081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081109 LIMIT 5 [ RunTime:0.006666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081109 ORDER BY `minOrder` ASC [ RunTime:0.004658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081109 ORDER BY `unit` DESC [ RunTime:0.013771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081109 LIMIT 2 [ RunTime:0.015798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081109 ORDER BY `minOrder` ASC [ RunTime:0.004524s ]
select * from pdf where partno='77345-09.0hg-01' and brandshort='honeywell' limit 1 [ RunTime:0.002723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77345-09.0hg-01' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.016229s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435697 LIMIT 5 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435697 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435697 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435697 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435697 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='77311-418-00LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-418-00LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.005694s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435697 AND `partno` = '77311-418-00LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796085 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512861 LIMIT 5 [ RunTime:0.004207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512861 ORDER BY `minOrder` ASC [ RunTime:0.004763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512861 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512861 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512861 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='77313-515-20LF' and brandshort='FCI Deutschland GmbH' limit 1 [ RunTime:0.001799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-515-20LF' OR `brand` LIKE 'FCI Deutschland GmbH%' ) ) LIMIT 1 [ RunTime:0.001710s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512861 AND `partno` = '77313-515-20LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fci deutschland gmbh%' ) [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435964 LIMIT 5 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435964 ORDER BY `minOrder` ASC [ RunTime:0.001323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435964 ORDER BY `unit` DESC [ RunTime:0.000850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435964 LIMIT 2 [ RunTime:0.003256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435964 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='77311-801-03LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-801-03LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000555s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435964 AND `partno` = '77311-801-03LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19813018 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448007 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448007 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448007 ORDER BY `unit` DESC [ RunTime:0.003276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448007 LIMIT 2 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448007 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='77311-402-00LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-402-00LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004419s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448007 AND `partno` = '77311-402-00LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196093 [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59453034 LIMIT 5 [ RunTime:0.002794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59453034 ORDER BY `minOrder` ASC [ RunTime:0.003663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59453034 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59453034 LIMIT 2 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59453034 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='77311-402-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-402-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002321s ]
SELECT `id` FROM `stock` WHERE `id` <> 59453034 AND `partno` = '77311-402-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.006010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197964 [ RunTime:0.002124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448117 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448117 ORDER BY `minOrder` ASC [ RunTime:0.001148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448117 ORDER BY `unit` DESC [ RunTime:0.002003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448117 LIMIT 2 [ RunTime:0.001844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448117 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
select * from pdf where partno='77315-124-03LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-124-03LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002075s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448117 AND `partno` = '77315-124-03LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15476384 [ RunTime:0.001092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512723 LIMIT 5 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512723 ORDER BY `minOrder` ASC [ RunTime:0.005499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512723 ORDER BY `unit` DESC [ RunTime:0.000839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512723 LIMIT 2 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512723 ORDER BY `minOrder` ASC [ RunTime:0.008409s ]
select * from pdf where partno='77311-801-02LF' and brandshort='FCI Deutschland GmbH' limit 1 [ RunTime:0.009716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-801-02LF' OR `brand` LIKE 'FCI Deutschland GmbH%' ) ) LIMIT 1 [ RunTime:0.023535s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512723 AND `partno` = '77311-801-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fci deutschland gmbh%' ) [ RunTime:0.030745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433664 LIMIT 5 [ RunTime:0.015909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433664 ORDER BY `minOrder` ASC [ RunTime:0.036046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433664 ORDER BY `unit` DESC [ RunTime:0.021969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433664 LIMIT 2 [ RunTime:0.039713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433664 ORDER BY `minOrder` ASC [ RunTime:0.016692s ]
select * from pdf where partno='77311-118-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.028597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-118-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59436752 LIMIT 5 [ RunTime:0.027461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59436752 ORDER BY `minOrder` ASC [ RunTime:0.043406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59436752 ORDER BY `unit` DESC [ RunTime:0.028130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59436752 LIMIT 2 [ RunTime:0.016920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59436752 ORDER BY `minOrder` ASC [ RunTime:0.024414s ]
select * from pdf where partno='77313-801-08LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.020451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-801-08LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.019900s ]
SELECT `id` FROM `stock` WHERE `id` <> 59436752 AND `partno` = '77313-801-08LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.011066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16219090 [ RunTime:0.033760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442196 LIMIT 5 [ RunTime:0.027997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442196 ORDER BY `minOrder` ASC [ RunTime:0.025948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442196 ORDER BY `unit` DESC [ RunTime:0.006393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442196 LIMIT 2 [ RunTime:0.039235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442196 ORDER BY `minOrder` ASC [ RunTime:0.014019s ]
select * from pdf where partno='77311-822-03LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.021683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-822-03LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003459s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442196 AND `partno` = '77311-822-03LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852391 [ RunTime:0.026432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442750 LIMIT 5 [ RunTime:0.006818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442750 ORDER BY `minOrder` ASC [ RunTime:0.013400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442750 ORDER BY `unit` DESC [ RunTime:0.053648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442750 LIMIT 2 [ RunTime:0.002685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442750 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
select * from pdf where partno='77311-138-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.016757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-138-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.034851s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442750 AND `partno` = '77311-138-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.026968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197461 [ RunTime:0.019810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442592 LIMIT 5 [ RunTime:0.010892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442592 ORDER BY `minOrder` ASC [ RunTime:0.051934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442592 ORDER BY `unit` DESC [ RunTime:0.009900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442592 LIMIT 2 [ RunTime:0.015154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442592 ORDER BY `minOrder` ASC [ RunTime:0.002880s ]
select * from pdf where partno='77315-422-06LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.033356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-422-06LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006612s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442592 AND `partno` = '77315-422-06LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850992 [ RunTime:0.029522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448057 LIMIT 5 [ RunTime:0.036525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448057 ORDER BY `minOrder` ASC [ RunTime:0.029966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448057 ORDER BY `unit` DESC [ RunTime:0.002213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448057 LIMIT 2 [ RunTime:0.007524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448057 ORDER BY `minOrder` ASC [ RunTime:0.002442s ]
select * from pdf where partno='77315-422-03LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.021418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-422-03LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012987s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448057 AND `partno` = '77315-422-03LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.014627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847948 [ RunTime:0.007939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448051 LIMIT 5 [ RunTime:0.019971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448051 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448051 ORDER BY `unit` DESC [ RunTime:0.008258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448051 LIMIT 2 [ RunTime:0.013825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448051 ORDER BY `minOrder` ASC [ RunTime:0.001187s ]
select * from pdf where partno='77311-103-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.022235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-103-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.009995s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448051 AND `partno` = '77311-103-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.017047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234590 [ RunTime:0.024780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442186 LIMIT 5 [ RunTime:0.006077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442186 ORDER BY `minOrder` ASC [ RunTime:0.004008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442186 ORDER BY `unit` DESC [ RunTime:0.006802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442186 LIMIT 2 [ RunTime:0.017538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442186 ORDER BY `minOrder` ASC [ RunTime:0.004017s ]
select * from pdf where partno='77311-802-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.016955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-802-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.016650s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442186 AND `partno` = '77311-802-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.006561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19814265 [ RunTime:0.002317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442260 LIMIT 5 [ RunTime:0.006833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442260 ORDER BY `minOrder` ASC [ RunTime:0.006790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442260 ORDER BY `unit` DESC [ RunTime:0.002365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442260 LIMIT 2 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442260 ORDER BY `minOrder` ASC [ RunTime:0.010453s ]
select * from pdf where partno='77313-124-04LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77313-124-04LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.005339s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442260 AND `partno` = '77313-124-04LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.021222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236375 [ RunTime:0.009145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442247 LIMIT 5 [ RunTime:0.010255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442247 ORDER BY `minOrder` ASC [ RunTime:0.004336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442247 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442247 LIMIT 2 [ RunTime:0.016216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442247 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
select * from pdf where partno='77315-118-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-118-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004308s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442247 AND `partno` = '77315-118-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.018138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847929 [ RunTime:0.002043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442146 LIMIT 5 [ RunTime:0.008959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442146 ORDER BY `minOrder` ASC [ RunTime:0.020957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442146 ORDER BY `unit` DESC [ RunTime:0.022817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442146 LIMIT 2 [ RunTime:0.004789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442146 ORDER BY `minOrder` ASC [ RunTime:0.025441s ]
select * from pdf where partno='77311-424-03LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.016823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-424-03LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.018279s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442146 AND `partno` = '77311-424-03LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.018832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847324 [ RunTime:0.008199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442233 LIMIT 5 [ RunTime:0.013309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442233 ORDER BY `minOrder` ASC [ RunTime:0.008477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442233 ORDER BY `unit` DESC [ RunTime:0.009126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442233 LIMIT 2 [ RunTime:0.016839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442233 ORDER BY `minOrder` ASC [ RunTime:0.004723s ]
select * from pdf where partno='77315-101-02LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77315-101-02LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.023060s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442233 AND `partno` = '77315-101-02LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.015412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234608 [ RunTime:0.004798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59436329 LIMIT 5 [ RunTime:0.028573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59436329 ORDER BY `minOrder` ASC [ RunTime:0.021720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59436329 ORDER BY `unit` DESC [ RunTime:0.013386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59436329 LIMIT 2 [ RunTime:0.024345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59436329 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
select * from pdf where partno='77311-818-04LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.039983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77311-818-04LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.045022s ]
SELECT `id` FROM `stock` WHERE `id` <> 59436329 AND `partno` = '77311-818-04LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.025966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847959 [ RunTime:0.025164s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017965s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005487s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010703s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003988s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023058s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005050s ]
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 '773%' OR `brand` LIKE '773%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032105s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '773%' OR `brand` LIKE '773%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.043404s ]