SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002281s ]
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.003333s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003117s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000622s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002075s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001831s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001750s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000831s ]
UPDATE `stock_search` SET `count` = 4182 , `updatetime` = '2026-06-08 16:54:44' WHERE `partno` = '210' [ RunTime:0.005003s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000265s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000253s ]
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.000456s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002398s ]
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.000400s ]
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 2340,20 [ RunTime:0.075885s ]
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 ('38052911','38052873','38052530','38052382','38052067','38051262','38051112','38051055','38051015','38050951','38050775','38037860','38037812','38032456','38032455','38032454','38032446','38032432','38032371','37992406') ORDER BY FIELD(s.id, 38052911,38052873,38052530,38052382,38052067,38051262,38051112,38051055,38051015,38050951,38050775,38037860,38037812,38032456,38032455,38032454,38032446,38032432,38032371,37992406) [ RunTime:0.013580s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38052911 LIMIT 4 [ RunTime:0.001522s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052911 ORDER BY `minOrder` ASC [ RunTime:0.008119s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38052911 ORDER BY `unit` DESC [ RunTime:0.027423s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38052911 LIMIT 2 [ RunTime:0.007773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052911 ORDER BY `minOrder` ASC [ RunTime:0.007298s ]
select * from pdf where partno='210-710' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001402s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-710' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38052873 LIMIT 4 [ RunTime:0.008967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052873 ORDER BY `minOrder` ASC [ RunTime:0.015739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38052873 ORDER BY `unit` DESC [ RunTime:0.010145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38052873 LIMIT 2 [ RunTime:0.004152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052873 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
select * from pdf where partno='210-880/000-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-880/000-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38052530 LIMIT 4 [ RunTime:0.002296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052530 ORDER BY `minOrder` ASC [ RunTime:0.012090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38052530 ORDER BY `unit` DESC [ RunTime:0.004382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38052530 LIMIT 2 [ RunTime:0.015711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052530 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
select * from pdf where partno='210-876/000-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-876/000-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38052382 LIMIT 4 [ RunTime:0.007863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052382 ORDER BY `minOrder` ASC [ RunTime:0.006409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38052382 ORDER BY `unit` DESC [ RunTime:0.008937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38052382 LIMIT 2 [ RunTime:0.008244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052382 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
select * from pdf where partno='210-882' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-882' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38052067 LIMIT 4 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052067 ORDER BY `minOrder` ASC [ RunTime:0.005929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38052067 ORDER BY `unit` DESC [ RunTime:0.009680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38052067 LIMIT 2 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38052067 ORDER BY `minOrder` ASC [ RunTime:0.002081s ]
select * from pdf where partno='210-708' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-708' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38051262 LIMIT 4 [ RunTime:0.004689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051262 ORDER BY `minOrder` ASC [ RunTime:0.005059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38051262 ORDER BY `unit` DESC [ RunTime:0.006491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38051262 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051262 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='210-707/000-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-707/000-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38051112 LIMIT 4 [ RunTime:0.006938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051112 ORDER BY `minOrder` ASC [ RunTime:0.003291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38051112 ORDER BY `unit` DESC [ RunTime:0.002357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38051112 LIMIT 2 [ RunTime:0.002060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051112 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='210-706/000-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-706/000-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38051055 LIMIT 4 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051055 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38051055 ORDER BY `unit` DESC [ RunTime:0.005810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38051055 LIMIT 2 [ RunTime:0.001846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051055 ORDER BY `minOrder` ASC [ RunTime:0.001234s ]
select * from pdf where partno='210-705/000-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-705/000-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38051015 LIMIT 4 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051015 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38051015 ORDER BY `unit` DESC [ RunTime:0.005868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38051015 LIMIT 2 [ RunTime:0.001698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38051015 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='210-707' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-707' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38050951 LIMIT 4 [ RunTime:0.018782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38050951 ORDER BY `minOrder` ASC [ RunTime:0.015081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38050951 ORDER BY `unit` DESC [ RunTime:0.009801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38050951 LIMIT 2 [ RunTime:0.003756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38050951 ORDER BY `minOrder` ASC [ RunTime:0.002796s ]
select * from pdf where partno='210-706' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-706' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38050775 LIMIT 4 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38050775 ORDER BY `minOrder` ASC [ RunTime:0.003845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38050775 ORDER BY `unit` DESC [ RunTime:0.006185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38050775 LIMIT 2 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38050775 ORDER BY `minOrder` ASC [ RunTime:0.002226s ]
select * from pdf where partno='210-705' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-705' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38037860 LIMIT 4 [ RunTime:0.033539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38037860 ORDER BY `minOrder` ASC [ RunTime:0.012562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38037860 ORDER BY `unit` DESC [ RunTime:0.019972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38037860 LIMIT 2 [ RunTime:0.010453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38037860 ORDER BY `minOrder` ASC [ RunTime:0.000999s ]
select * from pdf where partno='210-874' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-874' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38037812 LIMIT 4 [ RunTime:0.017112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38037812 ORDER BY `minOrder` ASC [ RunTime:0.006017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38037812 ORDER BY `unit` DESC [ RunTime:0.026993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38037812 LIMIT 2 [ RunTime:0.015106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38037812 ORDER BY `minOrder` ASC [ RunTime:0.006663s ]
select * from pdf where partno='210-870' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.052905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-870' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38032456 LIMIT 4 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032456 ORDER BY `minOrder` ASC [ RunTime:0.009307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38032456 ORDER BY `unit` DESC [ RunTime:0.004204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38032456 LIMIT 2 [ RunTime:0.003320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032456 ORDER BY `minOrder` ASC [ RunTime:0.013608s ]
select * from pdf where partno='2105' and brandshort='80/20, LLC' limit 1 [ RunTime:0.008871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.013271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38032455 LIMIT 4 [ RunTime:0.029820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032455 ORDER BY `minOrder` ASC [ RunTime:0.023616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38032455 ORDER BY `unit` DESC [ RunTime:0.009563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38032455 LIMIT 2 [ RunTime:0.006101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032455 ORDER BY `minOrder` ASC [ RunTime:0.019472s ]
select * from pdf where partno='2104' and brandshort='80/20, LLC' limit 1 [ RunTime:0.005898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.011787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38032454 LIMIT 4 [ RunTime:0.005141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032454 ORDER BY `minOrder` ASC [ RunTime:0.031081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38032454 ORDER BY `unit` DESC [ RunTime:0.002631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38032454 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032454 ORDER BY `minOrder` ASC [ RunTime:0.008956s ]
select * from pdf where partno='2105-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.004527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.012258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38032446 LIMIT 4 [ RunTime:0.011718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032446 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38032446 ORDER BY `unit` DESC [ RunTime:0.014232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38032446 LIMIT 2 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032446 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='2106-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.003033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38032432 LIMIT 4 [ RunTime:0.002352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032432 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38032432 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38032432 LIMIT 2 [ RunTime:0.003057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032432 ORDER BY `minOrder` ASC [ RunTime:0.005788s ]
select * from pdf where partno='2106' and brandshort='80/20, LLC' limit 1 [ RunTime:0.007586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.015796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38032371 LIMIT 4 [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032371 ORDER BY `minOrder` ASC [ RunTime:0.009980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38032371 ORDER BY `unit` DESC [ RunTime:0.003586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38032371 LIMIT 2 [ RunTime:0.005174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38032371 ORDER BY `minOrder` ASC [ RunTime:0.003940s ]
select * from pdf where partno='2106-BE' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-BE' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37992406 LIMIT 4 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37992406 ORDER BY `minOrder` ASC [ RunTime:0.001287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37992406 ORDER BY `unit` DESC [ RunTime:0.001569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37992406 LIMIT 2 [ RunTime:0.001380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37992406 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='2102217' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102217' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003432s ]
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.002450s ]