SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001598s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=17&search=1' [ RunTime:0.008066s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.019138s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002395s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.008612s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002629s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001995s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003173s ]
SELECT * FROM `stock_search` WHERE `partno` = '17' LIMIT 1 [ RunTime:0.009205s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 14:49:44' WHERE `partno` = '17' [ RunTime:0.004734s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002375s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.967449s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12608904 LIMIT 5 [ RunTime:0.040104s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12608904 ORDER BY `minOrder` ASC [ RunTime:0.021251s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12608904 ORDER BY `unit` DESC [ RunTime:0.037554s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12608904 LIMIT 2 [ RunTime:0.022408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12608904 ORDER BY `minOrder` ASC [ RunTime:0.001658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612731 LIMIT 5 [ RunTime:0.033057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612731 ORDER BY `minOrder` ASC [ RunTime:0.055098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612731 ORDER BY `unit` DESC [ RunTime:0.019522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612731 LIMIT 2 [ RunTime:0.004510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612731 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297909 LIMIT 5 [ RunTime:0.017268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297909 ORDER BY `minOrder` ASC [ RunTime:0.015058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297909 ORDER BY `unit` DESC [ RunTime:0.044202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297909 LIMIT 2 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297909 ORDER BY `minOrder` ASC [ RunTime:0.017885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609619 LIMIT 5 [ RunTime:0.022507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609619 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609619 ORDER BY `unit` DESC [ RunTime:0.043910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609619 LIMIT 2 [ RunTime:0.041126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609619 ORDER BY `minOrder` ASC [ RunTime:0.023831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610068 LIMIT 5 [ RunTime:0.046689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610068 ORDER BY `minOrder` ASC [ RunTime:0.017968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610068 ORDER BY `unit` DESC [ RunTime:0.030811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610068 LIMIT 2 [ RunTime:0.027114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610068 ORDER BY `minOrder` ASC [ RunTime:0.017225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299445 LIMIT 5 [ RunTime:0.058888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299445 ORDER BY `minOrder` ASC [ RunTime:0.037790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17299445 ORDER BY `unit` DESC [ RunTime:0.028152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17299445 LIMIT 2 [ RunTime:0.066090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299445 ORDER BY `minOrder` ASC [ RunTime:0.019598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589221 LIMIT 5 [ RunTime:0.010981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589221 ORDER BY `minOrder` ASC [ RunTime:0.011260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589221 ORDER BY `unit` DESC [ RunTime:0.012915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589221 LIMIT 2 [ RunTime:0.032620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589221 ORDER BY `minOrder` ASC [ RunTime:0.003753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609028 LIMIT 5 [ RunTime:0.024739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609028 ORDER BY `minOrder` ASC [ RunTime:0.013946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609028 ORDER BY `unit` DESC [ RunTime:0.079175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609028 LIMIT 2 [ RunTime:0.032885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609028 ORDER BY `minOrder` ASC [ RunTime:0.014516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589193 LIMIT 5 [ RunTime:0.014004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589193 ORDER BY `minOrder` ASC [ RunTime:0.038820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589193 ORDER BY `unit` DESC [ RunTime:0.026422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589193 LIMIT 2 [ RunTime:0.066714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589193 ORDER BY `minOrder` ASC [ RunTime:0.018792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297910 LIMIT 5 [ RunTime:0.035507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297910 ORDER BY `minOrder` ASC [ RunTime:0.037461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297910 ORDER BY `unit` DESC [ RunTime:0.032324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297910 LIMIT 2 [ RunTime:0.017089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297910 ORDER BY `minOrder` ASC [ RunTime:0.026120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589222 LIMIT 5 [ RunTime:0.004707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589222 ORDER BY `minOrder` ASC [ RunTime:0.008236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589222 ORDER BY `unit` DESC [ RunTime:0.014642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589222 LIMIT 2 [ RunTime:0.016462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589222 ORDER BY `minOrder` ASC [ RunTime:0.012059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611690 LIMIT 5 [ RunTime:0.011761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611690 ORDER BY `minOrder` ASC [ RunTime:0.013470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611690 ORDER BY `unit` DESC [ RunTime:0.007771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611690 LIMIT 2 [ RunTime:0.017955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611690 ORDER BY `minOrder` ASC [ RunTime:0.024448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812988 LIMIT 5 [ RunTime:0.019462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812988 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812988 ORDER BY `unit` DESC [ RunTime:0.032499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812988 LIMIT 2 [ RunTime:0.016733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812988 ORDER BY `minOrder` ASC [ RunTime:0.005667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579713 LIMIT 5 [ RunTime:0.005886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579713 ORDER BY `minOrder` ASC [ RunTime:0.008739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579713 ORDER BY `unit` DESC [ RunTime:0.007957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579713 LIMIT 2 [ RunTime:0.020434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579713 ORDER BY `minOrder` ASC [ RunTime:0.026662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481379 LIMIT 5 [ RunTime:0.028693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481379 ORDER BY `minOrder` ASC [ RunTime:0.037973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481379 ORDER BY `unit` DESC [ RunTime:0.020925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481379 LIMIT 2 [ RunTime:0.027111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481379 ORDER BY `minOrder` ASC [ RunTime:0.020571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588968 LIMIT 5 [ RunTime:0.033663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588968 ORDER BY `minOrder` ASC [ RunTime:0.015186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19588968 ORDER BY `unit` DESC [ RunTime:0.009810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19588968 LIMIT 2 [ RunTime:0.010117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588968 ORDER BY `minOrder` ASC [ RunTime:0.002963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612753 LIMIT 5 [ RunTime:0.020819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612753 ORDER BY `minOrder` ASC [ RunTime:0.006859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612753 ORDER BY `unit` DESC [ RunTime:0.003299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612753 LIMIT 2 [ RunTime:0.019711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612753 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
select * from pdf where partno='1727184121' and brandshort='Molex' limit 1 [ RunTime:0.021825s ]
select foldpath,foldpath2,filename from pdf_file where id=1902671 limit 1 [ RunTime:0.013818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588975 LIMIT 5 [ RunTime:0.008882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588975 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19588975 ORDER BY `unit` DESC [ RunTime:0.009727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19588975 LIMIT 2 [ RunTime:0.017111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588975 ORDER BY `minOrder` ASC [ RunTime:0.020802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481859 LIMIT 5 [ RunTime:0.008263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481859 ORDER BY `minOrder` ASC [ RunTime:0.020368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481859 ORDER BY `unit` DESC [ RunTime:0.052426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481859 LIMIT 2 [ RunTime:0.039350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481859 ORDER BY `minOrder` ASC [ RunTime:0.012203s ]
select * from pdf where partno='1740336-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.028871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609446 LIMIT 5 [ RunTime:0.014794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609446 ORDER BY `minOrder` ASC [ RunTime:0.026896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609446 ORDER BY `unit` DESC [ RunTime:0.071289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609446 LIMIT 2 [ RunTime:0.070236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609446 ORDER BY `minOrder` ASC [ RunTime:0.003254s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267196 LIMIT 5 [ RunTime:0.010725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267196 ORDER BY `minOrder` ASC [ RunTime:0.023659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267196 ORDER BY `unit` DESC [ RunTime:0.025051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267196 LIMIT 2 [ RunTime:0.032125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267196 ORDER BY `minOrder` ASC [ RunTime:0.001998s ]
select * from pdf where partno='175062-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.014616s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175062-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.037172s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267196 AND `partno` = '175062-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.015552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275938 LIMIT 5 [ RunTime:0.017561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275938 ORDER BY `minOrder` ASC [ RunTime:0.021531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275938 ORDER BY `unit` DESC [ RunTime:0.015292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275938 LIMIT 2 [ RunTime:0.021125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275938 ORDER BY `minOrder` ASC [ RunTime:0.037142s ]
select * from pdf where partno='175196-2' and brandshort='te connectivity' limit 1 [ RunTime:0.004254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175196-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.034543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276459 LIMIT 5 [ RunTime:0.027033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276459 ORDER BY `minOrder` ASC [ RunTime:0.037305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276459 ORDER BY `unit` DESC [ RunTime:0.027222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276459 LIMIT 2 [ RunTime:0.006693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276459 ORDER BY `minOrder` ASC [ RunTime:0.011881s ]
select * from pdf where partno='175286-2' and brandshort='te connectivity' limit 1 [ RunTime:0.030745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175286-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.028436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281307 LIMIT 5 [ RunTime:0.012087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281307 ORDER BY `minOrder` ASC [ RunTime:0.004312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281307 ORDER BY `unit` DESC [ RunTime:0.006534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281307 LIMIT 2 [ RunTime:0.022316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281307 ORDER BY `minOrder` ASC [ RunTime:0.012916s ]
select * from pdf where partno='172677-0100' and brandshort='molex' limit 1 [ RunTime:0.014804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172677-0100' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.030139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282158 LIMIT 5 [ RunTime:0.031576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282158 ORDER BY `minOrder` ASC [ RunTime:0.011257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282158 ORDER BY `unit` DESC [ RunTime:0.024375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282158 LIMIT 2 [ RunTime:0.014445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282158 ORDER BY `minOrder` ASC [ RunTime:0.013399s ]
select * from pdf where partno='170887-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.011984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170887-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.011735s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282158 AND `partno` = '170887-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.025463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277292 LIMIT 5 [ RunTime:0.024142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277292 ORDER BY `minOrder` ASC [ RunTime:0.006234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277292 ORDER BY `unit` DESC [ RunTime:0.026789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277292 LIMIT 2 [ RunTime:0.004556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277292 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
select * from pdf where partno='1744423-1' and brandshort='te connectivity' limit 1 [ RunTime:0.026998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1744423-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.040522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276627 LIMIT 5 [ RunTime:0.021742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276627 ORDER BY `minOrder` ASC [ RunTime:0.014398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276627 ORDER BY `unit` DESC [ RunTime:0.015822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276627 LIMIT 2 [ RunTime:0.009102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276627 ORDER BY `minOrder` ASC [ RunTime:0.014846s ]
select * from pdf where partno='1775444-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.019706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1775444-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004133s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276627 AND `partno` = '1775444-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.032729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276622 LIMIT 5 [ RunTime:0.022020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276622 ORDER BY `minOrder` ASC [ RunTime:0.026818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276622 ORDER BY `unit` DESC [ RunTime:0.015730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276622 LIMIT 2 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276622 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='170262-2 (mouser reel)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.007037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170262-2 (mouser reel)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.006064s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276622 AND `partno` = '170262-2 (mouser reel)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267280 LIMIT 5 [ RunTime:0.007378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267280 ORDER BY `minOrder` ASC [ RunTime:0.006476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267280 ORDER BY `unit` DESC [ RunTime:0.012740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267280 LIMIT 2 [ RunTime:0.008471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267280 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='175411-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.038523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175411-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.013487s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267280 AND `partno` = '175411-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.024152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282354 LIMIT 5 [ RunTime:0.007624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282354 ORDER BY `minOrder` ASC [ RunTime:0.012553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282354 ORDER BY `unit` DESC [ RunTime:0.017164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282354 LIMIT 2 [ RunTime:0.002467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282354 ORDER BY `minOrder` ASC [ RunTime:0.010160s ]
select * from pdf where partno='172677-0200' and brandshort='molex' limit 1 [ RunTime:0.015797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172677-0200' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282336 LIMIT 5 [ RunTime:0.007484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282336 ORDER BY `minOrder` ASC [ RunTime:0.004981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282336 ORDER BY `unit` DESC [ RunTime:0.007545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282336 LIMIT 2 [ RunTime:0.014764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282336 ORDER BY `minOrder` ASC [ RunTime:0.010103s ]
select * from pdf where partno='172677-0200' and brandshort='molex' limit 1 [ RunTime:0.011963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172677-0200' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.003345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281400 LIMIT 5 [ RunTime:0.013590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281400 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281400 ORDER BY `unit` DESC [ RunTime:0.003229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281400 LIMIT 2 [ RunTime:0.003973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281400 ORDER BY `minOrder` ASC [ RunTime:0.002348s ]
select * from pdf where partno='1742428-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1742428-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003796s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281400 AND `partno` = '1742428-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.002457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276265 LIMIT 5 [ RunTime:0.005669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276265 ORDER BY `minOrder` ASC [ RunTime:0.003394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276265 ORDER BY `unit` DESC [ RunTime:0.010739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276265 LIMIT 2 [ RunTime:0.004749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276265 ORDER BY `minOrder` ASC [ RunTime:0.003917s ]
select * from pdf where partno='175195-2' and brandshort='te connectivity' limit 1 [ RunTime:0.005406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175195-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.013597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281309 LIMIT 5 [ RunTime:0.003839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281309 ORDER BY `minOrder` ASC [ RunTime:0.005758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281309 ORDER BY `unit` DESC [ RunTime:0.001537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281309 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281309 ORDER BY `minOrder` ASC [ RunTime:0.004118s ]
select * from pdf where partno='170001-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.009496s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281309 AND `partno` = '170001-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.017219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276621 LIMIT 5 [ RunTime:0.007855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276621 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276621 ORDER BY `unit` DESC [ RunTime:0.007319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276621 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276621 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='170262-4' and brandshort='te connectivity' limit 1 [ RunTime:0.009631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170262-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.022491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267695 LIMIT 5 [ RunTime:0.005372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267695 ORDER BY `minOrder` ASC [ RunTime:0.015760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267695 ORDER BY `unit` DESC [ RunTime:0.006397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267695 LIMIT 2 [ RunTime:0.001651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267695 ORDER BY `minOrder` ASC [ RunTime:0.002477s ]
select * from pdf where partno='1719532-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.006729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1719532-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000916s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267695 AND `partno` = '1719532-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281798 LIMIT 5 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281798 ORDER BY `minOrder` ASC [ RunTime:0.001158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281798 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281798 LIMIT 2 [ RunTime:0.010914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281798 ORDER BY `minOrder` ASC [ RunTime:0.002861s ]
select * from pdf where partno='170342-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170342-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.006387s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281798 AND `partno` = '170342-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.007512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276266 LIMIT 5 [ RunTime:0.008361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276266 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276266 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276266 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276266 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
select * from pdf where partno='175285-2' and brandshort='te connectivity' limit 1 [ RunTime:0.001480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175285-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.008610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282160 LIMIT 5 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282160 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282160 ORDER BY `unit` DESC [ RunTime:0.001962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282160 LIMIT 2 [ RunTime:0.003646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282160 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='175412-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175412-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.012617s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282160 AND `partno` = '175412-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.025528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277064 LIMIT 5 [ RunTime:0.007653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277064 ORDER BY `minOrder` ASC [ RunTime:0.001700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277064 ORDER BY `unit` DESC [ RunTime:0.000955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277064 LIMIT 2 [ RunTime:0.009381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277064 ORDER BY `minOrder` ASC [ RunTime:0.005477s ]
select * from pdf where partno='170263-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.009296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170263-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002060s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277064 AND `partno` = '170263-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004315s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.225527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53558330 LIMIT 5 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53558330 ORDER BY `minOrder` ASC [ RunTime:0.009942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53558330 ORDER BY `unit` DESC [ RunTime:0.002051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53558330 LIMIT 2 [ RunTime:0.003773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53558330 ORDER BY `minOrder` ASC [ RunTime:0.018257s ]
select * from pdf where partno='1740829-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.022977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1740829-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.010082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525866 LIMIT 5 [ RunTime:0.005351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525866 ORDER BY `minOrder` ASC [ RunTime:0.002118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525866 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525866 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525866 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='1735801-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1735801-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54171274 LIMIT 5 [ RunTime:0.001935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171274 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54171274 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54171274 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171274 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='179973-6' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '179973-6' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.023020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525870 LIMIT 5 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525870 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525870 ORDER BY `unit` DESC [ RunTime:0.005788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525870 LIMIT 2 [ RunTime:0.002443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525870 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='175151-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175151-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005886s ]
SELECT `id` FROM `stock` WHERE `id` <> 53525870 AND `partno` = '175151-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612731 [ RunTime:0.001265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087964 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087964 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087964 ORDER BY `unit` DESC [ RunTime:0.000774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087964 LIMIT 2 [ RunTime:0.009176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087964 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='1744416-8' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1744416-8' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.027802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53076202 LIMIT 5 [ RunTime:0.017344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076202 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53076202 ORDER BY `unit` DESC [ RunTime:0.001991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53076202 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53076202 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='176282-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '176282-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006122s ]
SELECT `id` FROM `stock` WHERE `id` <> 53076202 AND `partno` = '176282-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525414 LIMIT 5 [ RunTime:0.009152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525414 ORDER BY `minOrder` ASC [ RunTime:0.004455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525414 ORDER BY `unit` DESC [ RunTime:0.003534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525414 LIMIT 2 [ RunTime:0.003616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525414 ORDER BY `minOrder` ASC [ RunTime:0.002312s ]
select * from pdf where partno='1722537023' and brandshort='Molex' limit 1 [ RunTime:0.004833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1722537023' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57359722 LIMIT 5 [ RunTime:0.006858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57359722 ORDER BY `minOrder` ASC [ RunTime:0.001310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57359722 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57359722 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57359722 ORDER BY `minOrder` ASC [ RunTime:0.006523s ]
select * from pdf where partno='1720BL15A0100001E' and brandshort='Johanson Technology Inc.' limit 1 [ RunTime:0.001778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1720BL15A0100001E' OR `brand` LIKE 'Johanson Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.006063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818317 LIMIT 5 [ RunTime:0.007351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818317 ORDER BY `minOrder` ASC [ RunTime:0.012186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818317 ORDER BY `unit` DESC [ RunTime:0.000872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818317 LIMIT 2 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818317 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='1742303-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1742303-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001710s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818317 AND `partno` = '1742303-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53822091 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53822091 ORDER BY `minOrder` ASC [ RunTime:0.006789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53822091 ORDER BY `unit` DESC [ RunTime:0.008898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53822091 LIMIT 2 [ RunTime:0.013598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53822091 ORDER BY `minOrder` ASC [ RunTime:0.003948s ]
select * from pdf where partno='170002-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170002-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002710s ]
SELECT `id` FROM `stock` WHERE `id` <> 53822091 AND `partno` = '170002-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299445 [ RunTime:0.002683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53527201 LIMIT 5 [ RunTime:0.008939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53527201 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53527201 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53527201 LIMIT 2 [ RunTime:0.002628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53527201 ORDER BY `minOrder` ASC [ RunTime:0.006965s ]
select * from pdf where partno='175217-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '175217-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001883s ]
SELECT `id` FROM `stock` WHERE `id` <> 53527201 AND `partno` = '175217-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609619 [ RunTime:0.007303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087668 LIMIT 5 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087668 ORDER BY `minOrder` ASC [ RunTime:0.001816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087668 ORDER BY `unit` DESC [ RunTime:0.009957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087668 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087668 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='1744428-4' and brandshort='TE Connectivity' limit 1 [ RunTime:0.002765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1744428-4' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.032097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525882 LIMIT 5 [ RunTime:0.004068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525882 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525882 ORDER BY `unit` DESC [ RunTime:0.004792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525882 LIMIT 2 [ RunTime:0.003983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525882 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='1727184121' and brandshort='Molex' limit 1 [ RunTime:0.003120s ]
select foldpath,foldpath2,filename from pdf_file where id=1902671 limit 1 [ RunTime:0.000425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1727184121' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53528415 LIMIT 5 [ RunTime:0.001597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53528415 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53528415 ORDER BY `unit` DESC [ RunTime:0.012571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53528415 LIMIT 2 [ RunTime:0.005605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53528415 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
select * from pdf where partno='1730420001' and brandshort='Molex' limit 1 [ RunTime:0.004918s ]
select foldpath,foldpath2,filename from pdf_file where id=1537240 limit 1 [ RunTime:0.000635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1730420001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525890 LIMIT 5 [ RunTime:0.002591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525890 ORDER BY `minOrder` ASC [ RunTime:0.003146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525890 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525890 LIMIT 2 [ RunTime:0.006451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525890 ORDER BY `minOrder` ASC [ RunTime:0.001899s ]
select * from pdf where partno='1744423-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1744423-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53819434 LIMIT 5 [ RunTime:0.004322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819434 ORDER BY `minOrder` ASC [ RunTime:0.036728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53819434 ORDER BY `unit` DESC [ RunTime:0.020417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53819434 LIMIT 2 [ RunTime:0.024014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819434 ORDER BY `minOrder` ASC [ RunTime:0.005304s ]
select * from pdf where partno='170043-4' and brandshort='TE Connectivity' limit 1 [ RunTime:0.032843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170043-4' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.030922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525893 LIMIT 5 [ RunTime:0.020091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525893 ORDER BY `minOrder` ASC [ RunTime:0.027945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525893 ORDER BY `unit` DESC [ RunTime:0.006480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525893 LIMIT 2 [ RunTime:0.035967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525893 ORDER BY `minOrder` ASC [ RunTime:0.008905s ]
select * from pdf where partno='1727654121' and brandshort='Molex' limit 1 [ RunTime:0.008853s ]
select foldpath,foldpath2,filename from pdf_file where id=2070376 limit 1 [ RunTime:0.011776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1727654121' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53536428 LIMIT 5 [ RunTime:0.010773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536428 ORDER BY `minOrder` ASC [ RunTime:0.004527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53536428 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53536428 LIMIT 2 [ RunTime:0.005079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536428 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='170362-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170362-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525901 LIMIT 5 [ RunTime:0.005602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525901 ORDER BY `minOrder` ASC [ RunTime:0.001624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525901 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525901 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525901 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='1775442-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1775442-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53831996 LIMIT 5 [ RunTime:0.003361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53831996 ORDER BY `minOrder` ASC [ RunTime:0.010367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53831996 ORDER BY `unit` DESC [ RunTime:0.001593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53831996 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53831996 ORDER BY `minOrder` ASC [ RunTime:0.002962s ]
select * from pdf where partno='172781-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172781-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003171s ]
SELECT `id` FROM `stock` WHERE `id` <> 53831996 AND `partno` = '172781-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589222 [ RunTime:0.008590s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004902s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002106s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001217s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012400s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009769s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002949s ]
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 '17%' OR `brand` LIKE '17%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32122240 LIMIT 5 [ RunTime:0.009059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122240 ORDER BY `minOrder` ASC [ RunTime:0.014020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32122240 ORDER BY `unit` DESC [ RunTime:0.008607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32122240 LIMIT 2 [ RunTime:0.006320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122240 ORDER BY `minOrder` ASC [ RunTime:0.010885s ]
select * from pdf where partno='178MU0006' and brandshort='KNSCHA' limit 1 [ RunTime:0.009680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0006' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.024711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32137579 LIMIT 5 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32137579 ORDER BY `minOrder` ASC [ RunTime:0.002055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32137579 ORDER BY `unit` DESC [ RunTime:0.000807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32137579 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32137579 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='178MU0006' and brandshort='KNSCHA' limit 1 [ RunTime:0.000673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0006' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014099 LIMIT 5 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014099 ORDER BY `minOrder` ASC [ RunTime:0.010299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014099 ORDER BY `unit` DESC [ RunTime:0.000876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014099 LIMIT 2 [ RunTime:0.003817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014099 ORDER BY `minOrder` ASC [ RunTime:0.004967s ]
select * from pdf where partno='170361-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.007534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170361-1' OR `brand` LIKE 'TE Connectivity(泰科电子)%' ) ) LIMIT 1 [ RunTime:0.027336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51021896 LIMIT 5 [ RunTime:0.012302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51021896 ORDER BY `minOrder` ASC [ RunTime:0.006963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51021896 ORDER BY `unit` DESC [ RunTime:0.002305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51021896 LIMIT 2 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51021896 ORDER BY `minOrder` ASC [ RunTime:0.003311s ]
select * from pdf where partno='178MU0002' and brandshort='KNSCHA' limit 1 [ RunTime:0.009007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0002' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.010539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32122559 LIMIT 5 [ RunTime:0.005781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122559 ORDER BY `minOrder` ASC [ RunTime:0.006752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32122559 ORDER BY `unit` DESC [ RunTime:0.006549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32122559 LIMIT 2 [ RunTime:0.009350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122559 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
select * from pdf where partno='178MU0008' and brandshort='KNSCHA' limit 1 [ RunTime:0.000851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0008' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.020573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32122778 LIMIT 5 [ RunTime:0.001053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122778 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32122778 ORDER BY `unit` DESC [ RunTime:0.004557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32122778 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122778 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='178MU0007' and brandshort='KNSCHA' limit 1 [ RunTime:0.000679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0007' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.005922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32138304 LIMIT 5 [ RunTime:0.004337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138304 ORDER BY `minOrder` ASC [ RunTime:0.019905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32138304 ORDER BY `unit` DESC [ RunTime:0.004504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32138304 LIMIT 2 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138304 ORDER BY `minOrder` ASC [ RunTime:0.001985s ]
select * from pdf where partno='178MU0007' and brandshort='KNSCHA' limit 1 [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0007' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32138039 LIMIT 5 [ RunTime:0.001133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138039 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32138039 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32138039 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138039 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
select * from pdf where partno='178MU0008' and brandshort='KNSCHA' limit 1 [ RunTime:0.000357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0008' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.000257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32122810 LIMIT 5 [ RunTime:0.003415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122810 ORDER BY `minOrder` ASC [ RunTime:0.006257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32122810 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32122810 LIMIT 2 [ RunTime:0.003191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122810 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='178MU0005' and brandshort='KNSCHA' limit 1 [ RunTime:0.000934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178MU0005' OR `brand` LIKE 'KNSCHA(科尼盛)%' ) ) LIMIT 1 [ RunTime:0.002402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014041 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014041 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014041 ORDER BY `unit` DESC [ RunTime:0.001510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014041 LIMIT 2 [ RunTime:0.006795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014041 ORDER BY `minOrder` ASC [ RunTime:0.001957s ]
select * from pdf where partno='1734753-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1734753-1' OR `brand` LIKE 'TE Connectivity(泰科电子)%' ) ) LIMIT 1 [ RunTime:0.022521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51017127 LIMIT 5 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51017127 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51017127 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51017127 LIMIT 2 [ RunTime:0.002586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51017127 ORDER BY `minOrder` ASC [ RunTime:0.010078s ]
select * from pdf where partno='178.6764.0001' and brandshort='Littelfuse' limit 1 [ RunTime:0.019719s ]
select foldpath,foldpath2,filename from pdf_file where id=145196 limit 1 [ RunTime:0.005599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '178.6764.0001' OR `brand` LIKE 'Littelfuse(美国力特)%' ) ) LIMIT 1 [ RunTime:0.012067s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '17%' OR `brand` LIKE '17%' ) ) AND ( (s.platform = 1) ) [ RunTime:1.416094s ]