SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002128s ]
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=2045&search=1' [ RunTime:0.003179s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002499s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002329s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001887s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002484s ]
SELECT * FROM `stock_search` WHERE `partno` = '2045' LIMIT 1 [ RunTime:0.001122s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-24 04:32:38' WHERE `partno` = '2045' [ RunTime:0.001861s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002498s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023769s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619136 LIMIT 5 [ RunTime:0.008602s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619136 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619136 ORDER BY `unit` DESC [ RunTime:0.014074s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619136 LIMIT 2 [ RunTime:0.005840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619136 ORDER BY `minOrder` ASC [ RunTime:0.002197s ]
select * from pdf where partno='2045320201' and brandshort='Molex' limit 1 [ RunTime:0.015313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619469 LIMIT 5 [ RunTime:0.006632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619469 ORDER BY `minOrder` ASC [ RunTime:0.002386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619469 ORDER BY `unit` DESC [ RunTime:0.013125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619469 LIMIT 2 [ RunTime:0.006068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619469 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
select * from pdf where partno='2045320301' and brandshort='Molex' limit 1 [ RunTime:0.021287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487578 LIMIT 5 [ RunTime:0.015264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487578 ORDER BY `minOrder` ASC [ RunTime:0.010297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487578 ORDER BY `unit` DESC [ RunTime:0.029336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487578 LIMIT 2 [ RunTime:0.015150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487578 ORDER BY `minOrder` ASC [ RunTime:0.018742s ]
select * from pdf where partno='2045320401' and brandshort='Molex' limit 1 [ RunTime:0.009153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618422 LIMIT 5 [ RunTime:0.025752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618422 ORDER BY `minOrder` ASC [ RunTime:0.044845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618422 ORDER BY `unit` DESC [ RunTime:0.016432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618422 LIMIT 2 [ RunTime:0.024486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618422 ORDER BY `minOrder` ASC [ RunTime:0.010362s ]
select * from pdf where partno='2045320501' and brandshort='Molex' limit 1 [ RunTime:0.002094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629205 LIMIT 5 [ RunTime:0.020370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629205 ORDER BY `minOrder` ASC [ RunTime:0.027328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629205 ORDER BY `unit` DESC [ RunTime:0.034241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629205 LIMIT 2 [ RunTime:0.009539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629205 ORDER BY `minOrder` ASC [ RunTime:0.005440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488371 LIMIT 5 [ RunTime:0.030588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488371 ORDER BY `minOrder` ASC [ RunTime:0.050675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488371 ORDER BY `unit` DESC [ RunTime:0.030048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488371 LIMIT 2 [ RunTime:0.023543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488371 ORDER BY `minOrder` ASC [ RunTime:0.009273s ]
select * from pdf where partno='2045321001' and brandshort='Molex' limit 1 [ RunTime:0.026886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494992 LIMIT 5 [ RunTime:0.020540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494992 ORDER BY `minOrder` ASC [ RunTime:0.021613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494992 ORDER BY `unit` DESC [ RunTime:0.021447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494992 LIMIT 2 [ RunTime:0.014950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494992 ORDER BY `minOrder` ASC [ RunTime:0.023093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487964 LIMIT 5 [ RunTime:0.017618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487964 ORDER BY `minOrder` ASC [ RunTime:0.025399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487964 ORDER BY `unit` DESC [ RunTime:0.052405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487964 LIMIT 2 [ RunTime:0.022058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487964 ORDER BY `minOrder` ASC [ RunTime:0.005882s ]
select * from pdf where partno='2045320601' and brandshort='Molex' limit 1 [ RunTime:0.025962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487991 LIMIT 5 [ RunTime:0.053713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487991 ORDER BY `minOrder` ASC [ RunTime:0.052695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487991 ORDER BY `unit` DESC [ RunTime:0.013044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487991 LIMIT 2 [ RunTime:0.009800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487991 ORDER BY `minOrder` ASC [ RunTime:0.016503s ]
select * from pdf where partno='2045320801' and brandshort='Molex' limit 1 [ RunTime:0.018634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12622719 LIMIT 5 [ RunTime:0.056761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12622719 ORDER BY `minOrder` ASC [ RunTime:0.044164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12622719 ORDER BY `unit` DESC [ RunTime:0.011188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12622719 LIMIT 2 [ RunTime:0.040058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12622719 ORDER BY `minOrder` ASC [ RunTime:0.048978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621058 LIMIT 5 [ RunTime:0.106214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621058 ORDER BY `minOrder` ASC [ RunTime:0.025139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621058 ORDER BY `unit` DESC [ RunTime:0.074239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621058 LIMIT 2 [ RunTime:0.052680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621058 ORDER BY `minOrder` ASC [ RunTime:0.047824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664422 LIMIT 5 [ RunTime:0.056051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664422 ORDER BY `minOrder` ASC [ RunTime:0.064739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12664422 ORDER BY `unit` DESC [ RunTime:0.019134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12664422 LIMIT 2 [ RunTime:0.046909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664422 ORDER BY `minOrder` ASC [ RunTime:0.002559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629368 LIMIT 5 [ RunTime:0.037349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629368 ORDER BY `minOrder` ASC [ RunTime:0.093909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629368 ORDER BY `unit` DESC [ RunTime:0.054383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629368 LIMIT 2 [ RunTime:0.050871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629368 ORDER BY `minOrder` ASC [ RunTime:0.033387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618932 LIMIT 5 [ RunTime:0.034905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618932 ORDER BY `minOrder` ASC [ RunTime:0.019135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618932 ORDER BY `unit` DESC [ RunTime:0.045036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618932 LIMIT 2 [ RunTime:0.048003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618932 ORDER BY `minOrder` ASC [ RunTime:0.034443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518752 LIMIT 5 [ RunTime:0.051347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518752 ORDER BY `minOrder` ASC [ RunTime:0.042921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11518752 ORDER BY `unit` DESC [ RunTime:0.046980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11518752 LIMIT 2 [ RunTime:0.085957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518752 ORDER BY `minOrder` ASC [ RunTime:0.023276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900265 LIMIT 5 [ RunTime:0.036559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900265 ORDER BY `minOrder` ASC [ RunTime:0.035269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900265 ORDER BY `unit` DESC [ RunTime:0.042674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900265 LIMIT 2 [ RunTime:0.052634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900265 ORDER BY `minOrder` ASC [ RunTime:0.059420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617810 LIMIT 5 [ RunTime:0.050688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617810 ORDER BY `minOrder` ASC [ RunTime:0.015011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12617810 ORDER BY `unit` DESC [ RunTime:0.033817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12617810 LIMIT 2 [ RunTime:0.006079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617810 ORDER BY `minOrder` ASC [ RunTime:0.020073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13177402 LIMIT 5 [ RunTime:0.032695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13177402 ORDER BY `minOrder` ASC [ RunTime:0.011746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13177402 ORDER BY `unit` DESC [ RunTime:0.104892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13177402 LIMIT 2 [ RunTime:0.054711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13177402 ORDER BY `minOrder` ASC [ RunTime:0.021237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794669 LIMIT 5 [ RunTime:0.015841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794669 ORDER BY `minOrder` ASC [ RunTime:0.005256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14794669 ORDER BY `unit` DESC [ RunTime:0.006111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14794669 LIMIT 2 [ RunTime:0.013469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794669 ORDER BY `minOrder` ASC [ RunTime:0.017873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11880395 LIMIT 5 [ RunTime:0.030435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11880395 ORDER BY `minOrder` ASC [ RunTime:0.015786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11880395 ORDER BY `unit` DESC [ RunTime:0.022398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11880395 LIMIT 2 [ RunTime:0.027388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11880395 ORDER BY `minOrder` ASC [ RunTime:0.018005s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277243 LIMIT 5 [ RunTime:0.078019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277243 ORDER BY `minOrder` ASC [ RunTime:0.032794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277243 ORDER BY `unit` DESC [ RunTime:0.017316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277243 LIMIT 2 [ RunTime:0.034936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277243 ORDER BY `minOrder` ASC [ RunTime:0.016313s ]
select * from pdf where partno='204532-0801' and brandshort='molex' limit 1 [ RunTime:0.022061s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '204532-0801' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.033664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266648 LIMIT 5 [ RunTime:0.028268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266648 ORDER BY `minOrder` ASC [ RunTime:0.038582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32266648 ORDER BY `unit` DESC [ RunTime:0.018507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32266648 LIMIT 2 [ RunTime:0.015021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266648 ORDER BY `minOrder` ASC [ RunTime:0.014463s ]
select * from pdf where partno='204501-5' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.027564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '204501-5' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.005914s ]
SELECT `id` FROM `stock` WHERE `id` <> 32266648 AND `partno` = '204501-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.031907s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935564 LIMIT 5 [ RunTime:0.023406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935564 ORDER BY `minOrder` ASC [ RunTime:0.018111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935564 ORDER BY `unit` DESC [ RunTime:0.025050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935564 LIMIT 2 [ RunTime:0.010209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935564 ORDER BY `minOrder` ASC [ RunTime:0.010157s ]
select * from pdf where partno='2045320301' and brandshort='Molex' limit 1 [ RunTime:0.007660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320301' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.051028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935565 LIMIT 5 [ RunTime:0.016512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935565 ORDER BY `minOrder` ASC [ RunTime:0.043379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935565 ORDER BY `unit` DESC [ RunTime:0.016203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935565 LIMIT 2 [ RunTime:0.007642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935565 ORDER BY `minOrder` ASC [ RunTime:0.011520s ]
select * from pdf where partno='2045320201' and brandshort='Molex' limit 1 [ RunTime:0.000911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320201' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935568 LIMIT 5 [ RunTime:0.010716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935568 ORDER BY `minOrder` ASC [ RunTime:0.015800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935568 ORDER BY `unit` DESC [ RunTime:0.006941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935568 LIMIT 2 [ RunTime:0.014888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935568 ORDER BY `minOrder` ASC [ RunTime:0.004665s ]
select * from pdf where partno='2045320501' and brandshort='Molex' limit 1 [ RunTime:0.001930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320501' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935569 LIMIT 5 [ RunTime:0.001756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935569 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935569 ORDER BY `unit` DESC [ RunTime:0.005744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935569 LIMIT 2 [ RunTime:0.021805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935569 ORDER BY `minOrder` ASC [ RunTime:0.005165s ]
select * from pdf where partno='2045320401' and brandshort='Molex' limit 1 [ RunTime:0.002912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320401' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935631 LIMIT 5 [ RunTime:0.026588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935631 ORDER BY `minOrder` ASC [ RunTime:0.029317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935631 ORDER BY `unit` DESC [ RunTime:0.005177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935631 LIMIT 2 [ RunTime:0.017395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935631 ORDER BY `minOrder` ASC [ RunTime:0.015083s ]
select * from pdf where partno='2045321001' and brandshort='Molex' limit 1 [ RunTime:0.021530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045321001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.040654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935604 LIMIT 5 [ RunTime:0.016394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935604 ORDER BY `minOrder` ASC [ RunTime:0.021539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935604 ORDER BY `unit` DESC [ RunTime:0.050598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935604 LIMIT 2 [ RunTime:0.028380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935604 ORDER BY `minOrder` ASC [ RunTime:0.026515s ]
select * from pdf where partno='2045320801' and brandshort='Molex' limit 1 [ RunTime:0.019582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320801' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.043815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935606 LIMIT 5 [ RunTime:0.014963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935606 ORDER BY `minOrder` ASC [ RunTime:0.022641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935606 ORDER BY `unit` DESC [ RunTime:0.011076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935606 LIMIT 2 [ RunTime:0.012976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935606 ORDER BY `minOrder` ASC [ RunTime:0.021559s ]
select * from pdf where partno='2045320901' and brandshort='Molex' limit 1 [ RunTime:0.060569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320901' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.094063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59748785 LIMIT 5 [ RunTime:0.053867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748785 ORDER BY `minOrder` ASC [ RunTime:0.033153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59748785 ORDER BY `unit` DESC [ RunTime:0.040489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59748785 LIMIT 2 [ RunTime:0.035494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748785 ORDER BY `minOrder` ASC [ RunTime:0.076489s ]
select * from pdf where partno='20455-030E-76' and brandshort='I-PEX' limit 1 [ RunTime:0.046504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20455-030E-76' OR `brand` LIKE 'I-PEX%' ) ) LIMIT 1 [ RunTime:0.045259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935734 LIMIT 5 [ RunTime:0.059100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935734 ORDER BY `minOrder` ASC [ RunTime:0.057957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935734 ORDER BY `unit` DESC [ RunTime:0.050295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935734 LIMIT 2 [ RunTime:0.103000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935734 ORDER BY `minOrder` ASC [ RunTime:0.057767s ]
select * from pdf where partno='2045321201' and brandshort='Molex' limit 1 [ RunTime:0.047778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045321201' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.062245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59748797 LIMIT 5 [ RunTime:0.051065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748797 ORDER BY `minOrder` ASC [ RunTime:0.124240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59748797 ORDER BY `unit` DESC [ RunTime:0.046879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59748797 LIMIT 2 [ RunTime:0.046253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748797 ORDER BY `minOrder` ASC [ RunTime:0.013262s ]
select * from pdf where partno='20455-040E-76' and brandshort='I-PEX' limit 1 [ RunTime:0.052986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20455-040E-76' OR `brand` LIKE 'I-PEX%' ) ) LIMIT 1 [ RunTime:0.023743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59748773 LIMIT 5 [ RunTime:0.023019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748773 ORDER BY `minOrder` ASC [ RunTime:0.046765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59748773 ORDER BY `unit` DESC [ RunTime:0.046759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59748773 LIMIT 2 [ RunTime:0.033580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748773 ORDER BY `minOrder` ASC [ RunTime:0.012637s ]
select * from pdf where partno='20455-A20E-76' and brandshort='I-PEX' limit 1 [ RunTime:0.010673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20455-A20E-76' OR `brand` LIKE 'I-PEX%' ) ) LIMIT 1 [ RunTime:0.053619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938868 LIMIT 5 [ RunTime:0.051491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938868 ORDER BY `minOrder` ASC [ RunTime:0.047354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938868 ORDER BY `unit` DESC [ RunTime:0.056046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938868 LIMIT 2 [ RunTime:0.040974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938868 ORDER BY `minOrder` ASC [ RunTime:0.014495s ]
select * from pdf where partno='2045321601' and brandshort='Molex' limit 1 [ RunTime:0.022059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045321601' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.027710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936131 LIMIT 5 [ RunTime:0.037048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936131 ORDER BY `minOrder` ASC [ RunTime:0.046760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936131 ORDER BY `unit` DESC [ RunTime:0.017674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936131 LIMIT 2 [ RunTime:0.003718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936131 ORDER BY `minOrder` ASC [ RunTime:0.013558s ]
select * from pdf where partno='2045231001' and brandshort='Molex' limit 1 [ RunTime:0.023364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045231001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935684 LIMIT 5 [ RunTime:0.007332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935684 ORDER BY `minOrder` ASC [ RunTime:0.043971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935684 ORDER BY `unit` DESC [ RunTime:0.006030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935684 LIMIT 2 [ RunTime:0.023619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935684 ORDER BY `minOrder` ASC [ RunTime:0.009786s ]
select * from pdf where partno='2045230601' and brandshort='Molex' limit 1 [ RunTime:0.002486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045230601' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750097 LIMIT 5 [ RunTime:0.043705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750097 ORDER BY `minOrder` ASC [ RunTime:0.013580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750097 ORDER BY `unit` DESC [ RunTime:0.014148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750097 LIMIT 2 [ RunTime:0.020569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750097 ORDER BY `minOrder` ASC [ RunTime:0.009287s ]
select * from pdf where partno='20455-050E-76' and brandshort='I-PEX' limit 1 [ RunTime:0.045128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20455-050E-76' OR `brand` LIKE 'I-PEX%' ) ) LIMIT 1 [ RunTime:0.019045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935587 LIMIT 5 [ RunTime:0.012600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935587 ORDER BY `minOrder` ASC [ RunTime:0.004644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935587 ORDER BY `unit` DESC [ RunTime:0.014340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935587 LIMIT 2 [ RunTime:0.083605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935587 ORDER BY `minOrder` ASC [ RunTime:0.015689s ]
select * from pdf where partno='2045320601' and brandshort='Molex' limit 1 [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045320601' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.025759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936205 LIMIT 5 [ RunTime:0.033636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936205 ORDER BY `minOrder` ASC [ RunTime:0.009515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936205 ORDER BY `unit` DESC [ RunTime:0.033383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936205 LIMIT 2 [ RunTime:0.017459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936205 ORDER BY `minOrder` ASC [ RunTime:0.007983s ]
select * from pdf where partno='2045231201' and brandshort='Molex' limit 1 [ RunTime:0.009969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045231201' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.033471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935858 LIMIT 5 [ RunTime:0.031393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935858 ORDER BY `minOrder` ASC [ RunTime:0.017830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935858 ORDER BY `unit` DESC [ RunTime:0.008263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935858 LIMIT 2 [ RunTime:0.018577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935858 ORDER BY `minOrder` ASC [ RunTime:0.012525s ]
select * from pdf where partno='2045230801' and brandshort='Molex' limit 1 [ RunTime:0.005591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045230801' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.042179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58205486 LIMIT 5 [ RunTime:0.025851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58205486 ORDER BY `minOrder` ASC [ RunTime:0.016493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58205486 ORDER BY `unit` DESC [ RunTime:0.021081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58205486 LIMIT 2 [ RunTime:0.043845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58205486 ORDER BY `minOrder` ASC [ RunTime:0.017292s ]
select * from pdf where partno='2045-35-BT1LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.042649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045-35-BT1LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.026626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58205487 LIMIT 5 [ RunTime:0.007901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58205487 ORDER BY `minOrder` ASC [ RunTime:0.048555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58205487 ORDER BY `unit` DESC [ RunTime:0.039151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58205487 LIMIT 2 [ RunTime:0.016012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58205487 ORDER BY `minOrder` ASC [ RunTime:0.020370s ]
select * from pdf where partno='2045-14-BT1LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.038466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2045-14-BT1LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.033518s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022228s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063773s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045955s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061738s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055863s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031710s ]
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 '2045%' OR `brand` LIKE '2045%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.116055s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2045%' OR `brand` LIKE '2045%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022614s ]