SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002031s ]
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=64&srecordnum=10000' [ RunTime:0.004221s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001630s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009799s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002386s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001869s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001893s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002986s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000679s ]
UPDATE `stock_search` SET `count` = 1187 , `updatetime` = '2026-06-12 02:53:42' WHERE `partno` = '228' [ RunTime:0.005965s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000296s ]
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.000445s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002290s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.206401s ]
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 1260,20 [ RunTime:0.108045s ]
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 ('32925662','32925661','32925660','32925659','32925658','32925657','32925656','32925655','32925654','32925653','32925652','32925651','32925650','32925649','32925648','32925647','32925646','32925645','32925644','32925643') ORDER BY FIELD(s.id, 32925662,32925661,32925660,32925659,32925658,32925657,32925656,32925655,32925654,32925653,32925652,32925651,32925650,32925649,32925648,32925647,32925646,32925645,32925644,32925643) [ RunTime:0.008576s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925662 LIMIT 4 [ RunTime:0.046024s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925662 ORDER BY `minOrder` ASC [ RunTime:0.039509s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925662 ORDER BY `unit` DESC [ RunTime:0.028901s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925662 LIMIT 2 [ RunTime:0.031024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925662 ORDER BY `minOrder` ASC [ RunTime:0.007801s ]
select * from pdf where partno='228ADS1ARBFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013065s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029723s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925662 AND `partno` = '228ADS1ARBFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366492 [ RunTime:0.028765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925661 LIMIT 4 [ RunTime:0.020188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925661 ORDER BY `minOrder` ASC [ RunTime:0.059480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925661 ORDER BY `unit` DESC [ RunTime:0.024725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925661 LIMIT 2 [ RunTime:0.027000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925661 ORDER BY `minOrder` ASC [ RunTime:0.008958s ]
select * from pdf where partno='228ADS1ARAFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023224s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925661 AND `partno` = '228ADS1ARAFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366491 [ RunTime:0.071382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925660 LIMIT 4 [ RunTime:0.050527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925660 ORDER BY `minOrder` ASC [ RunTime:0.023525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925660 ORDER BY `unit` DESC [ RunTime:0.057773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925660 LIMIT 2 [ RunTime:0.012592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925660 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='228ADS1AAWFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017872s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925660 AND `partno` = '228ADS1AAWFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449809 [ RunTime:0.008813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925659 LIMIT 4 [ RunTime:0.019325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925659 ORDER BY `minOrder` ASC [ RunTime:0.024677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925659 ORDER BY `unit` DESC [ RunTime:0.005723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925659 LIMIT 2 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925659 ORDER BY `minOrder` ASC [ RunTime:0.014631s ]
select * from pdf where partno='228ADS1AAWFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014170s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925659 AND `partno` = '228ADS1AAWFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449808 [ RunTime:0.008796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925658 LIMIT 4 [ RunTime:0.010364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925658 ORDER BY `minOrder` ASC [ RunTime:0.011633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925658 ORDER BY `unit` DESC [ RunTime:0.033479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925658 LIMIT 2 [ RunTime:0.023320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925658 ORDER BY `minOrder` ASC [ RunTime:0.016221s ]
select * from pdf where partno='228ADS1AYGFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011182s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925658 AND `partno` = '228ADS1AYGFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449807 [ RunTime:0.034161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925657 LIMIT 4 [ RunTime:0.022769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925657 ORDER BY `minOrder` ASC [ RunTime:0.034014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925657 ORDER BY `unit` DESC [ RunTime:0.036342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925657 LIMIT 2 [ RunTime:0.028884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925657 ORDER BY `minOrder` ASC [ RunTime:0.004174s ]
select * from pdf where partno='228ADS1AYFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008211s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925657 AND `partno` = '228ADS1AYFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449806 [ RunTime:0.010440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925656 LIMIT 4 [ RunTime:0.011421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925656 ORDER BY `minOrder` ASC [ RunTime:0.019276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925656 ORDER BY `unit` DESC [ RunTime:0.009771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925656 LIMIT 2 [ RunTime:0.019681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925656 ORDER BY `minOrder` ASC [ RunTime:0.008763s ]
select * from pdf where partno='228ADS1AAWFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035887s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925656 AND `partno` = '228ADS1AAWFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.075398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925655 LIMIT 4 [ RunTime:0.034331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925655 ORDER BY `minOrder` ASC [ RunTime:0.008101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925655 ORDER BY `unit` DESC [ RunTime:0.032200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925655 LIMIT 2 [ RunTime:0.017879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925655 ORDER BY `minOrder` ASC [ RunTime:0.005706s ]
select * from pdf where partno='228ADS1AYFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019945s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925655 AND `partno` = '228ADS1AYFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925654 LIMIT 4 [ RunTime:0.010012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925654 ORDER BY `minOrder` ASC [ RunTime:0.010381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925654 ORDER BY `unit` DESC [ RunTime:0.034423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925654 LIMIT 2 [ RunTime:0.019757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925654 ORDER BY `minOrder` ASC [ RunTime:0.022595s ]
select * from pdf where partno='228ADS1ARAFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001957s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925654 AND `partno` = '228ADS1ARAFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449805 [ RunTime:0.029711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925653 LIMIT 4 [ RunTime:0.031871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925653 ORDER BY `minOrder` ASC [ RunTime:0.023833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925653 ORDER BY `unit` DESC [ RunTime:0.022156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925653 LIMIT 2 [ RunTime:0.023135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925653 ORDER BY `minOrder` ASC [ RunTime:0.019391s ]
select * from pdf where partno='228ADS1AAFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015467s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925653 AND `partno` = '228ADS1AAFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449804 [ RunTime:0.016625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925652 LIMIT 4 [ RunTime:0.008944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925652 ORDER BY `minOrder` ASC [ RunTime:0.005499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925652 ORDER BY `unit` DESC [ RunTime:0.025775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925652 LIMIT 2 [ RunTime:0.016700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925652 ORDER BY `minOrder` ASC [ RunTime:0.006651s ]
select * from pdf where partno='228ADS1ARFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019405s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925652 AND `partno` = '228ADS1ARFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449803 [ RunTime:0.004824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925651 LIMIT 4 [ RunTime:0.022843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925651 ORDER BY `minOrder` ASC [ RunTime:0.004409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925651 ORDER BY `unit` DESC [ RunTime:0.012055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925651 LIMIT 2 [ RunTime:0.018447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925651 ORDER BY `minOrder` ASC [ RunTime:0.012784s ]
select * from pdf where partno='228ADS1AAFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022496s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925651 AND `partno` = '228ADS1AAFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449802 [ RunTime:0.010732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925650 LIMIT 4 [ RunTime:0.031507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925650 ORDER BY `minOrder` ASC [ RunTime:0.011755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925650 ORDER BY `unit` DESC [ RunTime:0.037938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925650 LIMIT 2 [ RunTime:0.091294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925650 ORDER BY `minOrder` ASC [ RunTime:0.019666s ]
select * from pdf where partno='228ADS1AAFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006857s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925650 AND `partno` = '228ADS1AAFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449801 [ RunTime:0.008113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925649 LIMIT 4 [ RunTime:0.029067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925649 ORDER BY `minOrder` ASC [ RunTime:0.029725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925649 ORDER BY `unit` DESC [ RunTime:0.050311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925649 LIMIT 2 [ RunTime:0.014273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925649 ORDER BY `minOrder` ASC [ RunTime:0.012500s ]
select * from pdf where partno='228ADS1AYFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031834s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925649 AND `partno` = '228ADS1AYFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366490 [ RunTime:0.025000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925648 LIMIT 4 [ RunTime:0.012830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925648 ORDER BY `minOrder` ASC [ RunTime:0.022377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925648 ORDER BY `unit` DESC [ RunTime:0.007924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925648 LIMIT 2 [ RunTime:0.011047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925648 ORDER BY `minOrder` ASC [ RunTime:0.007004s ]
select * from pdf where partno='228ADS1AAWFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022942s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925648 AND `partno` = '228ADS1AAWFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366489 [ RunTime:0.006517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925647 LIMIT 4 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925647 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925647 ORDER BY `unit` DESC [ RunTime:0.014023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925647 LIMIT 2 [ RunTime:0.012465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925647 ORDER BY `minOrder` ASC [ RunTime:0.005235s ]
select * from pdf where partno='228ADS1AAWFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007510s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925647 AND `partno` = '228ADS1AAWFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449800 [ RunTime:0.016367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925646 LIMIT 4 [ RunTime:0.022621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925646 ORDER BY `minOrder` ASC [ RunTime:0.003860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925646 ORDER BY `unit` DESC [ RunTime:0.021738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925646 LIMIT 2 [ RunTime:0.017537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925646 ORDER BY `minOrder` ASC [ RunTime:0.013838s ]
select * from pdf where partno='228ADS1AAWFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012436s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925646 AND `partno` = '228ADS1AAWFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449799 [ RunTime:0.012069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925645 LIMIT 4 [ RunTime:0.002111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925645 ORDER BY `minOrder` ASC [ RunTime:0.012383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925645 ORDER BY `unit` DESC [ RunTime:0.020631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925645 LIMIT 2 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925645 ORDER BY `minOrder` ASC [ RunTime:0.006272s ]
select * from pdf where partno='228ADS1AAFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013727s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925645 AND `partno` = '228ADS1AAFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925644 LIMIT 4 [ RunTime:0.005737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925644 ORDER BY `minOrder` ASC [ RunTime:0.006937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925644 ORDER BY `unit` DESC [ RunTime:0.024809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925644 LIMIT 2 [ RunTime:0.002622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925644 ORDER BY `minOrder` ASC [ RunTime:0.005320s ]
select * from pdf where partno='228ADS1AYFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001501s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925644 AND `partno` = '228ADS1AYFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925643 LIMIT 4 [ RunTime:0.007289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925643 ORDER BY `minOrder` ASC [ RunTime:0.016226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925643 ORDER BY `unit` DESC [ RunTime:0.012837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925643 LIMIT 2 [ RunTime:0.032041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925643 ORDER BY `minOrder` ASC [ RunTime:0.029152s ]
select * from pdf where partno='228ADS1ABFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033842s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925643 AND `partno` = '228ADS1ABFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008834s ]
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.007580s ]