SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001246s ]
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.004858s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001455s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001187s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000813s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001445s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001570s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000587s ]
UPDATE `stock_search` SET `count` = 2089 , `updatetime` = '2026-06-07 00:00:48' WHERE `partno` = '210' [ RunTime:0.006266s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001986s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000297s ]
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.000559s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001326s ]
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.000365s ]
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 3300,20 [ RunTime:0.095206s ]
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 ('32401301','32398888','32398881','32393769','32393764','32393759','32389420','32384737','32381641','32381511','32375945','32374201','32373797','32372598','32371071','32370857','32369933','32364935','32363855','32360405') ORDER BY FIELD(s.id, 32401301,32398888,32398881,32393769,32393764,32393759,32389420,32384737,32381641,32381511,32375945,32374201,32373797,32372598,32371071,32370857,32369933,32364935,32363855,32360405) [ RunTime:0.022828s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32401301 LIMIT 4 [ RunTime:0.024245s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401301 ORDER BY `minOrder` ASC [ RunTime:0.041297s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.023826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32401301 ORDER BY `unit` DESC [ RunTime:0.047496s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32401301 LIMIT 2 [ RunTime:0.006774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401301 ORDER BY `minOrder` ASC [ RunTime:0.030141s ]
select * from pdf where partno='2102004' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013228s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102004' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32398888 LIMIT 4 [ RunTime:0.034881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398888 ORDER BY `minOrder` ASC [ RunTime:0.046074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32398888 ORDER BY `unit` DESC [ RunTime:0.016857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32398888 LIMIT 2 [ RunTime:0.041271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398888 ORDER BY `minOrder` ASC [ RunTime:0.003514s ]
select * from pdf where partno='2108944' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.041375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108944' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.034832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32398881 LIMIT 4 [ RunTime:0.032542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398881 ORDER BY `minOrder` ASC [ RunTime:0.048811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32398881 ORDER BY `unit` DESC [ RunTime:0.060685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32398881 LIMIT 2 [ RunTime:0.018000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398881 ORDER BY `minOrder` ASC [ RunTime:0.015301s ]
select * from pdf where partno='2107264' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107264' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393769 LIMIT 4 [ RunTime:0.015959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393769 ORDER BY `minOrder` ASC [ RunTime:0.067082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393769 ORDER BY `unit` DESC [ RunTime:0.040062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393769 LIMIT 2 [ RunTime:0.073871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393769 ORDER BY `minOrder` ASC [ RunTime:0.048824s ]
select * from pdf where partno='2109318' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109318' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393764 LIMIT 4 [ RunTime:0.025586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393764 ORDER BY `minOrder` ASC [ RunTime:0.024819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393764 ORDER BY `unit` DESC [ RunTime:0.042521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393764 LIMIT 2 [ RunTime:0.052561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393764 ORDER BY `minOrder` ASC [ RunTime:0.025510s ]
select * from pdf where partno='2103190' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103190' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393759 LIMIT 4 [ RunTime:0.031041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393759 ORDER BY `minOrder` ASC [ RunTime:0.050676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393759 ORDER BY `unit` DESC [ RunTime:0.042256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393759 LIMIT 2 [ RunTime:0.045626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393759 ORDER BY `minOrder` ASC [ RunTime:0.021085s ]
select * from pdf where partno='2108571' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108571' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32389420 LIMIT 4 [ RunTime:0.022764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32389420 ORDER BY `minOrder` ASC [ RunTime:0.079431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32389420 ORDER BY `unit` DESC [ RunTime:0.036720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32389420 LIMIT 2 [ RunTime:0.019090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32389420 ORDER BY `minOrder` ASC [ RunTime:0.012832s ]
select * from pdf where partno='2101876' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.076903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101876' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32384737 LIMIT 4 [ RunTime:0.048043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32384737 ORDER BY `minOrder` ASC [ RunTime:0.041345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32384737 ORDER BY `unit` DESC [ RunTime:0.035736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32384737 LIMIT 2 [ RunTime:0.047617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32384737 ORDER BY `minOrder` ASC [ RunTime:0.018432s ]
select * from pdf where partno='2101143-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.057643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101143-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.031376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32381641 LIMIT 4 [ RunTime:0.011133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381641 ORDER BY `minOrder` ASC [ RunTime:0.049478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32381641 ORDER BY `unit` DESC [ RunTime:0.042326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32381641 LIMIT 2 [ RunTime:0.027044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381641 ORDER BY `minOrder` ASC [ RunTime:0.038608s ]
select * from pdf where partno='21028' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.018955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21028' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.063335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32381511 LIMIT 4 [ RunTime:0.064360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381511 ORDER BY `minOrder` ASC [ RunTime:0.050230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32381511 ORDER BY `unit` DESC [ RunTime:0.058287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32381511 LIMIT 2 [ RunTime:0.041759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381511 ORDER BY `minOrder` ASC [ RunTime:0.023907s ]
select * from pdf where partno='2101830' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.083008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101830' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32375945 LIMIT 4 [ RunTime:0.036590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32375945 ORDER BY `minOrder` ASC [ RunTime:0.022700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32375945 ORDER BY `unit` DESC [ RunTime:0.112936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32375945 LIMIT 2 [ RunTime:0.061177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32375945 ORDER BY `minOrder` ASC [ RunTime:0.002432s ]
select * from pdf where partno='21021' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.024551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.018517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32374201 LIMIT 4 [ RunTime:0.014902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32374201 ORDER BY `minOrder` ASC [ RunTime:0.020809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32374201 ORDER BY `unit` DESC [ RunTime:0.026590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32374201 LIMIT 2 [ RunTime:0.024434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32374201 ORDER BY `minOrder` ASC [ RunTime:0.009933s ]
select * from pdf where partno='21023' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.060166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.041329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32373797 LIMIT 4 [ RunTime:0.030286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32373797 ORDER BY `minOrder` ASC [ RunTime:0.017414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32373797 ORDER BY `unit` DESC [ RunTime:0.033045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32373797 LIMIT 2 [ RunTime:0.037053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32373797 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='21072' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.018093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21072' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.039283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32372598 LIMIT 4 [ RunTime:0.039192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32372598 ORDER BY `minOrder` ASC [ RunTime:0.096010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32372598 ORDER BY `unit` DESC [ RunTime:0.025693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32372598 LIMIT 2 [ RunTime:0.044175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32372598 ORDER BY `minOrder` ASC [ RunTime:0.006198s ]
select * from pdf where partno='21039' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.021020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21039' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.031220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32371071 LIMIT 4 [ RunTime:0.077325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32371071 ORDER BY `minOrder` ASC [ RunTime:0.043839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32371071 ORDER BY `unit` DESC [ RunTime:0.008373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32371071 LIMIT 2 [ RunTime:0.005686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32371071 ORDER BY `minOrder` ASC [ RunTime:0.029395s ]
select * from pdf where partno='21037' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.043325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21037' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.035781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32370857 LIMIT 4 [ RunTime:0.061593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32370857 ORDER BY `minOrder` ASC [ RunTime:0.040794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32370857 ORDER BY `unit` DESC [ RunTime:0.030474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32370857 LIMIT 2 [ RunTime:0.066996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32370857 ORDER BY `minOrder` ASC [ RunTime:0.081126s ]
select * from pdf where partno='2104098' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104098' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.045339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32369933 LIMIT 4 [ RunTime:0.045236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32369933 ORDER BY `minOrder` ASC [ RunTime:0.024326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32369933 ORDER BY `unit` DESC [ RunTime:0.031929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32369933 LIMIT 2 [ RunTime:0.062498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32369933 ORDER BY `minOrder` ASC [ RunTime:0.016333s ]
select * from pdf where partno='21029' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.063422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21029' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.055368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32364935 LIMIT 4 [ RunTime:0.075770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32364935 ORDER BY `minOrder` ASC [ RunTime:0.029998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32364935 ORDER BY `unit` DESC [ RunTime:0.047462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32364935 LIMIT 2 [ RunTime:0.040677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32364935 ORDER BY `minOrder` ASC [ RunTime:0.020923s ]
select * from pdf where partno='21054' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.037898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21054' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.006033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32363855 LIMIT 4 [ RunTime:0.007140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363855 ORDER BY `minOrder` ASC [ RunTime:0.026814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32363855 ORDER BY `unit` DESC [ RunTime:0.003065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32363855 LIMIT 2 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363855 ORDER BY `minOrder` ASC [ RunTime:0.004601s ]
select * from pdf where partno='2102668-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102668-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32360405 LIMIT 4 [ RunTime:0.008819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32360405 ORDER BY `minOrder` ASC [ RunTime:0.005085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32360405 ORDER BY `unit` DESC [ RunTime:0.000781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32360405 LIMIT 2 [ RunTime:0.007404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32360405 ORDER BY `minOrder` ASC [ RunTime:0.006864s ]
select * from pdf where partno='210-0309' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.003841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-0309' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.014050s ]
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.009266s ]