SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001506s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.177' , `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=340&search=1' [ RunTime:0.012800s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002395s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002923s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.177' ) [ RunTime:0.005218s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002277s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002200s ]
SELECT * FROM `stock_search` WHERE `partno` = '340' LIMIT 1 [ RunTime:0.003226s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 13:05:56' WHERE `partno` = '340' [ RunTime:0.002110s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003428s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045541s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584057 LIMIT 5 [ RunTime:0.002748s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584057 ORDER BY `minOrder` ASC [ RunTime:0.008810s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584057 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584057 LIMIT 2 [ RunTime:0.008144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584057 ORDER BY `minOrder` ASC [ RunTime:0.002834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044986 LIMIT 5 [ RunTime:0.001232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044986 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12044986 ORDER BY `unit` DESC [ RunTime:0.000257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12044986 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044986 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441314 LIMIT 5 [ RunTime:0.001651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441314 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441314 ORDER BY `unit` DESC [ RunTime:0.003445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441314 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441314 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13812185 LIMIT 5 [ RunTime:0.003928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13812185 ORDER BY `minOrder` ASC [ RunTime:0.006415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13812185 ORDER BY `unit` DESC [ RunTime:0.008067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13812185 LIMIT 2 [ RunTime:0.005944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13812185 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441494 LIMIT 5 [ RunTime:0.008575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441494 ORDER BY `minOrder` ASC [ RunTime:0.003050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441494 ORDER BY `unit` DESC [ RunTime:0.011934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441494 LIMIT 2 [ RunTime:0.003475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441494 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582038 LIMIT 5 [ RunTime:0.000896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582038 ORDER BY `minOrder` ASC [ RunTime:0.017691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582038 ORDER BY `unit` DESC [ RunTime:0.010737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582038 LIMIT 2 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582038 ORDER BY `minOrder` ASC [ RunTime:0.002913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628655 LIMIT 5 [ RunTime:0.004836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628655 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16628655 ORDER BY `unit` DESC [ RunTime:0.001795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16628655 LIMIT 2 [ RunTime:0.003938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628655 ORDER BY `minOrder` ASC [ RunTime:0.004735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14703228 LIMIT 5 [ RunTime:0.008980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703228 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14703228 ORDER BY `unit` DESC [ RunTime:0.005547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14703228 LIMIT 2 [ RunTime:0.005994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703228 ORDER BY `minOrder` ASC [ RunTime:0.007350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13329058 LIMIT 5 [ RunTime:0.003423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13329058 ORDER BY `minOrder` ASC [ RunTime:0.011754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13329058 ORDER BY `unit` DESC [ RunTime:0.008259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13329058 LIMIT 2 [ RunTime:0.003399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13329058 ORDER BY `minOrder` ASC [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14703246 LIMIT 5 [ RunTime:0.002223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703246 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14703246 ORDER BY `unit` DESC [ RunTime:0.008365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14703246 LIMIT 2 [ RunTime:0.001071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703246 ORDER BY `minOrder` ASC [ RunTime:0.002238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704646 LIMIT 5 [ RunTime:0.004601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704646 ORDER BY `minOrder` ASC [ RunTime:0.004018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704646 ORDER BY `unit` DESC [ RunTime:0.001229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704646 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704646 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12049868 LIMIT 5 [ RunTime:0.007120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12049868 ORDER BY `minOrder` ASC [ RunTime:0.000998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12049868 ORDER BY `unit` DESC [ RunTime:0.000707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12049868 LIMIT 2 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12049868 ORDER BY `minOrder` ASC [ RunTime:0.002142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14703550 LIMIT 5 [ RunTime:0.001020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703550 ORDER BY `minOrder` ASC [ RunTime:0.012088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14703550 ORDER BY `unit` DESC [ RunTime:0.000678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14703550 LIMIT 2 [ RunTime:0.006864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703550 ORDER BY `minOrder` ASC [ RunTime:0.004463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584073 LIMIT 5 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584073 ORDER BY `minOrder` ASC [ RunTime:0.004840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584073 ORDER BY `unit` DESC [ RunTime:0.003904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584073 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584073 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13815192 LIMIT 5 [ RunTime:0.005274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13815192 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13815192 ORDER BY `unit` DESC [ RunTime:0.012606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13815192 LIMIT 2 [ RunTime:0.003719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13815192 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13812747 LIMIT 5 [ RunTime:0.004153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13812747 ORDER BY `minOrder` ASC [ RunTime:0.002159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13812747 ORDER BY `unit` DESC [ RunTime:0.004758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13812747 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13812747 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 225 LIMIT 5 [ RunTime:0.003248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 225 ORDER BY `minOrder` ASC [ RunTime:0.005779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 225 ORDER BY `unit` DESC [ RunTime:0.007805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 225 LIMIT 2 [ RunTime:0.014478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 225 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34080' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.009592s ]
SELECT `id` FROM `stock` WHERE `id` <> 225 AND `partno` = '34080' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.010331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16626715 LIMIT 5 [ RunTime:0.010153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16626715 ORDER BY `minOrder` ASC [ RunTime:0.021300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16626715 ORDER BY `unit` DESC [ RunTime:0.058775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16626715 LIMIT 2 [ RunTime:0.029191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16626715 ORDER BY `minOrder` ASC [ RunTime:0.010164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13813144 LIMIT 5 [ RunTime:0.035572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813144 ORDER BY `minOrder` ASC [ RunTime:0.008738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13813144 ORDER BY `unit` DESC [ RunTime:0.009323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13813144 LIMIT 2 [ RunTime:0.008666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813144 ORDER BY `minOrder` ASC [ RunTime:0.004945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16626716 LIMIT 5 [ RunTime:0.025419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16626716 ORDER BY `minOrder` ASC [ RunTime:0.007932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16626716 ORDER BY `unit` DESC [ RunTime:0.022873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16626716 LIMIT 2 [ RunTime:0.015123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16626716 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267656 LIMIT 5 [ RunTime:0.010808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267656 ORDER BY `minOrder` ASC [ RunTime:0.034340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267656 ORDER BY `unit` DESC [ RunTime:0.015874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267656 LIMIT 2 [ RunTime:0.024000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267656 ORDER BY `minOrder` ASC [ RunTime:0.008376s ]
select * from pdf where partno='34081-4001' and brandshort='molex' limit 1 [ RunTime:0.033468s ]
select foldpath,foldpath2,filename from pdf_file where id=762346 limit 1 [ RunTime:0.021106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-4001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.015428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267898 LIMIT 5 [ RunTime:0.003283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267898 ORDER BY `minOrder` ASC [ RunTime:0.008413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267898 ORDER BY `unit` DESC [ RunTime:0.001030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267898 LIMIT 2 [ RunTime:0.008975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267898 ORDER BY `minOrder` ASC [ RunTime:0.006363s ]
select * from pdf where partno='34081-5001' and brandshort='molex' limit 1 [ RunTime:0.006543s ]
select foldpath,foldpath2,filename from pdf_file where id=762350 limit 1 [ RunTime:0.002491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-5001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.018158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267504 LIMIT 5 [ RunTime:0.007312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267504 ORDER BY `minOrder` ASC [ RunTime:0.003990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267504 ORDER BY `unit` DESC [ RunTime:0.010681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267504 LIMIT 2 [ RunTime:0.007069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267504 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='34062-0023' and brandshort='molex' limit 1 [ RunTime:0.009824s ]
select foldpath,foldpath2,filename from pdf_file where id=762339 limit 1 [ RunTime:0.018029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-0023' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267896 LIMIT 5 [ RunTime:0.000976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267896 ORDER BY `minOrder` ASC [ RunTime:0.017672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267896 ORDER BY `unit` DESC [ RunTime:0.013856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267896 LIMIT 2 [ RunTime:0.008000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267896 ORDER BY `minOrder` ASC [ RunTime:0.010836s ]
select * from pdf where partno='34080-0206' and brandshort='molex' limit 1 [ RunTime:0.014962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34080-0206' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.020502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268136 LIMIT 5 [ RunTime:0.004375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268136 ORDER BY `minOrder` ASC [ RunTime:0.011449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268136 ORDER BY `unit` DESC [ RunTime:0.009588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268136 LIMIT 2 [ RunTime:0.004091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268136 ORDER BY `minOrder` ASC [ RunTime:0.008055s ]
select * from pdf where partno='34081-2004' and brandshort='molex' limit 1 [ RunTime:0.004282s ]
select foldpath,foldpath2,filename from pdf_file where id=762346 limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-2004' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.021873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268137 LIMIT 5 [ RunTime:0.009317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268137 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268137 ORDER BY `unit` DESC [ RunTime:0.001745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268137 LIMIT 2 [ RunTime:0.000830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268137 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='34081-3003' and brandshort='molex' limit 1 [ RunTime:0.008058s ]
select foldpath,foldpath2,filename from pdf_file where id=762350 limit 1 [ RunTime:0.001168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-3003' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267897 LIMIT 5 [ RunTime:0.004766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267897 ORDER BY `minOrder` ASC [ RunTime:0.002500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267897 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267897 LIMIT 2 [ RunTime:0.001533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267897 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='34081-2005' and brandshort='molex' limit 1 [ RunTime:0.003601s ]
select foldpath,foldpath2,filename from pdf_file where id=762347 limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-2005' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.015085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268030 LIMIT 5 [ RunTime:0.001860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268030 ORDER BY `minOrder` ASC [ RunTime:0.003372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268030 ORDER BY `unit` DESC [ RunTime:0.000557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268030 LIMIT 2 [ RunTime:0.014561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268030 ORDER BY `minOrder` ASC [ RunTime:0.006029s ]
select * from pdf where partno='34081-4002' and brandshort='molex' limit 1 [ RunTime:0.002897s ]
select foldpath,foldpath2,filename from pdf_file where id=762346 limit 1 [ RunTime:0.000989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-4002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.021172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267362 LIMIT 5 [ RunTime:0.021020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267362 ORDER BY `minOrder` ASC [ RunTime:0.012425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267362 ORDER BY `unit` DESC [ RunTime:0.005369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267362 LIMIT 2 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267362 ORDER BY `minOrder` ASC [ RunTime:0.003045s ]
select * from pdf where partno='34081-3005' and brandshort='molex' limit 1 [ RunTime:0.004740s ]
select foldpath,foldpath2,filename from pdf_file where id=762349 limit 1 [ RunTime:0.004694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-3005' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.018142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267436 LIMIT 5 [ RunTime:0.007813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267436 ORDER BY `minOrder` ASC [ RunTime:0.004941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267436 ORDER BY `unit` DESC [ RunTime:0.013701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267436 LIMIT 2 [ RunTime:0.002569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267436 ORDER BY `minOrder` ASC [ RunTime:0.009809s ]
select * from pdf where partno='34081-3004' and brandshort='molex' limit 1 [ RunTime:0.003584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-3004' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267466 LIMIT 5 [ RunTime:0.006941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267466 ORDER BY `minOrder` ASC [ RunTime:0.003236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267466 ORDER BY `unit` DESC [ RunTime:0.005151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267466 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267466 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
select * from pdf where partno='34080-1104' and brandshort='molex' limit 1 [ RunTime:0.006140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34080-1104' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267266 LIMIT 5 [ RunTime:0.001709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267266 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267266 ORDER BY `unit` DESC [ RunTime:0.001798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267266 LIMIT 2 [ RunTime:0.002216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267266 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='34062-0022' and brandshort='molex' limit 1 [ RunTime:0.000924s ]
select foldpath,foldpath2,filename from pdf_file where id=762339 limit 1 [ RunTime:0.009591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-0022' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.021797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267465 LIMIT 5 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267465 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267465 ORDER BY `unit` DESC [ RunTime:0.002347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267465 LIMIT 2 [ RunTime:0.001301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267465 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='34062-4003' and brandshort='molex' limit 1 [ RunTime:0.002693s ]
select foldpath,foldpath2,filename from pdf_file where id=1551941 limit 1 [ RunTime:0.003000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-4003' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.014654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267435 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267435 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267435 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267435 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267435 ORDER BY `minOrder` ASC [ RunTime:0.003199s ]
select * from pdf where partno='34062-0032' and brandshort='molex' limit 1 [ RunTime:0.001062s ]
select foldpath,foldpath2,filename from pdf_file where id=764065 limit 1 [ RunTime:0.001071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-0032' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267267 LIMIT 5 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267267 ORDER BY `minOrder` ASC [ RunTime:0.011717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267267 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267267 LIMIT 2 [ RunTime:0.009375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267267 ORDER BY `minOrder` ASC [ RunTime:0.003172s ]
select * from pdf where partno='34062-4009' and brandshort='molex' limit 1 [ RunTime:0.009260s ]
select foldpath,foldpath2,filename from pdf_file where id=1551941 limit 1 [ RunTime:0.006208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-4009' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267464 LIMIT 5 [ RunTime:0.001342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267464 ORDER BY `minOrder` ASC [ RunTime:0.002344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267464 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267464 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267464 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='34062-0037' and brandshort='molex' limit 1 [ RunTime:0.003018s ]
select foldpath,foldpath2,filename from pdf_file where id=2035111 limit 1 [ RunTime:0.000649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-0037' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267798 LIMIT 5 [ RunTime:0.001693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267798 ORDER BY `minOrder` ASC [ RunTime:0.001195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267798 ORDER BY `unit` DESC [ RunTime:0.001842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267798 LIMIT 2 [ RunTime:0.001260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267798 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='34062-4008' and brandshort='molex' limit 1 [ RunTime:0.001034s ]
select foldpath,foldpath2,filename from pdf_file where id=1551941 limit 1 [ RunTime:0.000349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-4008' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111107 LIMIT 5 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111107 ORDER BY `minOrder` ASC [ RunTime:0.001414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111107 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111107 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111107 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='3403' and brandshort='adafruit' limit 1 [ RunTime:0.002001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3403' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.004895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098609 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098609 ORDER BY `minOrder` ASC [ RunTime:0.001773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098609 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098609 LIMIT 2 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098609 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='3407na-ba-6' and brandshort='3m electronic solutions division' limit 1 [ RunTime:0.000854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3407na-ba-6' OR `brand` LIKE '3m electronic solutions division%' ) ) LIMIT 1 [ RunTime:0.000686s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098609 AND `partno` = '3407na-ba-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic solutions division%' ) [ RunTime:0.002581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028265 LIMIT 5 [ RunTime:0.001359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028265 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51028265 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51028265 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028265 ORDER BY `minOrder` ASC [ RunTime:0.002714s ]
select * from pdf where partno='340p14-u' and brandshort='that' limit 1 [ RunTime:0.001282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '340p14-u' OR `brand` LIKE 'that%' ) ) LIMIT 1 [ RunTime:0.000641s ]
SELECT `id` FROM `stock` WHERE `id` <> 51028265 AND `partno` = '340p14-u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%that%' ) [ RunTime:0.000645s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52486845 LIMIT 5 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52486845 ORDER BY `minOrder` ASC [ RunTime:0.001176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52486845 ORDER BY `unit` DESC [ RunTime:0.005825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52486845 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52486845 ORDER BY `minOrder` ASC [ RunTime:0.002247s ]
select * from pdf where partno='34071' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34071' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000600s ]
SELECT `id` FROM `stock` WHERE `id` <> 52486845 AND `partno` = '34071' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584057 [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52486696 LIMIT 5 [ RunTime:0.003128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52486696 ORDER BY `minOrder` ASC [ RunTime:0.003349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52486696 ORDER BY `unit` DESC [ RunTime:0.011139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52486696 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52486696 ORDER BY `minOrder` ASC [ RunTime:0.002840s ]
select * from pdf where partno='34070' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34070' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010968s ]
SELECT `id` FROM `stock` WHERE `id` <> 52486696 AND `partno` = '34070' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441314 [ RunTime:0.008721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56594826 LIMIT 5 [ RunTime:0.012422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56594826 ORDER BY `minOrder` ASC [ RunTime:0.005959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56594826 ORDER BY `unit` DESC [ RunTime:0.002692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56594826 LIMIT 2 [ RunTime:0.004825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56594826 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
select * from pdf where partno='340' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.002898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '340' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001791s ]
SELECT `id` FROM `stock` WHERE `id` <> 56594826 AND `partno` = '340' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.001314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044986 [ RunTime:0.001687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087494 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087494 ORDER BY `minOrder` ASC [ RunTime:0.007292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087494 ORDER BY `unit` DESC [ RunTime:0.002831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087494 LIMIT 2 [ RunTime:0.001007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087494 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='34081-4001' and brandshort='Molex' limit 1 [ RunTime:0.002411s ]
select foldpath,foldpath2,filename from pdf_file where id=762346 limit 1 [ RunTime:0.000259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-4001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51302745 LIMIT 5 [ RunTime:0.009754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51302745 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51302745 ORDER BY `unit` DESC [ RunTime:0.006577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51302745 LIMIT 2 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51302745 ORDER BY `minOrder` ASC [ RunTime:0.003674s ]
select * from pdf where partno='3403.0155.24' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.009514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3403.0155.24' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.003054s ]
SELECT `id` FROM `stock` WHERE `id` <> 51302745 AND `partno` = '3403.0155.24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.011065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13812185 [ RunTime:0.014639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52487040 LIMIT 5 [ RunTime:0.005092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52487040 ORDER BY `minOrder` ASC [ RunTime:0.015871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52487040 ORDER BY `unit` DESC [ RunTime:0.002109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52487040 LIMIT 2 [ RunTime:0.001210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52487040 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='34067' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34067' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002072s ]
SELECT `id` FROM `stock` WHERE `id` <> 52487040 AND `partno` = '34067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441494 [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087451 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087451 ORDER BY `minOrder` ASC [ RunTime:0.003513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087451 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087451 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087451 ORDER BY `minOrder` ASC [ RunTime:0.001121s ]
select * from pdf where partno='34080-1206' and brandshort='Molex' limit 1 [ RunTime:0.000744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34080-1206' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56552689 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552689 ORDER BY `minOrder` ASC [ RunTime:0.002057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56552689 ORDER BY `unit` DESC [ RunTime:0.000557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56552689 LIMIT 2 [ RunTime:0.005999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552689 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='3404400031' and brandshort='Essentra Components' limit 1 [ RunTime:0.002549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3404400031' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000543s ]
SELECT `id` FROM `stock` WHERE `id` <> 56552689 AND `partno` = '3404400031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.002530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087821 LIMIT 5 [ RunTime:0.022485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087821 ORDER BY `minOrder` ASC [ RunTime:0.005657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087821 ORDER BY `unit` DESC [ RunTime:0.002344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087821 LIMIT 2 [ RunTime:0.010338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087821 ORDER BY `minOrder` ASC [ RunTime:0.004361s ]
select * from pdf where partno='34080-1106' and brandshort='Molex' limit 1 [ RunTime:0.007111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34080-1106' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087820 LIMIT 5 [ RunTime:0.015179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087820 ORDER BY `minOrder` ASC [ RunTime:0.012953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087820 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087820 LIMIT 2 [ RunTime:0.002826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087820 ORDER BY `minOrder` ASC [ RunTime:0.002412s ]
select * from pdf where partno='34081-2005' and brandshort='Molex' limit 1 [ RunTime:0.002919s ]
select foldpath,foldpath2,filename from pdf_file where id=762347 limit 1 [ RunTime:0.007296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34081-2005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51303732 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51303732 ORDER BY `minOrder` ASC [ RunTime:0.017086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51303732 ORDER BY `unit` DESC [ RunTime:0.002422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51303732 LIMIT 2 [ RunTime:0.016439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51303732 ORDER BY `minOrder` ASC [ RunTime:0.011996s ]
select * from pdf where partno='3403.0022.24' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.001531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3403.0022.24' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.007197s ]
SELECT `id` FROM `stock` WHERE `id` <> 51303732 AND `partno` = '3403.0022.24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.007034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14703228 [ RunTime:0.005965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087992 LIMIT 5 [ RunTime:0.001879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087992 ORDER BY `minOrder` ASC [ RunTime:0.008212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087992 ORDER BY `unit` DESC [ RunTime:0.003012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087992 LIMIT 2 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087992 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='34062-0030' and brandshort='WEC' limit 1 [ RunTime:0.003088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34062-0030' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51303733 LIMIT 5 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51303733 ORDER BY `minOrder` ASC [ RunTime:0.004247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51303733 ORDER BY `unit` DESC [ RunTime:0.012704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51303733 LIMIT 2 [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51303733 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
select * from pdf where partno='3403.0016.24' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.004746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3403.0016.24' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.003649s ]
SELECT `id` FROM `stock` WHERE `id` <> 51303733 AND `partno` = '3403.0016.24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628655 [ RunTime:0.012676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56552691 LIMIT 5 [ RunTime:0.003151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552691 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56552691 ORDER BY `unit` DESC [ RunTime:0.006075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56552691 LIMIT 2 [ RunTime:0.002007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552691 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='3408320100' and brandshort='Essentra Components' limit 1 [ RunTime:0.001158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3408320100' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.011038s ]
SELECT `id` FROM `stock` WHERE `id` <> 56552691 AND `partno` = '3408320100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.003175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13329058 [ RunTime:0.007031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56552960 LIMIT 5 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552960 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56552960 ORDER BY `unit` DESC [ RunTime:0.004424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56552960 LIMIT 2 [ RunTime:0.001247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552960 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
select * from pdf where partno='3404400100' and brandshort='Essentra Components' limit 1 [ RunTime:0.000976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3404400100' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000740s ]
SELECT `id` FROM `stock` WHERE `id` <> 56552960 AND `partno` = '3404400100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56552961 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552961 ORDER BY `minOrder` ASC [ RunTime:0.002234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56552961 ORDER BY `unit` DESC [ RunTime:0.003139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56552961 LIMIT 2 [ RunTime:0.001882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552961 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='3408320050' and brandshort='Essentra Components' limit 1 [ RunTime:0.001191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3408320050' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.025900s ]
SELECT `id` FROM `stock` WHERE `id` <> 56552961 AND `partno` = '3408320050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.010802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087823 LIMIT 5 [ RunTime:0.006138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087823 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087823 ORDER BY `unit` DESC [ RunTime:0.002884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087823 LIMIT 2 [ RunTime:0.003962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087823 ORDER BY `minOrder` ASC [ RunTime:0.002264s ]
select * from pdf where partno='34080-1104' and brandshort='Molex' limit 1 [ RunTime:0.010153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34080-1104' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51304469 LIMIT 5 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51304469 ORDER BY `minOrder` ASC [ RunTime:0.001256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51304469 ORDER BY `unit` DESC [ RunTime:0.003205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51304469 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51304469 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='3404.2415.22' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.004300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3404.2415.22' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.005713s ]
SELECT `id` FROM `stock` WHERE `id` <> 51304469 AND `partno` = '3404.2415.22' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.018482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14703246 [ RunTime:0.016502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51302735 LIMIT 5 [ RunTime:0.007345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51302735 ORDER BY `minOrder` ASC [ RunTime:0.016503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51302735 ORDER BY `unit` DESC [ RunTime:0.008553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51302735 LIMIT 2 [ RunTime:0.019592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51302735 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
select * from pdf where partno='3403.0159.24' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.018304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3403.0159.24' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.001312s ]
SELECT `id` FROM `stock` WHERE `id` <> 51302735 AND `partno` = '3403.0159.24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.001232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628071 [ RunTime:0.000916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56552963 LIMIT 5 [ RunTime:0.002627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552963 ORDER BY `minOrder` ASC [ RunTime:0.001545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56552963 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56552963 LIMIT 2 [ RunTime:0.007327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56552963 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='3404400150' and brandshort='Essentra Components' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3404400150' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000839s ]
SELECT `id` FROM `stock` WHERE `id` <> 56552963 AND `partno` = '3404400150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12049868 [ RunTime:0.000696s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001860s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002035s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001190s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001072s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001183s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005196s ]
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 '340%' OR `brand` LIKE '340%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001062s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '340%' OR `brand` LIKE '340%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008406s ]