SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001435s ]
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=14006&search=1' [ RunTime:0.008076s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002125s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008380s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002798s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002207s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002384s ]
SELECT * FROM `stock_search` WHERE `partno` = '14006' LIMIT 1 [ RunTime:0.000788s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 16:15:48' WHERE `partno` = '14006' [ RunTime:0.010478s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002822s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019990s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883321 LIMIT 5 [ RunTime:0.033725s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883321 ORDER BY `minOrder` ASC [ RunTime:0.003677s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883321 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883321 LIMIT 2 [ RunTime:0.006127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883321 ORDER BY `minOrder` ASC [ RunTime:0.001573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095072 LIMIT 5 [ RunTime:0.003714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095072 ORDER BY `minOrder` ASC [ RunTime:0.012290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095072 ORDER BY `unit` DESC [ RunTime:0.005417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095072 LIMIT 2 [ RunTime:0.042188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095072 ORDER BY `minOrder` ASC [ RunTime:0.010391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13575167 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13575167 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13575167 ORDER BY `unit` DESC [ RunTime:0.000427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13575167 LIMIT 2 [ RunTime:0.001255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13575167 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644937 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644937 ORDER BY `minOrder` ASC [ RunTime:0.010508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644937 ORDER BY `unit` DESC [ RunTime:0.023267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644937 LIMIT 2 [ RunTime:0.033154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644937 ORDER BY `minOrder` ASC [ RunTime:0.009598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095380 LIMIT 5 [ RunTime:0.015534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095380 ORDER BY `minOrder` ASC [ RunTime:0.009989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095380 ORDER BY `unit` DESC [ RunTime:0.006292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095380 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095380 ORDER BY `minOrder` ASC [ RunTime:0.003127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095378 LIMIT 5 [ RunTime:0.011348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095378 ORDER BY `minOrder` ASC [ RunTime:0.005774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095378 ORDER BY `unit` DESC [ RunTime:0.011759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095378 LIMIT 2 [ RunTime:0.009786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095378 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095377 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095377 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095377 ORDER BY `unit` DESC [ RunTime:0.002693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095377 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095377 ORDER BY `minOrder` ASC [ RunTime:0.005294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095375 LIMIT 5 [ RunTime:0.009647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095375 ORDER BY `minOrder` ASC [ RunTime:0.006223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095375 ORDER BY `unit` DESC [ RunTime:0.005472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095375 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095375 ORDER BY `minOrder` ASC [ RunTime:0.001549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095287 LIMIT 5 [ RunTime:0.006062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095287 ORDER BY `minOrder` ASC [ RunTime:0.003767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095287 ORDER BY `unit` DESC [ RunTime:0.018078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095287 LIMIT 2 [ RunTime:0.013445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095287 ORDER BY `minOrder` ASC [ RunTime:0.002057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19095159 LIMIT 5 [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095159 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19095159 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19095159 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19095159 ORDER BY `minOrder` ASC [ RunTime:0.006571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19094133 LIMIT 5 [ RunTime:0.007663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094133 ORDER BY `minOrder` ASC [ RunTime:0.009323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19094133 ORDER BY `unit` DESC [ RunTime:0.005866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19094133 LIMIT 2 [ RunTime:0.015333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094133 ORDER BY `minOrder` ASC [ RunTime:0.002349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18610806 LIMIT 5 [ RunTime:0.017202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18610806 ORDER BY `minOrder` ASC [ RunTime:0.006179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18610806 ORDER BY `unit` DESC [ RunTime:0.025174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18610806 LIMIT 2 [ RunTime:0.012164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18610806 ORDER BY `minOrder` ASC [ RunTime:0.036786s ]
select * from pdf where partno='14006-2PPS REV L-G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.022769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17079263 LIMIT 5 [ RunTime:0.029391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17079263 ORDER BY `minOrder` ASC [ RunTime:0.025822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17079263 ORDER BY `unit` DESC [ RunTime:0.018675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17079263 LIMIT 2 [ RunTime:0.035334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17079263 ORDER BY `minOrder` ASC [ RunTime:0.005959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17078980 LIMIT 5 [ RunTime:0.022203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17078980 ORDER BY `minOrder` ASC [ RunTime:0.015285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17078980 ORDER BY `unit` DESC [ RunTime:0.017316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17078980 LIMIT 2 [ RunTime:0.022345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17078980 ORDER BY `minOrder` ASC [ RunTime:0.002424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17078821 LIMIT 5 [ RunTime:0.049356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17078821 ORDER BY `minOrder` ASC [ RunTime:0.015191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17078821 ORDER BY `unit` DESC [ RunTime:0.010880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17078821 LIMIT 2 [ RunTime:0.010498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17078821 ORDER BY `minOrder` ASC [ RunTime:0.007802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14440219 LIMIT 5 [ RunTime:0.041159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440219 ORDER BY `minOrder` ASC [ RunTime:0.021691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14440219 ORDER BY `unit` DESC [ RunTime:0.045286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14440219 LIMIT 2 [ RunTime:0.034003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440219 ORDER BY `minOrder` ASC [ RunTime:0.003382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14440218 LIMIT 5 [ RunTime:0.036409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440218 ORDER BY `minOrder` ASC [ RunTime:0.039275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14440218 ORDER BY `unit` DESC [ RunTime:0.034223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14440218 LIMIT 2 [ RunTime:0.018386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440218 ORDER BY `minOrder` ASC [ RunTime:0.014507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14440217 LIMIT 5 [ RunTime:0.008153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440217 ORDER BY `minOrder` ASC [ RunTime:0.045463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14440217 ORDER BY `unit` DESC [ RunTime:0.088203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14440217 LIMIT 2 [ RunTime:0.020329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440217 ORDER BY `minOrder` ASC [ RunTime:0.005602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14440113 LIMIT 5 [ RunTime:0.029728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440113 ORDER BY `minOrder` ASC [ RunTime:0.023202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14440113 ORDER BY `unit` DESC [ RunTime:0.006264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14440113 LIMIT 2 [ RunTime:0.034454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14440113 ORDER BY `minOrder` ASC [ RunTime:0.015630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14437144 LIMIT 5 [ RunTime:0.068965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14437144 ORDER BY `minOrder` ASC [ RunTime:0.047859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14437144 ORDER BY `unit` DESC [ RunTime:0.019902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14437144 LIMIT 2 [ RunTime:0.005427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14437144 ORDER BY `minOrder` ASC [ RunTime:0.007820s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007201s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60605812 LIMIT 5 [ RunTime:0.003625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60605812 ORDER BY `minOrder` ASC [ RunTime:0.012302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60605812 ORDER BY `unit` DESC [ RunTime:0.003901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60605812 LIMIT 2 [ RunTime:0.006271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60605812 ORDER BY `minOrder` ASC [ RunTime:0.011819s ]
select * from pdf where partno='1400620000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002693s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.008934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400620000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005614s ]
SELECT `id` FROM `stock` WHERE `id` <> 60605812 AND `partno` = '1400620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883321 [ RunTime:0.003656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434334 LIMIT 5 [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434334 ORDER BY `minOrder` ASC [ RunTime:0.001242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434334 ORDER BY `unit` DESC [ RunTime:0.016245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434334 LIMIT 2 [ RunTime:0.005819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434334 ORDER BY `minOrder` ASC [ RunTime:0.001856s ]
select * from pdf where partno='1400627' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400627' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434218 LIMIT 5 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434218 ORDER BY `minOrder` ASC [ RunTime:0.005392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434218 ORDER BY `unit` DESC [ RunTime:0.007451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434218 LIMIT 2 [ RunTime:0.002338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434218 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='1400648' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400648' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62233976 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62233976 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62233976 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62233976 LIMIT 2 [ RunTime:0.007956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62233976 ORDER BY `minOrder` ASC [ RunTime:0.001972s ]
select * from pdf where partno='1400622' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400622' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64435831 LIMIT 5 [ RunTime:0.006152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64435831 ORDER BY `minOrder` ASC [ RunTime:0.002992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64435831 ORDER BY `unit` DESC [ RunTime:0.006901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64435831 LIMIT 2 [ RunTime:0.001687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64435831 ORDER BY `minOrder` ASC [ RunTime:0.002932s ]
select * from pdf where partno='1400637' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400637' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64435427 LIMIT 5 [ RunTime:0.003341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64435427 ORDER BY `minOrder` ASC [ RunTime:0.008006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64435427 ORDER BY `unit` DESC [ RunTime:0.009530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64435427 LIMIT 2 [ RunTime:0.005525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64435427 ORDER BY `minOrder` ASC [ RunTime:0.004463s ]
select * from pdf where partno='1400641' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400641' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64435065 LIMIT 5 [ RunTime:0.009449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64435065 ORDER BY `minOrder` ASC [ RunTime:0.025337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64435065 ORDER BY `unit` DESC [ RunTime:0.009377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64435065 LIMIT 2 [ RunTime:0.009533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64435065 ORDER BY `minOrder` ASC [ RunTime:0.012259s ]
select * from pdf where partno='1400620' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400620' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434973 LIMIT 5 [ RunTime:0.024211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434973 ORDER BY `minOrder` ASC [ RunTime:0.047033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434973 ORDER BY `unit` DESC [ RunTime:0.028778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434973 LIMIT 2 [ RunTime:0.014522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434973 ORDER BY `minOrder` ASC [ RunTime:0.026634s ]
select * from pdf where partno='1400605' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400605' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434970 LIMIT 5 [ RunTime:0.016374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434970 ORDER BY `minOrder` ASC [ RunTime:0.015900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434970 ORDER BY `unit` DESC [ RunTime:0.001672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434970 LIMIT 2 [ RunTime:0.016094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434970 ORDER BY `minOrder` ASC [ RunTime:0.004259s ]
select * from pdf where partno='1400694' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.037696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400694' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.047062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434925 LIMIT 5 [ RunTime:0.053244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434925 ORDER BY `minOrder` ASC [ RunTime:0.020889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434925 ORDER BY `unit` DESC [ RunTime:0.018947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434925 LIMIT 2 [ RunTime:0.014552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434925 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
select * from pdf where partno='1400607' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400607' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434924 LIMIT 5 [ RunTime:0.013921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434924 ORDER BY `minOrder` ASC [ RunTime:0.034096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434924 ORDER BY `unit` DESC [ RunTime:0.024754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434924 LIMIT 2 [ RunTime:0.019733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434924 ORDER BY `minOrder` ASC [ RunTime:0.025850s ]
select * from pdf where partno='1400610' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400610' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434812 LIMIT 5 [ RunTime:0.010272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434812 ORDER BY `minOrder` ASC [ RunTime:0.025945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434812 ORDER BY `unit` DESC [ RunTime:0.020092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434812 LIMIT 2 [ RunTime:0.014209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434812 ORDER BY `minOrder` ASC [ RunTime:0.006281s ]
select * from pdf where partno='1400698' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400698' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434543 LIMIT 5 [ RunTime:0.015412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434543 ORDER BY `minOrder` ASC [ RunTime:0.020583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434543 ORDER BY `unit` DESC [ RunTime:0.025211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434543 LIMIT 2 [ RunTime:0.014004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434543 ORDER BY `minOrder` ASC [ RunTime:0.001250s ]
select * from pdf where partno='1400609' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400609' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64028475 LIMIT 5 [ RunTime:0.021204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028475 ORDER BY `minOrder` ASC [ RunTime:0.043104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64028475 ORDER BY `unit` DESC [ RunTime:0.016360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64028475 LIMIT 2 [ RunTime:0.032324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028475 ORDER BY `minOrder` ASC [ RunTime:0.017330s ]
select * from pdf where partno='14006' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.013586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14006' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.017000s ]
SELECT `id` FROM `stock` WHERE `id` <> 64028475 AND `partno` = '14006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.012000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402646 [ RunTime:0.013644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63413045 LIMIT 5 [ RunTime:0.018688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63413045 ORDER BY `minOrder` ASC [ RunTime:0.009354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63413045 ORDER BY `unit` DESC [ RunTime:0.012546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63413045 LIMIT 2 [ RunTime:0.009459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63413045 ORDER BY `minOrder` ASC [ RunTime:0.011453s ]
select * from pdf where partno='14006' and brandshort='80/20, LLC' limit 1 [ RunTime:0.012644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14006' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.042993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62235635 LIMIT 5 [ RunTime:0.006957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62235635 ORDER BY `minOrder` ASC [ RunTime:0.013863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62235635 ORDER BY `unit` DESC [ RunTime:0.023122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62235635 LIMIT 2 [ RunTime:0.036971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62235635 ORDER BY `minOrder` ASC [ RunTime:0.011072s ]
select * from pdf where partno='1400697' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.027456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400697' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.017263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62235556 LIMIT 5 [ RunTime:0.026987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62235556 ORDER BY `minOrder` ASC [ RunTime:0.029606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62235556 ORDER BY `unit` DESC [ RunTime:0.027906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62235556 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62235556 ORDER BY `minOrder` ASC [ RunTime:0.004222s ]
select * from pdf where partno='1400690' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400690' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62234370 LIMIT 5 [ RunTime:0.008120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62234370 ORDER BY `minOrder` ASC [ RunTime:0.020689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62234370 ORDER BY `unit` DESC [ RunTime:0.012770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62234370 LIMIT 2 [ RunTime:0.027499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62234370 ORDER BY `minOrder` ASC [ RunTime:0.017974s ]
select * from pdf where partno='1400684' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400684' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62233844 LIMIT 5 [ RunTime:0.001585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62233844 ORDER BY `minOrder` ASC [ RunTime:0.001597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62233844 ORDER BY `unit` DESC [ RunTime:0.014197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62233844 LIMIT 2 [ RunTime:0.003540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62233844 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='1400695' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400695' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62233843 LIMIT 5 [ RunTime:0.016244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62233843 ORDER BY `minOrder` ASC [ RunTime:0.005356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62233843 ORDER BY `unit` DESC [ RunTime:0.018513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62233843 LIMIT 2 [ RunTime:0.021251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62233843 ORDER BY `minOrder` ASC [ RunTime:0.001451s ]
select * from pdf where partno='1400699' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1400699' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010538s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002888s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012867s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005933s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015104s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017716s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002823s ]
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 '14006%' OR `brand` LIKE '14006%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012885s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14006%' OR `brand` LIKE '14006%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033698s ]