SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001191s ]
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=53&srecordnum=10000' [ RunTime:0.007611s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001279s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000528s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001611s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.002021s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001524s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002108s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000409s ]
UPDATE `stock_search` SET `count` = 1152 , `updatetime` = '2026-06-11 20:59:01' WHERE `partno` = '228' [ RunTime:0.004803s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000379s ]
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.001500s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001705s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.223545s ]
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 1040,20 [ RunTime:0.105956s ]
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 ('32925974','32925973','32925972','32925971','32925970','32925936','32925935','32925934','32925933','32925932','32925931','32925930','32925929','32925928','32925927','32925926','32925925','32925924','32925923','32925922') ORDER BY FIELD(s.id, 32925974,32925973,32925972,32925971,32925970,32925936,32925935,32925934,32925933,32925932,32925931,32925930,32925929,32925928,32925927,32925926,32925925,32925924,32925923,32925922) [ RunTime:0.003811s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925974 LIMIT 4 [ RunTime:0.004269s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925974 ORDER BY `minOrder` ASC [ RunTime:0.010576s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925974 ORDER BY `unit` DESC [ RunTime:0.011509s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925974 LIMIT 2 [ RunTime:0.010453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925974 ORDER BY `minOrder` ASC [ RunTime:0.002123s ]
select * from pdf where partno='228FMVAABR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009932s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVAABR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012077s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925974 AND `partno` = '228FMVAABR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449887 [ RunTime:0.011077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925973 LIMIT 4 [ RunTime:0.007142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925973 ORDER BY `minOrder` ASC [ RunTime:0.013587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925973 ORDER BY `unit` DESC [ RunTime:0.016681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925973 LIMIT 2 [ RunTime:0.014728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925973 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='228FMVAYBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVAYBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012792s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925973 AND `partno` = '228FMVAYBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366557 [ RunTime:0.018504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925972 LIMIT 4 [ RunTime:0.023663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925972 ORDER BY `minOrder` ASC [ RunTime:0.014906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925972 ORDER BY `unit` DESC [ RunTime:0.019949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925972 LIMIT 2 [ RunTime:0.020024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925972 ORDER BY `minOrder` ASC [ RunTime:0.003674s ]
select * from pdf where partno='228FMVARBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVARBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011146s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925972 AND `partno` = '228FMVARBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925971 LIMIT 4 [ RunTime:0.012901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925971 ORDER BY `minOrder` ASC [ RunTime:0.003644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925971 ORDER BY `unit` DESC [ RunTime:0.016450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925971 LIMIT 2 [ RunTime:0.025900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925971 ORDER BY `minOrder` ASC [ RunTime:0.015692s ]
select * from pdf where partno='228FMVALBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVALBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005199s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925971 AND `partno` = '228FMVALBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449886 [ RunTime:0.009881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925970 LIMIT 4 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925970 ORDER BY `minOrder` ASC [ RunTime:0.009128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925970 ORDER BY `unit` DESC [ RunTime:0.036877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925970 LIMIT 2 [ RunTime:0.027946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925970 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
select * from pdf where partno='228FMVAWBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVAWBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023310s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925970 AND `partno` = '228FMVAWBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925936 LIMIT 4 [ RunTime:0.064518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925936 ORDER BY `minOrder` ASC [ RunTime:0.038667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925936 ORDER BY `unit` DESC [ RunTime:0.022432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925936 LIMIT 2 [ RunTime:0.015171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925936 ORDER BY `minOrder` ASC [ RunTime:0.015460s ]
select * from pdf where partno='228ADS1AWFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014600s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925936 AND `partno` = '228ADS1AWFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925935 LIMIT 4 [ RunTime:0.036490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925935 ORDER BY `minOrder` ASC [ RunTime:0.049080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925935 ORDER BY `unit` DESC [ RunTime:0.021722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925935 LIMIT 2 [ RunTime:0.008441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925935 ORDER BY `minOrder` ASC [ RunTime:0.021894s ]
select * from pdf where partno='228ADS1AWFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026376s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925935 AND `partno` = '228ADS1AWFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449884 [ RunTime:0.073255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925934 LIMIT 4 [ RunTime:0.021957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925934 ORDER BY `minOrder` ASC [ RunTime:0.077875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925934 ORDER BY `unit` DESC [ RunTime:0.083981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925934 LIMIT 2 [ RunTime:0.024283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925934 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
select * from pdf where partno='228ADS1AAWFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017313s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925934 AND `partno` = '228ADS1AAWFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449883 [ RunTime:0.040870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925933 LIMIT 4 [ RunTime:0.054087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925933 ORDER BY `minOrder` ASC [ RunTime:0.077214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925933 ORDER BY `unit` DESC [ RunTime:0.011211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925933 LIMIT 2 [ RunTime:0.081166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925933 ORDER BY `minOrder` ASC [ RunTime:0.054731s ]
select * from pdf where partno='228ADS1AWFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.040667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.037033s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925933 AND `partno` = '228ADS1AWFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.064286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366556 [ RunTime:0.061389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925932 LIMIT 4 [ RunTime:0.043720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925932 ORDER BY `minOrder` ASC [ RunTime:0.029200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925932 ORDER BY `unit` DESC [ RunTime:0.093366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925932 LIMIT 2 [ RunTime:0.066081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925932 ORDER BY `minOrder` ASC [ RunTime:0.019047s ]
select * from pdf where partno='228ADS1AAWFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014630s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925932 AND `partno` = '228ADS1AAWFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366555 [ RunTime:0.092639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925931 LIMIT 4 [ RunTime:0.025769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925931 ORDER BY `minOrder` ASC [ RunTime:0.049285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925931 ORDER BY `unit` DESC [ RunTime:0.048874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925931 LIMIT 2 [ RunTime:0.030545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925931 ORDER BY `minOrder` ASC [ RunTime:0.007447s ]
select * from pdf where partno='228ADS1AGFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023363s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925931 AND `partno` = '228ADS1AGFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366554 [ RunTime:0.042423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925930 LIMIT 4 [ RunTime:0.049170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925930 ORDER BY `minOrder` ASC [ RunTime:0.135842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925930 ORDER BY `unit` DESC [ RunTime:0.042850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925930 LIMIT 2 [ RunTime:0.036678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925930 ORDER BY `minOrder` ASC [ RunTime:0.018979s ]
select * from pdf where partno='228ADS1AWFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041249s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925930 AND `partno` = '228ADS1AWFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366553 [ RunTime:0.019107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925929 LIMIT 4 [ RunTime:0.015520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925929 ORDER BY `minOrder` ASC [ RunTime:0.019862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925929 ORDER BY `unit` DESC [ RunTime:0.018219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925929 LIMIT 2 [ RunTime:0.035904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925929 ORDER BY `minOrder` ASC [ RunTime:0.007367s ]
select * from pdf where partno='228ADS1ARFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.087978s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925929 AND `partno` = '228ADS1ARFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366552 [ RunTime:0.022464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925928 LIMIT 4 [ RunTime:0.033791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925928 ORDER BY `minOrder` ASC [ RunTime:0.024670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925928 ORDER BY `unit` DESC [ RunTime:0.068491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925928 LIMIT 2 [ RunTime:0.045415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925928 ORDER BY `minOrder` ASC [ RunTime:0.028492s ]
select * from pdf where partno='228ADS1AGFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004944s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925928 AND `partno` = '228ADS1AGFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366551 [ RunTime:0.020631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925927 LIMIT 4 [ RunTime:0.007497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925927 ORDER BY `minOrder` ASC [ RunTime:0.009903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925927 ORDER BY `unit` DESC [ RunTime:0.046077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925927 LIMIT 2 [ RunTime:0.005547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925927 ORDER BY `minOrder` ASC [ RunTime:0.031146s ]
select * from pdf where partno='228ADS1ABFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021328s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925927 AND `partno` = '228ADS1ABFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449882 [ RunTime:0.010787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925926 LIMIT 4 [ RunTime:0.017648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925926 ORDER BY `minOrder` ASC [ RunTime:0.032282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925926 ORDER BY `unit` DESC [ RunTime:0.032382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925926 LIMIT 2 [ RunTime:0.041953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925926 ORDER BY `minOrder` ASC [ RunTime:0.034557s ]
select * from pdf where partno='228ADS1AWFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016285s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925926 AND `partno` = '228ADS1AWFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366550 [ RunTime:0.013381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925925 LIMIT 4 [ RunTime:0.023988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925925 ORDER BY `minOrder` ASC [ RunTime:0.042355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925925 ORDER BY `unit` DESC [ RunTime:0.041540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925925 LIMIT 2 [ RunTime:0.100084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925925 ORDER BY `minOrder` ASC [ RunTime:0.019876s ]
select * from pdf where partno='228ADS1ARGFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027298s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925925 AND `partno` = '228ADS1ARGFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366549 [ RunTime:0.017644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925924 LIMIT 4 [ RunTime:0.017622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925924 ORDER BY `minOrder` ASC [ RunTime:0.022466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925924 ORDER BY `unit` DESC [ RunTime:0.009721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925924 LIMIT 2 [ RunTime:0.044952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925924 ORDER BY `minOrder` ASC [ RunTime:0.001089s ]
select * from pdf where partno='228ADS1ARGFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.056841s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925924 AND `partno` = '228ADS1ARGFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366548 [ RunTime:0.026007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925923 LIMIT 4 [ RunTime:0.078024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925923 ORDER BY `minOrder` ASC [ RunTime:0.016947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925923 ORDER BY `unit` DESC [ RunTime:0.029592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925923 LIMIT 2 [ RunTime:0.031990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925923 ORDER BY `minOrder` ASC [ RunTime:0.047796s ]
select * from pdf where partno='228ADS1ABFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011108s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925923 AND `partno` = '228ADS1ABFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.051146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366547 [ RunTime:0.034882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925922 LIMIT 4 [ RunTime:0.032434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925922 ORDER BY `minOrder` ASC [ RunTime:0.016683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925922 ORDER BY `unit` DESC [ RunTime:0.032875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925922 LIMIT 2 [ RunTime:0.020460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925922 ORDER BY `minOrder` ASC [ RunTime:0.004313s ]
select * from pdf where partno='228ADS1ABFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022194s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925922 AND `partno` = '228ADS1ABFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012149s ]
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.082190s ]