SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001562s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.004748s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002254s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001064s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002508s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.001330s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002245s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002285s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003109s ]
UPDATE `stock_search` SET `count` = 2340 , `updatetime` = '2026-06-07 01:08:19' WHERE `partno` = '210' [ RunTime:0.002227s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001295s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001952s ]
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.001724s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003685s ]
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.000454s ]
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 3160,20 [ RunTime:0.075362s ]
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 ('32878755','32878754','32878753','32878751','32878750','32878749','32878748','32878747','32878746','32878645','32878644','32878643','32878642','32878641','32878640','32878639','32878638','32878637','32878636','32878635') ORDER BY FIELD(s.id, 32878755,32878754,32878753,32878751,32878750,32878749,32878748,32878747,32878746,32878645,32878644,32878643,32878642,32878641,32878640,32878639,32878638,32878637,32878636,32878635) [ RunTime:0.007052s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878755 LIMIT 4 [ RunTime:0.009899s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878755 ORDER BY `minOrder` ASC [ RunTime:0.010104s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878755 ORDER BY `unit` DESC [ RunTime:0.005092s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878755 LIMIT 2 [ RunTime:0.021213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878755 ORDER BY `minOrder` ASC [ RunTime:0.014400s ]
select * from pdf where partno='210-3LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014200s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878754 LIMIT 4 [ RunTime:0.011646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878754 ORDER BY `minOrder` ASC [ RunTime:0.009177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878754 ORDER BY `unit` DESC [ RunTime:0.032057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878754 LIMIT 2 [ RunTime:0.022939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878754 ORDER BY `minOrder` ASC [ RunTime:0.008067s ]
select * from pdf where partno='210-3ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878753 LIMIT 4 [ RunTime:0.025632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878753 ORDER BY `minOrder` ASC [ RunTime:0.055094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878753 ORDER BY `unit` DESC [ RunTime:0.037625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878753 LIMIT 2 [ RunTime:0.053872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878753 ORDER BY `minOrder` ASC [ RunTime:0.016892s ]
select * from pdf where partno='210-3LPS' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPS' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878751 LIMIT 4 [ RunTime:0.042547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878751 ORDER BY `minOrder` ASC [ RunTime:0.019104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878751 ORDER BY `unit` DESC [ RunTime:0.015199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878751 LIMIT 2 [ RunTime:0.014467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878751 ORDER BY `minOrder` ASC [ RunTime:0.018425s ]
select * from pdf where partno='210-2MSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878750 LIMIT 4 [ RunTime:0.049430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878750 ORDER BY `minOrder` ASC [ RunTime:0.014188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878750 ORDER BY `unit` DESC [ RunTime:0.015552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878750 LIMIT 2 [ RunTime:0.014155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878750 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='210-2LPSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878749 LIMIT 4 [ RunTime:0.023937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878749 ORDER BY `minOrder` ASC [ RunTime:0.019239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878749 ORDER BY `unit` DESC [ RunTime:0.011396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878749 LIMIT 2 [ RunTime:0.016006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878749 ORDER BY `minOrder` ASC [ RunTime:0.029507s ]
select * from pdf where partno='210-2MSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878748 LIMIT 4 [ RunTime:0.016636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878748 ORDER BY `minOrder` ASC [ RunTime:0.017793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878748 ORDER BY `unit` DESC [ RunTime:0.019289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878748 LIMIT 2 [ RunTime:0.017165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878748 ORDER BY `minOrder` ASC [ RunTime:0.001206s ]
select * from pdf where partno='210-2LPSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878747 LIMIT 4 [ RunTime:0.012621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878747 ORDER BY `minOrder` ASC [ RunTime:0.018688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878747 ORDER BY `unit` DESC [ RunTime:0.015406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878747 LIMIT 2 [ RunTime:0.014968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878747 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='210-2MSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.044451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878746 LIMIT 4 [ RunTime:0.007636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878746 ORDER BY `minOrder` ASC [ RunTime:0.028207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878746 ORDER BY `unit` DESC [ RunTime:0.003248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878746 LIMIT 2 [ RunTime:0.027710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878746 ORDER BY `minOrder` ASC [ RunTime:0.016814s ]
select * from pdf where partno='210-2LPSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878645 LIMIT 4 [ RunTime:0.016616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878645 ORDER BY `minOrder` ASC [ RunTime:0.034380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878645 ORDER BY `unit` DESC [ RunTime:0.006825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878645 LIMIT 2 [ RunTime:0.015576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878645 ORDER BY `minOrder` ASC [ RunTime:0.012586s ]
select * from pdf where partno='210-2MST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878644 LIMIT 4 [ RunTime:0.031660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878644 ORDER BY `minOrder` ASC [ RunTime:0.037512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878644 ORDER BY `unit` DESC [ RunTime:0.018306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878644 LIMIT 2 [ RunTime:0.052114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878644 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
select * from pdf where partno='210-2LPST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.064769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878643 LIMIT 4 [ RunTime:0.023887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878643 ORDER BY `minOrder` ASC [ RunTime:0.015858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878643 ORDER BY `unit` DESC [ RunTime:0.019753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878643 LIMIT 2 [ RunTime:0.035271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878643 ORDER BY `minOrder` ASC [ RunTime:0.013491s ]
select * from pdf where partno='210-2ESFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ESFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878642 LIMIT 4 [ RunTime:0.018352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878642 ORDER BY `minOrder` ASC [ RunTime:0.022707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878642 ORDER BY `unit` DESC [ RunTime:0.026302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878642 LIMIT 2 [ RunTime:0.033021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878642 ORDER BY `minOrder` ASC [ RunTime:0.024349s ]
select * from pdf where partno='210-2MSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878641 LIMIT 4 [ RunTime:0.034269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878641 ORDER BY `minOrder` ASC [ RunTime:0.006372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878641 ORDER BY `unit` DESC [ RunTime:0.019209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878641 LIMIT 2 [ RunTime:0.057819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878641 ORDER BY `minOrder` ASC [ RunTime:0.012533s ]
select * from pdf where partno='210-2LPSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878640 LIMIT 4 [ RunTime:0.040301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878640 ORDER BY `minOrder` ASC [ RunTime:0.028055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878640 ORDER BY `unit` DESC [ RunTime:0.020835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878640 LIMIT 2 [ RunTime:0.022788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878640 ORDER BY `minOrder` ASC [ RunTime:0.011351s ]
select * from pdf where partno='210-2ESD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ESD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878639 LIMIT 4 [ RunTime:0.024389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878639 ORDER BY `minOrder` ASC [ RunTime:0.019876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878639 ORDER BY `unit` DESC [ RunTime:0.003258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878639 LIMIT 2 [ RunTime:0.018567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878639 ORDER BY `minOrder` ASC [ RunTime:0.006097s ]
select * from pdf where partno='210-2MSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878638 LIMIT 4 [ RunTime:0.019013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878638 ORDER BY `minOrder` ASC [ RunTime:0.011707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878638 ORDER BY `unit` DESC [ RunTime:0.017694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878638 LIMIT 2 [ RunTime:0.012591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878638 ORDER BY `minOrder` ASC [ RunTime:0.001870s ]
select * from pdf where partno='210-2LPSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878637 LIMIT 4 [ RunTime:0.010243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878637 ORDER BY `minOrder` ASC [ RunTime:0.015454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878637 ORDER BY `unit` DESC [ RunTime:0.005568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878637 LIMIT 2 [ RunTime:0.026425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878637 ORDER BY `minOrder` ASC [ RunTime:0.011788s ]
select * from pdf where partno='210-2ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878636 LIMIT 4 [ RunTime:0.027509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878636 ORDER BY `minOrder` ASC [ RunTime:0.035508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878636 ORDER BY `unit` DESC [ RunTime:0.024984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878636 LIMIT 2 [ RunTime:0.019332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878636 ORDER BY `minOrder` ASC [ RunTime:0.002166s ]
select * from pdf where partno='210-2MSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878635 LIMIT 4 [ RunTime:0.019774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878635 ORDER BY `minOrder` ASC [ RunTime:0.013550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878635 ORDER BY `unit` DESC [ RunTime:0.050976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878635 LIMIT 2 [ RunTime:0.017848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878635 ORDER BY `minOrder` ASC [ RunTime:0.013044s ]
select * from pdf where partno='210-2LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013242s ]
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.020612s ]