SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001005s ]
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.001669s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001058s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000462s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003019s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.002339s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002085s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003052s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001757s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000761s ]
UPDATE `stock_search` SET `count` = 3870 , `updatetime` = '2026-06-08 15:49:53' WHERE `partno` = '210' [ RunTime:0.007315s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000281s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000235s ]
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.004872s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002201s ]
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.282636s ]
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 5200,20 [ RunTime:0.087577s ]
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 ('32878776','32878775','32878771','32878770','32878769','32878768','32878767','32878766','32878765','32878764','32878763','32878762','32878761','32878760','32878759','32878758','32878757','32878756','32878755','32878754') ORDER BY FIELD(s.id, 32878776,32878775,32878771,32878770,32878769,32878768,32878767,32878766,32878765,32878764,32878763,32878762,32878761,32878760,32878759,32878758,32878757,32878756,32878755,32878754) [ RunTime:0.008810s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878776 LIMIT 4 [ RunTime:0.002243s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878776 ORDER BY `minOrder` ASC [ RunTime:0.007616s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878776 ORDER BY `unit` DESC [ RunTime:0.001175s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878776 LIMIT 2 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878776 ORDER BY `minOrder` ASC [ RunTime:0.003240s ]
select * from pdf where partno='210-4LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018514s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-4LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878775 LIMIT 4 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878775 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878775 ORDER BY `unit` DESC [ RunTime:0.003831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878775 LIMIT 2 [ RunTime:0.007927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878775 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
select * from pdf where partno='210-4LPS' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-4LPS' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878771 LIMIT 4 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878771 ORDER BY `minOrder` ASC [ RunTime:0.005726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878771 ORDER BY `unit` DESC [ RunTime:0.007303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878771 LIMIT 2 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878771 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
select * from pdf where partno='210-3MSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878770 LIMIT 4 [ RunTime:0.009553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878770 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878770 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878770 LIMIT 2 [ RunTime:0.001851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878770 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='210-3LPSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878769 LIMIT 4 [ RunTime:0.007249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878769 ORDER BY `minOrder` ASC [ RunTime:0.002687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878769 ORDER BY `unit` DESC [ RunTime:0.005069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878769 LIMIT 2 [ RunTime:0.008912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878769 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
select * from pdf where partno='210-3MSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878768 LIMIT 4 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878768 ORDER BY `minOrder` ASC [ RunTime:0.007686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878768 ORDER BY `unit` DESC [ RunTime:0.005423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878768 LIMIT 2 [ RunTime:0.002512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878768 ORDER BY `minOrder` ASC [ RunTime:0.002879s ]
select * from pdf where partno='210-3LPSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878767 LIMIT 4 [ RunTime:0.017258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878767 ORDER BY `minOrder` ASC [ RunTime:0.006729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878767 ORDER BY `unit` DESC [ RunTime:0.025866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878767 LIMIT 2 [ RunTime:0.004349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878767 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
select * from pdf where partno='210-3MSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878766 LIMIT 4 [ RunTime:0.016469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878766 ORDER BY `minOrder` ASC [ RunTime:0.009184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878766 ORDER BY `unit` DESC [ RunTime:0.007522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878766 LIMIT 2 [ RunTime:0.016111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878766 ORDER BY `minOrder` ASC [ RunTime:0.011114s ]
select * from pdf where partno='210-3LPSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878765 LIMIT 4 [ RunTime:0.006537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878765 ORDER BY `minOrder` ASC [ RunTime:0.006486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878765 ORDER BY `unit` DESC [ RunTime:0.019086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878765 LIMIT 2 [ RunTime:0.010322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878765 ORDER BY `minOrder` ASC [ RunTime:0.004905s ]
select * from pdf where partno='210-3MST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878764 LIMIT 4 [ RunTime:0.009271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878764 ORDER BY `minOrder` ASC [ RunTime:0.003272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878764 ORDER BY `unit` DESC [ RunTime:0.000853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878764 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878764 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='210-3LPST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878763 LIMIT 4 [ RunTime:0.009537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878763 ORDER BY `minOrder` ASC [ RunTime:0.014866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878763 ORDER BY `unit` DESC [ RunTime:0.007996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878763 LIMIT 2 [ RunTime:0.019695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878763 ORDER BY `minOrder` ASC [ RunTime:0.001419s ]
select * from pdf where partno='210-3ESFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3ESFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878762 LIMIT 4 [ RunTime:0.015357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878762 ORDER BY `minOrder` ASC [ RunTime:0.020928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878762 ORDER BY `unit` DESC [ RunTime:0.018855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878762 LIMIT 2 [ RunTime:0.007674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878762 ORDER BY `minOrder` ASC [ RunTime:0.007981s ]
select * from pdf where partno='210-3MSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878761 LIMIT 4 [ RunTime:0.004573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878761 ORDER BY `minOrder` ASC [ RunTime:0.004484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878761 ORDER BY `unit` DESC [ RunTime:0.016360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878761 LIMIT 2 [ RunTime:0.001995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878761 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='210-3LPSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878760 LIMIT 4 [ RunTime:0.018699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878760 ORDER BY `minOrder` ASC [ RunTime:0.013654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878760 ORDER BY `unit` DESC [ RunTime:0.011808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878760 LIMIT 2 [ RunTime:0.026605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878760 ORDER BY `minOrder` ASC [ RunTime:0.034918s ]
select * from pdf where partno='210-3ESD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3ESD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.038215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878759 LIMIT 4 [ RunTime:0.011791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878759 ORDER BY `minOrder` ASC [ RunTime:0.072101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878759 ORDER BY `unit` DESC [ RunTime:0.041745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878759 LIMIT 2 [ RunTime:0.017396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878759 ORDER BY `minOrder` ASC [ RunTime:0.011560s ]
select * from pdf where partno='210-3MSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878758 LIMIT 4 [ RunTime:0.018610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878758 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878758 ORDER BY `unit` DESC [ RunTime:0.002691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878758 LIMIT 2 [ RunTime:0.010855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878758 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
select * from pdf where partno='210-3LPSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878757 LIMIT 4 [ RunTime:0.024686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878757 ORDER BY `minOrder` ASC [ RunTime:0.042532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878757 ORDER BY `unit` DESC [ RunTime:0.029104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878757 LIMIT 2 [ RunTime:0.026458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878757 ORDER BY `minOrder` ASC [ RunTime:0.058108s ]
select * from pdf where partno='210-3ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.067613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878756 LIMIT 4 [ RunTime:0.036352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878756 ORDER BY `minOrder` ASC [ RunTime:0.017809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878756 ORDER BY `unit` DESC [ RunTime:0.024966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878756 LIMIT 2 [ RunTime:0.049444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878756 ORDER BY `minOrder` ASC [ RunTime:0.021198s ]
select * from pdf where partno='210-3MSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3MSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878755 LIMIT 4 [ RunTime:0.038714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878755 ORDER BY `minOrder` ASC [ RunTime:0.018988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878755 ORDER BY `unit` DESC [ RunTime:0.027765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878755 LIMIT 2 [ RunTime:0.038753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878755 ORDER BY `minOrder` ASC [ RunTime:0.026522s ]
select * from pdf where partno='210-3LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878754 LIMIT 4 [ RunTime:0.018180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878754 ORDER BY `minOrder` ASC [ RunTime:0.082118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878754 ORDER BY `unit` DESC [ RunTime:0.024099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878754 LIMIT 2 [ RunTime:0.019822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878754 ORDER BY `minOrder` ASC [ RunTime:0.015465s ]
select * from pdf where partno='210-3ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-3ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034926s ]
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.150282s ]