SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004547s ]
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=76&srecordnum=10000' [ RunTime:0.003064s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002543s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001774s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000974s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000207s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001045s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000843s ]
UPDATE `stock_search` SET `count` = 1962 , `updatetime` = '2026-06-12 10:15:12' WHERE `partno` = '228' [ RunTime:0.007210s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000239s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000218s ]
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.000346s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001701s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.231570s ]
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 1500,20 [ RunTime:0.107265s ]
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 ('32925315','32925314','32925313','32925312','32925311','32925310','32925309','32925308','32925307','32925306','32925305','32925304','32925303','32925302','32925301','32925300','32925299','32925298','32925297','32925296') ORDER BY FIELD(s.id, 32925315,32925314,32925313,32925312,32925311,32925310,32925309,32925308,32925307,32925306,32925305,32925304,32925303,32925302,32925301,32925300,32925299,32925298,32925297,32925296) [ RunTime:0.017057s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925315 LIMIT 4 [ RunTime:0.003723s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925315 ORDER BY `minOrder` ASC [ RunTime:0.006642s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925315 ORDER BY `unit` DESC [ RunTime:0.018198s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925315 LIMIT 2 [ RunTime:0.002250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925315 ORDER BY `minOrder` ASC [ RunTime:0.006172s ]
select * from pdf where partno='228CDVAAWFEBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014483s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFEBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009113s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925315 AND `partno` = '228CDVAAWFEBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366416 [ RunTime:0.022312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925314 LIMIT 4 [ RunTime:0.007417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925314 ORDER BY `minOrder` ASC [ RunTime:0.033876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925314 ORDER BY `unit` DESC [ RunTime:0.005270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925314 LIMIT 2 [ RunTime:0.004121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925314 ORDER BY `minOrder` ASC [ RunTime:0.004424s ]
select * from pdf where partno='228CDVAGFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003734s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925314 AND `partno` = '228CDVAGFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366415 [ RunTime:0.001965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925313 LIMIT 4 [ RunTime:0.001347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925313 ORDER BY `minOrder` ASC [ RunTime:0.002125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925313 ORDER BY `unit` DESC [ RunTime:0.011658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925313 LIMIT 2 [ RunTime:0.010571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925313 ORDER BY `minOrder` ASC [ RunTime:0.002164s ]
select * from pdf where partno='228CDVARFAWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006842s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925313 AND `partno` = '228CDVARFAWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366414 [ RunTime:0.001883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925312 LIMIT 4 [ RunTime:0.006583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925312 ORDER BY `minOrder` ASC [ RunTime:0.008627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925312 ORDER BY `unit` DESC [ RunTime:0.017510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925312 LIMIT 2 [ RunTime:0.006486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925312 ORDER BY `minOrder` ASC [ RunTime:0.007877s ]
select * from pdf where partno='228CDVAAWFFAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFFAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009427s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925312 AND `partno` = '228CDVAAWFFAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449693 [ RunTime:0.015099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925311 LIMIT 4 [ RunTime:0.014526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925311 ORDER BY `minOrder` ASC [ RunTime:0.011077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925311 ORDER BY `unit` DESC [ RunTime:0.016558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925311 LIMIT 2 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925311 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
select * from pdf where partno='228CDVARAFERB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFERB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006292s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925311 AND `partno` = '228CDVARAFERB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449692 [ RunTime:0.009020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925310 LIMIT 4 [ RunTime:0.033748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925310 ORDER BY `minOrder` ASC [ RunTime:0.012799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925310 ORDER BY `unit` DESC [ RunTime:0.014805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925310 LIMIT 2 [ RunTime:0.023962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925310 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
select * from pdf where partno='228CDVARAFDWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFDWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010254s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925310 AND `partno` = '228CDVARAFDWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449691 [ RunTime:0.008979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925309 LIMIT 4 [ RunTime:0.017223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925309 ORDER BY `minOrder` ASC [ RunTime:0.018219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925309 ORDER BY `unit` DESC [ RunTime:0.008081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925309 LIMIT 2 [ RunTime:0.009875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925309 ORDER BY `minOrder` ASC [ RunTime:0.009645s ]
select * from pdf where partno='228CDVARGFEAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFEAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010244s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925309 AND `partno` = '228CDVARGFEAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925308 LIMIT 4 [ RunTime:0.016416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925308 ORDER BY `minOrder` ASC [ RunTime:0.010457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925308 ORDER BY `unit` DESC [ RunTime:0.008148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925308 LIMIT 2 [ RunTime:0.021235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925308 ORDER BY `minOrder` ASC [ RunTime:0.005261s ]
select * from pdf where partno='228CDVAYFFAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021546s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925308 AND `partno` = '228CDVAYFFAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925307 LIMIT 4 [ RunTime:0.009041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925307 ORDER BY `minOrder` ASC [ RunTime:0.047896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925307 ORDER BY `unit` DESC [ RunTime:0.013513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925307 LIMIT 2 [ RunTime:0.033652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925307 ORDER BY `minOrder` ASC [ RunTime:0.022250s ]
select * from pdf where partno='228CDVARAFFAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013226s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925307 AND `partno` = '228CDVARAFFAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925306 LIMIT 4 [ RunTime:0.004283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925306 ORDER BY `minOrder` ASC [ RunTime:0.011296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925306 ORDER BY `unit` DESC [ RunTime:0.005682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925306 LIMIT 2 [ RunTime:0.001799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925306 ORDER BY `minOrder` ASC [ RunTime:0.002823s ]
select * from pdf where partno='228CDVAGFAAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFAAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006460s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925306 AND `partno` = '228CDVAGFAAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925305 LIMIT 4 [ RunTime:0.003034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925305 ORDER BY `minOrder` ASC [ RunTime:0.004057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925305 ORDER BY `unit` DESC [ RunTime:0.009475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925305 LIMIT 2 [ RunTime:0.007242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925305 ORDER BY `minOrder` ASC [ RunTime:0.007011s ]
select * from pdf where partno='228CDVARGFFWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004237s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925305 AND `partno` = '228CDVARGFFWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449690 [ RunTime:0.006505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925304 LIMIT 4 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925304 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925304 ORDER BY `unit` DESC [ RunTime:0.002614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925304 LIMIT 2 [ RunTime:0.007144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925304 ORDER BY `minOrder` ASC [ RunTime:0.004666s ]
select * from pdf where partno='228CDVAYFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011244s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925304 AND `partno` = '228CDVAYFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925303 LIMIT 4 [ RunTime:0.014363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925303 ORDER BY `minOrder` ASC [ RunTime:0.010804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925303 ORDER BY `unit` DESC [ RunTime:0.009123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925303 LIMIT 2 [ RunTime:0.002079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925303 ORDER BY `minOrder` ASC [ RunTime:0.002853s ]
select * from pdf where partno='228CDVAYFDWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFDWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003051s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925303 AND `partno` = '228CDVAYFDWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366413 [ RunTime:0.005751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925302 LIMIT 4 [ RunTime:0.010568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925302 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925302 ORDER BY `unit` DESC [ RunTime:0.001507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925302 LIMIT 2 [ RunTime:0.008454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925302 ORDER BY `minOrder` ASC [ RunTime:0.004607s ]
select * from pdf where partno='228CDVAAWFEBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFEBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004311s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925302 AND `partno` = '228CDVAAWFEBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449689 [ RunTime:0.003012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925301 LIMIT 4 [ RunTime:0.012222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925301 ORDER BY `minOrder` ASC [ RunTime:0.010250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925301 ORDER BY `unit` DESC [ RunTime:0.003489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925301 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925301 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
select * from pdf where partno='228CDVAGFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003001s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925301 AND `partno` = '228CDVAGFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449688 [ RunTime:0.007359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925300 LIMIT 4 [ RunTime:0.008569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925300 ORDER BY `minOrder` ASC [ RunTime:0.008098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925300 ORDER BY `unit` DESC [ RunTime:0.005202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925300 LIMIT 2 [ RunTime:0.002081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925300 ORDER BY `minOrder` ASC [ RunTime:0.007569s ]
select * from pdf where partno='228CDVAGFAMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFAMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002779s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925300 AND `partno` = '228CDVAGFAMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449687 [ RunTime:0.006490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925299 LIMIT 4 [ RunTime:0.001770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925299 ORDER BY `minOrder` ASC [ RunTime:0.012802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925299 ORDER BY `unit` DESC [ RunTime:0.013263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925299 LIMIT 2 [ RunTime:0.005820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925299 ORDER BY `minOrder` ASC [ RunTime:0.007082s ]
select * from pdf where partno='228CDVARFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002331s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925299 AND `partno` = '228CDVARFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366412 [ RunTime:0.009964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925298 LIMIT 4 [ RunTime:0.006293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925298 ORDER BY `minOrder` ASC [ RunTime:0.007990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925298 ORDER BY `unit` DESC [ RunTime:0.011579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925298 LIMIT 2 [ RunTime:0.014026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925298 ORDER BY `minOrder` ASC [ RunTime:0.002580s ]
select * from pdf where partno='228CDVARGFFBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012789s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925298 AND `partno` = '228CDVARGFFBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366411 [ RunTime:0.009189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925297 LIMIT 4 [ RunTime:0.005481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925297 ORDER BY `minOrder` ASC [ RunTime:0.006813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925297 ORDER BY `unit` DESC [ RunTime:0.005709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925297 LIMIT 2 [ RunTime:0.007302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925297 ORDER BY `minOrder` ASC [ RunTime:0.007709s ]
select * from pdf where partno='228CDVARGFFBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005176s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925297 AND `partno` = '228CDVARGFFBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366410 [ RunTime:0.001211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925296 LIMIT 4 [ RunTime:0.020807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925296 ORDER BY `minOrder` ASC [ RunTime:0.005014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925296 ORDER BY `unit` DESC [ RunTime:0.006430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925296 LIMIT 2 [ RunTime:0.007916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925296 ORDER BY `minOrder` ASC [ RunTime:0.004887s ]
select * from pdf where partno='228CDVARGBFDMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFDMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010561s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925296 AND `partno` = '228CDVARGBFDMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366409 [ RunTime:0.007348s ]
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.104087s ]