SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001988s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=205&search=1' [ RunTime:0.004160s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002986s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013671s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001685s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.009777s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001596s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010258s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001355s ]
SELECT * FROM `stock_search` WHERE `partno` = '205' LIMIT 1 [ RunTime:0.039449s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-27 22:17:57' WHERE `partno` = '205' [ RunTime:0.013069s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001147s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.233857s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578495 LIMIT 5 [ RunTime:0.029337s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578495 ORDER BY `minOrder` ASC [ RunTime:0.022416s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578495 ORDER BY `unit` DESC [ RunTime:0.040513s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578495 LIMIT 2 [ RunTime:0.035104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578495 ORDER BY `minOrder` ASC [ RunTime:0.031221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579315 LIMIT 5 [ RunTime:0.085347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579315 ORDER BY `minOrder` ASC [ RunTime:0.090512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579315 ORDER BY `unit` DESC [ RunTime:0.019266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579315 LIMIT 2 [ RunTime:0.058672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579315 ORDER BY `minOrder` ASC [ RunTime:0.030179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619471 LIMIT 5 [ RunTime:0.090108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619471 ORDER BY `minOrder` ASC [ RunTime:0.080434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619471 ORDER BY `unit` DESC [ RunTime:0.060843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619471 LIMIT 2 [ RunTime:0.047934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619471 ORDER BY `minOrder` ASC [ RunTime:0.057355s ]
select * from pdf where partno='2053410204' and brandshort='Molex' limit 1 [ RunTime:0.077112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19580006 LIMIT 5 [ RunTime:0.079212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19580006 ORDER BY `minOrder` ASC [ RunTime:0.050525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19580006 ORDER BY `unit` DESC [ RunTime:0.047310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19580006 LIMIT 2 [ RunTime:0.082521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19580006 ORDER BY `minOrder` ASC [ RunTime:0.006972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13534983 LIMIT 5 [ RunTime:0.021166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534983 ORDER BY `minOrder` ASC [ RunTime:0.059579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13534983 ORDER BY `unit` DESC [ RunTime:0.043375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13534983 LIMIT 2 [ RunTime:0.030789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534983 ORDER BY `minOrder` ASC [ RunTime:0.023616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579749 LIMIT 5 [ RunTime:0.048778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579749 ORDER BY `minOrder` ASC [ RunTime:0.033599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579749 ORDER BY `unit` DESC [ RunTime:0.022525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579749 LIMIT 2 [ RunTime:0.039822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579749 ORDER BY `minOrder` ASC [ RunTime:0.022458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405217 LIMIT 5 [ RunTime:0.074213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405217 ORDER BY `minOrder` ASC [ RunTime:0.072313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405217 ORDER BY `unit` DESC [ RunTime:0.009831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405217 LIMIT 2 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405217 ORDER BY `minOrder` ASC [ RunTime:0.032089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298238 LIMIT 5 [ RunTime:0.017385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298238 ORDER BY `minOrder` ASC [ RunTime:0.044618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298238 ORDER BY `unit` DESC [ RunTime:0.029575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298238 LIMIT 2 [ RunTime:0.022760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298238 ORDER BY `minOrder` ASC [ RunTime:0.007899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481147 LIMIT 5 [ RunTime:0.012568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481147 ORDER BY `minOrder` ASC [ RunTime:0.013366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481147 ORDER BY `unit` DESC [ RunTime:0.052638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481147 LIMIT 2 [ RunTime:0.038184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481147 ORDER BY `minOrder` ASC [ RunTime:0.044378s ]
select * from pdf where partno='2050328000' and brandshort='Molex' limit 1 [ RunTime:0.033296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12543207 LIMIT 5 [ RunTime:0.036832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12543207 ORDER BY `minOrder` ASC [ RunTime:0.004519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12543207 ORDER BY `unit` DESC [ RunTime:0.027736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12543207 LIMIT 2 [ RunTime:0.029094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12543207 ORDER BY `minOrder` ASC [ RunTime:0.007822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668099 LIMIT 5 [ RunTime:0.007722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668099 ORDER BY `minOrder` ASC [ RunTime:0.043921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668099 ORDER BY `unit` DESC [ RunTime:0.024304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668099 LIMIT 2 [ RunTime:0.017740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668099 ORDER BY `minOrder` ASC [ RunTime:0.001397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12545893 LIMIT 5 [ RunTime:0.008112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12545893 ORDER BY `minOrder` ASC [ RunTime:0.012865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12545893 ORDER BY `unit` DESC [ RunTime:0.019099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12545893 LIMIT 2 [ RunTime:0.012903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12545893 ORDER BY `minOrder` ASC [ RunTime:0.005629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579995 LIMIT 5 [ RunTime:0.014373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579995 ORDER BY `minOrder` ASC [ RunTime:0.004375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579995 ORDER BY `unit` DESC [ RunTime:0.006708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579995 LIMIT 2 [ RunTime:0.006183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579995 ORDER BY `minOrder` ASC [ RunTime:0.002730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616463 LIMIT 5 [ RunTime:0.007638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616463 ORDER BY `minOrder` ASC [ RunTime:0.003621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616463 ORDER BY `unit` DESC [ RunTime:0.004218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616463 LIMIT 2 [ RunTime:0.003874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616463 ORDER BY `minOrder` ASC [ RunTime:0.003354s ]
select * from pdf where partno='2053410202' and brandshort='Molex' limit 1 [ RunTime:0.013321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667806 LIMIT 5 [ RunTime:0.008250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667806 ORDER BY `minOrder` ASC [ RunTime:0.002910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667806 ORDER BY `unit` DESC [ RunTime:0.008165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667806 LIMIT 2 [ RunTime:0.000923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667806 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668458 LIMIT 5 [ RunTime:0.001324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668458 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668458 ORDER BY `unit` DESC [ RunTime:0.007681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668458 LIMIT 2 [ RunTime:0.000958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668458 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195955 LIMIT 5 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195955 ORDER BY `minOrder` ASC [ RunTime:0.012916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13195955 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13195955 LIMIT 2 [ RunTime:0.009159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195955 ORDER BY `minOrder` ASC [ RunTime:0.001014s ]
select * from pdf where partno='2057141001' and brandshort='Molex' limit 1 [ RunTime:0.001413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19848602 LIMIT 5 [ RunTime:0.001320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19848602 ORDER BY `minOrder` ASC [ RunTime:0.008065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19848602 ORDER BY `unit` DESC [ RunTime:0.001372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19848602 LIMIT 2 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19848602 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='2053380002' and brandshort='Molex' limit 1 [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578522 LIMIT 5 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578522 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578522 ORDER BY `unit` DESC [ RunTime:0.008696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578522 LIMIT 2 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578522 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12623264 LIMIT 5 [ RunTime:0.008882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12623264 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12623264 ORDER BY `unit` DESC [ RunTime:0.005471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12623264 LIMIT 2 [ RunTime:0.004037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12623264 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='2053410206' and brandshort='Molex' limit 1 [ RunTime:0.002279s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252214 LIMIT 5 [ RunTime:0.003824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252214 ORDER BY `minOrder` ASC [ RunTime:0.003251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252214 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252214 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252214 ORDER BY `minOrder` ASC [ RunTime:0.004355s ]
select * from pdf where partno='205201-7' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.005197s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205201-7' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070259 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070259 ORDER BY `minOrder` ASC [ RunTime:0.001145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070259 ORDER BY `unit` DESC [ RunTime:0.009191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070259 LIMIT 2 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070259 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='2058302-1' and brandshort='te connectivity' limit 1 [ RunTime:0.005126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058302-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.018947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227895 LIMIT 5 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227895 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32227895 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32227895 LIMIT 2 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227895 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
select * from pdf where partno='2058302-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058302-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070188 LIMIT 5 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070188 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070188 ORDER BY `unit` DESC [ RunTime:0.003800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070188 LIMIT 2 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070188 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='2058301-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.002891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058301-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.000938s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070188 AND `partno` = '2058301-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.001422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227894 [ RunTime:0.003778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227894 LIMIT 5 [ RunTime:0.007531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227894 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32227894 ORDER BY `unit` DESC [ RunTime:0.009008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32227894 LIMIT 2 [ RunTime:0.004322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227894 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
select * from pdf where partno='2058301-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.000691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058301-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT `id` FROM `stock` WHERE `id` <> 32227894 AND `partno` = '2058301-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.004010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070188 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070693 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070693 ORDER BY `minOrder` ASC [ RunTime:0.001154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070693 ORDER BY `unit` DESC [ RunTime:0.003421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070693 LIMIT 2 [ RunTime:0.005303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070693 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='2058301-1 (mouser reel)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058301-1 (mouser reel)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003382s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070693 AND `partno` = '2058301-1 (mouser reel)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252541 LIMIT 5 [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252541 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252541 ORDER BY `unit` DESC [ RunTime:0.000427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252541 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252541 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='205201-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205201-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001052s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252541 AND `partno` = '205201-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070393 LIMIT 5 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070393 ORDER BY `minOrder` ASC [ RunTime:0.001528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070393 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070393 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070393 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='2058703-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.001070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058703-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.000885s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070393 AND `partno` = '2058703-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070209 LIMIT 5 [ RunTime:0.003782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070209 ORDER BY `minOrder` ASC [ RunTime:0.007089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070209 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070209 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070209 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='2058301-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058301-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.010221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252363 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252363 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252363 ORDER BY `unit` DESC [ RunTime:0.000438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252363 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252363 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='205202-2 (cut strip)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205202-2 (cut strip)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000487s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252363 AND `partno` = '205202-2 (cut strip)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.002752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252272 LIMIT 5 [ RunTime:0.004037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252272 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252272 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252272 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252272 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
select * from pdf where partno='205310-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205310-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001173s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252272 AND `partno` = '205310-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267704 LIMIT 5 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267704 ORDER BY `minOrder` ASC [ RunTime:0.000977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267704 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267704 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267704 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='2050994-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2050994-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.009504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070395 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070395 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070395 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070395 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070395 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='2058943-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.001172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058943-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.002424s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070395 AND `partno` = '2058943-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.001394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252468 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252468 ORDER BY `minOrder` ASC [ RunTime:0.003682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252468 ORDER BY `unit` DESC [ RunTime:0.004858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252468 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252468 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='205089-2' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.004142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205089-2' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.001704s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252468 AND `partno` = '205089-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.013965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070314 LIMIT 5 [ RunTime:0.005986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070314 ORDER BY `minOrder` ASC [ RunTime:0.007379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070314 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070314 LIMIT 2 [ RunTime:0.007585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070314 ORDER BY `minOrder` ASC [ RunTime:0.003613s ]
select * from pdf where partno='2058128-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058128-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.022975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227690 LIMIT 5 [ RunTime:0.019275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227690 ORDER BY `minOrder` ASC [ RunTime:0.011514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32227690 ORDER BY `unit` DESC [ RunTime:0.014763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32227690 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227690 ORDER BY `minOrder` ASC [ RunTime:0.000612s ]
select * from pdf where partno='2058302-2' and brandshort='te connectivity' limit 1 [ RunTime:0.012382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058302-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.039793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070392 LIMIT 5 [ RunTime:0.042367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070392 ORDER BY `minOrder` ASC [ RunTime:0.005539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070392 ORDER BY `unit` DESC [ RunTime:0.004125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070392 LIMIT 2 [ RunTime:0.002418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070392 ORDER BY `minOrder` ASC [ RunTime:0.006747s ]
select * from pdf where partno='2058299-2' and brandshort='te connectivity' limit 1 [ RunTime:0.022095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058299-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.093504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070171 LIMIT 5 [ RunTime:0.006023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070171 ORDER BY `minOrder` ASC [ RunTime:0.022026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070171 ORDER BY `unit` DESC [ RunTime:0.007511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070171 LIMIT 2 [ RunTime:0.018652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070171 ORDER BY `minOrder` ASC [ RunTime:0.015651s ]
select * from pdf where partno='2058302-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058302-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.016281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070394 LIMIT 5 [ RunTime:0.029426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070394 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070394 ORDER BY `unit` DESC [ RunTime:0.014063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070394 LIMIT 2 [ RunTime:0.007234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070394 ORDER BY `minOrder` ASC [ RunTime:0.014091s ]
select * from pdf where partno='2058943-1' and brandshort='te connectivity' limit 1 [ RunTime:0.012433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058943-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.047867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070694 LIMIT 5 [ RunTime:0.011315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070694 ORDER BY `minOrder` ASC [ RunTime:0.016384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070694 ORDER BY `unit` DESC [ RunTime:0.007206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070694 LIMIT 2 [ RunTime:0.029537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070694 ORDER BY `minOrder` ASC [ RunTime:0.005032s ]
select * from pdf where partno='2058302-1 (mouser reel)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.019730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058302-1 (mouser reel)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.013749s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070694 AND `partno` = '2058302-1 (mouser reel)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.007074s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.154942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60346237 LIMIT 5 [ RunTime:0.009535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60346237 ORDER BY `minOrder` ASC [ RunTime:0.004961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60346237 ORDER BY `unit` DESC [ RunTime:0.004054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60346237 LIMIT 2 [ RunTime:0.001156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60346237 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='205342-5128' and brandshort='WEC' limit 1 [ RunTime:0.000885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205342-5128' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.002546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61098576 LIMIT 5 [ RunTime:0.001533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61098576 ORDER BY `minOrder` ASC [ RunTime:0.015527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61098576 ORDER BY `unit` DESC [ RunTime:0.003081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61098576 LIMIT 2 [ RunTime:0.007246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61098576 ORDER BY `minOrder` ASC [ RunTime:0.003167s ]
select * from pdf where partno='205208-1009' and brandshort='WEC' limit 1 [ RunTime:0.005951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205208-1009' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60342955 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342955 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60342955 ORDER BY `unit` DESC [ RunTime:0.004880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60342955 LIMIT 2 [ RunTime:0.003187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342955 ORDER BY `minOrder` ASC [ RunTime:0.006807s ]
select * from pdf where partno='2053425128' and brandshort='Molex' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2053425128' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354141 LIMIT 5 [ RunTime:0.005531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354141 ORDER BY `minOrder` ASC [ RunTime:0.008111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354141 ORDER BY `unit` DESC [ RunTime:0.001611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354141 LIMIT 2 [ RunTime:0.004727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354141 ORDER BY `minOrder` ASC [ RunTime:0.009011s ]
select * from pdf where partno='205090-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205090-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002903s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354141 AND `partno` = '205090-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.005061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578522 [ RunTime:0.004993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944077 LIMIT 5 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944077 ORDER BY `minOrder` ASC [ RunTime:0.009400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944077 ORDER BY `unit` DESC [ RunTime:0.005313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944077 LIMIT 2 [ RunTime:0.016190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944077 ORDER BY `minOrder` ASC [ RunTime:0.003362s ]
select * from pdf where partno='205341-0204' and brandshort='WEC' limit 1 [ RunTime:0.003425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205341-0204' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.010760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61907842 LIMIT 5 [ RunTime:0.011753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61907842 ORDER BY `minOrder` ASC [ RunTime:0.021193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61907842 ORDER BY `unit` DESC [ RunTime:0.001054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61907842 LIMIT 2 [ RunTime:0.011880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61907842 ORDER BY `minOrder` ASC [ RunTime:0.003698s ]
select * from pdf where partno='20579-001E' and brandshort='I-PEX' limit 1 [ RunTime:0.000896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20579-001E' OR `brand` LIKE 'I-PEX%' ) ) LIMIT 1 [ RunTime:0.014138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343799 LIMIT 5 [ RunTime:0.010411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343799 ORDER BY `minOrder` ASC [ RunTime:0.012635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343799 ORDER BY `unit` DESC [ RunTime:0.012789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343799 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343799 ORDER BY `minOrder` ASC [ RunTime:0.012384s ]
select * from pdf where partno='2050328000' and brandshort='Molex' limit 1 [ RunTime:0.012286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2050328000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.025461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354248 LIMIT 5 [ RunTime:0.013483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354248 ORDER BY `minOrder` ASC [ RunTime:0.003579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354248 ORDER BY `unit` DESC [ RunTime:0.011723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354248 LIMIT 2 [ RunTime:0.017169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354248 ORDER BY `minOrder` ASC [ RunTime:0.008509s ]
select * from pdf where partno='205090-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205090-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000990s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354248 AND `partno` = '205090-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.010206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579315 [ RunTime:0.011416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354408 LIMIT 5 [ RunTime:0.040104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354408 ORDER BY `minOrder` ASC [ RunTime:0.014570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354408 ORDER BY `unit` DESC [ RunTime:0.007181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354408 LIMIT 2 [ RunTime:0.023006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354408 ORDER BY `minOrder` ASC [ RunTime:0.002418s ]
select * from pdf where partno='205201-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205201-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008838s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354408 AND `partno` = '205201-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19580006 [ RunTime:0.020898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63131958 LIMIT 5 [ RunTime:0.050079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63131958 ORDER BY `minOrder` ASC [ RunTime:0.039814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63131958 ORDER BY `unit` DESC [ RunTime:0.006598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63131958 LIMIT 2 [ RunTime:0.014653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63131958 ORDER BY `minOrder` ASC [ RunTime:0.022519s ]
select * from pdf where partno='2057' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.009969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2057' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.035412s ]
SELECT `id` FROM `stock` WHERE `id` <> 63131958 AND `partno` = '2057' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.008198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13534983 [ RunTime:0.018861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934266 LIMIT 5 [ RunTime:0.004589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934266 ORDER BY `minOrder` ASC [ RunTime:0.008659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934266 ORDER BY `unit` DESC [ RunTime:0.003330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934266 LIMIT 2 [ RunTime:0.010623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934266 ORDER BY `minOrder` ASC [ RunTime:0.002690s ]
select * from pdf where partno='2053410202' and brandshort='Molex' limit 1 [ RunTime:0.004467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2053410202' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936106 LIMIT 5 [ RunTime:0.016076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936106 ORDER BY `minOrder` ASC [ RunTime:0.016216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936106 ORDER BY `unit` DESC [ RunTime:0.003238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936106 LIMIT 2 [ RunTime:0.009960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936106 ORDER BY `minOrder` ASC [ RunTime:0.010673s ]
select * from pdf where partno='2053410204' and brandshort='Molex' limit 1 [ RunTime:0.005246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2053410204' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354358 LIMIT 5 [ RunTime:0.010794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354358 ORDER BY `minOrder` ASC [ RunTime:0.010915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354358 ORDER BY `unit` DESC [ RunTime:0.018372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354358 LIMIT 2 [ RunTime:0.015578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354358 ORDER BY `minOrder` ASC [ RunTime:0.002854s ]
select * from pdf where partno='205202-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205202-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008090s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354358 AND `partno` = '205202-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579749 [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59517890 LIMIT 5 [ RunTime:0.008383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59517890 ORDER BY `minOrder` ASC [ RunTime:0.003175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59517890 ORDER BY `unit` DESC [ RunTime:0.014216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59517890 LIMIT 2 [ RunTime:0.003053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59517890 ORDER BY `minOrder` ASC [ RunTime:0.004950s ]
select * from pdf where partno='205338-0006' and brandshort='WEC' limit 1 [ RunTime:0.002152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205338-0006' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354688 LIMIT 5 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354688 ORDER BY `minOrder` ASC [ RunTime:0.002168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354688 ORDER BY `unit` DESC [ RunTime:0.001785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354688 LIMIT 2 [ RunTime:0.002419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354688 ORDER BY `minOrder` ASC [ RunTime:0.001732s ]
select * from pdf where partno='205201-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '205201-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000609s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354688 AND `partno` = '205201-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298238 [ RunTime:0.005444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63131909 LIMIT 5 [ RunTime:0.001221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63131909 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63131909 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63131909 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63131909 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='2053' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.004332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2053' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.001791s ]
SELECT `id` FROM `stock` WHERE `id` <> 63131909 AND `partno` = '2053' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405217 [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60559377 LIMIT 5 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559377 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60559377 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60559377 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559377 ORDER BY `minOrder` ASC [ RunTime:0.002664s ]
select * from pdf where partno='2059-303/998-403' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2059-303/998-403' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343814 LIMIT 5 [ RunTime:0.002001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343814 ORDER BY `minOrder` ASC [ RunTime:0.002470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343814 ORDER BY `unit` DESC [ RunTime:0.009314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343814 LIMIT 2 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343814 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='2050338000' and brandshort='Molex' limit 1 [ RunTime:0.000603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2050338000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59748784 LIMIT 5 [ RunTime:0.002055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748784 ORDER BY `minOrder` ASC [ RunTime:0.002343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59748784 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59748784 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748784 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='20525-030E-02' and brandshort='I-PEX' limit 1 [ RunTime:0.003881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20525-030E-02' OR `brand` LIKE 'I-PEX%' ) ) LIMIT 1 [ RunTime:0.002821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936379 LIMIT 5 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936379 ORDER BY `minOrder` ASC [ RunTime:0.001607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936379 ORDER BY `unit` DESC [ RunTime:0.008473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936379 LIMIT 2 [ RunTime:0.014976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936379 ORDER BY `minOrder` ASC [ RunTime:0.011609s ]
select * from pdf where partno='2053410206' and brandshort='Molex' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2053410206' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013381s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003023s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003897s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011882s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005286s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004233s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007497s ]
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 '205%' OR `brand` LIKE '205%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019596 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019596 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019596 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019596 LIMIT 2 [ RunTime:0.003533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019596 ORDER BY `minOrder` ASC [ RunTime:0.021714s ]
select * from pdf where partno='2059-302/998-403' and brandshort='WAGO' limit 1 [ RunTime:0.008944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2059-302/998-403' OR `brand` LIKE 'WAGO(万可)%' ) ) LIMIT 1 [ RunTime:0.010042s ]
SELECT `id` FROM `stock` WHERE `id` <> 58019596 AND `partno` = '2059-302/998-403' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wago%' ) [ RunTime:0.010430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60559327 [ RunTime:0.007348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019893 LIMIT 5 [ RunTime:0.001766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019893 ORDER BY `minOrder` ASC [ RunTime:0.002255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019893 ORDER BY `unit` DESC [ RunTime:0.002923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019893 LIMIT 2 [ RunTime:0.004350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019893 ORDER BY `minOrder` ASC [ RunTime:0.001201s ]
select * from pdf where partno='2059-301/998-403' and brandshort='WAGO' limit 1 [ RunTime:0.001405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2059-301/998-403' OR `brand` LIKE 'WAGO(万可)%' ) ) LIMIT 1 [ RunTime:0.001624s ]
SELECT `id` FROM `stock` WHERE `id` <> 58019893 AND `partno` = '2059-301/998-403' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wago%' ) [ RunTime:0.001923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12543207 [ RunTime:0.006540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51017118 LIMIT 5 [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51017118 ORDER BY `minOrder` ASC [ RunTime:0.003198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51017118 ORDER BY `unit` DESC [ RunTime:0.001021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51017118 LIMIT 2 [ RunTime:0.002723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51017118 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='2051-09-SM-RPLF' and brandshort='BOURNS' limit 1 [ RunTime:0.001199s ]
select foldpath,foldpath2,filename from pdf_file where id=1167049 limit 1 [ RunTime:0.005067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2051-09-SM-RPLF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.009279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58025893 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58025893 ORDER BY `minOrder` ASC [ RunTime:0.005679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58025893 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58025893 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58025893 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='2058943-4' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2058943-4' OR `brand` LIKE 'TE Connectivity(泰科电子)%' ) ) LIMIT 1 [ RunTime:0.009947s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '205%' OR `brand` LIKE '205%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010667s ]