SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001898s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.60' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.002794s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001591s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001556s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003070s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001847s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000689s ]
UPDATE `stock_search` SET `count` = 2633 , `updatetime` = '2026-06-08 06:07:12' WHERE `partno` = '210' [ RunTime:0.001763s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000341s ]
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.000802s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001970s ]
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.152086s ]
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 2760,20 [ RunTime:0.133091s ]
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 ('36830608','36809935','36791639','36791638','36791485','36791484','36791470','36791345','36791111','36791030','36790609','36790290','36790179','36781891','36781670','36781536','36781359','36781351','36781275','36781274') ORDER BY FIELD(s.id, 36830608,36809935,36791639,36791638,36791485,36791484,36791470,36791345,36791111,36791030,36790609,36790290,36790179,36781891,36781670,36781536,36781359,36781351,36781275,36781274) [ RunTime:0.003865s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36830608 LIMIT 4 [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830608 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36830608 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36830608 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36830608 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='2104, CL' and brandshort='Serpac' limit 1 [ RunTime:0.003186s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104, CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.001030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36809935 LIMIT 4 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36809935 ORDER BY `minOrder` ASC [ RunTime:0.000871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36809935 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36809935 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36809935 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='2107, IR' and brandshort='Serpac' limit 1 [ RunTime:0.000732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, IR' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791639 LIMIT 4 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791639 ORDER BY `minOrder` ASC [ RunTime:0.000768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791639 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791639 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791639 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='2102-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.001602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791638 LIMIT 4 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791638 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791638 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791638 LIMIT 2 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791638 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='2101-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791485 LIMIT 4 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791485 ORDER BY `minOrder` ASC [ RunTime:0.000982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791485 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791485 LIMIT 2 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791485 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='2101' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791484 LIMIT 4 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791484 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791484 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791484 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791484 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='2102' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791470 LIMIT 4 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791470 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791470 ORDER BY `unit` DESC [ RunTime:0.000448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791470 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791470 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='2107-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791345 LIMIT 4 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791345 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791345 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791345 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791345 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='2103-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791111 LIMIT 4 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791111 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791111 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791111 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791111 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='2107' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36791030 LIMIT 4 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791030 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36791030 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36791030 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36791030 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='2103' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36790609 LIMIT 4 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36790609 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36790609 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36790609 LIMIT 2 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36790609 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='2100-HW' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-HW' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36790290 LIMIT 4 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36790290 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36790290 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36790290 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36790290 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='2107-BE' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-BE' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36790179 LIMIT 4 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36790179 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36790179 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36790179 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36790179 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='2100' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781891 LIMIT 4 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781891 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781891 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781891 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781891 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='2105-632-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-632-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781670 LIMIT 4 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781670 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781670 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781670 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781670 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='2108-440-S-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108-440-S-12' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781536 LIMIT 4 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781536 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781536 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781536 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781536 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='2101-632-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101-632-N' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781359 LIMIT 4 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781359 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781359 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781359 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781359 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='2104' and brandshort='ABBATRON' limit 1 [ RunTime:0.001321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.001254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781351 LIMIT 4 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781351 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781351 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781351 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781351 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='2109' and brandshort='ABBATRON' limit 1 [ RunTime:0.000805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781275 LIMIT 4 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781275 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781275 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781275 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781275 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='2103' and brandshort='ABBATRON' limit 1 [ RunTime:0.000879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.000668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781274 LIMIT 4 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781274 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781274 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781274 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781274 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='2108' and brandshort='ABBATRON' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.000696s ]
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.085807s ]