SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003003s ]
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=86513&search=1' [ RunTime:0.003737s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.005009s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002509s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002454s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001818s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001870s ]
SELECT * FROM `stock_search` WHERE `partno` = '86513' LIMIT 1 [ RunTime:0.009600s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-21 14:08:46' WHERE `partno` = '86513' [ RunTime:0.003178s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002176s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002716s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18854098 LIMIT 5 [ RunTime:0.002206s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18854098 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18854098 ORDER BY `unit` DESC [ RunTime:0.003735s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18854098 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18854098 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15362445 LIMIT 5 [ RunTime:0.007834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15362445 ORDER BY `minOrder` ASC [ RunTime:0.005204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15362445 ORDER BY `unit` DESC [ RunTime:0.000925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15362445 LIMIT 2 [ RunTime:0.002647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15362445 ORDER BY `minOrder` ASC [ RunTime:0.007246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352650 LIMIT 5 [ RunTime:0.009859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352650 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14352650 ORDER BY `unit` DESC [ RunTime:0.011955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14352650 LIMIT 2 [ RunTime:0.001948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352650 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352626 LIMIT 5 [ RunTime:0.009713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352626 ORDER BY `minOrder` ASC [ RunTime:0.014923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14352626 ORDER BY `unit` DESC [ RunTime:0.021629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14352626 LIMIT 2 [ RunTime:0.008338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352626 ORDER BY `minOrder` ASC [ RunTime:0.013318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352574 LIMIT 5 [ RunTime:0.006825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352574 ORDER BY `minOrder` ASC [ RunTime:0.013074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14352574 ORDER BY `unit` DESC [ RunTime:0.024913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14352574 LIMIT 2 [ RunTime:0.024922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14352574 ORDER BY `minOrder` ASC [ RunTime:0.003195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344916 LIMIT 5 [ RunTime:0.014308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344916 ORDER BY `minOrder` ASC [ RunTime:0.020123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14344916 ORDER BY `unit` DESC [ RunTime:0.024892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14344916 LIMIT 2 [ RunTime:0.012792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344916 ORDER BY `minOrder` ASC [ RunTime:0.003898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475519 LIMIT 5 [ RunTime:0.008438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475519 ORDER BY `minOrder` ASC [ RunTime:0.010208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13475519 ORDER BY `unit` DESC [ RunTime:0.025575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13475519 LIMIT 2 [ RunTime:0.011402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475519 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475517 LIMIT 5 [ RunTime:0.001212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475517 ORDER BY `minOrder` ASC [ RunTime:0.001981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13475517 ORDER BY `unit` DESC [ RunTime:0.005956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13475517 LIMIT 2 [ RunTime:0.003766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475517 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475211 LIMIT 5 [ RunTime:0.001138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475211 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13475211 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13475211 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475211 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475009 LIMIT 5 [ RunTime:0.000961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475009 ORDER BY `minOrder` ASC [ RunTime:0.005626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13475009 ORDER BY `unit` DESC [ RunTime:0.007516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13475009 LIMIT 2 [ RunTime:0.008841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13475009 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474814 LIMIT 5 [ RunTime:0.009401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474814 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474814 ORDER BY `unit` DESC [ RunTime:0.003674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474814 LIMIT 2 [ RunTime:0.008357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474814 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001750s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521189 LIMIT 5 [ RunTime:0.003442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521189 ORDER BY `minOrder` ASC [ RunTime:0.001420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521189 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521189 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521189 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='86513' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001567s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002624s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521189 AND `partno` = '86513' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344916 [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64501472 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501472 ORDER BY `minOrder` ASC [ RunTime:0.002449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64501472 ORDER BY `unit` DESC [ RunTime:0.002898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64501472 LIMIT 2 [ RunTime:0.001234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501472 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='86513623' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513623' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000561s ]
SELECT `id` FROM `stock` WHERE `id` <> 64501472 AND `partno` = '86513623' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64501271 LIMIT 5 [ RunTime:0.005554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501271 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64501271 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64501271 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501271 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='86513622' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513622' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.004566s ]
SELECT `id` FROM `stock` WHERE `id` <> 64501271 AND `partno` = '86513622' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64501086 LIMIT 5 [ RunTime:0.001644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501086 ORDER BY `minOrder` ASC [ RunTime:0.003958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64501086 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64501086 LIMIT 2 [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64501086 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='86513621' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513621' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000653s ]
SELECT `id` FROM `stock` WHERE `id` <> 64501086 AND `partno` = '86513621' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64500592 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500592 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64500592 ORDER BY `unit` DESC [ RunTime:0.003161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64500592 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64500592 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='86513620' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513620' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002729s ]
SELECT `id` FROM `stock` WHERE `id` <> 64500592 AND `partno` = '86513620' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64495897 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64495897 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64495897 ORDER BY `unit` DESC [ RunTime:0.002070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64495897 LIMIT 2 [ RunTime:0.007596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64495897 ORDER BY `minOrder` ASC [ RunTime:0.011838s ]
select * from pdf where partno='86513300' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513300' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.005007s ]
SELECT `id` FROM `stock` WHERE `id` <> 64495897 AND `partno` = '86513300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475519 [ RunTime:0.000737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64495827 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64495827 ORDER BY `minOrder` ASC [ RunTime:0.001068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64495827 ORDER BY `unit` DESC [ RunTime:0.005790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64495827 LIMIT 2 [ RunTime:0.006961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64495827 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
select * from pdf where partno='86513301' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513301' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.009790s ]
SELECT `id` FROM `stock` WHERE `id` <> 64495827 AND `partno` = '86513301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.016418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475517 [ RunTime:0.017895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64494783 LIMIT 5 [ RunTime:0.003713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64494783 ORDER BY `minOrder` ASC [ RunTime:0.012703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64494783 ORDER BY `unit` DESC [ RunTime:0.004148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64494783 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64494783 ORDER BY `minOrder` ASC [ RunTime:0.001734s ]
select * from pdf where partno='86513551' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513551' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.006732s ]
SELECT `id` FROM `stock` WHERE `id` <> 64494783 AND `partno` = '86513551' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.019161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475211 [ RunTime:0.013168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64494700 LIMIT 5 [ RunTime:0.024579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64494700 ORDER BY `minOrder` ASC [ RunTime:0.011940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64494700 ORDER BY `unit` DESC [ RunTime:0.011160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64494700 LIMIT 2 [ RunTime:0.022157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64494700 ORDER BY `minOrder` ASC [ RunTime:0.006111s ]
select * from pdf where partno='86513101' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513101' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.006145s ]
SELECT `id` FROM `stock` WHERE `id` <> 64494700 AND `partno` = '86513101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352650 [ RunTime:0.002189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64493525 LIMIT 5 [ RunTime:0.001137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64493525 ORDER BY `minOrder` ASC [ RunTime:0.015870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64493525 ORDER BY `unit` DESC [ RunTime:0.004968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64493525 LIMIT 2 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64493525 ORDER BY `minOrder` ASC [ RunTime:0.003401s ]
select * from pdf where partno='86513100' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513100' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002695s ]
SELECT `id` FROM `stock` WHERE `id` <> 64493525 AND `partno` = '86513100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352626 [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64493192 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64493192 ORDER BY `minOrder` ASC [ RunTime:0.002538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64493192 ORDER BY `unit` DESC [ RunTime:0.004325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64493192 LIMIT 2 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64493192 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='86513500' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513500' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002563s ]
SELECT `id` FROM `stock` WHERE `id` <> 64493192 AND `partno` = '86513500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.003010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475009 [ RunTime:0.004960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64493191 LIMIT 5 [ RunTime:0.008733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64493191 ORDER BY `minOrder` ASC [ RunTime:0.012538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64493191 ORDER BY `unit` DESC [ RunTime:0.005430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64493191 LIMIT 2 [ RunTime:0.001589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64493191 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='86513401' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513401' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.008748s ]
SELECT `id` FROM `stock` WHERE `id` <> 64493191 AND `partno` = '86513401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.008868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352574 [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64492752 LIMIT 5 [ RunTime:0.009309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64492752 ORDER BY `minOrder` ASC [ RunTime:0.005760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64492752 ORDER BY `unit` DESC [ RunTime:0.008061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64492752 LIMIT 2 [ RunTime:0.003775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64492752 ORDER BY `minOrder` ASC [ RunTime:0.006328s ]
select * from pdf where partno='86513000' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.006843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513000' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.011073s ]
SELECT `id` FROM `stock` WHERE `id` <> 64492752 AND `partno` = '86513000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474814 [ RunTime:0.003870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64077736 LIMIT 5 [ RunTime:0.010636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64077736 ORDER BY `minOrder` ASC [ RunTime:0.012506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64077736 ORDER BY `unit` DESC [ RunTime:0.005859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64077736 LIMIT 2 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64077736 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='86513-26' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513-26' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.003795s ]
SELECT `id` FROM `stock` WHERE `id` <> 64077736 AND `partno` = '86513-26' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.010281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18854098 [ RunTime:0.008807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63276552 LIMIT 5 [ RunTime:0.022705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63276552 ORDER BY `minOrder` ASC [ RunTime:0.009906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63276552 ORDER BY `unit` DESC [ RunTime:0.014451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63276552 LIMIT 2 [ RunTime:0.002364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63276552 ORDER BY `minOrder` ASC [ RunTime:0.004145s ]
select * from pdf where partno='86513-000' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86513-000' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.001310s ]
SELECT `id` FROM `stock` WHERE `id` <> 63276552 AND `partno` = '86513-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15362445 [ RunTime:0.000449s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000814s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002539s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009826s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002995s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000694s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001727s ]
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 '86513%' OR `brand` LIKE '86513%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000707s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '86513%' OR `brand` LIKE '86513%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000517s ]