SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002619s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=4846&search=1' [ RunTime:0.002105s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002002s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001246s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000983s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014788s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001829s ]
SELECT * FROM `stock_search` WHERE `partno` = '4846' LIMIT 1 [ RunTime:0.002724s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-16 15:42:51' WHERE `partno` = '4846' [ RunTime:0.012559s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001316s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016789s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.031658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14634115 LIMIT 5 [ RunTime:0.027832s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14634115 ORDER BY `minOrder` ASC [ RunTime:0.036985s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14634115 ORDER BY `unit` DESC [ RunTime:0.056753s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.047418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14634115 LIMIT 2 [ RunTime:0.032850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14634115 ORDER BY `minOrder` ASC [ RunTime:0.051039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799580 LIMIT 5 [ RunTime:0.057085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799580 ORDER BY `minOrder` ASC [ RunTime:0.049450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799580 ORDER BY `unit` DESC [ RunTime:0.073618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799580 LIMIT 2 [ RunTime:0.059924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799580 ORDER BY `minOrder` ASC [ RunTime:0.031897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792090 LIMIT 5 [ RunTime:0.029287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792090 ORDER BY `minOrder` ASC [ RunTime:0.067164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792090 ORDER BY `unit` DESC [ RunTime:0.060355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792090 LIMIT 2 [ RunTime:0.015609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792090 ORDER BY `minOrder` ASC [ RunTime:0.029510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609929 LIMIT 5 [ RunTime:0.058383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609929 ORDER BY `minOrder` ASC [ RunTime:0.030173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609929 ORDER BY `unit` DESC [ RunTime:0.134150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609929 LIMIT 2 [ RunTime:0.046732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609929 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041049 LIMIT 5 [ RunTime:0.037122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041049 ORDER BY `minOrder` ASC [ RunTime:0.014463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041049 ORDER BY `unit` DESC [ RunTime:0.023494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041049 LIMIT 2 [ RunTime:0.027133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041049 ORDER BY `minOrder` ASC [ RunTime:0.009922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14349159 LIMIT 5 [ RunTime:0.028483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14349159 ORDER BY `minOrder` ASC [ RunTime:0.005578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14349159 ORDER BY `unit` DESC [ RunTime:0.003486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14349159 LIMIT 2 [ RunTime:0.036613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14349159 ORDER BY `minOrder` ASC [ RunTime:0.012439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13751616 LIMIT 5 [ RunTime:0.018883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13751616 ORDER BY `minOrder` ASC [ RunTime:0.020291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13751616 ORDER BY `unit` DESC [ RunTime:0.042820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13751616 LIMIT 2 [ RunTime:0.019582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13751616 ORDER BY `minOrder` ASC [ RunTime:0.010145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628037 LIMIT 5 [ RunTime:0.010920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628037 ORDER BY `minOrder` ASC [ RunTime:0.008965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14628037 ORDER BY `unit` DESC [ RunTime:0.009739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14628037 LIMIT 2 [ RunTime:0.017609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628037 ORDER BY `minOrder` ASC [ RunTime:0.027837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16583462 LIMIT 5 [ RunTime:0.029810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16583462 ORDER BY `minOrder` ASC [ RunTime:0.027068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16583462 ORDER BY `unit` DESC [ RunTime:0.024182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16583462 LIMIT 2 [ RunTime:0.013391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16583462 ORDER BY `minOrder` ASC [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628054 LIMIT 5 [ RunTime:0.009376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628054 ORDER BY `minOrder` ASC [ RunTime:0.017396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14628054 ORDER BY `unit` DESC [ RunTime:0.008175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14628054 LIMIT 2 [ RunTime:0.008134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628054 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11982759 LIMIT 5 [ RunTime:0.003722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11982759 ORDER BY `minOrder` ASC [ RunTime:0.012264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11982759 ORDER BY `unit` DESC [ RunTime:0.011844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11982759 LIMIT 2 [ RunTime:0.001367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11982759 ORDER BY `minOrder` ASC [ RunTime:0.011687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13754924 LIMIT 5 [ RunTime:0.003274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13754924 ORDER BY `minOrder` ASC [ RunTime:0.000793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13754924 ORDER BY `unit` DESC [ RunTime:0.004174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13754924 LIMIT 2 [ RunTime:0.004792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13754924 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18620301 LIMIT 5 [ RunTime:0.001256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18620301 ORDER BY `minOrder` ASC [ RunTime:0.001824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18620301 ORDER BY `unit` DESC [ RunTime:0.008034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18620301 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18620301 ORDER BY `minOrder` ASC [ RunTime:0.002202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16597930 LIMIT 5 [ RunTime:0.003642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16597930 ORDER BY `minOrder` ASC [ RunTime:0.001742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16597930 ORDER BY `unit` DESC [ RunTime:0.011696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16597930 LIMIT 2 [ RunTime:0.017640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16597930 ORDER BY `minOrder` ASC [ RunTime:0.003561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16597898 LIMIT 5 [ RunTime:0.003273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16597898 ORDER BY `minOrder` ASC [ RunTime:0.006402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16597898 ORDER BY `unit` DESC [ RunTime:0.000732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16597898 LIMIT 2 [ RunTime:0.001758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16597898 ORDER BY `minOrder` ASC [ RunTime:0.008197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16588128 LIMIT 5 [ RunTime:0.002688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16588128 ORDER BY `minOrder` ASC [ RunTime:0.001862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16588128 ORDER BY `unit` DESC [ RunTime:0.011319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16588128 LIMIT 2 [ RunTime:0.008411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16588128 ORDER BY `minOrder` ASC [ RunTime:0.004157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15257757 LIMIT 5 [ RunTime:0.003052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15257757 ORDER BY `minOrder` ASC [ RunTime:0.029347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15257757 ORDER BY `unit` DESC [ RunTime:0.007824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15257757 LIMIT 2 [ RunTime:0.003249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15257757 ORDER BY `minOrder` ASC [ RunTime:0.002602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14644424 LIMIT 5 [ RunTime:0.001166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14644424 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14644424 ORDER BY `unit` DESC [ RunTime:0.005090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14644424 LIMIT 2 [ RunTime:0.011743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14644424 ORDER BY `minOrder` ASC [ RunTime:0.004624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14644423 LIMIT 5 [ RunTime:0.002162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14644423 ORDER BY `minOrder` ASC [ RunTime:0.008193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14644423 ORDER BY `unit` DESC [ RunTime:0.008735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14644423 LIMIT 2 [ RunTime:0.001005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14644423 ORDER BY `minOrder` ASC [ RunTime:0.003084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14644400 LIMIT 5 [ RunTime:0.003446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14644400 ORDER BY `minOrder` ASC [ RunTime:0.006478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14644400 ORDER BY `unit` DESC [ RunTime:0.000781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14644400 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14644400 ORDER BY `minOrder` ASC [ RunTime:0.001733s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007609s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59947964 LIMIT 5 [ RunTime:0.013832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947964 ORDER BY `minOrder` ASC [ RunTime:0.008536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59947964 ORDER BY `unit` DESC [ RunTime:0.005414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59947964 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947964 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='484661-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.004848s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484661-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.007654s ]
SELECT `id` FROM `stock` WHERE `id` <> 59947964 AND `partno` = '484661-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.008344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58341493 LIMIT 5 [ RunTime:0.013935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58341493 ORDER BY `minOrder` ASC [ RunTime:0.014484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58341493 ORDER BY `unit` DESC [ RunTime:0.019692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58341493 LIMIT 2 [ RunTime:0.008449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58341493 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='484607000' and brandshort='C&K' limit 1 [ RunTime:0.017386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484607000' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.029287s ]
SELECT `id` FROM `stock` WHERE `id` <> 58341493 AND `partno` = '484607000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.010566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63392326 LIMIT 5 [ RunTime:0.002840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392326 ORDER BY `minOrder` ASC [ RunTime:0.012949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63392326 ORDER BY `unit` DESC [ RunTime:0.001906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63392326 LIMIT 2 [ RunTime:0.009034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392326 ORDER BY `minOrder` ASC [ RunTime:0.007599s ]
select * from pdf where partno='4846' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.005278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.013383s ]
SELECT `id` FROM `stock` WHERE `id` <> 63392326 AND `partno` = '4846' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.014469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041049 [ RunTime:0.007351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59907498 LIMIT 5 [ RunTime:0.016444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907498 ORDER BY `minOrder` ASC [ RunTime:0.015280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59907498 ORDER BY `unit` DESC [ RunTime:0.005581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59907498 LIMIT 2 [ RunTime:0.004026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907498 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='484655-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.010372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484655-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.001488s ]
SELECT `id` FROM `stock` WHERE `id` <> 59907498 AND `partno` = '484655-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.015385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799580 [ RunTime:0.019450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359869 LIMIT 5 [ RunTime:0.008512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359869 ORDER BY `minOrder` ASC [ RunTime:0.012047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359869 ORDER BY `unit` DESC [ RunTime:0.005880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359869 LIMIT 2 [ RunTime:0.008211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359869 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='484619-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.001467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484619-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.000903s ]
SELECT `id` FROM `stock` WHERE `id` <> 59359869 AND `partno` = '484619-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.011294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792090 [ RunTime:0.008224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62454180 LIMIT 5 [ RunTime:0.013045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62454180 ORDER BY `minOrder` ASC [ RunTime:0.008334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62454180 ORDER BY `unit` DESC [ RunTime:0.009658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62454180 LIMIT 2 [ RunTime:0.004436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62454180 ORDER BY `minOrder` ASC [ RunTime:0.012584s ]
select * from pdf where partno='4846-UU-60' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.010562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-UU-60' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.015628s ]
SELECT `id` FROM `stock` WHERE `id` <> 62454180 AND `partno` = '4846-UU-60' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.013775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14634115 [ RunTime:0.005511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62838678 LIMIT 5 [ RunTime:0.004968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62838678 ORDER BY `minOrder` ASC [ RunTime:0.013817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62838678 ORDER BY `unit` DESC [ RunTime:0.007729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62838678 LIMIT 2 [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62838678 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='4846-UU-36' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.001168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-UU-36' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.001576s ]
SELECT `id` FROM `stock` WHERE `id` <> 62838678 AND `partno` = '4846-UU-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.007060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13751616 [ RunTime:0.007764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297910 LIMIT 5 [ RunTime:0.004332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297910 ORDER BY `minOrder` ASC [ RunTime:0.012564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297910 ORDER BY `unit` DESC [ RunTime:0.003299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297910 LIMIT 2 [ RunTime:0.014633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297910 ORDER BY `minOrder` ASC [ RunTime:0.006520s ]
select * from pdf where partno='4846' and brandshort='Pololu' limit 1 [ RunTime:0.010192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.004025s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297910 AND `partno` = '4846' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.021254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14349159 [ RunTime:0.001535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62838889 LIMIT 5 [ RunTime:0.002115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62838889 ORDER BY `minOrder` ASC [ RunTime:0.003329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62838889 ORDER BY `unit` DESC [ RunTime:0.000522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62838889 LIMIT 2 [ RunTime:0.006623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62838889 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
select * from pdf where partno='4846-UU-12' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.011174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-UU-12' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.018200s ]
SELECT `id` FROM `stock` WHERE `id` <> 62838889 AND `partno` = '4846-UU-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.011034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628037 [ RunTime:0.012519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62839003 LIMIT 5 [ RunTime:0.002612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62839003 ORDER BY `minOrder` ASC [ RunTime:0.016895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62839003 ORDER BY `unit` DESC [ RunTime:0.005647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62839003 LIMIT 2 [ RunTime:0.012944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62839003 ORDER BY `minOrder` ASC [ RunTime:0.006879s ]
select * from pdf where partno='4846-UU-48' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.001957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-UU-48' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.011744s ]
SELECT `id` FROM `stock` WHERE `id` <> 62839003 AND `partno` = '4846-UU-48' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.017372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16583462 [ RunTime:0.012513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62838941 LIMIT 5 [ RunTime:0.006910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62838941 ORDER BY `minOrder` ASC [ RunTime:0.002935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62838941 ORDER BY `unit` DESC [ RunTime:0.001006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62838941 LIMIT 2 [ RunTime:0.009734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62838941 ORDER BY `minOrder` ASC [ RunTime:0.002616s ]
select * from pdf where partno='4846-UU-24' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.019168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-UU-24' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.001633s ]
SELECT `id` FROM `stock` WHERE `id` <> 62838941 AND `partno` = '4846-UU-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.011251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628054 [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64192399 LIMIT 5 [ RunTime:0.009380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192399 ORDER BY `minOrder` ASC [ RunTime:0.021636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64192399 ORDER BY `unit` DESC [ RunTime:0.015357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64192399 LIMIT 2 [ RunTime:0.003075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192399 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='4846-6010-40' and brandshort='Amphenol XMA' limit 1 [ RunTime:0.001750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-6010-40' OR `brand` LIKE 'Amphenol XMA%' ) ) LIMIT 1 [ RunTime:0.006049s ]
SELECT `id` FROM `stock` WHERE `id` <> 64192399 AND `partno` = '4846-6010-40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol xma%' ) [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11982759 [ RunTime:0.000724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359868 LIMIT 5 [ RunTime:0.014009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359868 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359868 ORDER BY `unit` DESC [ RunTime:0.017209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359868 LIMIT 2 [ RunTime:0.003068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359868 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
select * from pdf where partno='484618-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.001920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484618-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.004746s ]
SELECT `id` FROM `stock` WHERE `id` <> 59359868 AND `partno` = '484618-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609929 [ RunTime:0.007020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62855073 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62855073 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62855073 ORDER BY `unit` DESC [ RunTime:0.014583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62855073 LIMIT 2 [ RunTime:0.006344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62855073 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
select * from pdf where partno='4846-K-48' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.001122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-K-48' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.014288s ]
SELECT `id` FROM `stock` WHERE `id` <> 62855073 AND `partno` = '4846-K-48' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.012731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16588128 [ RunTime:0.002612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62855072 LIMIT 5 [ RunTime:0.001145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62855072 ORDER BY `minOrder` ASC [ RunTime:0.004733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62855072 ORDER BY `unit` DESC [ RunTime:0.006916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62855072 LIMIT 2 [ RunTime:0.011802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62855072 ORDER BY `minOrder` ASC [ RunTime:0.001562s ]
select * from pdf where partno='4846-K-24' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.003215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-K-24' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.009811s ]
SELECT `id` FROM `stock` WHERE `id` <> 62855072 AND `partno` = '4846-K-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.001225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14633208 [ RunTime:0.016973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62846701 LIMIT 5 [ RunTime:0.004878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62846701 ORDER BY `minOrder` ASC [ RunTime:0.001779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62846701 ORDER BY `unit` DESC [ RunTime:0.002177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62846701 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62846701 ORDER BY `minOrder` ASC [ RunTime:0.002616s ]
select * from pdf where partno='4846-C-12' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.002266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846-C-12' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.000455s ]
SELECT `id` FROM `stock` WHERE `id` <> 62846701 AND `partno` = '4846-C-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.008978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14630532 [ RunTime:0.002446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623369 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623369 ORDER BY `minOrder` ASC [ RunTime:0.024783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623369 ORDER BY `unit` DESC [ RunTime:0.008941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623369 LIMIT 2 [ RunTime:0.006902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623369 ORDER BY `minOrder` ASC [ RunTime:0.005172s ]
select * from pdf where partno='4846.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.014908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4846.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.019357s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623369 AND `partno` = '4846.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.012299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59915790 LIMIT 5 [ RunTime:0.012472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915790 ORDER BY `minOrder` ASC [ RunTime:0.019219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59915790 ORDER BY `unit` DESC [ RunTime:0.048215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59915790 LIMIT 2 [ RunTime:0.001223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915790 ORDER BY `minOrder` ASC [ RunTime:0.010726s ]
select * from pdf where partno='484661-E' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484661-E' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004794s ]
SELECT `id` FROM `stock` WHERE `id` <> 59915790 AND `partno` = '484661-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803614 [ RunTime:0.011015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59915620 LIMIT 5 [ RunTime:0.005760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915620 ORDER BY `minOrder` ASC [ RunTime:0.009126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59915620 ORDER BY `unit` DESC [ RunTime:0.039080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59915620 LIMIT 2 [ RunTime:0.070279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915620 ORDER BY `minOrder` ASC [ RunTime:0.012059s ]
select * from pdf where partno='484642-E' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484642-E' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026228s ]
SELECT `id` FROM `stock` WHERE `id` <> 59915620 AND `partno` = '484642-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.030134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11618455 [ RunTime:0.008744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59915615 LIMIT 5 [ RunTime:0.031800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915615 ORDER BY `minOrder` ASC [ RunTime:0.008878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59915615 ORDER BY `unit` DESC [ RunTime:0.007724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59915615 LIMIT 2 [ RunTime:0.011972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915615 ORDER BY `minOrder` ASC [ RunTime:0.013577s ]
select * from pdf where partno='484659-E' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '484659-E' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026892s ]
SELECT `id` FROM `stock` WHERE `id` <> 59915615 AND `partno` = '484659-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803499 [ RunTime:0.010437s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026288s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015923s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015502s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015077s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008335s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020717s ]
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 '4846%' OR `brand` LIKE '4846%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013347s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4846%' OR `brand` LIKE '4846%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009744s ]