SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001505s ]
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=81&srecordnum=10000' [ RunTime:0.001664s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001242s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001256s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001315s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001230s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002658s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004606s ]
UPDATE `stock_search` SET `count` = 1967 , `updatetime` = '2026-06-12 11:27:52' WHERE `partno` = '228' [ RunTime:0.001856s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000268s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000235s ]
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.005076s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001491s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.255503s ]
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 1600,20 [ RunTime:0.073601s ]
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 ('32925215','32925214','32925213','32925212','32925211','32925210','32925209','32925208','32925207','32925206','32925205','32925204','32925203','32925202','32925201','32925200','32925199','32925198','32925197','32925196') ORDER BY FIELD(s.id, 32925215,32925214,32925213,32925212,32925211,32925210,32925209,32925208,32925207,32925206,32925205,32925204,32925203,32925202,32925201,32925200,32925199,32925198,32925197,32925196) [ RunTime:0.014209s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925215 LIMIT 4 [ RunTime:0.001960s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925215 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925215 ORDER BY `unit` DESC [ RunTime:0.009604s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925215 LIMIT 2 [ RunTime:0.006854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925215 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
select * from pdf where partno='228CDVAYFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023661s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.047978s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925215 AND `partno` = '228CDVAYFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449635 [ RunTime:0.021662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925214 LIMIT 4 [ RunTime:0.005894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925214 ORDER BY `minOrder` ASC [ RunTime:0.014684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925214 ORDER BY `unit` DESC [ RunTime:0.011238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925214 LIMIT 2 [ RunTime:0.012908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925214 ORDER BY `minOrder` ASC [ RunTime:0.001845s ]
select * from pdf where partno='228CDVARGFEMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFEMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004562s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925214 AND `partno` = '228CDVARGFEMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366386 [ RunTime:0.007658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925213 LIMIT 4 [ RunTime:0.003505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925213 ORDER BY `minOrder` ASC [ RunTime:0.005383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925213 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925213 LIMIT 2 [ RunTime:0.001415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925213 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
select * from pdf where partno='228CDVAAFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001452s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925213 AND `partno` = '228CDVAAFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449634 [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925212 LIMIT 4 [ RunTime:0.006781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925212 ORDER BY `minOrder` ASC [ RunTime:0.005289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925212 ORDER BY `unit` DESC [ RunTime:0.006824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925212 LIMIT 2 [ RunTime:0.003425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925212 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='228CDVARFAWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001781s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925212 AND `partno` = '228CDVARFAWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366385 [ RunTime:0.000483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925211 LIMIT 4 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925211 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925211 ORDER BY `unit` DESC [ RunTime:0.003842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925211 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925211 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
select * from pdf where partno='228CDVAYGFEAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYGFEAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001895s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925211 AND `partno` = '228CDVAYGFEAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366384 [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925210 LIMIT 4 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925210 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925210 ORDER BY `unit` DESC [ RunTime:0.004142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925210 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925210 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='228CDVARAFFBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001549s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925210 AND `partno` = '228CDVARAFFBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366383 [ RunTime:0.002077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925209 LIMIT 4 [ RunTime:0.003270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925209 ORDER BY `minOrder` ASC [ RunTime:0.003082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925209 ORDER BY `unit` DESC [ RunTime:0.003142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925209 LIMIT 2 [ RunTime:0.003402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925209 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='228CDVAAWFEAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFEAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000577s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925209 AND `partno` = '228CDVAAWFEAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925208 LIMIT 4 [ RunTime:0.012344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925208 ORDER BY `minOrder` ASC [ RunTime:0.006150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925208 ORDER BY `unit` DESC [ RunTime:0.002441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925208 LIMIT 2 [ RunTime:0.006816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925208 ORDER BY `minOrder` ASC [ RunTime:0.003296s ]
select * from pdf where partno='228CDVARFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005859s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925208 AND `partno` = '228CDVARFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925207 LIMIT 4 [ RunTime:0.006593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925207 ORDER BY `minOrder` ASC [ RunTime:0.004869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925207 ORDER BY `unit` DESC [ RunTime:0.005183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925207 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925207 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
select * from pdf where partno='228CDVAWFAWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001411s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925207 AND `partno` = '228CDVAWFAWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925206 LIMIT 4 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925206 ORDER BY `minOrder` ASC [ RunTime:0.007616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925206 ORDER BY `unit` DESC [ RunTime:0.006505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925206 LIMIT 2 [ RunTime:0.005057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925206 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='228CDVAGFFMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFFMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007002s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925206 AND `partno` = '228CDVAGFFMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925205 LIMIT 4 [ RunTime:0.002849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925205 ORDER BY `minOrder` ASC [ RunTime:0.008210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925205 ORDER BY `unit` DESC [ RunTime:0.002312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925205 LIMIT 2 [ RunTime:0.005489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925205 ORDER BY `minOrder` ASC [ RunTime:0.001026s ]
select * from pdf where partno='228CDVAGFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011169s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925205 AND `partno` = '228CDVAGFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366382 [ RunTime:0.006217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925204 LIMIT 4 [ RunTime:0.001361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925204 ORDER BY `minOrder` ASC [ RunTime:0.002750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925204 ORDER BY `unit` DESC [ RunTime:0.009075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925204 LIMIT 2 [ RunTime:0.001859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925204 ORDER BY `minOrder` ASC [ RunTime:0.003764s ]
select * from pdf where partno='228CDVABFABBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFABBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011388s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925204 AND `partno` = '228CDVABFABBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449633 [ RunTime:0.006730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925203 LIMIT 4 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925203 ORDER BY `minOrder` ASC [ RunTime:0.010815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925203 ORDER BY `unit` DESC [ RunTime:0.001098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925203 LIMIT 2 [ RunTime:0.005145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925203 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
select * from pdf where partno='228CDVAGFBAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFBAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008105s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925203 AND `partno` = '228CDVAGFBAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366381 [ RunTime:0.006377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925202 LIMIT 4 [ RunTime:0.004602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925202 ORDER BY `minOrder` ASC [ RunTime:0.003438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925202 ORDER BY `unit` DESC [ RunTime:0.006885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925202 LIMIT 2 [ RunTime:0.005658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925202 ORDER BY `minOrder` ASC [ RunTime:0.001486s ]
select * from pdf where partno='228CDVARGBFEMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFEMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001483s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925202 AND `partno` = '228CDVARGBFEMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449632 [ RunTime:0.015063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925201 LIMIT 4 [ RunTime:0.003648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925201 ORDER BY `minOrder` ASC [ RunTime:0.004045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925201 ORDER BY `unit` DESC [ RunTime:0.004151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925201 LIMIT 2 [ RunTime:0.008744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925201 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='228CDVARGFFBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007099s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925201 AND `partno` = '228CDVARGFFBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449631 [ RunTime:0.004274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925200 LIMIT 4 [ RunTime:0.004196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925200 ORDER BY `minOrder` ASC [ RunTime:0.010873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925200 ORDER BY `unit` DESC [ RunTime:0.013966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925200 LIMIT 2 [ RunTime:0.002080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925200 ORDER BY `minOrder` ASC [ RunTime:0.005290s ]
select * from pdf where partno='228CDVAAFDBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008469s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925200 AND `partno` = '228CDVAAFDBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449630 [ RunTime:0.009868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925199 LIMIT 4 [ RunTime:0.014528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925199 ORDER BY `minOrder` ASC [ RunTime:0.001938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925199 ORDER BY `unit` DESC [ RunTime:0.006155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925199 LIMIT 2 [ RunTime:0.011213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925199 ORDER BY `minOrder` ASC [ RunTime:0.002601s ]
select * from pdf where partno='228CDVAAFABBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFABBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036854s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925199 AND `partno` = '228CDVAAFABBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366380 [ RunTime:0.009809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925198 LIMIT 4 [ RunTime:0.017143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925198 ORDER BY `minOrder` ASC [ RunTime:0.017340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925198 ORDER BY `unit` DESC [ RunTime:0.034647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925198 LIMIT 2 [ RunTime:0.049798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925198 ORDER BY `minOrder` ASC [ RunTime:0.025258s ]
select * from pdf where partno='228CDVAAFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024170s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925198 AND `partno` = '228CDVAAFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.043959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366379 [ RunTime:0.057934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925197 LIMIT 4 [ RunTime:0.027680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925197 ORDER BY `minOrder` ASC [ RunTime:0.013430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925197 ORDER BY `unit` DESC [ RunTime:0.029310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925197 LIMIT 2 [ RunTime:0.025547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925197 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
select * from pdf where partno='228CDVARGFDWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.044562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFDWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017692s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925197 AND `partno` = '228CDVARGFDWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366378 [ RunTime:0.011856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925196 LIMIT 4 [ RunTime:0.007043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925196 ORDER BY `minOrder` ASC [ RunTime:0.068207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925196 ORDER BY `unit` DESC [ RunTime:0.030883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925196 LIMIT 2 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925196 ORDER BY `minOrder` ASC [ RunTime:0.012736s ]
select * from pdf where partno='228CDVAWFAWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.031213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024408s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925196 AND `partno` = '228CDVAWFAWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366377 [ RunTime:0.002983s ]
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.128769s ]