SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001099s ]
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=52&srecordnum=10000' [ RunTime:0.003939s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002233s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003105s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.003099s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002709s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002609s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.003850s ]
UPDATE `stock_search` SET `count` = 1153 , `updatetime` = '2026-06-11 20:59:01' WHERE `partno` = '228' [ RunTime:0.010775s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.010160s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.011570s ]
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.010042s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002512s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.173275s ]
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 1020,20 [ RunTime:0.105896s ]
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 ('32926159','32926158','32926157','32926156','32926155','32926150','32926149','32926148','32926147','32926146','32926145','32926144','32926143','32926142','32926097','32926096','32926095','32926094','32926093','32926092') ORDER BY FIELD(s.id, 32926159,32926158,32926157,32926156,32926155,32926150,32926149,32926148,32926147,32926146,32926145,32926144,32926143,32926142,32926097,32926096,32926095,32926094,32926093,32926092) [ RunTime:0.012479s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926159 LIMIT 4 [ RunTime:0.007558s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926159 ORDER BY `minOrder` ASC [ RunTime:0.021005s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926159 ORDER BY `unit` DESC [ RunTime:0.006022s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926159 LIMIT 2 [ RunTime:0.005912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926159 ORDER BY `minOrder` ASC [ RunTime:0.016319s ]
select * from pdf where partno='228CMVARGBFCNR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009786s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCNR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002388s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926159 AND `partno` = '228CMVARGBFCNR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449931 [ RunTime:0.017827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926158 LIMIT 4 [ RunTime:0.014060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926158 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926158 ORDER BY `unit` DESC [ RunTime:0.003429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926158 LIMIT 2 [ RunTime:0.011515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926158 ORDER BY `minOrder` ASC [ RunTime:0.010208s ]
select * from pdf where partno='228CMVARGBFANR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFANR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015315s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926158 AND `partno` = '228CMVARGBFANR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926157 LIMIT 4 [ RunTime:0.026852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926157 ORDER BY `minOrder` ASC [ RunTime:0.022490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926157 ORDER BY `unit` DESC [ RunTime:0.018382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926157 LIMIT 2 [ RunTime:0.007081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926157 ORDER BY `minOrder` ASC [ RunTime:0.004590s ]
select * from pdf where partno='228CMVARGBFBNR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFBNR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007500s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926157 AND `partno` = '228CMVARGBFBNR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926156 LIMIT 4 [ RunTime:0.009542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926156 ORDER BY `minOrder` ASC [ RunTime:0.012154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926156 ORDER BY `unit` DESC [ RunTime:0.016462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926156 LIMIT 2 [ RunTime:0.037883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926156 ORDER BY `minOrder` ASC [ RunTime:0.006166s ]
select * from pdf where partno='228CMVARGBFENR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFENR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015034s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926156 AND `partno` = '228CMVARGBFENR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449930 [ RunTime:0.004612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926155 LIMIT 4 [ RunTime:0.025158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926155 ORDER BY `minOrder` ASC [ RunTime:0.042642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926155 ORDER BY `unit` DESC [ RunTime:0.032328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926155 LIMIT 2 [ RunTime:0.045323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926155 ORDER BY `minOrder` ASC [ RunTime:0.040071s ]
select * from pdf where partno='228CMVARGBFFNR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFNR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.038424s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926155 AND `partno` = '228CMVARGBFFNR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449929 [ RunTime:0.029350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926150 LIMIT 4 [ RunTime:0.034896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926150 ORDER BY `minOrder` ASC [ RunTime:0.027983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926150 ORDER BY `unit` DESC [ RunTime:0.025162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926150 LIMIT 2 [ RunTime:0.034338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926150 ORDER BY `minOrder` ASC [ RunTime:0.045842s ]
select * from pdf where partno='228HMVAABFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVAABFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029536s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926150 AND `partno` = '228HMVAABFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449914 [ RunTime:0.036854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926149 LIMIT 4 [ RunTime:0.078003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926149 ORDER BY `minOrder` ASC [ RunTime:0.034199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926149 ORDER BY `unit` DESC [ RunTime:0.043017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926149 LIMIT 2 [ RunTime:0.104341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926149 ORDER BY `minOrder` ASC [ RunTime:0.013558s ]
select * from pdf where partno='228HMVALWFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVALWFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023032s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926149 AND `partno` = '228HMVALWFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.052483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449913 [ RunTime:0.011749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926148 LIMIT 4 [ RunTime:0.035060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926148 ORDER BY `minOrder` ASC [ RunTime:0.041865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926148 ORDER BY `unit` DESC [ RunTime:0.031850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926148 LIMIT 2 [ RunTime:0.086162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926148 ORDER BY `minOrder` ASC [ RunTime:0.032622s ]
select * from pdf where partno='228HMVAWFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.042689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVAWFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027985s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926148 AND `partno` = '228HMVAWFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449912 [ RunTime:0.027786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926147 LIMIT 4 [ RunTime:0.011586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926147 ORDER BY `minOrder` ASC [ RunTime:0.025431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926147 ORDER BY `unit` DESC [ RunTime:0.049389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926147 LIMIT 2 [ RunTime:0.026991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926147 ORDER BY `minOrder` ASC [ RunTime:0.020099s ]
select * from pdf where partno='228HMVARLFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.032654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVARLFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034657s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926147 AND `partno` = '228HMVARLFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926146 LIMIT 4 [ RunTime:0.055891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926146 ORDER BY `minOrder` ASC [ RunTime:0.042130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926146 ORDER BY `unit` DESC [ RunTime:0.045777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926146 LIMIT 2 [ RunTime:0.021474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926146 ORDER BY `minOrder` ASC [ RunTime:0.029838s ]
select * from pdf where partno='228HMVALBFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVALBFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.061896s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926146 AND `partno` = '228HMVALBFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926145 LIMIT 4 [ RunTime:0.014252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926145 ORDER BY `minOrder` ASC [ RunTime:0.042661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926145 ORDER BY `unit` DESC [ RunTime:0.040106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926145 LIMIT 2 [ RunTime:0.034983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926145 ORDER BY `minOrder` ASC [ RunTime:0.007891s ]
select * from pdf where partno='228HMVABFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVABFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028489s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926145 AND `partno` = '228HMVABFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449911 [ RunTime:0.042497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926144 LIMIT 4 [ RunTime:0.042892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926144 ORDER BY `minOrder` ASC [ RunTime:0.078544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926144 ORDER BY `unit` DESC [ RunTime:0.027108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926144 LIMIT 2 [ RunTime:0.021687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926144 ORDER BY `minOrder` ASC [ RunTime:0.011947s ]
select * from pdf where partno='228HMVARGFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.039972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVARGFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006245s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926144 AND `partno` = '228HMVARGFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.049465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449910 [ RunTime:0.017203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926143 LIMIT 4 [ RunTime:0.017660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926143 ORDER BY `minOrder` ASC [ RunTime:0.020917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926143 ORDER BY `unit` DESC [ RunTime:0.024355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926143 LIMIT 2 [ RunTime:0.016635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926143 ORDER BY `minOrder` ASC [ RunTime:0.016572s ]
select * from pdf where partno='228HMVAAWFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVAAWFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017991s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926143 AND `partno` = '228HMVAAWFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.045822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449909 [ RunTime:0.011725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926142 LIMIT 4 [ RunTime:0.027049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926142 ORDER BY `minOrder` ASC [ RunTime:0.092849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926142 ORDER BY `unit` DESC [ RunTime:0.027275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926142 LIMIT 2 [ RunTime:0.004409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926142 ORDER BY `minOrder` ASC [ RunTime:0.065387s ]
select * from pdf where partno='228HMVAAFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.045359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228HMVAAFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017342s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926142 AND `partno` = '228HMVAAFR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366577 [ RunTime:0.054224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926097 LIMIT 4 [ RunTime:0.030709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926097 ORDER BY `minOrder` ASC [ RunTime:0.027535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926097 ORDER BY `unit` DESC [ RunTime:0.018331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926097 LIMIT 2 [ RunTime:0.021088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926097 ORDER BY `minOrder` ASC [ RunTime:0.025743s ]
select * from pdf where partno='228FMVALYBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.058973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVALYBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025476s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926097 AND `partno` = '228FMVALYBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449893 [ RunTime:0.024925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926096 LIMIT 4 [ RunTime:0.011940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926096 ORDER BY `minOrder` ASC [ RunTime:0.017478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926096 ORDER BY `unit` DESC [ RunTime:0.049337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926096 LIMIT 2 [ RunTime:0.013470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926096 ORDER BY `minOrder` ASC [ RunTime:0.008304s ]
select * from pdf where partno='228FMVARLBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.035918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVARLBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.042716s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926096 AND `partno` = '228FMVARLBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449892 [ RunTime:0.046876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926095 LIMIT 4 [ RunTime:0.018901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926095 ORDER BY `minOrder` ASC [ RunTime:0.046731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926095 ORDER BY `unit` DESC [ RunTime:0.100623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926095 LIMIT 2 [ RunTime:0.020541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926095 ORDER BY `minOrder` ASC [ RunTime:0.019483s ]
select * from pdf where partno='228FMVARBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVARBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013162s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926095 AND `partno` = '228FMVARBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.034669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366565 [ RunTime:0.049931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926094 LIMIT 4 [ RunTime:0.037885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926094 ORDER BY `minOrder` ASC [ RunTime:0.028101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926094 ORDER BY `unit` DESC [ RunTime:0.059491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926094 LIMIT 2 [ RunTime:0.025236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926094 ORDER BY `minOrder` ASC [ RunTime:0.043871s ]
select * from pdf where partno='228FMVALABR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.032182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVALABR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011914s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926094 AND `partno` = '228FMVALABR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366564 [ RunTime:0.041240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926093 LIMIT 4 [ RunTime:0.016350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926093 ORDER BY `minOrder` ASC [ RunTime:0.028491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926093 ORDER BY `unit` DESC [ RunTime:0.048212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926093 LIMIT 2 [ RunTime:0.023698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926093 ORDER BY `minOrder` ASC [ RunTime:0.025099s ]
select * from pdf where partno='228FMVABABR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVABABR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035002s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926093 AND `partno` = '228FMVABABR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366563 [ RunTime:0.038604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926092 LIMIT 4 [ RunTime:0.014583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926092 ORDER BY `minOrder` ASC [ RunTime:0.013112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926092 ORDER BY `unit` DESC [ RunTime:0.033317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926092 LIMIT 2 [ RunTime:0.019564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926092 ORDER BY `minOrder` ASC [ RunTime:0.007098s ]
select * from pdf where partno='228FMVAYWBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVAYWBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028573s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926092 AND `partno` = '228FMVAYWBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366562 [ RunTime:0.004951s ]
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.128071s ]