SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001333s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.12' , `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=480&search=1' [ RunTime:0.003615s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001664s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002507s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001643s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.12' ) [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001329s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001695s ]
SELECT * FROM `stock_search` WHERE `partno` = '480' LIMIT 1 [ RunTime:0.000514s ]
UPDATE `stock_search` SET `count` = 25 , `updatetime` = '2026-10-20 08:31:18' WHERE `partno` = '480' [ RunTime:0.001896s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001346s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034262s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12567 LIMIT 5 [ RunTime:0.000429s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12567 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12567 ORDER BY `unit` DESC [ RunTime:0.000782s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12567 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12567 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4803-187' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.001006s ]
SELECT `id` FROM `stock` WHERE `id` <> 12567 AND `partno` = '4803-187' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jst%' ) [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926494 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926494 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926494 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926494 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926494 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611148 LIMIT 5 [ RunTime:0.001264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611148 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611148 ORDER BY `unit` DESC [ RunTime:0.000272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611148 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611148 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418349 LIMIT 5 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418349 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418349 ORDER BY `unit` DESC [ RunTime:0.000317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418349 LIMIT 2 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418349 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308294 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308294 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13308294 ORDER BY `unit` DESC [ RunTime:0.000246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13308294 LIMIT 2 [ RunTime:0.000233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308294 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926495 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926495 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926495 ORDER BY `unit` DESC [ RunTime:0.001089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926495 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926495 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12035840 LIMIT 5 [ RunTime:0.001102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12035840 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12035840 ORDER BY `unit` DESC [ RunTime:0.000842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12035840 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12035840 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609378 LIMIT 5 [ RunTime:0.000946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609378 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609378 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609378 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609378 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609983 LIMIT 5 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609983 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609983 ORDER BY `unit` DESC [ RunTime:0.000543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609983 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609983 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418366 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418366 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418366 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418366 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418366 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12035862 LIMIT 5 [ RunTime:0.000939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12035862 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12035862 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12035862 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12035862 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629266 LIMIT 5 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629266 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629266 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629266 LIMIT 2 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629266 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610026 LIMIT 5 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610026 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610026 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610026 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610026 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481756 LIMIT 5 [ RunTime:0.002943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481756 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481756 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481756 LIMIT 2 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481756 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482278 LIMIT 5 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482278 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482278 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482278 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482278 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418370 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418370 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418370 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418370 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418370 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609862 LIMIT 5 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609862 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609862 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609862 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609862 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13318039 LIMIT 5 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13318039 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13318039 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13318039 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13318039 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519164 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519164 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519164 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519164 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519164 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418664 LIMIT 5 [ RunTime:0.001877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418664 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418664 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418664 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418664 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71806675 LIMIT 5 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71806675 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71806675 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71806675 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71806675 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='480416-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480416-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.013576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276505 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276505 ORDER BY `minOrder` ASC [ RunTime:0.002005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276505 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276505 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276505 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='48052-000lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48052-000lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.000466s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276505 AND `partno` = '48052-000lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71807604 LIMIT 5 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807604 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71807604 ORDER BY `unit` DESC [ RunTime:0.000827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71807604 LIMIT 2 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807604 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
select * from pdf where partno='48049-000lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48049-000lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.000608s ]
SELECT `id` FROM `stock` WHERE `id` <> 71807604 AND `partno` = '48049-000lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71789579 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71789579 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71789579 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71789579 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71789579 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
select * from pdf where partno='48099-4000' and brandshort='molex' limit 1 [ RunTime:0.000864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48099-4000' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71787372 LIMIT 5 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787372 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71787372 ORDER BY `unit` DESC [ RunTime:0.000602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71787372 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787372 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='4808-3004-cp' and brandshort='3m electronic solutions division' limit 1 [ RunTime:0.000995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4808-3004-cp' OR `brand` LIKE '3m electronic solutions division%' ) ) LIMIT 1 [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71788445 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788445 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71788445 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71788445 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788445 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='48037-1000' and brandshort='molex' limit 1 [ RunTime:0.001079s ]
select foldpath,foldpath2,filename from pdf_file where id=766122 limit 1 [ RunTime:0.000481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48037-1000' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71789878 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71789878 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71789878 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71789878 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71789878 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
select * from pdf where partno='48099-5701' and brandshort='molex' limit 1 [ RunTime:0.000508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48099-5701' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71788446 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788446 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71788446 ORDER BY `unit` DESC [ RunTime:0.000497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71788446 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788446 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='48037-2200' and brandshort='molex' limit 1 [ RunTime:0.001474s ]
select foldpath,foldpath2,filename from pdf_file where id=766126 limit 1 [ RunTime:0.000383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48037-2200' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811740 LIMIT 5 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811740 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811740 ORDER BY `unit` DESC [ RunTime:0.000552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811740 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811740 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='480053-3' and brandshort='te connectivity' limit 1 [ RunTime:0.001212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480053-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.018309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71788444 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788444 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71788444 ORDER BY `unit` DESC [ RunTime:0.000503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71788444 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788444 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='48037-0001' and brandshort='molex' limit 1 [ RunTime:0.001464s ]
select foldpath,foldpath2,filename from pdf_file where id=766120 limit 1 [ RunTime:0.000476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48037-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.013642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71787542 LIMIT 5 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787542 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71787542 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71787542 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787542 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='48037-2100' and brandshort='molex' limit 1 [ RunTime:0.000720s ]
select foldpath,foldpath2,filename from pdf_file where id=766125 limit 1 [ RunTime:0.000347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48037-2100' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811741 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811741 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811741 ORDER BY `unit` DESC [ RunTime:0.000309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811741 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811741 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='480054-5' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480054-5' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000338s ]
SELECT `id` FROM `stock` WHERE `id` <> 71811741 AND `partno` = '480054-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281357 LIMIT 5 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281357 ORDER BY `minOrder` ASC [ RunTime:0.001337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281357 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281357 LIMIT 2 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281357 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='480053-4' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480053-4' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000338s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281357 AND `partno` = '480053-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71810742 LIMIT 5 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71810742 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71810742 ORDER BY `unit` DESC [ RunTime:0.000248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71810742 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71810742 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='480764-9' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480764-9' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000386s ]
SELECT `id` FROM `stock` WHERE `id` <> 71810742 AND `partno` = '480764-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71787371 LIMIT 5 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787371 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71787371 ORDER BY `unit` DESC [ RunTime:0.000288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71787371 LIMIT 2 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787371 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='4808-3000-cp' and brandshort='3m electronic solutions division' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4808-3000-cp' OR `brand` LIKE '3m electronic solutions division%' ) ) LIMIT 1 [ RunTime:0.001660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309285 LIMIT 5 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309285 ORDER BY `minOrder` ASC [ RunTime:0.002982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309285 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309285 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309285 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='48000k' and brandshort='spotsee' limit 1 [ RunTime:0.000478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48000k' OR `brand` LIKE 'spotsee%' ) ) LIMIT 1 [ RunTime:0.000599s ]
SELECT `id` FROM `stock` WHERE `id` <> 32309285 AND `partno` = '48000k' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%spotsee%' ) [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71833637 LIMIT 5 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71833637 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71833637 ORDER BY `unit` DESC [ RunTime:0.000306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71833637 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71833637 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='4808' and brandshort='adafruit' limit 1 [ RunTime:0.003245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4808' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279083 LIMIT 5 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279083 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279083 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279083 LIMIT 2 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279083 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='48025-0091' and brandshort='molex' limit 1 [ RunTime:0.000817s ]
select foldpath,foldpath2,filename from pdf_file where id=766112 limit 1 [ RunTime:0.000323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48025-0091' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.006199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71802371 LIMIT 5 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71802371 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71802371 ORDER BY `unit` DESC [ RunTime:0.000270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71802371 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71802371 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='4802.1310' and brandshort='schurter' limit 1 [ RunTime:0.001053s ]
select foldpath,foldpath2,filename from pdf_file where id=1821981 limit 1 [ RunTime:0.000918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4802.1310' OR `brand` LIKE 'schurter%' ) ) LIMIT 1 [ RunTime:0.002094s ]
SELECT `id` FROM `stock` WHERE `id` <> 71802371 AND `partno` = '4802.1310' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter%' ) [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11675477 [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71802275 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71802275 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71802275 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71802275 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71802275 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='4802.2300' and brandshort='schurter' limit 1 [ RunTime:0.000696s ]
select foldpath,foldpath2,filename from pdf_file where id=2032640 limit 1 [ RunTime:0.000355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4802.2300' OR `brand` LIKE 'schurter%' ) ) LIMIT 1 [ RunTime:0.001497s ]
SELECT `id` FROM `stock` WHERE `id` <> 71802275 AND `partno` = '4802.2300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter%' ) [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12869659 [ RunTime:0.000519s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154470 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154470 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154470 ORDER BY `unit` DESC [ RunTime:0.000808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154470 LIMIT 2 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154470 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
select * from pdf where partno='48051-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48051-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000811s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154470 AND `partno` = '48051-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611148 [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155930 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155930 ORDER BY `minOrder` ASC [ RunTime:0.001846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155930 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155930 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155930 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='48050-002LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48050-002LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000639s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155930 AND `partno` = '48050-002LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482304 [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154476 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154476 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154476 ORDER BY `unit` DESC [ RunTime:0.000866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154476 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154476 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
select * from pdf where partno='48051-002LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48051-002LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000860s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154476 AND `partno` = '48051-002LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481645 [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155817 LIMIT 5 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155817 ORDER BY `minOrder` ASC [ RunTime:0.001035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155817 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155817 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155817 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
select * from pdf where partno='48045-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48045-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000552s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155817 AND `partno` = '48045-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609378 [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70171450 LIMIT 5 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171450 ORDER BY `minOrder` ASC [ RunTime:0.001087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70171450 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70171450 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171450 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='4802' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4802' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000677s ]
SELECT `id` FROM `stock` WHERE `id` <> 70171450 AND `partno` = '4802' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308294 [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67156619 LIMIT 5 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67156619 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67156619 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67156619 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67156619 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='48050-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48050-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000592s ]
SELECT `id` FROM `stock` WHERE `id` <> 67156619 AND `partno` = '48050-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609983 [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70171433 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171433 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70171433 ORDER BY `unit` DESC [ RunTime:0.001164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70171433 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171433 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
select * from pdf where partno='4800' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4800' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001352s ]
SELECT `id` FROM `stock` WHERE `id` <> 70171433 AND `partno` = '4800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12035840 [ RunTime:0.000656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67779900 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67779900 ORDER BY `minOrder` ASC [ RunTime:0.001309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67779900 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67779900 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67779900 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
select * from pdf where partno='4808-3004-CP' and brandshort='3M' limit 1 [ RunTime:0.000776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4808-3004-CP' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002806s ]
SELECT `id` FROM `stock` WHERE `id` <> 67779900 AND `partno` = '4808-3004-CP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926494 [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155874 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155874 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155874 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155874 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155874 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='48046-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48046-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000731s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155874 AND `partno` = '48046-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482278 [ RunTime:0.000632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70171457 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171457 ORDER BY `minOrder` ASC [ RunTime:0.000709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70171457 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70171457 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171457 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
select * from pdf where partno='4801' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4801' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000729s ]
SELECT `id` FROM `stock` WHERE `id` <> 70171457 AND `partno` = '4801' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308298 [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67779888 LIMIT 5 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67779888 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67779888 ORDER BY `unit` DESC [ RunTime:0.000580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67779888 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67779888 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
select * from pdf where partno='4808-3000-CP' and brandshort='3M' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4808-3000-CP' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002737s ]
SELECT `id` FROM `stock` WHERE `id` <> 67779888 AND `partno` = '4808-3000-CP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926495 [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66750610 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66750610 ORDER BY `minOrder` ASC [ RunTime:0.001133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66750610 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66750610 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66750610 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
select * from pdf where partno='480763-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480763-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000729s ]
SELECT `id` FROM `stock` WHERE `id` <> 66750610 AND `partno` = '480763-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629266 [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67157025 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67157025 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67157025 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67157025 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67157025 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
select * from pdf where partno='48047-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48047-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000947s ]
SELECT `id` FROM `stock` WHERE `id` <> 67157025 AND `partno` = '48047-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481756 [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155880 LIMIT 5 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155880 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155880 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155880 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155880 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
select * from pdf where partno='48049-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48049-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000698s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155880 AND `partno` = '48049-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609423 [ RunTime:0.001224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67130665 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130665 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67130665 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67130665 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130665 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
select * from pdf where partno='480053-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480053-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000743s ]
SELECT `id` FROM `stock` WHERE `id` <> 67130665 AND `partno` = '480053-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418370 [ RunTime:0.000670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70172080 LIMIT 5 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70172080 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70172080 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70172080 LIMIT 2 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70172080 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
select * from pdf where partno='4803' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4803' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000723s ]
SELECT `id` FROM `stock` WHERE `id` <> 70172080 AND `partno` = '4803' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67130623 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130623 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67130623 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67130623 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130623 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='480435-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480435-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001110s ]
SELECT `id` FROM `stock` WHERE `id` <> 67130623 AND `partno` = '480435-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418349 [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67130660 LIMIT 5 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130660 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67130660 ORDER BY `unit` DESC [ RunTime:0.000553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67130660 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130660 ORDER BY `minOrder` ASC [ RunTime:0.000612s ]
select * from pdf where partno='480054-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480054-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000695s ]
SELECT `id` FROM `stock` WHERE `id` <> 67130660 AND `partno` = '480054-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67130748 LIMIT 5 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130748 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67130748 ORDER BY `unit` DESC [ RunTime:0.000539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67130748 LIMIT 2 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67130748 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
select * from pdf where partno='480416-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480416-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000735s ]
SELECT `id` FROM `stock` WHERE `id` <> 67130748 AND `partno` = '480416-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418366 [ RunTime:0.000563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70172135 LIMIT 5 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70172135 ORDER BY `minOrder` ASC [ RunTime:0.000930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70172135 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70172135 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70172135 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
select * from pdf where partno='4806' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4806' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 70172135 AND `partno` = '4806' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12035862 [ RunTime:0.000598s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001337s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001267s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001170s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001202s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001228s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001163s ]
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 '480%' OR `brand` LIKE '480%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64840150 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840150 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64840150 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64840150 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840150 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='480994000' and brandshort='MOLEX' limit 1 [ RunTime:0.000845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '480994000' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.008248s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '480%' OR `brand` LIKE '480%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003632s ]