SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002232s ]
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.016457s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002068s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001765s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003925s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.008994s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002977s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011141s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003196s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001135s ]
UPDATE `stock_search` SET `count` = 3828 , `updatetime` = '2026-06-08 15:25:14' WHERE `partno` = '210' [ RunTime:0.018210s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003538s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003317s ]
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.001375s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001932s ]
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.085970s ]
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 4420,20 [ RunTime:0.080992s ]
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 ('34324027','34323913','34323906','34323842','34323753','34323749','34323618','34323577','34323404','34323394','34323369','34323354','34323291','34323252','34323250','34323119','34323114','34323060','34323011','34323003') ORDER BY FIELD(s.id, 34324027,34323913,34323906,34323842,34323753,34323749,34323618,34323577,34323404,34323394,34323369,34323354,34323291,34323252,34323250,34323119,34323114,34323060,34323011,34323003) [ RunTime:0.045961s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34324027 LIMIT 4 [ RunTime:0.029242s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34324027 ORDER BY `minOrder` ASC [ RunTime:0.037579s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.023666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34324027 ORDER BY `unit` DESC [ RunTime:0.020251s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34324027 LIMIT 2 [ RunTime:0.051694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34324027 ORDER BY `minOrder` ASC [ RunTime:0.046317s ]
select * from pdf where partno='210-87-636-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.139795s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-636-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.103266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323913 LIMIT 4 [ RunTime:0.050965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323913 ORDER BY `minOrder` ASC [ RunTime:0.051062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323913 ORDER BY `unit` DESC [ RunTime:0.083478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323913 LIMIT 2 [ RunTime:0.108490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323913 ORDER BY `minOrder` ASC [ RunTime:0.050368s ]
select * from pdf where partno='210-83-318-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.122451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-318-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.088071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323906 LIMIT 4 [ RunTime:0.117122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323906 ORDER BY `minOrder` ASC [ RunTime:0.062890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323906 ORDER BY `unit` DESC [ RunTime:0.059116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323906 LIMIT 2 [ RunTime:0.058474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323906 ORDER BY `minOrder` ASC [ RunTime:0.034112s ]
select * from pdf where partno='210-83-320-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.075138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-320-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.052791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323842 LIMIT 4 [ RunTime:0.047594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323842 ORDER BY `minOrder` ASC [ RunTime:0.065344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323842 ORDER BY `unit` DESC [ RunTime:0.032324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323842 LIMIT 2 [ RunTime:0.055366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323842 ORDER BY `minOrder` ASC [ RunTime:0.003205s ]
select * from pdf where partno='210-87-632-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.020927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-632-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.094765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323753 LIMIT 4 [ RunTime:0.051298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323753 ORDER BY `minOrder` ASC [ RunTime:0.051365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323753 ORDER BY `unit` DESC [ RunTime:0.147881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323753 LIMIT 2 [ RunTime:0.149746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323753 ORDER BY `minOrder` ASC [ RunTime:0.178210s ]
select * from pdf where partno='210748-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.039295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210748-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323749 LIMIT 4 [ RunTime:0.084427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323749 ORDER BY `minOrder` ASC [ RunTime:0.041108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323749 ORDER BY `unit` DESC [ RunTime:0.055601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323749 LIMIT 2 [ RunTime:0.047973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323749 ORDER BY `minOrder` ASC [ RunTime:0.072510s ]
select * from pdf where partno='210-1-48-006' and brandshort='CNC Tech' limit 1 [ RunTime:0.147392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-1-48-006' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.064902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323618 LIMIT 4 [ RunTime:0.041887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323618 ORDER BY `minOrder` ASC [ RunTime:0.039903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323618 ORDER BY `unit` DESC [ RunTime:0.040232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323618 LIMIT 2 [ RunTime:0.038114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323618 ORDER BY `minOrder` ASC [ RunTime:0.025300s ]
select * from pdf where partno='210-87-628-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.023012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-628-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.043952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323577 LIMIT 4 [ RunTime:0.027291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323577 ORDER BY `minOrder` ASC [ RunTime:0.011407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323577 ORDER BY `unit` DESC [ RunTime:0.020328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323577 LIMIT 2 [ RunTime:0.027402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323577 ORDER BY `minOrder` ASC [ RunTime:0.029919s ]
select * from pdf where partno='210-83-316-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.001988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-316-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.024159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323404 LIMIT 4 [ RunTime:0.019153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323404 ORDER BY `minOrder` ASC [ RunTime:0.008374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323404 ORDER BY `unit` DESC [ RunTime:0.018124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323404 LIMIT 2 [ RunTime:0.046139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323404 ORDER BY `minOrder` ASC [ RunTime:0.009838s ]
select * from pdf where partno='210-83-314-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.011764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-314-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.042915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323394 LIMIT 4 [ RunTime:0.021287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323394 ORDER BY `minOrder` ASC [ RunTime:0.045608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323394 ORDER BY `unit` DESC [ RunTime:0.089892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323394 LIMIT 2 [ RunTime:0.017006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323394 ORDER BY `minOrder` ASC [ RunTime:0.017537s ]
select * from pdf where partno='210-87-624-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.041843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-624-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.004361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323369 LIMIT 4 [ RunTime:0.038980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323369 ORDER BY `minOrder` ASC [ RunTime:0.048773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323369 ORDER BY `unit` DESC [ RunTime:0.012137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323369 LIMIT 2 [ RunTime:0.043316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323369 ORDER BY `minOrder` ASC [ RunTime:0.009218s ]
select * from pdf where partno='210-87-424-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.004500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-424-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.024471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323354 LIMIT 4 [ RunTime:0.011364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323354 ORDER BY `minOrder` ASC [ RunTime:0.029674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323354 ORDER BY `unit` DESC [ RunTime:0.050417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323354 LIMIT 2 [ RunTime:0.022827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323354 ORDER BY `minOrder` ASC [ RunTime:0.008418s ]
select * from pdf where partno='210-87-324-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.016224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-324-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.011370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323291 LIMIT 4 [ RunTime:0.012746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323291 ORDER BY `minOrder` ASC [ RunTime:0.059601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323291 ORDER BY `unit` DESC [ RunTime:0.018002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323291 LIMIT 2 [ RunTime:0.061209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323291 ORDER BY `minOrder` ASC [ RunTime:0.030598s ]
select * from pdf where partno='210-87-422-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.060403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-422-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.016929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323252 LIMIT 4 [ RunTime:0.011185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323252 ORDER BY `minOrder` ASC [ RunTime:0.029370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323252 ORDER BY `unit` DESC [ RunTime:0.030823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323252 LIMIT 2 [ RunTime:0.028167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323252 ORDER BY `minOrder` ASC [ RunTime:0.008663s ]
select * from pdf where partno='210-87-320-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.018133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-320-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.012753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323250 LIMIT 4 [ RunTime:0.021097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323250 ORDER BY `minOrder` ASC [ RunTime:0.032232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323250 ORDER BY `unit` DESC [ RunTime:0.016730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323250 LIMIT 2 [ RunTime:0.018606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323250 ORDER BY `minOrder` ASC [ RunTime:0.019611s ]
select * from pdf where partno='210-1-32-006' and brandshort='CNC Tech' limit 1 [ RunTime:0.010699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-1-32-006' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.030783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323119 LIMIT 4 [ RunTime:0.050759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323119 ORDER BY `minOrder` ASC [ RunTime:0.002755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323119 ORDER BY `unit` DESC [ RunTime:0.016820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323119 LIMIT 2 [ RunTime:0.013083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323119 ORDER BY `minOrder` ASC [ RunTime:0.005280s ]
select * from pdf where partno='210-87-318-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.016673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-318-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.007926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323114 LIMIT 4 [ RunTime:0.009713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323114 ORDER BY `minOrder` ASC [ RunTime:0.013413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323114 ORDER BY `unit` DESC [ RunTime:0.015980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323114 LIMIT 2 [ RunTime:0.015704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323114 ORDER BY `minOrder` ASC [ RunTime:0.008012s ]
select * from pdf where partno='210-83-310-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.012347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-310-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.012285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323060 LIMIT 4 [ RunTime:0.014618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323060 ORDER BY `minOrder` ASC [ RunTime:0.033760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323060 ORDER BY `unit` DESC [ RunTime:0.012428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323060 LIMIT 2 [ RunTime:0.028286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323060 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
select * from pdf where partno='210-87-316-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.025882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-316-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.016987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323011 LIMIT 4 [ RunTime:0.025325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323011 ORDER BY `minOrder` ASC [ RunTime:0.016313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323011 ORDER BY `unit` DESC [ RunTime:0.020164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323011 LIMIT 2 [ RunTime:0.020746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323011 ORDER BY `minOrder` ASC [ RunTime:0.010846s ]
select * from pdf where partno='210-1-24-006' and brandshort='CNC Tech' limit 1 [ RunTime:0.002844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-1-24-006' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.013244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323003 LIMIT 4 [ RunTime:0.017862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323003 ORDER BY `minOrder` ASC [ RunTime:0.002236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323003 ORDER BY `unit` DESC [ RunTime:0.010106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323003 LIMIT 2 [ RunTime:0.006868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323003 ORDER BY `minOrder` ASC [ RunTime:0.001161s ]
select * from pdf where partno='210-83-308-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.003223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-308-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.012103s ]
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.004057s ]