SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001124s ]
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` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=147&srecordnum=7365' [ RunTime:0.005005s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001592s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000748s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002123s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002131s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001985s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001909s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.012380s ]
UPDATE `stock_search` SET `count` = 4252 , `updatetime` = '2026-06-08 17:23:32' WHERE `partno` = '210' [ RunTime:0.012590s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002334s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000503s ]
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.010525s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002668s ]
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.511851s ]
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 2920,20 [ RunTime:0.199604s ]
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 ('36832786','36832785','36832784','36832783','36832782','36830760','36830758','36830707','36830694','36830644','36830608','36809935','36791639','36791638','36791485','36791484','36791470','36791345','36791111','36791030') ORDER BY FIELD(s.id, 36832786,36832785,36832784,36832783,36832782,36830760,36830758,36830707,36830694,36830644,36830608,36809935,36791639,36791638,36791485,36791484,36791470,36791345,36791111,36791030) [ RunTime:0.207493s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832786 LIMIT 4 [ RunTime:0.074326s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832786 ORDER BY `minOrder` ASC [ RunTime:0.071698s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.062437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832786 ORDER BY `unit` DESC [ RunTime:0.038695s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832786 LIMIT 2 [ RunTime:0.023264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832786 ORDER BY `minOrder` ASC [ RunTime:0.097031s ]
select * from pdf where partno='2107, GY' and brandshort='Serpac' limit 1 [ RunTime:0.031731s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, GY' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.028125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832785 LIMIT 4 [ RunTime:0.048846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832785 ORDER BY `minOrder` ASC [ RunTime:0.048835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832785 ORDER BY `unit` DESC [ RunTime:0.037040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832785 LIMIT 2 [ RunTime:0.040613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832785 ORDER BY `minOrder` ASC [ RunTime:0.051060s ]
select * from pdf where partno='2106, AL' and brandshort='Serpac' limit 1 [ RunTime:0.016288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106, AL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.049578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832784 LIMIT 4 [ RunTime:0.058461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832784 ORDER BY `minOrder` ASC [ RunTime:0.042147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832784 ORDER BY `unit` DESC [ RunTime:0.058754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832784 LIMIT 2 [ RunTime:0.127360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832784 ORDER BY `minOrder` ASC [ RunTime:0.049813s ]
select * from pdf where partno='2105, BK' and brandshort='Serpac' limit 1 [ RunTime:0.034497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105, BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.129035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832783 LIMIT 4 [ RunTime:0.122540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832783 ORDER BY `minOrder` ASC [ RunTime:0.071447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832783 ORDER BY `unit` DESC [ RunTime:0.070045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832783 LIMIT 2 [ RunTime:0.060440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832783 ORDER BY `minOrder` ASC [ RunTime:0.053061s ]
select * from pdf where partno='2106, BK' and brandshort='Serpac' limit 1 [ RunTime:0.047064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106, BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.054611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832782 LIMIT 4 [ RunTime:0.099741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832782 ORDER BY `minOrder` ASC [ RunTime:0.033211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832782 ORDER BY `unit` DESC [ RunTime:0.084860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832782 LIMIT 2 [ RunTime:0.025316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832782 ORDER BY `minOrder` ASC [ RunTime:0.031322s ]
select * from pdf where partno='2107, AL' and brandshort='Serpac' limit 1 [ RunTime:0.068367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, AL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.038816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830760 LIMIT 4 [ RunTime:0.066838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830760 ORDER BY `minOrder` ASC [ RunTime:0.097691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830760 ORDER BY `unit` DESC [ RunTime:0.054939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830760 LIMIT 2 [ RunTime:0.044386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830760 ORDER BY `minOrder` ASC [ RunTime:0.012974s ]
select * from pdf where partno='2107, R' and brandshort='Serpac' limit 1 [ RunTime:0.054693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, R' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.028102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830758 LIMIT 4 [ RunTime:0.030057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830758 ORDER BY `minOrder` ASC [ RunTime:0.042216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830758 ORDER BY `unit` DESC [ RunTime:0.033879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830758 LIMIT 2 [ RunTime:0.030698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830758 ORDER BY `minOrder` ASC [ RunTime:0.006487s ]
select * from pdf where partno='2106, R' and brandshort='Serpac' limit 1 [ RunTime:0.013951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106, R' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.015046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830707 LIMIT 4 [ RunTime:0.014604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830707 ORDER BY `minOrder` ASC [ RunTime:0.023418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830707 ORDER BY `unit` DESC [ RunTime:0.030294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830707 LIMIT 2 [ RunTime:0.078399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830707 ORDER BY `minOrder` ASC [ RunTime:0.015472s ]
select * from pdf where partno='2105, R' and brandshort='Serpac' limit 1 [ RunTime:0.024669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105, R' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.032070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830694 LIMIT 4 [ RunTime:0.042612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830694 ORDER BY `minOrder` ASC [ RunTime:0.030197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830694 ORDER BY `unit` DESC [ RunTime:0.013583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830694 LIMIT 2 [ RunTime:0.033346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830694 ORDER BY `minOrder` ASC [ RunTime:0.018657s ]
select * from pdf where partno='2104, R' and brandshort='Serpac' limit 1 [ RunTime:0.017476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104, R' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.003657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830644 LIMIT 4 [ RunTime:0.016261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830644 ORDER BY `minOrder` ASC [ RunTime:0.029548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830644 ORDER BY `unit` DESC [ RunTime:0.033564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830644 LIMIT 2 [ RunTime:0.021519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830644 ORDER BY `minOrder` ASC [ RunTime:0.017745s ]
select * from pdf where partno='2107, CL' and brandshort='Serpac' limit 1 [ RunTime:0.035233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.007561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830608 LIMIT 4 [ RunTime:0.002545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830608 ORDER BY `minOrder` ASC [ RunTime:0.004461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830608 ORDER BY `unit` DESC [ RunTime:0.039611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830608 LIMIT 2 [ RunTime:0.017883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830608 ORDER BY `minOrder` ASC [ RunTime:0.018530s ]
select * from pdf where partno='2104, CL' and brandshort='Serpac' limit 1 [ RunTime:0.042861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104, CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.019658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36809935 LIMIT 4 [ RunTime:0.016333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36809935 ORDER BY `minOrder` ASC [ RunTime:0.044298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36809935 ORDER BY `unit` DESC [ RunTime:0.013609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36809935 LIMIT 2 [ RunTime:0.012966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36809935 ORDER BY `minOrder` ASC [ RunTime:0.041276s ]
select * from pdf where partno='2107, IR' and brandshort='Serpac' limit 1 [ RunTime:0.003122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, IR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.006334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791639 LIMIT 4 [ RunTime:0.030004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791639 ORDER BY `minOrder` ASC [ RunTime:0.031681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791639 ORDER BY `unit` DESC [ RunTime:0.028833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791639 LIMIT 2 [ RunTime:0.020602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791639 ORDER BY `minOrder` ASC [ RunTime:0.017088s ]
select * from pdf where partno='2102-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.015032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.009785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791638 LIMIT 4 [ RunTime:0.039354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791638 ORDER BY `minOrder` ASC [ RunTime:0.045409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791638 ORDER BY `unit` DESC [ RunTime:0.052614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791638 LIMIT 2 [ RunTime:0.053363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791638 ORDER BY `minOrder` ASC [ RunTime:0.014371s ]
select * from pdf where partno='2101-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.025050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.052543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791485 LIMIT 4 [ RunTime:0.058850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791485 ORDER BY `minOrder` ASC [ RunTime:0.041254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791485 ORDER BY `unit` DESC [ RunTime:0.049881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791485 LIMIT 2 [ RunTime:0.030740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791485 ORDER BY `minOrder` ASC [ RunTime:0.004306s ]
select * from pdf where partno='2101' and brandshort='80/20, LLC' limit 1 [ RunTime:0.015273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.006321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791484 LIMIT 4 [ RunTime:0.019118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791484 ORDER BY `minOrder` ASC [ RunTime:0.017893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791484 ORDER BY `unit` DESC [ RunTime:0.015270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791484 LIMIT 2 [ RunTime:0.057908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791484 ORDER BY `minOrder` ASC [ RunTime:0.008232s ]
select * from pdf where partno='2102' and brandshort='80/20, LLC' limit 1 [ RunTime:0.021162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.014983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791470 LIMIT 4 [ RunTime:0.033026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791470 ORDER BY `minOrder` ASC [ RunTime:0.043408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791470 ORDER BY `unit` DESC [ RunTime:0.056536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791470 LIMIT 2 [ RunTime:0.034171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791470 ORDER BY `minOrder` ASC [ RunTime:0.010722s ]
select * from pdf where partno='2107-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.042133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.055006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791345 LIMIT 4 [ RunTime:0.028638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791345 ORDER BY `minOrder` ASC [ RunTime:0.022194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791345 ORDER BY `unit` DESC [ RunTime:0.015278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791345 LIMIT 2 [ RunTime:0.038021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791345 ORDER BY `minOrder` ASC [ RunTime:0.008167s ]
select * from pdf where partno='2103-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.028035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.027263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791111 LIMIT 4 [ RunTime:0.021243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791111 ORDER BY `minOrder` ASC [ RunTime:0.041282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791111 ORDER BY `unit` DESC [ RunTime:0.024711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791111 LIMIT 2 [ RunTime:0.020449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791111 ORDER BY `minOrder` ASC [ RunTime:0.005178s ]
select * from pdf where partno='2107' and brandshort='80/20, LLC' limit 1 [ RunTime:0.009204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.005876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791030 LIMIT 4 [ RunTime:0.001680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791030 ORDER BY `minOrder` ASC [ RunTime:0.039700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791030 ORDER BY `unit` DESC [ RunTime:0.011268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791030 LIMIT 2 [ RunTime:0.016924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791030 ORDER BY `minOrder` ASC [ RunTime:0.010674s ]
select * from pdf where partno='2103' and brandshort='80/20, LLC' limit 1 [ RunTime:0.009985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.002350s ]
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.000631s ]