SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002173s ]
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://www.ic118.com/stock&keyword=228&page=63&srecordnum=10000' [ RunTime:0.001804s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001056s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000774s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001470s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.014025s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001493s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001958s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001850s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.006530s ]
UPDATE `stock_search` SET `count` = 1186 , `updatetime` = '2026-06-12 02:53:42' WHERE `partno` = '228' [ RunTime:0.013317s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003808s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006115s ]
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.000864s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002359s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.221373s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1240,20 [ RunTime:0.109821s ]
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 ('32925682','32925681','32925680','32925679','32925678','32925677','32925676','32925675','32925674','32925673','32925672','32925671','32925670','32925669','32925668','32925667','32925666','32925665','32925664','32925663') ORDER BY FIELD(s.id, 32925682,32925681,32925680,32925679,32925678,32925677,32925676,32925675,32925674,32925673,32925672,32925671,32925670,32925669,32925668,32925667,32925666,32925665,32925664,32925663) [ RunTime:0.010647s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925682 LIMIT 4 [ RunTime:0.031995s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.030311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925682 ORDER BY `minOrder` ASC [ RunTime:0.044369s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925682 ORDER BY `unit` DESC [ RunTime:0.019732s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925682 LIMIT 2 [ RunTime:0.009092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925682 ORDER BY `minOrder` ASC [ RunTime:0.017713s ]
select * from pdf where partno='228ADS1AYFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016594s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039597s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925682 AND `partno` = '228ADS1AYFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366503 [ RunTime:0.016523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925681 LIMIT 4 [ RunTime:0.043692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925681 ORDER BY `minOrder` ASC [ RunTime:0.046201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925681 ORDER BY `unit` DESC [ RunTime:0.016488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925681 LIMIT 2 [ RunTime:0.030835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925681 ORDER BY `minOrder` ASC [ RunTime:0.023080s ]
select * from pdf where partno='228ADS1AAFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024132s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925681 AND `partno` = '228ADS1AAFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.050088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366502 [ RunTime:0.073261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925680 LIMIT 4 [ RunTime:0.011379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925680 ORDER BY `minOrder` ASC [ RunTime:0.045032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925680 ORDER BY `unit` DESC [ RunTime:0.045793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925680 LIMIT 2 [ RunTime:0.009045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925680 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
select * from pdf where partno='228ADS1AYGFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020126s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925680 AND `partno` = '228ADS1AYGFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366501 [ RunTime:0.013543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925679 LIMIT 4 [ RunTime:0.007350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925679 ORDER BY `minOrder` ASC [ RunTime:0.010795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925679 ORDER BY `unit` DESC [ RunTime:0.005979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925679 LIMIT 2 [ RunTime:0.016013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925679 ORDER BY `minOrder` ASC [ RunTime:0.008994s ]
select * from pdf where partno='228ADS1AAFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005267s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925679 AND `partno` = '228ADS1AAFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366500 [ RunTime:0.020906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925678 LIMIT 4 [ RunTime:0.034202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925678 ORDER BY `minOrder` ASC [ RunTime:0.012748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925678 ORDER BY `unit` DESC [ RunTime:0.055595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925678 LIMIT 2 [ RunTime:0.018922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925678 ORDER BY `minOrder` ASC [ RunTime:0.004540s ]
select * from pdf where partno='228ADS1AYGFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.039470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021107s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925678 AND `partno` = '228ADS1AYGFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925677 LIMIT 4 [ RunTime:0.028624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925677 ORDER BY `minOrder` ASC [ RunTime:0.037094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925677 ORDER BY `unit` DESC [ RunTime:0.006292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925677 LIMIT 2 [ RunTime:0.005400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925677 ORDER BY `minOrder` ASC [ RunTime:0.003579s ]
select * from pdf where partno='228ADS1AAWFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005310s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925677 AND `partno` = '228ADS1AAWFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925676 LIMIT 4 [ RunTime:0.014753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925676 ORDER BY `minOrder` ASC [ RunTime:0.010809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925676 ORDER BY `unit` DESC [ RunTime:0.016565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925676 LIMIT 2 [ RunTime:0.012450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925676 ORDER BY `minOrder` ASC [ RunTime:0.008696s ]
select * from pdf where partno='228ADS1AAFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028072s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925676 AND `partno` = '228ADS1AAFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925675 LIMIT 4 [ RunTime:0.047539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925675 ORDER BY `minOrder` ASC [ RunTime:0.032820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925675 ORDER BY `unit` DESC [ RunTime:0.017419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925675 LIMIT 2 [ RunTime:0.036405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925675 ORDER BY `minOrder` ASC [ RunTime:0.017247s ]
select * from pdf where partno='228ADS1ARFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.046238s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925675 AND `partno` = '228ADS1ARFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925674 LIMIT 4 [ RunTime:0.015371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925674 ORDER BY `minOrder` ASC [ RunTime:0.036578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925674 ORDER BY `unit` DESC [ RunTime:0.019334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925674 LIMIT 2 [ RunTime:0.029721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925674 ORDER BY `minOrder` ASC [ RunTime:0.009787s ]
select * from pdf where partno='228ADS1ABFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034806s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925674 AND `partno` = '228ADS1ABFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366499 [ RunTime:0.044104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925673 LIMIT 4 [ RunTime:0.005244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925673 ORDER BY `minOrder` ASC [ RunTime:0.013022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925673 ORDER BY `unit` DESC [ RunTime:0.009015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925673 LIMIT 2 [ RunTime:0.027803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925673 ORDER BY `minOrder` ASC [ RunTime:0.013967s ]
select * from pdf where partno='228ADS1AYGFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023409s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925673 AND `partno` = '228ADS1AYGFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925672 LIMIT 4 [ RunTime:0.012241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925672 ORDER BY `minOrder` ASC [ RunTime:0.010341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925672 ORDER BY `unit` DESC [ RunTime:0.025259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925672 LIMIT 2 [ RunTime:0.013389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925672 ORDER BY `minOrder` ASC [ RunTime:0.002588s ]
select * from pdf where partno='228ADS1AYGFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023408s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925672 AND `partno` = '228ADS1AYGFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925671 LIMIT 4 [ RunTime:0.013318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925671 ORDER BY `minOrder` ASC [ RunTime:0.018507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925671 ORDER BY `unit` DESC [ RunTime:0.015868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925671 LIMIT 2 [ RunTime:0.039247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925671 ORDER BY `minOrder` ASC [ RunTime:0.016275s ]
select * from pdf where partno='228ADS1ARGFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.044970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024303s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925671 AND `partno` = '228ADS1ARGFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366498 [ RunTime:0.039994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925670 LIMIT 4 [ RunTime:0.053872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925670 ORDER BY `minOrder` ASC [ RunTime:0.063022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925670 ORDER BY `unit` DESC [ RunTime:0.019459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925670 LIMIT 2 [ RunTime:0.029284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925670 ORDER BY `minOrder` ASC [ RunTime:0.011213s ]
select * from pdf where partno='228ADS1AYGFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026743s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925670 AND `partno` = '228ADS1AYGFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449812 [ RunTime:0.029292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925669 LIMIT 4 [ RunTime:0.019991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925669 ORDER BY `minOrder` ASC [ RunTime:0.043617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925669 ORDER BY `unit` DESC [ RunTime:0.022645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925669 LIMIT 2 [ RunTime:0.006853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925669 ORDER BY `minOrder` ASC [ RunTime:0.020491s ]
select * from pdf where partno='228ADS1AGFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009608s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925669 AND `partno` = '228ADS1AGFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366497 [ RunTime:0.010670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925668 LIMIT 4 [ RunTime:0.004596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925668 ORDER BY `minOrder` ASC [ RunTime:0.008420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925668 ORDER BY `unit` DESC [ RunTime:0.003057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925668 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925668 ORDER BY `minOrder` ASC [ RunTime:0.005552s ]
select * from pdf where partno='228ADS1ARAFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001699s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925668 AND `partno` = '228ADS1ARAFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366496 [ RunTime:0.006743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925667 LIMIT 4 [ RunTime:0.003109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925667 ORDER BY `minOrder` ASC [ RunTime:0.012601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925667 ORDER BY `unit` DESC [ RunTime:0.005349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925667 LIMIT 2 [ RunTime:0.006252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925667 ORDER BY `minOrder` ASC [ RunTime:0.002993s ]
select * from pdf where partno='228ADS1ARAFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009067s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925667 AND `partno` = '228ADS1ARAFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366495 [ RunTime:0.018091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925666 LIMIT 4 [ RunTime:0.014326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925666 ORDER BY `minOrder` ASC [ RunTime:0.014204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925666 ORDER BY `unit` DESC [ RunTime:0.013602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925666 LIMIT 2 [ RunTime:0.022940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925666 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
select * from pdf where partno='228ADS1ARGFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.030515s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925666 AND `partno` = '228ADS1ARGFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449811 [ RunTime:0.003873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925665 LIMIT 4 [ RunTime:0.002799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925665 ORDER BY `minOrder` ASC [ RunTime:0.013796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925665 ORDER BY `unit` DESC [ RunTime:0.019675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925665 LIMIT 2 [ RunTime:0.010885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925665 ORDER BY `minOrder` ASC [ RunTime:0.001373s ]
select * from pdf where partno='228ADS1AYGFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019648s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925665 AND `partno` = '228ADS1AYGFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366494 [ RunTime:0.006981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925664 LIMIT 4 [ RunTime:0.007558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925664 ORDER BY `minOrder` ASC [ RunTime:0.015790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925664 ORDER BY `unit` DESC [ RunTime:0.007264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925664 LIMIT 2 [ RunTime:0.009333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925664 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
select * from pdf where partno='228ADS1ARFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006469s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925664 AND `partno` = '228ADS1ARFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366493 [ RunTime:0.010767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925663 LIMIT 4 [ RunTime:0.014787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925663 ORDER BY `minOrder` ASC [ RunTime:0.040722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925663 ORDER BY `unit` DESC [ RunTime:0.010091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925663 LIMIT 2 [ RunTime:0.020814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925663 ORDER BY `minOrder` ASC [ RunTime:0.015355s ]
select * from pdf where partno='228ADS1AYGFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009687s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925663 AND `partno` = '228ADS1AYGFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449810 [ RunTime:0.025982s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.004455s ]