SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001462s ]
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=942135999-2&search=1' [ RunTime:0.001740s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001289s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000525s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001445s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002543s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001342s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001767s ]
SELECT * FROM `stock_search` WHERE `partno` = '942135999-2' LIMIT 1 [ RunTime:0.000776s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-26 20:13:38' WHERE `partno` = '942135999-2' [ RunTime:0.009295s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002717s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012138s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278423 LIMIT 5 [ RunTime:0.010427s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278423 ORDER BY `minOrder` ASC [ RunTime:0.011837s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278423 ORDER BY `unit` DESC [ RunTime:0.000935s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278423 LIMIT 2 [ RunTime:0.001668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278423 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006419 LIMIT 5 [ RunTime:0.001047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006419 ORDER BY `minOrder` ASC [ RunTime:0.003504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006419 ORDER BY `unit` DESC [ RunTime:0.006856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006419 LIMIT 2 [ RunTime:0.009523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006419 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='942135999-28' and brandshort='Hirschmann' limit 1 [ RunTime:0.001857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006287 LIMIT 5 [ RunTime:0.002724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006287 ORDER BY `minOrder` ASC [ RunTime:0.002737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006287 ORDER BY `unit` DESC [ RunTime:0.013036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006287 LIMIT 2 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006287 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005135s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388590 LIMIT 5 [ RunTime:0.009724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388590 ORDER BY `minOrder` ASC [ RunTime:0.007974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388590 ORDER BY `unit` DESC [ RunTime:0.001235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388590 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388590 ORDER BY `minOrder` ASC [ RunTime:0.003552s ]
select * from pdf where partno='942135999-20' and brandshort='Hirschmann' limit 1 [ RunTime:0.005247s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-20' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.015166s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388590 AND `partno` = '942135999-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.010510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278423 [ RunTime:0.013121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388438 LIMIT 5 [ RunTime:0.006786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388438 ORDER BY `minOrder` ASC [ RunTime:0.003477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388438 ORDER BY `unit` DESC [ RunTime:0.009774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388438 LIMIT 2 [ RunTime:0.007264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388438 ORDER BY `minOrder` ASC [ RunTime:0.002539s ]
select * from pdf where partno='942135999-28' and brandshort='Hirschmann' limit 1 [ RunTime:0.003001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-28' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.009399s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388438 AND `partno` = '942135999-28' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.013673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006419 [ RunTime:0.008046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388172 LIMIT 5 [ RunTime:0.011050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388172 ORDER BY `minOrder` ASC [ RunTime:0.008890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388172 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388172 LIMIT 2 [ RunTime:0.023333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388172 ORDER BY `minOrder` ASC [ RunTime:0.001908s ]
select * from pdf where partno='942135999-21' and brandshort='Hirschmann' limit 1 [ RunTime:0.003906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-21' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.001918s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388172 AND `partno` = '942135999-21' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.005372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006287 [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775343 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775343 ORDER BY `minOrder` ASC [ RunTime:0.003242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775343 ORDER BY `unit` DESC [ RunTime:0.002012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775343 LIMIT 2 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775343 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
select * from pdf where partno='942135999-288' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.012020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-288' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.005556s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775343 AND `partno` = '942135999-288' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.001015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775339 LIMIT 5 [ RunTime:0.002105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775339 ORDER BY `minOrder` ASC [ RunTime:0.005934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775339 ORDER BY `unit` DESC [ RunTime:0.010260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775339 LIMIT 2 [ RunTime:0.003736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775339 ORDER BY `minOrder` ASC [ RunTime:0.012333s ]
select * from pdf where partno='942135999-297' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.002514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-297' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.000955s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775339 AND `partno` = '942135999-297' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.006562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775335 LIMIT 5 [ RunTime:0.008290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775335 ORDER BY `minOrder` ASC [ RunTime:0.010845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775335 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775335 LIMIT 2 [ RunTime:0.001813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775335 ORDER BY `minOrder` ASC [ RunTime:0.003794s ]
select * from pdf where partno='942135999-243' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.004177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-243' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.023208s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775335 AND `partno` = '942135999-243' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.012699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775327 LIMIT 5 [ RunTime:0.003171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775327 ORDER BY `minOrder` ASC [ RunTime:0.013999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775327 ORDER BY `unit` DESC [ RunTime:0.010008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775327 LIMIT 2 [ RunTime:0.012268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775327 ORDER BY `minOrder` ASC [ RunTime:0.016251s ]
select * from pdf where partno='942135999-295' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.002160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-295' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.002328s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775327 AND `partno` = '942135999-295' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.011576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775067 LIMIT 5 [ RunTime:0.003001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775067 ORDER BY `minOrder` ASC [ RunTime:0.001581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775067 ORDER BY `unit` DESC [ RunTime:0.004607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775067 LIMIT 2 [ RunTime:0.004733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775067 ORDER BY `minOrder` ASC [ RunTime:0.010873s ]
select * from pdf where partno='942135999-255' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.004191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-255' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.005239s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775067 AND `partno` = '942135999-255' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.006717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775065 LIMIT 5 [ RunTime:0.011582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775065 ORDER BY `minOrder` ASC [ RunTime:0.011450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775065 ORDER BY `unit` DESC [ RunTime:0.011235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775065 LIMIT 2 [ RunTime:0.017427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775065 ORDER BY `minOrder` ASC [ RunTime:0.021282s ]
select * from pdf where partno='942135999-27' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.022606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-27' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.019850s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775065 AND `partno` = '942135999-27' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.023377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775057 LIMIT 5 [ RunTime:0.030476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775057 ORDER BY `minOrder` ASC [ RunTime:0.019422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775057 ORDER BY `unit` DESC [ RunTime:0.019589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775057 LIMIT 2 [ RunTime:0.026470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775057 ORDER BY `minOrder` ASC [ RunTime:0.021946s ]
select * from pdf where partno='942135999-219' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.016123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-219' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.020226s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775057 AND `partno` = '942135999-219' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.034584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775047 LIMIT 5 [ RunTime:0.104661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775047 ORDER BY `minOrder` ASC [ RunTime:0.023025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775047 ORDER BY `unit` DESC [ RunTime:0.025017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775047 LIMIT 2 [ RunTime:0.007364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775047 ORDER BY `minOrder` ASC [ RunTime:0.002356s ]
select * from pdf where partno='942135999-241' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.011032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-241' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.026114s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775047 AND `partno` = '942135999-241' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.034922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775046 LIMIT 5 [ RunTime:0.023803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775046 ORDER BY `minOrder` ASC [ RunTime:0.020216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775046 ORDER BY `unit` DESC [ RunTime:0.039227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775046 LIMIT 2 [ RunTime:0.011580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775046 ORDER BY `minOrder` ASC [ RunTime:0.046992s ]
select * from pdf where partno='942135999-202' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.006884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-202' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.009883s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775046 AND `partno` = '942135999-202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.030683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775043 LIMIT 5 [ RunTime:0.026854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775043 ORDER BY `minOrder` ASC [ RunTime:0.014396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775043 ORDER BY `unit` DESC [ RunTime:0.022914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775043 LIMIT 2 [ RunTime:0.013173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775043 ORDER BY `minOrder` ASC [ RunTime:0.008554s ]
select * from pdf where partno='942135999-289' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.003074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-289' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.013557s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775043 AND `partno` = '942135999-289' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.025441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775042 LIMIT 5 [ RunTime:0.025635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775042 ORDER BY `minOrder` ASC [ RunTime:0.012315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775042 ORDER BY `unit` DESC [ RunTime:0.025632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775042 LIMIT 2 [ RunTime:0.026475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775042 ORDER BY `minOrder` ASC [ RunTime:0.011703s ]
select * from pdf where partno='942135999-287' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.014452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-287' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.020672s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775042 AND `partno` = '942135999-287' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.014042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32775033 LIMIT 5 [ RunTime:0.032566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775033 ORDER BY `minOrder` ASC [ RunTime:0.053547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32775033 ORDER BY `unit` DESC [ RunTime:0.043717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32775033 LIMIT 2 [ RunTime:0.019204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32775033 ORDER BY `minOrder` ASC [ RunTime:0.020758s ]
select * from pdf where partno='942135999-240' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.033606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-240' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.029437s ]
SELECT `id` FROM `stock` WHERE `id` <> 32775033 AND `partno` = '942135999-240' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.029036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32774867 LIMIT 5 [ RunTime:0.048808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774867 ORDER BY `minOrder` ASC [ RunTime:0.004964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32774867 ORDER BY `unit` DESC [ RunTime:0.010306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32774867 LIMIT 2 [ RunTime:0.009123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774867 ORDER BY `minOrder` ASC [ RunTime:0.026116s ]
select * from pdf where partno='942135999-274' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.032357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-274' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.017336s ]
SELECT `id` FROM `stock` WHERE `id` <> 32774867 AND `partno` = '942135999-274' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.041797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32774820 LIMIT 5 [ RunTime:0.007712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774820 ORDER BY `minOrder` ASC [ RunTime:0.029161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32774820 ORDER BY `unit` DESC [ RunTime:0.062284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32774820 LIMIT 2 [ RunTime:0.021397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774820 ORDER BY `minOrder` ASC [ RunTime:0.009657s ]
select * from pdf where partno='942135999-257' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.034214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-257' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.031017s ]
SELECT `id` FROM `stock` WHERE `id` <> 32774820 AND `partno` = '942135999-257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.018726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32774816 LIMIT 5 [ RunTime:0.028918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774816 ORDER BY `minOrder` ASC [ RunTime:0.046879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32774816 ORDER BY `unit` DESC [ RunTime:0.066409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32774816 LIMIT 2 [ RunTime:0.049535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774816 ORDER BY `minOrder` ASC [ RunTime:0.019962s ]
select * from pdf where partno='942135999-244' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.040623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-244' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.014356s ]
SELECT `id` FROM `stock` WHERE `id` <> 32774816 AND `partno` = '942135999-244' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.019854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32774803 LIMIT 5 [ RunTime:0.016519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774803 ORDER BY `minOrder` ASC [ RunTime:0.010670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32774803 ORDER BY `unit` DESC [ RunTime:0.032311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32774803 LIMIT 2 [ RunTime:0.031967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774803 ORDER BY `minOrder` ASC [ RunTime:0.011659s ]
select * from pdf where partno='942135999-216' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.019330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-216' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.018975s ]
SELECT `id` FROM `stock` WHERE `id` <> 32774803 AND `partno` = '942135999-216' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.029637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32774792 LIMIT 5 [ RunTime:0.024467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774792 ORDER BY `minOrder` ASC [ RunTime:0.040889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32774792 ORDER BY `unit` DESC [ RunTime:0.026685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32774792 LIMIT 2 [ RunTime:0.010077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32774792 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
select * from pdf where partno='942135999-24' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.011616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '942135999-24' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.016228s ]
SELECT `id` FROM `stock` WHERE `id` <> 32774792 AND `partno` = '942135999-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.039630s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052768s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031152s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015391s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001192s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010838s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045879s ]
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 '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021262s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '942135999-2%' OR `brand` LIKE '942135999-2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018269s ]