SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002959s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=14166&search=1' [ RunTime:0.004233s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001427s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001086s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003069s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001230s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001509s ]
SELECT * FROM `stock_search` WHERE `partno` = '14166' LIMIT 1 [ RunTime:0.001411s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-24 02:08:57' WHERE `partno` = '14166' [ RunTime:0.004300s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001286s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082370s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.020294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13795918 LIMIT 5 [ RunTime:0.013535s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795918 ORDER BY `minOrder` ASC [ RunTime:0.013759s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13795918 ORDER BY `unit` DESC [ RunTime:0.005270s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13795918 LIMIT 2 [ RunTime:0.037432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795918 ORDER BY `minOrder` ASC [ RunTime:0.014762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14682087 LIMIT 5 [ RunTime:0.011322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682087 ORDER BY `minOrder` ASC [ RunTime:0.015804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14682087 ORDER BY `unit` DESC [ RunTime:0.022926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14682087 LIMIT 2 [ RunTime:0.019750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682087 ORDER BY `minOrder` ASC [ RunTime:0.019306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14684085 LIMIT 5 [ RunTime:0.050431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14684085 ORDER BY `minOrder` ASC [ RunTime:0.026912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14684085 ORDER BY `unit` DESC [ RunTime:0.056261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14684085 LIMIT 2 [ RunTime:0.018374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14684085 ORDER BY `minOrder` ASC [ RunTime:0.006632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13795490 LIMIT 5 [ RunTime:0.018563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795490 ORDER BY `minOrder` ASC [ RunTime:0.010517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13795490 ORDER BY `unit` DESC [ RunTime:0.020786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13795490 LIMIT 2 [ RunTime:0.058993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795490 ORDER BY `minOrder` ASC [ RunTime:0.001526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14682762 LIMIT 5 [ RunTime:0.029716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682762 ORDER BY `minOrder` ASC [ RunTime:0.007733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14682762 ORDER BY `unit` DESC [ RunTime:0.007142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14682762 LIMIT 2 [ RunTime:0.012280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682762 ORDER BY `minOrder` ASC [ RunTime:0.016864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14681421 LIMIT 5 [ RunTime:0.035882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14681421 ORDER BY `minOrder` ASC [ RunTime:0.026179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14681421 ORDER BY `unit` DESC [ RunTime:0.014549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14681421 LIMIT 2 [ RunTime:0.009454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14681421 ORDER BY `minOrder` ASC [ RunTime:0.010581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13795493 LIMIT 5 [ RunTime:0.009157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795493 ORDER BY `minOrder` ASC [ RunTime:0.064341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13795493 ORDER BY `unit` DESC [ RunTime:0.034948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13795493 LIMIT 2 [ RunTime:0.018951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795493 ORDER BY `minOrder` ASC [ RunTime:0.011547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787277 LIMIT 5 [ RunTime:0.034407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787277 ORDER BY `minOrder` ASC [ RunTime:0.024784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787277 ORDER BY `unit` DESC [ RunTime:0.025468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787277 LIMIT 2 [ RunTime:0.012346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787277 ORDER BY `minOrder` ASC [ RunTime:0.013059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787091 LIMIT 5 [ RunTime:0.020413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787091 ORDER BY `minOrder` ASC [ RunTime:0.024990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787091 ORDER BY `unit` DESC [ RunTime:0.025359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787091 LIMIT 2 [ RunTime:0.014896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787091 ORDER BY `minOrder` ASC [ RunTime:0.010799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671157 LIMIT 5 [ RunTime:0.016638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671157 ORDER BY `minOrder` ASC [ RunTime:0.013550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671157 ORDER BY `unit` DESC [ RunTime:0.031690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671157 LIMIT 2 [ RunTime:0.031299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671157 ORDER BY `minOrder` ASC [ RunTime:0.035689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671003 LIMIT 5 [ RunTime:0.016557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671003 ORDER BY `minOrder` ASC [ RunTime:0.024210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671003 ORDER BY `unit` DESC [ RunTime:0.035898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671003 LIMIT 2 [ RunTime:0.052021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671003 ORDER BY `minOrder` ASC [ RunTime:0.029499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14670957 LIMIT 5 [ RunTime:0.007951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670957 ORDER BY `minOrder` ASC [ RunTime:0.022594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14670957 ORDER BY `unit` DESC [ RunTime:0.024351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14670957 LIMIT 2 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670957 ORDER BY `minOrder` ASC [ RunTime:0.013119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787151 LIMIT 5 [ RunTime:0.004982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787151 ORDER BY `minOrder` ASC [ RunTime:0.015446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787151 ORDER BY `unit` DESC [ RunTime:0.018388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787151 LIMIT 2 [ RunTime:0.011012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787151 ORDER BY `minOrder` ASC [ RunTime:0.019037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17482234 LIMIT 5 [ RunTime:0.010261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17482234 ORDER BY `minOrder` ASC [ RunTime:0.014201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17482234 ORDER BY `unit` DESC [ RunTime:0.018710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17482234 LIMIT 2 [ RunTime:0.003617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17482234 ORDER BY `minOrder` ASC [ RunTime:0.006718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671777 LIMIT 5 [ RunTime:0.013056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671777 ORDER BY `minOrder` ASC [ RunTime:0.007528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671777 ORDER BY `unit` DESC [ RunTime:0.006941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671777 LIMIT 2 [ RunTime:0.005714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671777 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671144 LIMIT 5 [ RunTime:0.014197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671144 ORDER BY `minOrder` ASC [ RunTime:0.022291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671144 ORDER BY `unit` DESC [ RunTime:0.006465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671144 LIMIT 2 [ RunTime:0.011774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671144 ORDER BY `minOrder` ASC [ RunTime:0.015324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671051 LIMIT 5 [ RunTime:0.010056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671051 ORDER BY `minOrder` ASC [ RunTime:0.019446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671051 ORDER BY `unit` DESC [ RunTime:0.019694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671051 LIMIT 2 [ RunTime:0.012513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671051 ORDER BY `minOrder` ASC [ RunTime:0.007203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14670833 LIMIT 5 [ RunTime:0.044350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670833 ORDER BY `minOrder` ASC [ RunTime:0.017666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14670833 ORDER BY `unit` DESC [ RunTime:0.014349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14670833 LIMIT 2 [ RunTime:0.018671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670833 ORDER BY `minOrder` ASC [ RunTime:0.002405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787333 LIMIT 5 [ RunTime:0.019819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787333 ORDER BY `minOrder` ASC [ RunTime:0.025136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787333 ORDER BY `unit` DESC [ RunTime:0.021872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787333 LIMIT 2 [ RunTime:0.022959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787333 ORDER BY `minOrder` ASC [ RunTime:0.004883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787253 LIMIT 5 [ RunTime:0.007439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787253 ORDER BY `minOrder` ASC [ RunTime:0.017171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787253 ORDER BY `unit` DESC [ RunTime:0.008696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787253 LIMIT 2 [ RunTime:0.016059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787253 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015732s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52915766 LIMIT 5 [ RunTime:0.011678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52915766 ORDER BY `minOrder` ASC [ RunTime:0.016192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52915766 ORDER BY `unit` DESC [ RunTime:0.000881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52915766 LIMIT 2 [ RunTime:0.015283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52915766 ORDER BY `minOrder` ASC [ RunTime:0.008094s ]
select * from pdf where partno='1416600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002328s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011039s ]
SELECT `id` FROM `stock` WHERE `id` <> 52915766 AND `partno` = '1416600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11524659 [ RunTime:0.043804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55312749 LIMIT 5 [ RunTime:0.016563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55312749 ORDER BY `minOrder` ASC [ RunTime:0.009243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55312749 ORDER BY `unit` DESC [ RunTime:0.005211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55312749 LIMIT 2 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55312749 ORDER BY `minOrder` ASC [ RunTime:0.002017s ]
select * from pdf where partno='1416673' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416673' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311097 LIMIT 5 [ RunTime:0.014699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311097 ORDER BY `minOrder` ASC [ RunTime:0.018953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311097 ORDER BY `unit` DESC [ RunTime:0.004208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311097 LIMIT 2 [ RunTime:0.002570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311097 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
select * from pdf where partno='1416646' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416646' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311078 LIMIT 5 [ RunTime:0.005086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311078 ORDER BY `minOrder` ASC [ RunTime:0.011035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311078 ORDER BY `unit` DESC [ RunTime:0.023379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311078 LIMIT 2 [ RunTime:0.026750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311078 ORDER BY `minOrder` ASC [ RunTime:0.008642s ]
select * from pdf where partno='1416633' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416633' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311012 LIMIT 5 [ RunTime:0.005798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311012 ORDER BY `minOrder` ASC [ RunTime:0.008497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311012 ORDER BY `unit` DESC [ RunTime:0.008484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311012 LIMIT 2 [ RunTime:0.005064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311012 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='1416600' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416600' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55310737 LIMIT 5 [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55310737 ORDER BY `minOrder` ASC [ RunTime:0.031319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55310737 ORDER BY `unit` DESC [ RunTime:0.009229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55310737 LIMIT 2 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55310737 ORDER BY `minOrder` ASC [ RunTime:0.010480s ]
select * from pdf where partno='1416621' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416621' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55319099 LIMIT 5 [ RunTime:0.004283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319099 ORDER BY `minOrder` ASC [ RunTime:0.011154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55319099 ORDER BY `unit` DESC [ RunTime:0.001965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55319099 LIMIT 2 [ RunTime:0.013113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319099 ORDER BY `minOrder` ASC [ RunTime:0.001955s ]
select * from pdf where partno='1416647' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416647' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318829 LIMIT 5 [ RunTime:0.009458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318829 ORDER BY `minOrder` ASC [ RunTime:0.007125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318829 ORDER BY `unit` DESC [ RunTime:0.018480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318829 LIMIT 2 [ RunTime:0.015305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318829 ORDER BY `minOrder` ASC [ RunTime:0.010149s ]
select * from pdf where partno='1416603' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416603' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318574 LIMIT 5 [ RunTime:0.006310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318574 ORDER BY `minOrder` ASC [ RunTime:0.012406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318574 ORDER BY `unit` DESC [ RunTime:0.009107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318574 LIMIT 2 [ RunTime:0.005418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318574 ORDER BY `minOrder` ASC [ RunTime:0.009459s ]
select * from pdf where partno='1416681' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416681' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311284 LIMIT 5 [ RunTime:0.003794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311284 ORDER BY `minOrder` ASC [ RunTime:0.011782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311284 ORDER BY `unit` DESC [ RunTime:0.014823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311284 LIMIT 2 [ RunTime:0.011164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311284 ORDER BY `minOrder` ASC [ RunTime:0.003310s ]
select * from pdf where partno='1416650' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416650' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55319167 LIMIT 5 [ RunTime:0.007814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319167 ORDER BY `minOrder` ASC [ RunTime:0.004333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55319167 ORDER BY `unit` DESC [ RunTime:0.027475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55319167 LIMIT 2 [ RunTime:0.013156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319167 ORDER BY `minOrder` ASC [ RunTime:0.020468s ]
select * from pdf where partno='1416656' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416656' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318687 LIMIT 5 [ RunTime:0.008676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318687 ORDER BY `minOrder` ASC [ RunTime:0.028574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318687 ORDER BY `unit` DESC [ RunTime:0.026644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318687 LIMIT 2 [ RunTime:0.011987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318687 ORDER BY `minOrder` ASC [ RunTime:0.001495s ]
select * from pdf where partno='1416655' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416655' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318497 LIMIT 5 [ RunTime:0.004703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318497 ORDER BY `minOrder` ASC [ RunTime:0.023833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318497 ORDER BY `unit` DESC [ RunTime:0.016035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318497 LIMIT 2 [ RunTime:0.032210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318497 ORDER BY `minOrder` ASC [ RunTime:0.003277s ]
select * from pdf where partno='1416684' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.033065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416684' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.045067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311042 LIMIT 5 [ RunTime:0.014516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311042 ORDER BY `minOrder` ASC [ RunTime:0.025424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311042 ORDER BY `unit` DESC [ RunTime:0.009746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311042 LIMIT 2 [ RunTime:0.054414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311042 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='1416626' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.036046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416626' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.090684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311013 LIMIT 5 [ RunTime:0.039782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311013 ORDER BY `minOrder` ASC [ RunTime:0.012881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311013 ORDER BY `unit` DESC [ RunTime:0.023317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311013 LIMIT 2 [ RunTime:0.011921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311013 ORDER BY `minOrder` ASC [ RunTime:0.013577s ]
select * from pdf where partno='1416604' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416604' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55349789 LIMIT 5 [ RunTime:0.018112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55349789 ORDER BY `minOrder` ASC [ RunTime:0.030180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55349789 ORDER BY `unit` DESC [ RunTime:0.031455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55349789 LIMIT 2 [ RunTime:0.046139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55349789 ORDER BY `minOrder` ASC [ RunTime:0.005386s ]
select * from pdf where partno='1416671' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.032916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416671' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.034647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55320694 LIMIT 5 [ RunTime:0.050387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55320694 ORDER BY `minOrder` ASC [ RunTime:0.032366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55320694 ORDER BY `unit` DESC [ RunTime:0.023048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55320694 LIMIT 2 [ RunTime:0.013814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55320694 ORDER BY `minOrder` ASC [ RunTime:0.008686s ]
select * from pdf where partno='1416672' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.027910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416672' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318438 LIMIT 5 [ RunTime:0.014135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318438 ORDER BY `minOrder` ASC [ RunTime:0.016766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318438 ORDER BY `unit` DESC [ RunTime:0.016940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318438 LIMIT 2 [ RunTime:0.009027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318438 ORDER BY `minOrder` ASC [ RunTime:0.006431s ]
select * from pdf where partno='1416688' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416688' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318319 LIMIT 5 [ RunTime:0.020129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318319 ORDER BY `minOrder` ASC [ RunTime:0.026253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318319 ORDER BY `unit` DESC [ RunTime:0.017575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318319 LIMIT 2 [ RunTime:0.006723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318319 ORDER BY `minOrder` ASC [ RunTime:0.008181s ]
select * from pdf where partno='1416631' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416631' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318282 LIMIT 5 [ RunTime:0.004859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318282 ORDER BY `minOrder` ASC [ RunTime:0.007864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318282 ORDER BY `unit` DESC [ RunTime:0.027466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318282 LIMIT 2 [ RunTime:0.011027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318282 ORDER BY `minOrder` ASC [ RunTime:0.013126s ]
select * from pdf where partno='1416618' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1416618' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019871s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008011s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021252s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012333s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021844s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014710s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005984s ]
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 '14166%' OR `brand` LIKE '14166%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013918s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14166%' OR `brand` LIKE '14166%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013005s ]