SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001107s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.180' , `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=109601&search=1' [ RunTime:0.002197s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001202s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001939s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002655s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.180' ) [ RunTime:0.000393s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002277s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003219s ]
SELECT * FROM `stock_search` WHERE `partno` = '109601' LIMIT 1 [ RunTime:0.003049s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 23:02:01' WHERE `partno` = '109601' [ RunTime:0.015553s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002757s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016921s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789465 LIMIT 5 [ RunTime:0.017320s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789465 ORDER BY `minOrder` ASC [ RunTime:0.005362s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13789465 ORDER BY `unit` DESC [ RunTime:0.015070s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13789465 LIMIT 2 [ RunTime:0.010252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789465 ORDER BY `minOrder` ASC [ RunTime:0.004132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14675214 LIMIT 5 [ RunTime:0.006514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14675214 ORDER BY `minOrder` ASC [ RunTime:0.018188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14675214 ORDER BY `unit` DESC [ RunTime:0.014090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14675214 LIMIT 2 [ RunTime:0.025680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14675214 ORDER BY `minOrder` ASC [ RunTime:0.005599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14670903 LIMIT 5 [ RunTime:0.007473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670903 ORDER BY `minOrder` ASC [ RunTime:0.016838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14670903 ORDER BY `unit` DESC [ RunTime:0.002684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14670903 LIMIT 2 [ RunTime:0.017208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670903 ORDER BY `minOrder` ASC [ RunTime:0.011757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697306 LIMIT 5 [ RunTime:0.013782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697306 ORDER BY `minOrder` ASC [ RunTime:0.013600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14697306 ORDER BY `unit` DESC [ RunTime:0.012869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14697306 LIMIT 2 [ RunTime:0.021054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697306 ORDER BY `minOrder` ASC [ RunTime:0.012079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787613 LIMIT 5 [ RunTime:0.010823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787613 ORDER BY `minOrder` ASC [ RunTime:0.033205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787613 ORDER BY `unit` DESC [ RunTime:0.024298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787613 LIMIT 2 [ RunTime:0.015717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787613 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643993 LIMIT 5 [ RunTime:0.030487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643993 ORDER BY `minOrder` ASC [ RunTime:0.008107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643993 ORDER BY `unit` DESC [ RunTime:0.026310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643993 LIMIT 2 [ RunTime:0.064226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643993 ORDER BY `minOrder` ASC [ RunTime:0.045455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979809 LIMIT 5 [ RunTime:0.009009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979809 ORDER BY `minOrder` ASC [ RunTime:0.045783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979809 ORDER BY `unit` DESC [ RunTime:0.026598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979809 LIMIT 2 [ RunTime:0.041360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979809 ORDER BY `minOrder` ASC [ RunTime:0.010070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17494066 LIMIT 5 [ RunTime:0.032734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17494066 ORDER BY `minOrder` ASC [ RunTime:0.031417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17494066 ORDER BY `unit` DESC [ RunTime:0.014572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17494066 LIMIT 2 [ RunTime:0.018209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17494066 ORDER BY `minOrder` ASC [ RunTime:0.015452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17485878 LIMIT 5 [ RunTime:0.008688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17485878 ORDER BY `minOrder` ASC [ RunTime:0.053840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17485878 ORDER BY `unit` DESC [ RunTime:0.007141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17485878 LIMIT 2 [ RunTime:0.030254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17485878 ORDER BY `minOrder` ASC [ RunTime:0.012000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17484180 LIMIT 5 [ RunTime:0.012864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17484180 ORDER BY `minOrder` ASC [ RunTime:0.025677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17484180 ORDER BY `unit` DESC [ RunTime:0.014635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17484180 LIMIT 2 [ RunTime:0.016155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17484180 ORDER BY `minOrder` ASC [ RunTime:0.023938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021000 LIMIT 5 [ RunTime:0.025590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021000 ORDER BY `minOrder` ASC [ RunTime:0.014450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021000 ORDER BY `unit` DESC [ RunTime:0.017489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021000 LIMIT 2 [ RunTime:0.010186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021000 ORDER BY `minOrder` ASC [ RunTime:0.003107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16614471 LIMIT 5 [ RunTime:0.037505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614471 ORDER BY `minOrder` ASC [ RunTime:0.018196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16614471 ORDER BY `unit` DESC [ RunTime:0.006966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16614471 LIMIT 2 [ RunTime:0.022649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614471 ORDER BY `minOrder` ASC [ RunTime:0.005661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14690981 LIMIT 5 [ RunTime:0.017309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690981 ORDER BY `minOrder` ASC [ RunTime:0.030902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14690981 ORDER BY `unit` DESC [ RunTime:0.035261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14690981 LIMIT 2 [ RunTime:0.016615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690981 ORDER BY `minOrder` ASC [ RunTime:0.036529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030144 LIMIT 5 [ RunTime:0.062071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030144 ORDER BY `minOrder` ASC [ RunTime:0.009068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12030144 ORDER BY `unit` DESC [ RunTime:0.026421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12030144 LIMIT 2 [ RunTime:0.029143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030144 ORDER BY `minOrder` ASC [ RunTime:0.008442s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027787s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62128001 LIMIT 5 [ RunTime:0.066514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62128001 ORDER BY `minOrder` ASC [ RunTime:0.080324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62128001 ORDER BY `unit` DESC [ RunTime:0.038509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62128001 LIMIT 2 [ RunTime:0.092841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62128001 ORDER BY `minOrder` ASC [ RunTime:0.013362s ]
select * from pdf where partno='1096015' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.062387s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096015' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.057016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62131568 LIMIT 5 [ RunTime:0.050174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62131568 ORDER BY `minOrder` ASC [ RunTime:0.025358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62131568 ORDER BY `unit` DESC [ RunTime:0.014348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62131568 LIMIT 2 [ RunTime:0.048793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62131568 ORDER BY `minOrder` ASC [ RunTime:0.009252s ]
select * from pdf where partno='1096014' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096014' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.048342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62139807 LIMIT 5 [ RunTime:0.022552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62139807 ORDER BY `minOrder` ASC [ RunTime:0.030231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62139807 ORDER BY `unit` DESC [ RunTime:0.048876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62139807 LIMIT 2 [ RunTime:0.037336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62139807 ORDER BY `minOrder` ASC [ RunTime:0.031911s ]
select * from pdf where partno='1096019' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.062199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096019' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62138623 LIMIT 5 [ RunTime:0.042791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138623 ORDER BY `minOrder` ASC [ RunTime:0.016629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62138623 ORDER BY `unit` DESC [ RunTime:0.069552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62138623 LIMIT 2 [ RunTime:0.052388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138623 ORDER BY `minOrder` ASC [ RunTime:0.006438s ]
select * from pdf where partno='1096016' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.068433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096016' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453677 LIMIT 5 [ RunTime:0.033223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453677 ORDER BY `minOrder` ASC [ RunTime:0.018568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453677 ORDER BY `unit` DESC [ RunTime:0.007374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453677 LIMIT 2 [ RunTime:0.031506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453677 ORDER BY `minOrder` ASC [ RunTime:0.004761s ]
select * from pdf where partno='1096014' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096014' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.044886s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453677 AND `partno` = '1096014' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021000 [ RunTime:0.020673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62141543 LIMIT 5 [ RunTime:0.027591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62141543 ORDER BY `minOrder` ASC [ RunTime:0.027490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62141543 ORDER BY `unit` DESC [ RunTime:0.010728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62141543 LIMIT 2 [ RunTime:0.015600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62141543 ORDER BY `minOrder` ASC [ RunTime:0.005777s ]
select * from pdf where partno='1096013' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.028687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096013' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811116 LIMIT 5 [ RunTime:0.068620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811116 ORDER BY `minOrder` ASC [ RunTime:0.057538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811116 ORDER BY `unit` DESC [ RunTime:0.038594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811116 LIMIT 2 [ RunTime:0.024128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811116 ORDER BY `minOrder` ASC [ RunTime:0.025988s ]
select * from pdf where partno='109601' and brandshort='Basler Inc.' limit 1 [ RunTime:0.033501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109601' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.040699s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811116 AND `partno` = '109601' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.028295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64116444 LIMIT 5 [ RunTime:0.019262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64116444 ORDER BY `minOrder` ASC [ RunTime:0.031361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64116444 ORDER BY `unit` DESC [ RunTime:0.034838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64116444 LIMIT 2 [ RunTime:0.015652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64116444 ORDER BY `minOrder` ASC [ RunTime:0.018785s ]
select * from pdf where partno='1096019' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096019' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014396s ]
SELECT `id` FROM `stock` WHERE `id` <> 64116444 AND `partno` = '1096019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030144 [ RunTime:0.051385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63197300 LIMIT 5 [ RunTime:0.040041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63197300 ORDER BY `minOrder` ASC [ RunTime:0.058032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63197300 ORDER BY `unit` DESC [ RunTime:0.045172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63197300 LIMIT 2 [ RunTime:0.041781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63197300 ORDER BY `minOrder` ASC [ RunTime:0.009202s ]
select * from pdf where partno='1096011' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096011' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.057009s ]
SELECT `id` FROM `stock` WHERE `id` <> 63197300 AND `partno` = '1096011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.047951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979809 [ RunTime:0.046058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62192682 LIMIT 5 [ RunTime:0.008038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62192682 ORDER BY `minOrder` ASC [ RunTime:0.022836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62192682 ORDER BY `unit` DESC [ RunTime:0.021376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62192682 LIMIT 2 [ RunTime:0.008597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62192682 ORDER BY `minOrder` ASC [ RunTime:0.026056s ]
select * from pdf where partno='1096017' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096017' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62190660 LIMIT 5 [ RunTime:0.024521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62190660 ORDER BY `minOrder` ASC [ RunTime:0.011241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62190660 ORDER BY `unit` DESC [ RunTime:0.025253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62190660 LIMIT 2 [ RunTime:0.036959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62190660 ORDER BY `minOrder` ASC [ RunTime:0.015826s ]
select * from pdf where partno='1096010' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.048241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096010' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62180036 LIMIT 5 [ RunTime:0.022755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62180036 ORDER BY `minOrder` ASC [ RunTime:0.028819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62180036 ORDER BY `unit` DESC [ RunTime:0.035020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62180036 LIMIT 2 [ RunTime:0.032017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62180036 ORDER BY `minOrder` ASC [ RunTime:0.010932s ]
select * from pdf where partno='1096012' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096012' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.051287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62179568 LIMIT 5 [ RunTime:0.071756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179568 ORDER BY `minOrder` ASC [ RunTime:0.030730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62179568 ORDER BY `unit` DESC [ RunTime:0.106422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62179568 LIMIT 2 [ RunTime:0.036706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179568 ORDER BY `minOrder` ASC [ RunTime:0.045892s ]
select * from pdf where partno='1096018' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096018' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62176804 LIMIT 5 [ RunTime:0.015933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62176804 ORDER BY `minOrder` ASC [ RunTime:0.015246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62176804 ORDER BY `unit` DESC [ RunTime:0.027565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62176804 LIMIT 2 [ RunTime:0.032010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62176804 ORDER BY `minOrder` ASC [ RunTime:0.022618s ]
select * from pdf where partno='1096011' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.037215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096011' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.035477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60539082 LIMIT 5 [ RunTime:0.031337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60539082 ORDER BY `minOrder` ASC [ RunTime:0.016987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60539082 ORDER BY `unit` DESC [ RunTime:0.016004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60539082 LIMIT 2 [ RunTime:0.058381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60539082 ORDER BY `minOrder` ASC [ RunTime:0.031356s ]
select * from pdf where partno='1096010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.059735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.039514s ]
SELECT `id` FROM `stock` WHERE `id` <> 60539082 AND `partno` = '1096010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.030866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643993 [ RunTime:0.035968s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044164s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055291s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036249s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052454s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053815s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049966s ]
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 '109601%' OR `brand` LIKE '109601%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030753s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '109601%' OR `brand` LIKE '109601%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.058685s ]