SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001764s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=SM15&page=10&srecordnum=548' [ RunTime:0.006065s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002321s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003444s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001344s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001580s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006999s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001188s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SM15' LIMIT 1 [ RunTime:0.011575s ]
UPDATE `stock_search` SET `count` = 3213 , `updatetime` = '2026-06-10 17:54:22' WHERE `partno` = 'SM15' [ RunTime:0.012109s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.010781s ]
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.004388s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002725s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'SM15%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.027088s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'SM15%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 180,20 [ RunTime:0.032400s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('39025950','39025949','39025948','39025947','39025946','39025945','39025944','39025943','39025942','39025941','39025940','38755451','38755450','38755341','38754716','38754715','37503382','36877383','32702495','32702473') ORDER BY FIELD(s.id, 39025950,39025949,39025948,39025947,39025946,39025945,39025944,39025943,39025942,39025941,39025940,38755451,38755450,38755341,38754716,38754715,37503382,36877383,32702495,32702473) [ RunTime:0.030706s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.019281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025950 LIMIT 4 [ RunTime:0.015200s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025950 ORDER BY `minOrder` ASC [ RunTime:0.006931s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025950 ORDER BY `unit` DESC [ RunTime:0.007292s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025950 LIMIT 2 [ RunTime:0.033178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025950 ORDER BY `minOrder` ASC [ RunTime:0.023419s ]
select * from pdf where partno='SM15-95R05B1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.009434s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-95R05B1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.006167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025949 LIMIT 4 [ RunTime:0.036448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025949 ORDER BY `minOrder` ASC [ RunTime:0.066991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025949 ORDER BY `unit` DESC [ RunTime:0.032008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025949 LIMIT 2 [ RunTime:0.011920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025949 ORDER BY `minOrder` ASC [ RunTime:0.001161s ]
select * from pdf where partno='SM15-4K297D1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.009543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-4K297D1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.038923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025948 LIMIT 4 [ RunTime:0.076255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025948 ORDER BY `minOrder` ASC [ RunTime:0.033819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025948 ORDER BY `unit` DESC [ RunTime:0.044153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025948 LIMIT 2 [ RunTime:0.007873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025948 ORDER BY `minOrder` ASC [ RunTime:0.014608s ]
select * from pdf where partno='SM15-38RB1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.006122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-38RB1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.012696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025947 LIMIT 4 [ RunTime:0.009696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025947 ORDER BY `minOrder` ASC [ RunTime:0.095234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025947 ORDER BY `unit` DESC [ RunTime:0.056278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025947 LIMIT 2 [ RunTime:0.023157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025947 ORDER BY `minOrder` ASC [ RunTime:0.029466s ]
select * from pdf where partno='SM15-2K5B8' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.061737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-2K5B8' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.046958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025946 LIMIT 4 [ RunTime:0.042379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025946 ORDER BY `minOrder` ASC [ RunTime:0.056433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025946 ORDER BY `unit` DESC [ RunTime:0.064759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025946 LIMIT 2 [ RunTime:0.062396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025946 ORDER BY `minOrder` ASC [ RunTime:0.024414s ]
select * from pdf where partno='SM15-50KD1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.061325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-50KD1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.030594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025945 LIMIT 4 [ RunTime:0.013923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025945 ORDER BY `minOrder` ASC [ RunTime:0.026035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025945 ORDER BY `unit` DESC [ RunTime:0.030321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025945 LIMIT 2 [ RunTime:0.017812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025945 ORDER BY `minOrder` ASC [ RunTime:0.014940s ]
select * from pdf where partno='SM15-5KB8' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.016083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-5KB8' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.057517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025944 LIMIT 4 [ RunTime:0.023260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025944 ORDER BY `minOrder` ASC [ RunTime:0.021179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025944 ORDER BY `unit` DESC [ RunTime:0.019492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025944 LIMIT 2 [ RunTime:0.034206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025944 ORDER BY `minOrder` ASC [ RunTime:0.039072s ]
select * from pdf where partno='SM15-200KD1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.021999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-200KD1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.032227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025943 LIMIT 4 [ RunTime:0.041888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025943 ORDER BY `minOrder` ASC [ RunTime:0.055194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025943 ORDER BY `unit` DESC [ RunTime:0.041162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025943 LIMIT 2 [ RunTime:0.021522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025943 ORDER BY `minOrder` ASC [ RunTime:0.033846s ]
select * from pdf where partno='SM15-50KX8' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.019714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-50KX8' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.008767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025942 LIMIT 4 [ RunTime:0.024902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025942 ORDER BY `minOrder` ASC [ RunTime:0.029169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025942 ORDER BY `unit` DESC [ RunTime:0.021918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025942 LIMIT 2 [ RunTime:0.008797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025942 ORDER BY `minOrder` ASC [ RunTime:0.015399s ]
select * from pdf where partno='SM15-250RB8' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.009402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-250RB8' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.030060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025941 LIMIT 4 [ RunTime:0.034903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025941 ORDER BY `minOrder` ASC [ RunTime:0.031835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025941 ORDER BY `unit` DESC [ RunTime:0.019932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025941 LIMIT 2 [ RunTime:0.014783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025941 ORDER BY `minOrder` ASC [ RunTime:0.015503s ]
select * from pdf where partno='SM15-1K3B1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.032460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-1K3B1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.009901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39025940 LIMIT 4 [ RunTime:0.017086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025940 ORDER BY `minOrder` ASC [ RunTime:0.054346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39025940 ORDER BY `unit` DESC [ RunTime:0.059662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39025940 LIMIT 2 [ RunTime:0.025033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39025940 ORDER BY `minOrder` ASC [ RunTime:0.020983s ]
select * from pdf where partno='SM15-100RD1' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.022497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-100RD1' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.030962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38755451 LIMIT 4 [ RunTime:0.025871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38755451 ORDER BY `minOrder` ASC [ RunTime:0.051414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38755451 ORDER BY `unit` DESC [ RunTime:0.021482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38755451 LIMIT 2 [ RunTime:0.046188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38755451 ORDER BY `minOrder` ASC [ RunTime:0.012968s ]
select * from pdf where partno='SM15-2K5X' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.006399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-2K5X' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.014549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38755450 LIMIT 4 [ RunTime:0.023046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38755450 ORDER BY `minOrder` ASC [ RunTime:0.011074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38755450 ORDER BY `unit` DESC [ RunTime:0.041060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38755450 LIMIT 2 [ RunTime:0.032033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38755450 ORDER BY `minOrder` ASC [ RunTime:0.030637s ]
select * from pdf where partno='SM15-100KX' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.016545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-100KX' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.009360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38755341 LIMIT 4 [ RunTime:0.019623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38755341 ORDER BY `minOrder` ASC [ RunTime:0.006955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38755341 ORDER BY `unit` DESC [ RunTime:0.014979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38755341 LIMIT 2 [ RunTime:0.051188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38755341 ORDER BY `minOrder` ASC [ RunTime:0.013042s ]
select * from pdf where partno='SM15-25KX' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.014211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-25KX' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.042739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38754716 LIMIT 4 [ RunTime:0.028447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38754716 ORDER BY `minOrder` ASC [ RunTime:0.065383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38754716 ORDER BY `unit` DESC [ RunTime:0.046609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38754716 LIMIT 2 [ RunTime:0.030662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38754716 ORDER BY `minOrder` ASC [ RunTime:0.028723s ]
select * from pdf where partno='SM15-500RX' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.040853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-500RX' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.032785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38754715 LIMIT 4 [ RunTime:0.046828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38754715 ORDER BY `minOrder` ASC [ RunTime:0.014758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38754715 ORDER BY `unit` DESC [ RunTime:0.022310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38754715 LIMIT 2 [ RunTime:0.008890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38754715 ORDER BY `minOrder` ASC [ RunTime:0.016964s ]
select * from pdf where partno='SM15-10KX' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.002806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-10KX' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.021185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37503382 LIMIT 4 [ RunTime:0.009118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37503382 ORDER BY `minOrder` ASC [ RunTime:0.009206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37503382 ORDER BY `unit` DESC [ RunTime:0.005600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37503382 LIMIT 2 [ RunTime:0.011822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37503382 ORDER BY `minOrder` ASC [ RunTime:0.003295s ]
select * from pdf where partno='SM1500RMXL2UTAA' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.002619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM1500RMXL2UTAA' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.007465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36877383 LIMIT 4 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36877383 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36877383 ORDER BY `unit` DESC [ RunTime:0.003163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36877383 LIMIT 2 [ RunTime:0.006078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36877383 ORDER BY `minOrder` ASC [ RunTime:0.003212s ]
select * from pdf where partno='SM15' and brandshort='Tempo Communications' limit 1 [ RunTime:0.012394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15' OR `brand` LIKE 'Tempo Communications%' ) ) LIMIT 1 [ RunTime:0.022960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32702495 LIMIT 4 [ RunTime:0.008903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32702495 ORDER BY `minOrder` ASC [ RunTime:0.006195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32702495 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32702495 LIMIT 2 [ RunTime:0.010969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32702495 ORDER BY `minOrder` ASC [ RunTime:0.003526s ]
select * from pdf where partno='SM150506-2' and brandshort='DB Unlimited' limit 1 [ RunTime:0.018796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM150506-2' OR `brand` LIKE 'DB Unlimited%' ) ) LIMIT 1 [ RunTime:0.029745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32702473 LIMIT 4 [ RunTime:0.021050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32702473 ORDER BY `minOrder` ASC [ RunTime:0.025746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32702473 ORDER BY `unit` DESC [ RunTime:0.021214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32702473 LIMIT 2 [ RunTime:0.015307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32702473 ORDER BY `minOrder` ASC [ RunTime:0.011270s ]
select * from pdf where partno='SM150506-1' and brandshort='DB Unlimited' limit 1 [ RunTime:0.012674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM150506-1' OR `brand` LIKE 'DB Unlimited%' ) ) LIMIT 1 [ RunTime:0.011049s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SM15%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.006742s ]