SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001899s ]
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=220&srecordnum=7530' [ RunTime:0.006138s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001157s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007441s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001597s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004494s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001260s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003316s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001065s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005960s ]
UPDATE `stock_search` SET `count` = 4592 , `updatetime` = '2026-06-08 19:02:20' WHERE `partno` = '210' [ RunTime:0.003301s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000202s ]
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.001485s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001508s ]
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.057830s ]
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 4380,20 [ RunTime:0.059977s ]
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 ('34335028','34335014','34335001','34334979','34334976','34334960','34334777','34334769','34332703','34332433','34332129','34332051','34331925','34331847','34331765','34331106','34330832','34330740','34330568','34330557') ORDER BY FIELD(s.id, 34335028,34335014,34335001,34334979,34334976,34334960,34334777,34334769,34332703,34332433,34332129,34332051,34331925,34331847,34331765,34331106,34330832,34330740,34330568,34330557) [ RunTime:0.003784s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34335028 LIMIT 4 [ RunTime:0.011662s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34335028 ORDER BY `minOrder` ASC [ RunTime:0.005024s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34335028 ORDER BY `unit` DESC [ RunTime:0.030322s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34335028 LIMIT 2 [ RunTime:0.002308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34335028 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='210-83-306-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.013455s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-306-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.014814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34335014 LIMIT 4 [ RunTime:0.062160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34335014 ORDER BY `minOrder` ASC [ RunTime:0.035413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34335014 ORDER BY `unit` DESC [ RunTime:0.010600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34335014 LIMIT 2 [ RunTime:0.009767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34335014 ORDER BY `minOrder` ASC [ RunTime:0.001029s ]
select * from pdf where partno='210-88-306-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.027232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-88-306-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.029851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34335001 LIMIT 4 [ RunTime:0.028828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34335001 ORDER BY `minOrder` ASC [ RunTime:0.009967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34335001 ORDER BY `unit` DESC [ RunTime:0.010850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34335001 LIMIT 2 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34335001 ORDER BY `minOrder` ASC [ RunTime:0.002713s ]
select * from pdf where partno='210-83-632-41-101000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.005679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-632-41-101000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.016437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34334979 LIMIT 4 [ RunTime:0.007415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334979 ORDER BY `minOrder` ASC [ RunTime:0.005490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34334979 ORDER BY `unit` DESC [ RunTime:0.020319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34334979 LIMIT 2 [ RunTime:0.009959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334979 ORDER BY `minOrder` ASC [ RunTime:0.005172s ]
select * from pdf where partno='210-83-624-41-101000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.008680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-624-41-101000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.009304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34334976 LIMIT 4 [ RunTime:0.013526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334976 ORDER BY `minOrder` ASC [ RunTime:0.005233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34334976 ORDER BY `unit` DESC [ RunTime:0.008279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34334976 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334976 ORDER BY `minOrder` ASC [ RunTime:0.004202s ]
select * from pdf where partno='210-83-320-41-101000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.002188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-320-41-101000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34334960 LIMIT 4 [ RunTime:0.021453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334960 ORDER BY `minOrder` ASC [ RunTime:0.012632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34334960 ORDER BY `unit` DESC [ RunTime:0.017818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34334960 LIMIT 2 [ RunTime:0.010221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334960 ORDER BY `minOrder` ASC [ RunTime:0.006605s ]
select * from pdf where partno='210-83-306-41-101000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.027920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-306-41-101000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.013326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34334777 LIMIT 4 [ RunTime:0.036587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334777 ORDER BY `minOrder` ASC [ RunTime:0.007218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34334777 ORDER BY `unit` DESC [ RunTime:0.005100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34334777 LIMIT 2 [ RunTime:0.008299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334777 ORDER BY `minOrder` ASC [ RunTime:0.005609s ]
select * from pdf where partno='210-2599-50-0602' and brandshort='3M' limit 1 [ RunTime:0.005739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2599-50-0602' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.009310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34334769 LIMIT 4 [ RunTime:0.026975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334769 ORDER BY `minOrder` ASC [ RunTime:0.049238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34334769 ORDER BY `unit` DESC [ RunTime:0.049723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34334769 LIMIT 2 [ RunTime:0.016836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34334769 ORDER BY `minOrder` ASC [ RunTime:0.029271s ]
select * from pdf where partno='2100-7243-00-1807' and brandshort='3M' limit 1 [ RunTime:0.023916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-7243-00-1807' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.026686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34332703 LIMIT 4 [ RunTime:0.010269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332703 ORDER BY `minOrder` ASC [ RunTime:0.008318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34332703 ORDER BY `unit` DESC [ RunTime:0.017453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34332703 LIMIT 2 [ RunTime:0.016416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332703 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='210-13-632-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-13-632-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.002056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34332433 LIMIT 4 [ RunTime:0.004181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332433 ORDER BY `minOrder` ASC [ RunTime:0.066583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34332433 ORDER BY `unit` DESC [ RunTime:0.029091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34332433 LIMIT 2 [ RunTime:0.007082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332433 ORDER BY `minOrder` ASC [ RunTime:0.019980s ]
select * from pdf where partno='210-13-628-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-13-628-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.007103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34332129 LIMIT 4 [ RunTime:0.020036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332129 ORDER BY `minOrder` ASC [ RunTime:0.013339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34332129 ORDER BY `unit` DESC [ RunTime:0.005331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34332129 LIMIT 2 [ RunTime:0.001790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332129 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='210-13-624-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-13-624-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.009405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34332051 LIMIT 4 [ RunTime:0.025728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332051 ORDER BY `minOrder` ASC [ RunTime:0.004806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34332051 ORDER BY `unit` DESC [ RunTime:0.001991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34332051 LIMIT 2 [ RunTime:0.003687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34332051 ORDER BY `minOrder` ASC [ RunTime:0.006994s ]
select * from pdf where partno='210790-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210790-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34331925 LIMIT 4 [ RunTime:0.007956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331925 ORDER BY `minOrder` ASC [ RunTime:0.049226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34331925 ORDER BY `unit` DESC [ RunTime:0.015127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34331925 LIMIT 2 [ RunTime:0.013519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331925 ORDER BY `minOrder` ASC [ RunTime:0.018596s ]
select * from pdf where partno='210-93-636-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-636-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.007869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34331847 LIMIT 4 [ RunTime:0.013607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331847 ORDER BY `minOrder` ASC [ RunTime:0.021746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34331847 ORDER BY `unit` DESC [ RunTime:0.020593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34331847 LIMIT 2 [ RunTime:0.042833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331847 ORDER BY `minOrder` ASC [ RunTime:0.032104s ]
select * from pdf where partno='210-47-964-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.035117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-47-964-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.025623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34331765 LIMIT 4 [ RunTime:0.032550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331765 ORDER BY `minOrder` ASC [ RunTime:0.033720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34331765 ORDER BY `unit` DESC [ RunTime:0.031883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34331765 LIMIT 2 [ RunTime:0.072572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331765 ORDER BY `minOrder` ASC [ RunTime:0.023061s ]
select * from pdf where partno='210-13-318-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.039687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-13-318-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.051301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34331106 LIMIT 4 [ RunTime:0.043205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331106 ORDER BY `minOrder` ASC [ RunTime:0.062444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34331106 ORDER BY `unit` DESC [ RunTime:0.048353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34331106 LIMIT 2 [ RunTime:0.042906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34331106 ORDER BY `minOrder` ASC [ RunTime:0.012305s ]
select * from pdf where partno='210793-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210793-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.025615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34330832 LIMIT 4 [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330832 ORDER BY `minOrder` ASC [ RunTime:0.013301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34330832 ORDER BY `unit` DESC [ RunTime:0.007846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34330832 LIMIT 2 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330832 ORDER BY `minOrder` ASC [ RunTime:0.003607s ]
select * from pdf where partno='210-93-318-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.004926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-318-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34330740 LIMIT 4 [ RunTime:0.005348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330740 ORDER BY `minOrder` ASC [ RunTime:0.032784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34330740 ORDER BY `unit` DESC [ RunTime:0.010236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34330740 LIMIT 2 [ RunTime:0.021519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330740 ORDER BY `minOrder` ASC [ RunTime:0.003120s ]
select * from pdf where partno='210-93-320-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-320-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.002666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34330568 LIMIT 4 [ RunTime:0.001741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330568 ORDER BY `minOrder` ASC [ RunTime:0.013726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34330568 ORDER BY `unit` DESC [ RunTime:0.014983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34330568 LIMIT 2 [ RunTime:0.038422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330568 ORDER BY `minOrder` ASC [ RunTime:0.006115s ]
select * from pdf where partno='210-47-636-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-47-636-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.010388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34330557 LIMIT 4 [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330557 ORDER BY `minOrder` ASC [ RunTime:0.000917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34330557 ORDER BY `unit` DESC [ RunTime:0.003420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34330557 LIMIT 2 [ RunTime:0.008356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34330557 ORDER BY `minOrder` ASC [ RunTime:0.004218s ]
select * from pdf where partno='210-91-628-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.036768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-91-628-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.018869s ]
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.009052s ]