SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001864s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=H8698&search=1' [ RunTime:0.064244s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002403s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.027169s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002433s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.038774s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002124s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.024720s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003040s ]
SELECT * FROM `stock_search` WHERE `partno` = 'H8698' LIMIT 1 [ RunTime:0.089031s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 17:34:49' WHERE `partno` = 'H8698' [ RunTime:0.125096s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003301s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101474s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.062341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18409927 LIMIT 5 [ RunTime:0.087551s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18409927 ORDER BY `minOrder` ASC [ RunTime:0.023652s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.130757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18409927 ORDER BY `unit` DESC [ RunTime:0.233125s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.067312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18409927 LIMIT 2 [ RunTime:0.091352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18409927 ORDER BY `minOrder` ASC [ RunTime:0.025199s ]
select * from pdf where partno='H8698RBYA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.087129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18408372 LIMIT 5 [ RunTime:0.032279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18408372 ORDER BY `minOrder` ASC [ RunTime:0.085238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18408372 ORDER BY `unit` DESC [ RunTime:0.111304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18408372 LIMIT 2 [ RunTime:0.053670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18408372 ORDER BY `minOrder` ASC [ RunTime:0.072655s ]
select * from pdf where partno='H8698KBDA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.067321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18408337 LIMIT 5 [ RunTime:0.119977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18408337 ORDER BY `minOrder` ASC [ RunTime:0.090178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18408337 ORDER BY `unit` DESC [ RunTime:0.127836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18408337 LIMIT 2 [ RunTime:0.090096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18408337 ORDER BY `minOrder` ASC [ RunTime:0.033236s ]
select * from pdf where partno='H8698RBDA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.051341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18404420 LIMIT 5 [ RunTime:0.095638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18404420 ORDER BY `minOrder` ASC [ RunTime:0.043245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18404420 ORDER BY `unit` DESC [ RunTime:0.098312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18404420 LIMIT 2 [ RunTime:0.009787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18404420 ORDER BY `minOrder` ASC [ RunTime:0.016332s ]
select * from pdf where partno='H8698KBCA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.051892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18401721 LIMIT 5 [ RunTime:0.037599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18401721 ORDER BY `minOrder` ASC [ RunTime:0.060463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18401721 ORDER BY `unit` DESC [ RunTime:0.015925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18401721 LIMIT 2 [ RunTime:0.026042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18401721 ORDER BY `minOrder` ASC [ RunTime:0.002262s ]
select * from pdf where partno='H8698KBZA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.017823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15123871 LIMIT 5 [ RunTime:0.015282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15123871 ORDER BY `minOrder` ASC [ RunTime:0.017807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15123871 ORDER BY `unit` DESC [ RunTime:0.042467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15123871 LIMIT 2 [ RunTime:0.012118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15123871 ORDER BY `minOrder` ASC [ RunTime:0.018405s ]
select * from pdf where partno='H8698KBYA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.012556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15121528 LIMIT 5 [ RunTime:0.037781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15121528 ORDER BY `minOrder` ASC [ RunTime:0.020939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15121528 ORDER BY `unit` DESC [ RunTime:0.033333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15121528 LIMIT 2 [ RunTime:0.016417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15121528 ORDER BY `minOrder` ASC [ RunTime:0.002572s ]
select * from pdf where partno='H8698RBZA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.011115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14150786 LIMIT 5 [ RunTime:0.011407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14150786 ORDER BY `minOrder` ASC [ RunTime:0.014624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14150786 ORDER BY `unit` DESC [ RunTime:0.022892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14150786 LIMIT 2 [ RunTime:0.016828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14150786 ORDER BY `minOrder` ASC [ RunTime:0.014719s ]
select * from pdf where partno='H8698RBCA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.010982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14150233 LIMIT 5 [ RunTime:0.013173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14150233 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14150233 ORDER BY `unit` DESC [ RunTime:0.016251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14150233 LIMIT 2 [ RunTime:0.010210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14150233 ORDER BY `minOrder` ASC [ RunTime:0.003517s ]
select * from pdf where partno='H8698RFDA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.011209s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013250s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63080907 LIMIT 5 [ RunTime:0.025759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63080907 ORDER BY `minOrder` ASC [ RunTime:0.008718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63080907 ORDER BY `unit` DESC [ RunTime:0.007178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63080907 LIMIT 2 [ RunTime:0.003229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63080907 ORDER BY `minOrder` ASC [ RunTime:0.002724s ]
select * from pdf where partno='H8698F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001180s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.008490s ]
SELECT `id` FROM `stock` WHERE `id` <> 63080907 AND `partno` = 'H8698F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.007114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63080430 LIMIT 5 [ RunTime:0.006631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63080430 ORDER BY `minOrder` ASC [ RunTime:0.006581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63080430 ORDER BY `unit` DESC [ RunTime:0.009135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63080430 LIMIT 2 [ RunTime:0.003236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63080430 ORDER BY `minOrder` ASC [ RunTime:0.001593s ]
select * from pdf where partno='H8698' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.006406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002171s ]
SELECT `id` FROM `stock` WHERE `id` <> 63080430 AND `partno` = 'H8698' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.013018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38929882 LIMIT 5 [ RunTime:0.001670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38929882 ORDER BY `minOrder` ASC [ RunTime:0.014914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38929882 ORDER BY `unit` DESC [ RunTime:0.006029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38929882 LIMIT 2 [ RunTime:0.005489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38929882 ORDER BY `minOrder` ASC [ RunTime:0.001538s ]
select * from pdf where partno='H8698RBYA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBYA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020487s ]
SELECT `id` FROM `stock` WHERE `id` <> 38929882 AND `partno` = 'H8698RBYA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38929834 LIMIT 5 [ RunTime:0.007556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38929834 ORDER BY `minOrder` ASC [ RunTime:0.023124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38929834 ORDER BY `unit` DESC [ RunTime:0.003642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38929834 LIMIT 2 [ RunTime:0.020045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38929834 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
select * from pdf where partno='H8698KBYA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBYA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001553s ]
SELECT `id` FROM `stock` WHERE `id` <> 38929834 AND `partno` = 'H8698KBYA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38928340 LIMIT 5 [ RunTime:0.006207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38928340 ORDER BY `minOrder` ASC [ RunTime:0.021656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38928340 ORDER BY `unit` DESC [ RunTime:0.003395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38928340 LIMIT 2 [ RunTime:0.005221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38928340 ORDER BY `minOrder` ASC [ RunTime:0.001160s ]
select * from pdf where partno='H8698KBDA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBDA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008400s ]
SELECT `id` FROM `stock` WHERE `id` <> 38928340 AND `partno` = 'H8698KBDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38928286 LIMIT 5 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38928286 ORDER BY `minOrder` ASC [ RunTime:0.009606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38928286 ORDER BY `unit` DESC [ RunTime:0.013986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38928286 LIMIT 2 [ RunTime:0.007276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38928286 ORDER BY `minOrder` ASC [ RunTime:0.017169s ]
select * from pdf where partno='H8698RBDA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBDA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007016s ]
SELECT `id` FROM `stock` WHERE `id` <> 38928286 AND `partno` = 'H8698RBDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38920652 LIMIT 5 [ RunTime:0.004291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38920652 ORDER BY `minOrder` ASC [ RunTime:0.014279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38920652 ORDER BY `unit` DESC [ RunTime:0.010869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38920652 LIMIT 2 [ RunTime:0.002174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38920652 ORDER BY `minOrder` ASC [ RunTime:0.017040s ]
select * from pdf where partno='H8698RBCA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBCA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008107s ]
SELECT `id` FROM `stock` WHERE `id` <> 38920652 AND `partno` = 'H8698RBCA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38920619 LIMIT 5 [ RunTime:0.012856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38920619 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38920619 ORDER BY `unit` DESC [ RunTime:0.000948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38920619 LIMIT 2 [ RunTime:0.004650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38920619 ORDER BY `minOrder` ASC [ RunTime:0.004265s ]
select * from pdf where partno='H8698KBCA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBCA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001738s ]
SELECT `id` FROM `stock` WHERE `id` <> 38920619 AND `partno` = 'H8698KBCA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38912590 LIMIT 5 [ RunTime:0.012762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38912590 ORDER BY `minOrder` ASC [ RunTime:0.011368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38912590 ORDER BY `unit` DESC [ RunTime:0.015471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38912590 LIMIT 2 [ RunTime:0.006941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38912590 ORDER BY `minOrder` ASC [ RunTime:0.006735s ]
select * from pdf where partno='H8698KBYA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.002549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBYA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.003110s ]
SELECT `id` FROM `stock` WHERE `id` <> 38912590 AND `partno` = 'H8698KBYA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.006150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15123871 [ RunTime:0.009366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38911158 LIMIT 5 [ RunTime:0.026698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38911158 ORDER BY `minOrder` ASC [ RunTime:0.017066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38911158 ORDER BY `unit` DESC [ RunTime:0.022121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38911158 LIMIT 2 [ RunTime:0.022978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38911158 ORDER BY `minOrder` ASC [ RunTime:0.007778s ]
select * from pdf where partno='H8698KBZA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBZA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009976s ]
SELECT `id` FROM `stock` WHERE `id` <> 38911158 AND `partno` = 'H8698KBZA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38911119 LIMIT 5 [ RunTime:0.001718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38911119 ORDER BY `minOrder` ASC [ RunTime:0.007778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38911119 ORDER BY `unit` DESC [ RunTime:0.005636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38911119 LIMIT 2 [ RunTime:0.012946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38911119 ORDER BY `minOrder` ASC [ RunTime:0.006394s ]
select * from pdf where partno='H8698RBZA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBZA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018150s ]
SELECT `id` FROM `stock` WHERE `id` <> 38911119 AND `partno` = 'H8698RBZA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.048284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38908748 LIMIT 5 [ RunTime:0.043635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38908748 ORDER BY `minOrder` ASC [ RunTime:0.010683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38908748 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38908748 LIMIT 2 [ RunTime:0.022012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38908748 ORDER BY `minOrder` ASC [ RunTime:0.008561s ]
select * from pdf where partno='H8698KBDA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.003745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBDA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.012941s ]
SELECT `id` FROM `stock` WHERE `id` <> 38908748 AND `partno` = 'H8698KBDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.040205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18408372 [ RunTime:0.008867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38908725 LIMIT 5 [ RunTime:0.016751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38908725 ORDER BY `minOrder` ASC [ RunTime:0.009304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38908725 ORDER BY `unit` DESC [ RunTime:0.013319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38908725 LIMIT 2 [ RunTime:0.006289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38908725 ORDER BY `minOrder` ASC [ RunTime:0.010047s ]
select * from pdf where partno='H8698RBDA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.013540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBDA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.001714s ]
SELECT `id` FROM `stock` WHERE `id` <> 38908725 AND `partno` = 'H8698RBDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.007793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18408337 [ RunTime:0.012017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38899417 LIMIT 5 [ RunTime:0.022871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38899417 ORDER BY `minOrder` ASC [ RunTime:0.015015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38899417 ORDER BY `unit` DESC [ RunTime:0.008885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38899417 LIMIT 2 [ RunTime:0.015499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38899417 ORDER BY `minOrder` ASC [ RunTime:0.013998s ]
select * from pdf where partno='H8698KBCA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.012582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBCA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.008447s ]
SELECT `id` FROM `stock` WHERE `id` <> 38899417 AND `partno` = 'H8698KBCA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.002108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18404420 [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38899291 LIMIT 5 [ RunTime:0.032893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38899291 ORDER BY `minOrder` ASC [ RunTime:0.008547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38899291 ORDER BY `unit` DESC [ RunTime:0.010687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38899291 LIMIT 2 [ RunTime:0.005580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38899291 ORDER BY `minOrder` ASC [ RunTime:0.000862s ]
select * from pdf where partno='H8698RBCA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.002531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBCA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.007348s ]
SELECT `id` FROM `stock` WHERE `id` <> 38899291 AND `partno` = 'H8698RBCA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.025627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14150786 [ RunTime:0.025449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38892656 LIMIT 5 [ RunTime:0.010334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38892656 ORDER BY `minOrder` ASC [ RunTime:0.014390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38892656 ORDER BY `unit` DESC [ RunTime:0.012125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38892656 LIMIT 2 [ RunTime:0.003077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38892656 ORDER BY `minOrder` ASC [ RunTime:0.007864s ]
select * from pdf where partno='H8698KBZA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.002754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698KBZA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.009477s ]
SELECT `id` FROM `stock` WHERE `id` <> 38892656 AND `partno` = 'H8698KBZA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.029526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18401721 [ RunTime:0.007701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38892622 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38892622 ORDER BY `minOrder` ASC [ RunTime:0.022287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38892622 ORDER BY `unit` DESC [ RunTime:0.017354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38892622 LIMIT 2 [ RunTime:0.012967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38892622 ORDER BY `minOrder` ASC [ RunTime:0.004549s ]
select * from pdf where partno='H8698RBZA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.006695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RBZA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.021087s ]
SELECT `id` FROM `stock` WHERE `id` <> 38892622 AND `partno` = 'H8698RBZA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.018952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15121528 [ RunTime:0.002465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38891291 LIMIT 5 [ RunTime:0.013867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38891291 ORDER BY `minOrder` ASC [ RunTime:0.014904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38891291 ORDER BY `unit` DESC [ RunTime:0.013791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38891291 LIMIT 2 [ RunTime:0.012744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38891291 ORDER BY `minOrder` ASC [ RunTime:0.003411s ]
select * from pdf where partno='H8698RFDA' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RFDA' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007319s ]
SELECT `id` FROM `stock` WHERE `id` <> 38891291 AND `partno` = 'H8698RFDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.044081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38881126 LIMIT 5 [ RunTime:0.014462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38881126 ORDER BY `minOrder` ASC [ RunTime:0.016948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38881126 ORDER BY `unit` DESC [ RunTime:0.011254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38881126 LIMIT 2 [ RunTime:0.011790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38881126 ORDER BY `minOrder` ASC [ RunTime:0.009007s ]
select * from pdf where partno='H8698RFDA' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.001340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H8698RFDA' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.030890s ]
SELECT `id` FROM `stock` WHERE `id` <> 38881126 AND `partno` = 'H8698RFDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.029681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14150233 [ RunTime:0.039931s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042585s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032252s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072520s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030586s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041519s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057586s ]
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 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081633s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'H8698%' OR `brand` LIKE 'H8698%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.074621s ]