SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001599s ]
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=71&srecordnum=10000' [ RunTime:0.006993s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002494s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001585s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003413s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001039s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001985s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010218s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002180s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004706s ]
UPDATE `stock_search` SET `count` = 1954 , `updatetime` = '2026-06-12 09:04:58' WHERE `partno` = '228' [ RunTime:0.008289s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003574s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000392s ]
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.006946s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002212s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.209849s ]
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 1400,20 [ RunTime:0.103766s ]
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 ('32925522','32925521','32925520','32925519','32925518','32925517','32925516','32925515','32925514','32925513','32925512','32925511','32925510','32925509','32925508','32925507','32925503','32925498','32925497','32925496') ORDER BY FIELD(s.id, 32925522,32925521,32925520,32925519,32925518,32925517,32925516,32925515,32925514,32925513,32925512,32925511,32925510,32925509,32925508,32925507,32925503,32925498,32925497,32925496) [ RunTime:0.010609s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925522 LIMIT 4 [ RunTime:0.029447s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925522 ORDER BY `minOrder` ASC [ RunTime:0.033126s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925522 ORDER BY `unit` DESC [ RunTime:0.038915s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925522 LIMIT 2 [ RunTime:0.020060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925522 ORDER BY `minOrder` ASC [ RunTime:0.013707s ]
select * from pdf where partno='228ADS1AAWFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007609s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039701s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925522 AND `partno` = '228ADS1AAWFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449742 [ RunTime:0.021765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925521 LIMIT 4 [ RunTime:0.037414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925521 ORDER BY `minOrder` ASC [ RunTime:0.050127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925521 ORDER BY `unit` DESC [ RunTime:0.023690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925521 LIMIT 2 [ RunTime:0.037021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925521 ORDER BY `minOrder` ASC [ RunTime:0.002904s ]
select * from pdf where partno='228ADS1AYFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.030893s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925521 AND `partno` = '228ADS1AYFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449741 [ RunTime:0.033488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925520 LIMIT 4 [ RunTime:0.012832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925520 ORDER BY `minOrder` ASC [ RunTime:0.059966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925520 ORDER BY `unit` DESC [ RunTime:0.019777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925520 LIMIT 2 [ RunTime:0.039163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925520 ORDER BY `minOrder` ASC [ RunTime:0.012523s ]
select * from pdf where partno='228ADS1ARFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016230s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925520 AND `partno` = '228ADS1ARFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366455 [ RunTime:0.005776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925519 LIMIT 4 [ RunTime:0.008226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925519 ORDER BY `minOrder` ASC [ RunTime:0.013813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925519 ORDER BY `unit` DESC [ RunTime:0.019278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925519 LIMIT 2 [ RunTime:0.068576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925519 ORDER BY `minOrder` ASC [ RunTime:0.031987s ]
select * from pdf where partno='228ADS1ARGFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025857s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925519 AND `partno` = '228ADS1ARGFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366454 [ RunTime:0.014725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925518 LIMIT 4 [ RunTime:0.007979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925518 ORDER BY `minOrder` ASC [ RunTime:0.048878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925518 ORDER BY `unit` DESC [ RunTime:0.014990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925518 LIMIT 2 [ RunTime:0.011245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925518 ORDER BY `minOrder` ASC [ RunTime:0.001659s ]
select * from pdf where partno='228ADS1AGFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009337s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925518 AND `partno` = '228ADS1AGFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366453 [ RunTime:0.015311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925517 LIMIT 4 [ RunTime:0.039468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925517 ORDER BY `minOrder` ASC [ RunTime:0.007783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925517 ORDER BY `unit` DESC [ RunTime:0.021338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925517 LIMIT 2 [ RunTime:0.052276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925517 ORDER BY `minOrder` ASC [ RunTime:0.012879s ]
select * from pdf where partno='228ADS1ARBFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.036158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004133s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925517 AND `partno` = '228ADS1ARBFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.070542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449740 [ RunTime:0.049149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925516 LIMIT 4 [ RunTime:0.016261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925516 ORDER BY `minOrder` ASC [ RunTime:0.032634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925516 ORDER BY `unit` DESC [ RunTime:0.024146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925516 LIMIT 2 [ RunTime:0.023659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925516 ORDER BY `minOrder` ASC [ RunTime:0.005863s ]
select * from pdf where partno='228ADS1AAFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020790s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925516 AND `partno` = '228ADS1AAFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.037623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449739 [ RunTime:0.047160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925515 LIMIT 4 [ RunTime:0.008837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925515 ORDER BY `minOrder` ASC [ RunTime:0.032953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925515 ORDER BY `unit` DESC [ RunTime:0.010421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925515 LIMIT 2 [ RunTime:0.043580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925515 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
select * from pdf where partno='228ADS1AGFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018941s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925515 AND `partno` = '228ADS1AGFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366452 [ RunTime:0.016895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925514 LIMIT 4 [ RunTime:0.018183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925514 ORDER BY `minOrder` ASC [ RunTime:0.047809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925514 ORDER BY `unit` DESC [ RunTime:0.001745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925514 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925514 ORDER BY `minOrder` ASC [ RunTime:0.001772s ]
select * from pdf where partno='228ADS1AYFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025467s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925514 AND `partno` = '228ADS1AYFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366451 [ RunTime:0.017135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925513 LIMIT 4 [ RunTime:0.024450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925513 ORDER BY `minOrder` ASC [ RunTime:0.048657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925513 ORDER BY `unit` DESC [ RunTime:0.016445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925513 LIMIT 2 [ RunTime:0.011146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925513 ORDER BY `minOrder` ASC [ RunTime:0.007891s ]
select * from pdf where partno='228ADS1ARFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024192s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925513 AND `partno` = '228ADS1ARFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925512 LIMIT 4 [ RunTime:0.007945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925512 ORDER BY `minOrder` ASC [ RunTime:0.022781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925512 ORDER BY `unit` DESC [ RunTime:0.025924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925512 LIMIT 2 [ RunTime:0.033701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925512 ORDER BY `minOrder` ASC [ RunTime:0.013924s ]
select * from pdf where partno='228ADS1AYFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003368s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925512 AND `partno` = '228ADS1AYFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925511 LIMIT 4 [ RunTime:0.008530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925511 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925511 ORDER BY `unit` DESC [ RunTime:0.026348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925511 LIMIT 2 [ RunTime:0.014977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925511 ORDER BY `minOrder` ASC [ RunTime:0.008804s ]
select * from pdf where partno='228ADS1AYGFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015015s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925511 AND `partno` = '228ADS1AYGFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366450 [ RunTime:0.012274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925510 LIMIT 4 [ RunTime:0.019529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925510 ORDER BY `minOrder` ASC [ RunTime:0.013265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925510 ORDER BY `unit` DESC [ RunTime:0.017303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925510 LIMIT 2 [ RunTime:0.007775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925510 ORDER BY `minOrder` ASC [ RunTime:0.006305s ]
select * from pdf where partno='228ADS1AAFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003791s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925510 AND `partno` = '228ADS1AAFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449738 [ RunTime:0.042966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925509 LIMIT 4 [ RunTime:0.025831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925509 ORDER BY `minOrder` ASC [ RunTime:0.030104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925509 ORDER BY `unit` DESC [ RunTime:0.028694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925509 LIMIT 2 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925509 ORDER BY `minOrder` ASC [ RunTime:0.025482s ]
select * from pdf where partno='228ADS1AAFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025566s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925509 AND `partno` = '228ADS1AAFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449737 [ RunTime:0.021853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925508 LIMIT 4 [ RunTime:0.018674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925508 ORDER BY `minOrder` ASC [ RunTime:0.050986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925508 ORDER BY `unit` DESC [ RunTime:0.051192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925508 LIMIT 2 [ RunTime:0.016604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925508 ORDER BY `minOrder` ASC [ RunTime:0.034741s ]
select * from pdf where partno='228ADS1AGFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.032560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011449s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925508 AND `partno` = '228ADS1AGFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449736 [ RunTime:0.023001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925507 LIMIT 4 [ RunTime:0.052415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925507 ORDER BY `minOrder` ASC [ RunTime:0.051400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925507 ORDER BY `unit` DESC [ RunTime:0.051007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925507 LIMIT 2 [ RunTime:0.050829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925507 ORDER BY `minOrder` ASC [ RunTime:0.051073s ]
select * from pdf where partno='228ADS1AGFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.055666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.073090s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925507 AND `partno` = '228ADS1AGFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.086882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449735 [ RunTime:0.051089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925503 LIMIT 4 [ RunTime:0.076606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925503 ORDER BY `minOrder` ASC [ RunTime:0.029649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925503 ORDER BY `unit` DESC [ RunTime:0.048771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925503 LIMIT 2 [ RunTime:0.149684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925503 ORDER BY `minOrder` ASC [ RunTime:0.034783s ]
select * from pdf where partno='228BMVARFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.108988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228BMVARFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.037118s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925503 AND `partno` = '228BMVARFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.087536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925498 LIMIT 4 [ RunTime:0.026891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925498 ORDER BY `minOrder` ASC [ RunTime:0.051030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925498 ORDER BY `unit` DESC [ RunTime:0.023509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925498 LIMIT 2 [ RunTime:0.067046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925498 ORDER BY `minOrder` ASC [ RunTime:0.035645s ]
select * from pdf where partno='228CDVARAFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015181s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925498 AND `partno` = '228CDVARAFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449728 [ RunTime:0.013085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925497 LIMIT 4 [ RunTime:0.035968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925497 ORDER BY `minOrder` ASC [ RunTime:0.008024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925497 ORDER BY `unit` DESC [ RunTime:0.013895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925497 LIMIT 2 [ RunTime:0.018823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925497 ORDER BY `minOrder` ASC [ RunTime:0.007221s ]
select * from pdf where partno='228CDVARAFDWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFDWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007512s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925497 AND `partno` = '228CDVARAFDWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449727 [ RunTime:0.001357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925496 LIMIT 4 [ RunTime:0.001650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925496 ORDER BY `minOrder` ASC [ RunTime:0.007079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925496 ORDER BY `unit` DESC [ RunTime:0.003178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925496 LIMIT 2 [ RunTime:0.003361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925496 ORDER BY `minOrder` ASC [ RunTime:0.002234s ]
select * from pdf where partno='228CDVARAFERA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFERA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003813s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925496 AND `partno` = '228CDVARAFERA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449726 [ RunTime:0.003933s ]
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.127404s ]