SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001643s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.013726s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001141s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015116s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001760s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.016705s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003063s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.020163s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001483s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.026045s ]
UPDATE `stock_search` SET `count` = 1992 , `updatetime` = '2026-06-06 21:08:49' WHERE `partno` = '210' [ RunTime:0.037527s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.007575s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.030403s ]
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.029814s ]
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.137785s ]
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 2860,20 [ RunTime:0.058102s ]
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 ('33392782','33392776','33392766','33392723','33392722','33392716','33392715','33392710','33392706','33392696','33392691','33392690','33392686','33392681','33392658','33392656','33392639','33392638','33392624','33392622') ORDER BY FIELD(s.id, 33392782,33392776,33392766,33392723,33392722,33392716,33392715,33392710,33392706,33392696,33392691,33392690,33392686,33392681,33392658,33392656,33392639,33392638,33392624,33392622) [ RunTime:0.052041s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392782 LIMIT 4 [ RunTime:0.016939s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392782 ORDER BY `minOrder` ASC [ RunTime:0.076733s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392782 ORDER BY `unit` DESC [ RunTime:0.027598s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392782 LIMIT 2 [ RunTime:0.019924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392782 ORDER BY `minOrder` ASC [ RunTime:0.020693s ]
select * from pdf where partno='2104-4-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.032145s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-4-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.020625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392776 LIMIT 4 [ RunTime:0.014448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392776 ORDER BY `minOrder` ASC [ RunTime:0.015641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392776 ORDER BY `unit` DESC [ RunTime:0.026449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392776 LIMIT 2 [ RunTime:0.018433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392776 ORDER BY `minOrder` ASC [ RunTime:0.036660s ]
select * from pdf where partno='2106-4-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.049853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-4-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.020941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392766 LIMIT 4 [ RunTime:0.030503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392766 ORDER BY `minOrder` ASC [ RunTime:0.110966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392766 ORDER BY `unit` DESC [ RunTime:0.041369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392766 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392766 ORDER BY `minOrder` ASC [ RunTime:0.051723s ]
select * from pdf where partno='2106-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.079909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-3-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.080066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392723 LIMIT 4 [ RunTime:0.092613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392723 ORDER BY `minOrder` ASC [ RunTime:0.024111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392723 ORDER BY `unit` DESC [ RunTime:0.040222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392723 LIMIT 2 [ RunTime:0.051054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392723 ORDER BY `minOrder` ASC [ RunTime:0.009732s ]
select * from pdf where partno='2104-4-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-4-01-80-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.059865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392722 LIMIT 4 [ RunTime:0.037517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392722 ORDER BY `minOrder` ASC [ RunTime:0.142399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392722 ORDER BY `unit` DESC [ RunTime:0.130095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392722 LIMIT 2 [ RunTime:0.018690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392722 ORDER BY `minOrder` ASC [ RunTime:0.044571s ]
select * from pdf where partno='2104-4-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.032248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-4-01-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.022843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392716 LIMIT 4 [ RunTime:0.051494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392716 ORDER BY `minOrder` ASC [ RunTime:0.111584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392716 ORDER BY `unit` DESC [ RunTime:0.015104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392716 LIMIT 2 [ RunTime:0.015186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392716 ORDER BY `minOrder` ASC [ RunTime:0.065877s ]
select * from pdf where partno='2104-3-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.058161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-3-01-80-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.026358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392715 LIMIT 4 [ RunTime:0.045131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392715 ORDER BY `minOrder` ASC [ RunTime:0.051150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392715 ORDER BY `unit` DESC [ RunTime:0.050891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392715 LIMIT 2 [ RunTime:0.050911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392715 ORDER BY `minOrder` ASC [ RunTime:0.050952s ]
select * from pdf where partno='2104-3-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.057909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-3-01-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.079045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392710 LIMIT 4 [ RunTime:0.076903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392710 ORDER BY `minOrder` ASC [ RunTime:0.022072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392710 ORDER BY `unit` DESC [ RunTime:0.025647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392710 LIMIT 2 [ RunTime:0.051071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392710 ORDER BY `minOrder` ASC [ RunTime:0.029491s ]
select * from pdf where partno='2103-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.035394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103-3-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392706 LIMIT 4 [ RunTime:0.010196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392706 ORDER BY `minOrder` ASC [ RunTime:0.071714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392706 ORDER BY `unit` DESC [ RunTime:0.012653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392706 LIMIT 2 [ RunTime:0.046332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392706 ORDER BY `minOrder` ASC [ RunTime:0.016471s ]
select * from pdf where partno='2107-4-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.021198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-4-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.016518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392696 LIMIT 4 [ RunTime:0.012972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392696 ORDER BY `minOrder` ASC [ RunTime:0.042645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392696 ORDER BY `unit` DESC [ RunTime:0.011105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392696 LIMIT 2 [ RunTime:0.008356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392696 ORDER BY `minOrder` ASC [ RunTime:0.020492s ]
select * from pdf where partno='2107-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.020323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-3-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.010313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392691 LIMIT 4 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392691 ORDER BY `minOrder` ASC [ RunTime:0.010256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392691 ORDER BY `unit` DESC [ RunTime:0.002996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392691 LIMIT 2 [ RunTime:0.002077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392691 ORDER BY `minOrder` ASC [ RunTime:0.051220s ]
select * from pdf where partno='2103-1-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.051083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103-1-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.013026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392690 LIMIT 4 [ RunTime:0.010812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392690 ORDER BY `minOrder` ASC [ RunTime:0.026692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392690 ORDER BY `unit` DESC [ RunTime:0.025623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392690 LIMIT 2 [ RunTime:0.037182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392690 ORDER BY `minOrder` ASC [ RunTime:0.013398s ]
select * from pdf where partno='2107-2-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.010080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-2-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.029745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392686 LIMIT 4 [ RunTime:0.019265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392686 ORDER BY `minOrder` ASC [ RunTime:0.070321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392686 ORDER BY `unit` DESC [ RunTime:0.019620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392686 LIMIT 2 [ RunTime:0.007224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392686 ORDER BY `minOrder` ASC [ RunTime:0.007132s ]
select * from pdf where partno='2107-1-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.015936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107-1-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.020847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392681 LIMIT 4 [ RunTime:0.004297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392681 ORDER BY `minOrder` ASC [ RunTime:0.016157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392681 ORDER BY `unit` DESC [ RunTime:0.010779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392681 LIMIT 2 [ RunTime:0.006447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392681 ORDER BY `minOrder` ASC [ RunTime:0.001091s ]
select * from pdf where partno='2106-1-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.004039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-1-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392658 LIMIT 4 [ RunTime:0.002425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392658 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392658 ORDER BY `unit` DESC [ RunTime:0.005332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392658 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392658 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='2106-4-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-4-01-80-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.004524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392656 LIMIT 4 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392656 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392656 ORDER BY `unit` DESC [ RunTime:0.003607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392656 LIMIT 2 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392656 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
select * from pdf where partno='2106-4-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-4-01-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.002600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392639 LIMIT 4 [ RunTime:0.003773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392639 ORDER BY `minOrder` ASC [ RunTime:0.002814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392639 ORDER BY `unit` DESC [ RunTime:0.002049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392639 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392639 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='2106-3-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-3-01-80-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392638 LIMIT 4 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392638 ORDER BY `minOrder` ASC [ RunTime:0.010071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392638 ORDER BY `unit` DESC [ RunTime:0.003143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392638 LIMIT 2 [ RunTime:0.001317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392638 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='2106-3-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-3-01-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392624 LIMIT 4 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392624 ORDER BY `minOrder` ASC [ RunTime:0.018295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392624 ORDER BY `unit` DESC [ RunTime:0.019886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392624 LIMIT 2 [ RunTime:0.059379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392624 ORDER BY `minOrder` ASC [ RunTime:0.035539s ]
select * from pdf where partno='2104-1-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1-01-80-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.045888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33392622 LIMIT 4 [ RunTime:0.027446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392622 ORDER BY `minOrder` ASC [ RunTime:0.004372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33392622 ORDER BY `unit` DESC [ RunTime:0.007248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33392622 LIMIT 2 [ RunTime:0.012601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33392622 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
select * from pdf where partno='2104-1-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1-01-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.013756s ]
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.005244s ]