SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001503s ]
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=942123999-1&search=1' [ RunTime:0.005834s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001991s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004140s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002149s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001567s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002572s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002376s ]
SELECT * FROM `stock_search` WHERE `partno` = '942123999-1' LIMIT 1 [ RunTime:0.013240s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-23 13:10:05' WHERE `partno` = '942123999-1' [ RunTime:0.015499s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001996s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002327s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277875 LIMIT 5 [ RunTime:0.027883s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277875 ORDER BY `minOrder` ASC [ RunTime:0.007471s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13277875 ORDER BY `unit` DESC [ RunTime:0.000683s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13277875 LIMIT 2 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13277875 ORDER BY `minOrder` ASC [ RunTime:0.006791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006173 LIMIT 5 [ RunTime:0.002115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006173 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006173 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006173 LIMIT 2 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006173 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006082 LIMIT 5 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006082 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006082 ORDER BY `unit` DESC [ RunTime:0.014703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006082 LIMIT 2 [ RunTime:0.004153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006082 ORDER BY `minOrder` ASC [ RunTime:0.038340s ]
select * from pdf where partno='942123999-16' and brandshort='Hirschmann' limit 1 [ RunTime:0.004111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006081 LIMIT 5 [ RunTime:0.005639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006081 ORDER BY `minOrder` ASC [ RunTime:0.010659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006081 ORDER BY `unit` DESC [ RunTime:0.013568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006081 LIMIT 2 [ RunTime:0.014359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006081 ORDER BY `minOrder` ASC [ RunTime:0.001356s ]
select * from pdf where partno='942123999-10' and brandshort='Hirschmann' limit 1 [ RunTime:0.006458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12005792 LIMIT 5 [ RunTime:0.021079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12005792 ORDER BY `minOrder` ASC [ RunTime:0.035470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12005792 ORDER BY `unit` DESC [ RunTime:0.043196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12005792 LIMIT 2 [ RunTime:0.042727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12005792 ORDER BY `minOrder` ASC [ RunTime:0.002440s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013512s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387963 LIMIT 5 [ RunTime:0.031963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387963 ORDER BY `minOrder` ASC [ RunTime:0.023933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387963 ORDER BY `unit` DESC [ RunTime:0.019429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387963 LIMIT 2 [ RunTime:0.034694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387963 ORDER BY `minOrder` ASC [ RunTime:0.038644s ]
select * from pdf where partno='942123999-11' and brandshort='Hirschmann' limit 1 [ RunTime:0.018086s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-11' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.049452s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387963 AND `partno` = '942123999-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.004419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006173 [ RunTime:0.040451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387784 LIMIT 5 [ RunTime:0.033463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387784 ORDER BY `minOrder` ASC [ RunTime:0.116716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387784 ORDER BY `unit` DESC [ RunTime:0.026542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387784 LIMIT 2 [ RunTime:0.138453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387784 ORDER BY `minOrder` ASC [ RunTime:0.089799s ]
select * from pdf where partno='942123999-16' and brandshort='Hirschmann' limit 1 [ RunTime:0.023778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-16' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.052120s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387784 AND `partno` = '942123999-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.098892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006082 [ RunTime:0.084593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387783 LIMIT 5 [ RunTime:0.044989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387783 ORDER BY `minOrder` ASC [ RunTime:0.113992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387783 ORDER BY `unit` DESC [ RunTime:0.057131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387783 LIMIT 2 [ RunTime:0.066669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387783 ORDER BY `minOrder` ASC [ RunTime:0.096056s ]
select * from pdf where partno='942123999-10' and brandshort='Hirschmann' limit 1 [ RunTime:0.015532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-10' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.040501s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387783 AND `partno` = '942123999-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.067508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006081 [ RunTime:0.110797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387647 LIMIT 5 [ RunTime:0.131678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387647 ORDER BY `minOrder` ASC [ RunTime:0.080590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387647 ORDER BY `unit` DESC [ RunTime:0.075794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387647 LIMIT 2 [ RunTime:0.027639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387647 ORDER BY `minOrder` ASC [ RunTime:0.047965s ]
select * from pdf where partno='942123999-15' and brandshort='Hirschmann' limit 1 [ RunTime:0.080182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-15' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.085254s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387647 AND `partno` = '942123999-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.069793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387646 LIMIT 5 [ RunTime:0.085536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387646 ORDER BY `minOrder` ASC [ RunTime:0.077616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387646 ORDER BY `unit` DESC [ RunTime:0.113886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387646 LIMIT 2 [ RunTime:0.075645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387646 ORDER BY `minOrder` ASC [ RunTime:0.032657s ]
select * from pdf where partno='942123999-12' and brandshort='Hirschmann' limit 1 [ RunTime:0.045609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-12' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.048488s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387646 AND `partno` = '942123999-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.074431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387256 LIMIT 5 [ RunTime:0.066127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387256 ORDER BY `minOrder` ASC [ RunTime:0.062555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387256 ORDER BY `unit` DESC [ RunTime:0.034917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387256 LIMIT 2 [ RunTime:0.052614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387256 ORDER BY `minOrder` ASC [ RunTime:0.003845s ]
select * from pdf where partno='942123999-17' and brandshort='Hirschmann' limit 1 [ RunTime:0.017347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-17' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.047083s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387256 AND `partno` = '942123999-17' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.004984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12005792 [ RunTime:0.004415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387224 LIMIT 5 [ RunTime:0.017631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387224 ORDER BY `minOrder` ASC [ RunTime:0.016924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387224 ORDER BY `unit` DESC [ RunTime:0.014147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387224 LIMIT 2 [ RunTime:0.017212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387224 ORDER BY `minOrder` ASC [ RunTime:0.028058s ]
select * from pdf where partno='942123999-1' and brandshort='Hirschmann' limit 1 [ RunTime:0.036700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-1' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.005562s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387224 AND `partno` = '942123999-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.011770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13277875 [ RunTime:0.028877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32770048 LIMIT 5 [ RunTime:0.031113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770048 ORDER BY `minOrder` ASC [ RunTime:0.074342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32770048 ORDER BY `unit` DESC [ RunTime:0.025734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32770048 LIMIT 2 [ RunTime:0.040643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770048 ORDER BY `minOrder` ASC [ RunTime:0.036411s ]
select * from pdf where partno='942123999-112' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.038599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-112' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.015009s ]
SELECT `id` FROM `stock` WHERE `id` <> 32770048 AND `partno` = '942123999-112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.039473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32770047 LIMIT 5 [ RunTime:0.061346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770047 ORDER BY `minOrder` ASC [ RunTime:0.039542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32770047 ORDER BY `unit` DESC [ RunTime:0.053773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32770047 LIMIT 2 [ RunTime:0.024454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770047 ORDER BY `minOrder` ASC [ RunTime:0.027791s ]
select * from pdf where partno='942123999-113' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.019182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-113' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.048386s ]
SELECT `id` FROM `stock` WHERE `id` <> 32770047 AND `partno` = '942123999-113' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.007394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32770045 LIMIT 5 [ RunTime:0.015374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770045 ORDER BY `minOrder` ASC [ RunTime:0.034318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32770045 ORDER BY `unit` DESC [ RunTime:0.022897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32770045 LIMIT 2 [ RunTime:0.006826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32770045 ORDER BY `minOrder` ASC [ RunTime:0.031228s ]
select * from pdf where partno='942123999-125' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.017436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-125' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.082552s ]
SELECT `id` FROM `stock` WHERE `id` <> 32770045 AND `partno` = '942123999-125' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.037446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32769727 LIMIT 5 [ RunTime:0.039881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32769727 ORDER BY `minOrder` ASC [ RunTime:0.027793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32769727 ORDER BY `unit` DESC [ RunTime:0.035358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32769727 LIMIT 2 [ RunTime:0.018271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32769727 ORDER BY `minOrder` ASC [ RunTime:0.027289s ]
select * from pdf where partno='942123999-124' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.025703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-124' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.009257s ]
SELECT `id` FROM `stock` WHERE `id` <> 32769727 AND `partno` = '942123999-124' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.020150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32769087 LIMIT 5 [ RunTime:0.012185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32769087 ORDER BY `minOrder` ASC [ RunTime:0.030637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32769087 ORDER BY `unit` DESC [ RunTime:0.002262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32769087 LIMIT 2 [ RunTime:0.023909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32769087 ORDER BY `minOrder` ASC [ RunTime:0.015819s ]
select * from pdf where partno='942123999-109' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.005342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-109' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.049861s ]
SELECT `id` FROM `stock` WHERE `id` <> 32769087 AND `partno` = '942123999-109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.008514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32768797 LIMIT 5 [ RunTime:0.057332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768797 ORDER BY `minOrder` ASC [ RunTime:0.015483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32768797 ORDER BY `unit` DESC [ RunTime:0.014066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32768797 LIMIT 2 [ RunTime:0.015651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768797 ORDER BY `minOrder` ASC [ RunTime:0.019283s ]
select * from pdf where partno='942123999-119' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.012326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-119' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.023143s ]
SELECT `id` FROM `stock` WHERE `id` <> 32768797 AND `partno` = '942123999-119' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.023453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32768796 LIMIT 5 [ RunTime:0.086466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768796 ORDER BY `minOrder` ASC [ RunTime:0.049912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32768796 ORDER BY `unit` DESC [ RunTime:0.053585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32768796 LIMIT 2 [ RunTime:0.035192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768796 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
select * from pdf where partno='942123999-101' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.049902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-101' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.018905s ]
SELECT `id` FROM `stock` WHERE `id` <> 32768796 AND `partno` = '942123999-101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.003583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32768759 LIMIT 5 [ RunTime:0.011424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768759 ORDER BY `minOrder` ASC [ RunTime:0.009175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32768759 ORDER BY `unit` DESC [ RunTime:0.030120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32768759 LIMIT 2 [ RunTime:0.033079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768759 ORDER BY `minOrder` ASC [ RunTime:0.011065s ]
select * from pdf where partno='942123999-131' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.026326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-131' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.009992s ]
SELECT `id` FROM `stock` WHERE `id` <> 32768759 AND `partno` = '942123999-131' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.017081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32768176 LIMIT 5 [ RunTime:0.029940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768176 ORDER BY `minOrder` ASC [ RunTime:0.009579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32768176 ORDER BY `unit` DESC [ RunTime:0.021153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32768176 LIMIT 2 [ RunTime:0.012462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768176 ORDER BY `minOrder` ASC [ RunTime:0.036550s ]
select * from pdf where partno='942123999-143' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.015506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-143' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.011767s ]
SELECT `id` FROM `stock` WHERE `id` <> 32768176 AND `partno` = '942123999-143' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.014397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32768175 LIMIT 5 [ RunTime:0.008411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768175 ORDER BY `minOrder` ASC [ RunTime:0.020029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32768175 ORDER BY `unit` DESC [ RunTime:0.045117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32768175 LIMIT 2 [ RunTime:0.015389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32768175 ORDER BY `minOrder` ASC [ RunTime:0.004612s ]
select * from pdf where partno='942123999-13' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.017978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-13' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.011024s ]
SELECT `id` FROM `stock` WHERE `id` <> 32768175 AND `partno` = '942123999-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.021733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32767942 LIMIT 5 [ RunTime:0.013411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32767942 ORDER BY `minOrder` ASC [ RunTime:0.017305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32767942 ORDER BY `unit` DESC [ RunTime:0.016648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32767942 LIMIT 2 [ RunTime:0.010588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32767942 ORDER BY `minOrder` ASC [ RunTime:0.003346s ]
select * from pdf where partno='942123999-142' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.005419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-142' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.021191s ]
SELECT `id` FROM `stock` WHERE `id` <> 32767942 AND `partno` = '942123999-142' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.027067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32767941 LIMIT 5 [ RunTime:0.014407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32767941 ORDER BY `minOrder` ASC [ RunTime:0.009941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32767941 ORDER BY `unit` DESC [ RunTime:0.011153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32767941 LIMIT 2 [ RunTime:0.008772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32767941 ORDER BY `minOrder` ASC [ RunTime:0.004730s ]
select * from pdf where partno='942123999-123' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.028214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-123' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.025725s ]
SELECT `id` FROM `stock` WHERE `id` <> 32767941 AND `partno` = '942123999-123' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.012935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32767940 LIMIT 5 [ RunTime:0.010749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32767940 ORDER BY `minOrder` ASC [ RunTime:0.005664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32767940 ORDER BY `unit` DESC [ RunTime:0.027729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32767940 LIMIT 2 [ RunTime:0.047881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32767940 ORDER BY `minOrder` ASC [ RunTime:0.008389s ]
select * from pdf where partno='942123999-128' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.000893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942123999-128' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.021459s ]
SELECT `id` FROM `stock` WHERE `id` <> 32767940 AND `partno` = '942123999-128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.001534s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025118s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019764s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032298s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014526s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037143s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033852s ]
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 '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040788s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '942123999-1%' OR `brand` LIKE '942123999-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023055s ]