SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003571s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.016865s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001969s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006424s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002105s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.006403s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001865s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002093s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001938s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002324s ]
UPDATE `stock_search` SET `count` = 3491 , `updatetime` = '2026-06-08 13:56:31' WHERE `partno` = '210' [ RunTime:0.002829s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001194s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000528s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.001694s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001460s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000491s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 4980,20 [ RunTime:0.066006s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('33308631','33308170','33307785','33307736','33307719','33307697','33307696','33307695','33307483','33307118','33306738','33304525','33304372','33174799','33172084','33171805','33171217','33171210','33171082','33170962') ORDER BY FIELD(s.id, 33308631,33308170,33307785,33307736,33307719,33307697,33307696,33307695,33307483,33307118,33306738,33304525,33304372,33174799,33172084,33171805,33171217,33171210,33171082,33170962) [ RunTime:0.006768s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33308631 LIMIT 4 [ RunTime:0.004253s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308631 ORDER BY `minOrder` ASC [ RunTime:0.024243s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33308631 ORDER BY `unit` DESC [ RunTime:0.007930s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33308631 LIMIT 2 [ RunTime:0.004674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308631 ORDER BY `minOrder` ASC [ RunTime:0.013936s ]
select * from pdf where partno='2105.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005209s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33308170 LIMIT 4 [ RunTime:0.001616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308170 ORDER BY `minOrder` ASC [ RunTime:0.005296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33308170 ORDER BY `unit` DESC [ RunTime:0.009716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33308170 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308170 ORDER BY `minOrder` ASC [ RunTime:0.002695s ]
select * from pdf where partno='2101.3' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.012356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.3' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.007481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307785 LIMIT 4 [ RunTime:0.006530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307785 ORDER BY `minOrder` ASC [ RunTime:0.017695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307785 ORDER BY `unit` DESC [ RunTime:0.009265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307785 LIMIT 2 [ RunTime:0.011277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307785 ORDER BY `minOrder` ASC [ RunTime:0.003889s ]
select * from pdf where partno='2104.5' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.009134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.5' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.008972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307736 LIMIT 4 [ RunTime:0.016999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307736 ORDER BY `minOrder` ASC [ RunTime:0.016462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307736 ORDER BY `unit` DESC [ RunTime:0.056329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307736 LIMIT 2 [ RunTime:0.006444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307736 ORDER BY `minOrder` ASC [ RunTime:0.013289s ]
select * from pdf where partno='210-549' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-549' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307719 LIMIT 4 [ RunTime:0.009098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307719 ORDER BY `minOrder` ASC [ RunTime:0.009430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307719 ORDER BY `unit` DESC [ RunTime:0.006573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307719 LIMIT 2 [ RunTime:0.004665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307719 ORDER BY `minOrder` ASC [ RunTime:0.005265s ]
select * from pdf where partno='2104.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.010808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.005346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307697 LIMIT 4 [ RunTime:0.011756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307697 ORDER BY `minOrder` ASC [ RunTime:0.027379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307697 ORDER BY `unit` DESC [ RunTime:0.009089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307697 LIMIT 2 [ RunTime:0.014292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307697 ORDER BY `minOrder` ASC [ RunTime:0.016316s ]
select * from pdf where partno='2101.8' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.004661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.8' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.020876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307696 LIMIT 4 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307696 ORDER BY `minOrder` ASC [ RunTime:0.017407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307696 ORDER BY `unit` DESC [ RunTime:0.024966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307696 LIMIT 2 [ RunTime:0.007862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307696 ORDER BY `minOrder` ASC [ RunTime:0.006193s ]
select * from pdf where partno='2101.5' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.008683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.5' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.008111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307695 LIMIT 4 [ RunTime:0.008646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307695 ORDER BY `minOrder` ASC [ RunTime:0.015949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307695 ORDER BY `unit` DESC [ RunTime:0.010850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307695 LIMIT 2 [ RunTime:0.002402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307695 ORDER BY `minOrder` ASC [ RunTime:0.007816s ]
select * from pdf where partno='2101.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.003216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.013294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307483 LIMIT 4 [ RunTime:0.002585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307483 ORDER BY `minOrder` ASC [ RunTime:0.009828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307483 ORDER BY `unit` DESC [ RunTime:0.016018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307483 LIMIT 2 [ RunTime:0.015126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307483 ORDER BY `minOrder` ASC [ RunTime:0.014965s ]
select * from pdf where partno='2104.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.042323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.019872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307118 LIMIT 4 [ RunTime:0.010453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307118 ORDER BY `minOrder` ASC [ RunTime:0.050474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307118 ORDER BY `unit` DESC [ RunTime:0.015649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307118 LIMIT 2 [ RunTime:0.011121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307118 ORDER BY `minOrder` ASC [ RunTime:0.022325s ]
select * from pdf where partno='2101.2' and brandshort='On Shore Technology Inc.' limit 1 [ RunTime:0.011243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.2' OR `brand` LIKE 'On Shore Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.002285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33306738 LIMIT 4 [ RunTime:0.011634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33306738 ORDER BY `minOrder` ASC [ RunTime:0.007948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33306738 ORDER BY `unit` DESC [ RunTime:0.003032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33306738 LIMIT 2 [ RunTime:0.011987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33306738 ORDER BY `minOrder` ASC [ RunTime:0.006079s ]
select * from pdf where partno='2104.2' and brandshort='On Shore Technology Inc.' limit 1 [ RunTime:0.006983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.2' OR `brand` LIKE 'On Shore Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.007755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33304525 LIMIT 4 [ RunTime:0.008767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304525 ORDER BY `minOrder` ASC [ RunTime:0.012697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33304525 ORDER BY `unit` DESC [ RunTime:0.004703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33304525 LIMIT 2 [ RunTime:0.005154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304525 ORDER BY `minOrder` ASC [ RunTime:0.008842s ]
select * from pdf where partno='2101.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.017977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.009747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33304372 LIMIT 4 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304372 ORDER BY `minOrder` ASC [ RunTime:0.019667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33304372 ORDER BY `unit` DESC [ RunTime:0.023844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33304372 LIMIT 2 [ RunTime:0.007570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304372 ORDER BY `minOrder` ASC [ RunTime:0.015194s ]
select * from pdf where partno='2102-1392' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.021721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1392' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33174799 LIMIT 4 [ RunTime:0.004754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33174799 ORDER BY `minOrder` ASC [ RunTime:0.049788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33174799 ORDER BY `unit` DESC [ RunTime:0.006847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33174799 LIMIT 2 [ RunTime:0.007754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33174799 ORDER BY `minOrder` ASC [ RunTime:0.007952s ]
select * from pdf where partno='2100-0065' and brandshort='Metcal' limit 1 [ RunTime:0.026570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-0065' OR `brand` LIKE 'Metcal%' ) ) LIMIT 1 [ RunTime:0.017033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33172084 LIMIT 4 [ RunTime:0.024660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33172084 ORDER BY `minOrder` ASC [ RunTime:0.019790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33172084 ORDER BY `unit` DESC [ RunTime:0.015303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33172084 LIMIT 2 [ RunTime:0.013149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33172084 ORDER BY `minOrder` ASC [ RunTime:0.003507s ]
select * from pdf where partno='21094' and brandshort='Wiha' limit 1 [ RunTime:0.006378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21094' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.007031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171805 LIMIT 4 [ RunTime:0.003815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171805 ORDER BY `minOrder` ASC [ RunTime:0.015401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171805 ORDER BY `unit` DESC [ RunTime:0.011630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171805 LIMIT 2 [ RunTime:0.003819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171805 ORDER BY `minOrder` ASC [ RunTime:0.013656s ]
select * from pdf where partno='21095' and brandshort='Wiha' limit 1 [ RunTime:0.003260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21095' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.045480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171217 LIMIT 4 [ RunTime:0.011870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171217 ORDER BY `minOrder` ASC [ RunTime:0.007890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171217 ORDER BY `unit` DESC [ RunTime:0.012612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171217 LIMIT 2 [ RunTime:0.001909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171217 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
select * from pdf where partno='21032' and brandshort='Wiha' limit 1 [ RunTime:0.010203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.009626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171210 LIMIT 4 [ RunTime:0.011237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171210 ORDER BY `minOrder` ASC [ RunTime:0.012336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171210 ORDER BY `unit` DESC [ RunTime:0.028723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171210 LIMIT 2 [ RunTime:0.011776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171210 ORDER BY `minOrder` ASC [ RunTime:0.002345s ]
select * from pdf where partno='21030' and brandshort='Wiha' limit 1 [ RunTime:0.000667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21030' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171082 LIMIT 4 [ RunTime:0.002810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171082 ORDER BY `minOrder` ASC [ RunTime:0.009640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171082 ORDER BY `unit` DESC [ RunTime:0.010574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171082 LIMIT 2 [ RunTime:0.009067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171082 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='21027' and brandshort='Wiha' limit 1 [ RunTime:0.016232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21027' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.007142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170962 LIMIT 4 [ RunTime:0.001853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.010498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170962 ORDER BY `unit` DESC [ RunTime:0.004895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170962 LIMIT 2 [ RunTime:0.007196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.010290s ]
select * from pdf where partno='21024' and brandshort='Wiha' limit 1 [ RunTime:0.004883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.007494s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.004201s ]