SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002111s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=942077999-1&search=1' [ RunTime:0.010792s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002257s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006949s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002330s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.027839s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002281s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012135s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002002s ]
SELECT * FROM `stock_search` WHERE `partno` = '942077999-1' LIMIT 1 [ RunTime:0.038904s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-23 21:50:59' WHERE `partno` = '942077999-1' [ RunTime:0.057181s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001960s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028384s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277539 LIMIT 5 [ RunTime:0.073258s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277539 ORDER BY `minOrder` ASC [ RunTime:0.033443s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277539 ORDER BY `unit` DESC [ RunTime:0.022637s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277539 LIMIT 2 [ RunTime:0.035713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277539 ORDER BY `minOrder` ASC [ RunTime:0.006265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277518 LIMIT 5 [ RunTime:0.098443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277518 ORDER BY `minOrder` ASC [ RunTime:0.072253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277518 ORDER BY `unit` DESC [ RunTime:0.096730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277518 LIMIT 2 [ RunTime:0.100297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277518 ORDER BY `minOrder` ASC [ RunTime:0.018884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277388 LIMIT 5 [ RunTime:0.058118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277388 ORDER BY `minOrder` ASC [ RunTime:0.036311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277388 ORDER BY `unit` DESC [ RunTime:0.070459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277388 LIMIT 2 [ RunTime:0.059340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277388 ORDER BY `minOrder` ASC [ RunTime:0.015356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277222 LIMIT 5 [ RunTime:0.032511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277222 ORDER BY `minOrder` ASC [ RunTime:0.016897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277222 ORDER BY `unit` DESC [ RunTime:0.061530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277222 LIMIT 2 [ RunTime:0.054740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277222 ORDER BY `minOrder` ASC [ RunTime:0.025231s ]
select * from pdf where partno='942077999-13' and brandshort='Hirschmann' limit 1 [ RunTime:0.019511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277171 LIMIT 5 [ RunTime:0.025363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277171 ORDER BY `minOrder` ASC [ RunTime:0.043512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277171 ORDER BY `unit` DESC [ RunTime:0.027028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277171 LIMIT 2 [ RunTime:0.005615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277171 ORDER BY `minOrder` ASC [ RunTime:0.084918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277142 LIMIT 5 [ RunTime:0.051565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277142 ORDER BY `minOrder` ASC [ RunTime:0.039454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277142 ORDER BY `unit` DESC [ RunTime:0.049883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277142 LIMIT 2 [ RunTime:0.021909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277142 ORDER BY `minOrder` ASC [ RunTime:0.033916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12005713 LIMIT 5 [ RunTime:0.030199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12005713 ORDER BY `minOrder` ASC [ RunTime:0.014491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12005713 ORDER BY `unit` DESC [ RunTime:0.034786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12005713 LIMIT 2 [ RunTime:0.016201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12005713 ORDER BY `minOrder` ASC [ RunTime:0.010814s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028314s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387086 LIMIT 5 [ RunTime:0.019227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387086 ORDER BY `minOrder` ASC [ RunTime:0.016489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387086 ORDER BY `unit` DESC [ RunTime:0.022130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387086 LIMIT 2 [ RunTime:0.038012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387086 ORDER BY `minOrder` ASC [ RunTime:0.046013s ]
select * from pdf where partno='942077999-14' and brandshort='Hirschmann' limit 1 [ RunTime:0.016489s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-14' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.007565s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387086 AND `partno` = '942077999-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.018293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12005713 [ RunTime:0.013193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64386263 LIMIT 5 [ RunTime:0.018643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64386263 ORDER BY `minOrder` ASC [ RunTime:0.034050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64386263 ORDER BY `unit` DESC [ RunTime:0.020147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64386263 LIMIT 2 [ RunTime:0.025555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64386263 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
select * from pdf where partno='942077999-1' and brandshort='Hirschmann' limit 1 [ RunTime:0.018862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-1' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.013874s ]
SELECT `id` FROM `stock` WHERE `id` <> 64386263 AND `partno` = '942077999-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.020937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277539 [ RunTime:0.020205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64386227 LIMIT 5 [ RunTime:0.013408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64386227 ORDER BY `minOrder` ASC [ RunTime:0.029775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64386227 ORDER BY `unit` DESC [ RunTime:0.014052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64386227 LIMIT 2 [ RunTime:0.021067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64386227 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
select * from pdf where partno='942077999-19' and brandshort='Hirschmann' limit 1 [ RunTime:0.008857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-19' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.031715s ]
SELECT `id` FROM `stock` WHERE `id` <> 64386227 AND `partno` = '942077999-19' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.013475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277518 [ RunTime:0.005796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64386226 LIMIT 5 [ RunTime:0.025728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64386226 ORDER BY `minOrder` ASC [ RunTime:0.012870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64386226 ORDER BY `unit` DESC [ RunTime:0.007824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64386226 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64386226 ORDER BY `minOrder` ASC [ RunTime:0.004518s ]
select * from pdf where partno='942077999-18' and brandshort='Hirschmann' limit 1 [ RunTime:0.016878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-18' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.036011s ]
SELECT `id` FROM `stock` WHERE `id` <> 64386226 AND `partno` = '942077999-18' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.014069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64385919 LIMIT 5 [ RunTime:0.020443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385919 ORDER BY `minOrder` ASC [ RunTime:0.012643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64385919 ORDER BY `unit` DESC [ RunTime:0.009697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64385919 LIMIT 2 [ RunTime:0.006637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385919 ORDER BY `minOrder` ASC [ RunTime:0.006395s ]
select * from pdf where partno='942077999-10' and brandshort='Hirschmann' limit 1 [ RunTime:0.011128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-10' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.020804s ]
SELECT `id` FROM `stock` WHERE `id` <> 64385919 AND `partno` = '942077999-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.017612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64385787 LIMIT 5 [ RunTime:0.006882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385787 ORDER BY `minOrder` ASC [ RunTime:0.006482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64385787 ORDER BY `unit` DESC [ RunTime:0.022891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64385787 LIMIT 2 [ RunTime:0.010963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385787 ORDER BY `minOrder` ASC [ RunTime:0.005011s ]
select * from pdf where partno='942077999-16' and brandshort='Hirschmann' limit 1 [ RunTime:0.013540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-16' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.014061s ]
SELECT `id` FROM `stock` WHERE `id` <> 64385787 AND `partno` = '942077999-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.028235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277388 [ RunTime:0.001980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64385365 LIMIT 5 [ RunTime:0.003701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385365 ORDER BY `minOrder` ASC [ RunTime:0.011860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64385365 ORDER BY `unit` DESC [ RunTime:0.010488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64385365 LIMIT 2 [ RunTime:0.014375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385365 ORDER BY `minOrder` ASC [ RunTime:0.011315s ]
select * from pdf where partno='942077999-13' and brandshort='Hirschmann' limit 1 [ RunTime:0.002805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-13' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.031692s ]
SELECT `id` FROM `stock` WHERE `id` <> 64385365 AND `partno` = '942077999-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.009779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277222 [ RunTime:0.011924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64385193 LIMIT 5 [ RunTime:0.009993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385193 ORDER BY `minOrder` ASC [ RunTime:0.021503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64385193 ORDER BY `unit` DESC [ RunTime:0.021307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64385193 LIMIT 2 [ RunTime:0.027313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385193 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
select * from pdf where partno='942077999-17' and brandshort='Hirschmann' limit 1 [ RunTime:0.042207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-17' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.028684s ]
SELECT `id` FROM `stock` WHERE `id` <> 64385193 AND `partno` = '942077999-17' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.012774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277171 [ RunTime:0.023750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64385131 LIMIT 5 [ RunTime:0.010569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385131 ORDER BY `minOrder` ASC [ RunTime:0.003319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64385131 ORDER BY `unit` DESC [ RunTime:0.008977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64385131 LIMIT 2 [ RunTime:0.006652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64385131 ORDER BY `minOrder` ASC [ RunTime:0.002120s ]
select * from pdf where partno='942077999-15' and brandshort='Hirschmann' limit 1 [ RunTime:0.006090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-15' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.021435s ]
SELECT `id` FROM `stock` WHERE `id` <> 64385131 AND `partno` = '942077999-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.025137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277142 [ RunTime:0.016794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32760519 LIMIT 5 [ RunTime:0.014310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32760519 ORDER BY `minOrder` ASC [ RunTime:0.029848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32760519 ORDER BY `unit` DESC [ RunTime:0.036215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32760519 LIMIT 2 [ RunTime:0.029686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32760519 ORDER BY `minOrder` ASC [ RunTime:0.010536s ]
select * from pdf where partno='942077999-127' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.017183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-127' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.018371s ]
SELECT `id` FROM `stock` WHERE `id` <> 32760519 AND `partno` = '942077999-127' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.016016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32758951 LIMIT 5 [ RunTime:0.018985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758951 ORDER BY `minOrder` ASC [ RunTime:0.022803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32758951 ORDER BY `unit` DESC [ RunTime:0.019687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32758951 LIMIT 2 [ RunTime:0.019953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758951 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='942077999-114' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.005354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-114' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.020673s ]
SELECT `id` FROM `stock` WHERE `id` <> 32758951 AND `partno` = '942077999-114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.014903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32748665 LIMIT 5 [ RunTime:0.010458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32748665 ORDER BY `minOrder` ASC [ RunTime:0.020752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32748665 ORDER BY `unit` DESC [ RunTime:0.023224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32748665 LIMIT 2 [ RunTime:0.014023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32748665 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='942077999-131' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.031765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-131' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.013466s ]
SELECT `id` FROM `stock` WHERE `id` <> 32748665 AND `partno` = '942077999-131' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.022783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32746361 LIMIT 5 [ RunTime:0.021504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32746361 ORDER BY `minOrder` ASC [ RunTime:0.039883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32746361 ORDER BY `unit` DESC [ RunTime:0.023895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32746361 LIMIT 2 [ RunTime:0.013459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32746361 ORDER BY `minOrder` ASC [ RunTime:0.010151s ]
select * from pdf where partno='942077999-100' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.013863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-100' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.012635s ]
SELECT `id` FROM `stock` WHERE `id` <> 32746361 AND `partno` = '942077999-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.020734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32745061 LIMIT 5 [ RunTime:0.050448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32745061 ORDER BY `minOrder` ASC [ RunTime:0.019271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32745061 ORDER BY `unit` DESC [ RunTime:0.005498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32745061 LIMIT 2 [ RunTime:0.018935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32745061 ORDER BY `minOrder` ASC [ RunTime:0.015391s ]
select * from pdf where partno='942077999-117' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.017565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-117' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.012974s ]
SELECT `id` FROM `stock` WHERE `id` <> 32745061 AND `partno` = '942077999-117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.060959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32745007 LIMIT 5 [ RunTime:0.047493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32745007 ORDER BY `minOrder` ASC [ RunTime:0.060949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32745007 ORDER BY `unit` DESC [ RunTime:0.026809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32745007 LIMIT 2 [ RunTime:0.020508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32745007 ORDER BY `minOrder` ASC [ RunTime:0.045465s ]
select * from pdf where partno='942077999-121' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.045331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-121' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.007558s ]
SELECT `id` FROM `stock` WHERE `id` <> 32745007 AND `partno` = '942077999-121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.038452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32742095 LIMIT 5 [ RunTime:0.031961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32742095 ORDER BY `minOrder` ASC [ RunTime:0.023800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32742095 ORDER BY `unit` DESC [ RunTime:0.097511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32742095 LIMIT 2 [ RunTime:0.026049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32742095 ORDER BY `minOrder` ASC [ RunTime:0.018938s ]
select * from pdf where partno='942077999-108' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.038796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-108' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.050265s ]
SELECT `id` FROM `stock` WHERE `id` <> 32742095 AND `partno` = '942077999-108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.071132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32740796 LIMIT 5 [ RunTime:0.067725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740796 ORDER BY `minOrder` ASC [ RunTime:0.097619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32740796 ORDER BY `unit` DESC [ RunTime:0.045948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32740796 LIMIT 2 [ RunTime:0.030533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740796 ORDER BY `minOrder` ASC [ RunTime:0.059565s ]
select * from pdf where partno='942077999-107' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.056502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-107' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.042462s ]
SELECT `id` FROM `stock` WHERE `id` <> 32740796 AND `partno` = '942077999-107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.052516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32740256 LIMIT 5 [ RunTime:0.037813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740256 ORDER BY `minOrder` ASC [ RunTime:0.015498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32740256 ORDER BY `unit` DESC [ RunTime:0.019478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32740256 LIMIT 2 [ RunTime:0.039026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740256 ORDER BY `minOrder` ASC [ RunTime:0.024102s ]
select * from pdf where partno='942077999-167' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.031395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-167' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.055634s ]
SELECT `id` FROM `stock` WHERE `id` <> 32740256 AND `partno` = '942077999-167' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.035855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32738059 LIMIT 5 [ RunTime:0.033762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32738059 ORDER BY `minOrder` ASC [ RunTime:0.095707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32738059 ORDER BY `unit` DESC [ RunTime:0.102885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32738059 LIMIT 2 [ RunTime:0.051983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32738059 ORDER BY `minOrder` ASC [ RunTime:0.037283s ]
select * from pdf where partno='942077999-155' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.079724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-155' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.065111s ]
SELECT `id` FROM `stock` WHERE `id` <> 32738059 AND `partno` = '942077999-155' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.097336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32738058 LIMIT 5 [ RunTime:0.071585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32738058 ORDER BY `minOrder` ASC [ RunTime:0.071498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32738058 ORDER BY `unit` DESC [ RunTime:0.055670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32738058 LIMIT 2 [ RunTime:0.195024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32738058 ORDER BY `minOrder` ASC [ RunTime:0.154213s ]
select * from pdf where partno='942077999-166' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.075835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942077999-166' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.067242s ]
SELECT `id` FROM `stock` WHERE `id` <> 32738058 AND `partno` = '942077999-166' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.126142s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.165324s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.223607s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104656s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.142102s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.130340s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104780s ]
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 '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.127510s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '942077999-1%' OR `brand` LIKE '942077999-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.088294s ]