SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001183s ]
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=48&srecordnum=10000' [ RunTime:0.002705s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001580s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003441s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001877s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002157s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001844s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000802s ]
UPDATE `stock_search` SET `count` = 1147 , `updatetime` = '2026-06-11 19:53:56' WHERE `partno` = '228' [ RunTime:0.002815s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000271s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000238s ]
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.000402s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002296s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.233174s ]
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 940,20 [ RunTime:0.095808s ]
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 ('32926253','32926252','32926251','32926250','32926249','32926248','32926247','32926246','32926245','32926244','32926243','32926242','32926241','32926240','32926239','32926238','32926237','32926236','32926235','32926234') ORDER BY FIELD(s.id, 32926253,32926252,32926251,32926250,32926249,32926248,32926247,32926246,32926245,32926244,32926243,32926242,32926241,32926240,32926239,32926238,32926237,32926236,32926235,32926234) [ RunTime:0.007112s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926253 LIMIT 4 [ RunTime:0.003467s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926253 ORDER BY `minOrder` ASC [ RunTime:0.004455s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926253 ORDER BY `unit` DESC [ RunTime:0.005068s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926253 LIMIT 2 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926253 ORDER BY `minOrder` ASC [ RunTime:0.003964s ]
select * from pdf where partno='228CMVARGBFAACR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009615s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAACR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025233s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926253 AND `partno` = '228CMVARGBFAACR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449972 [ RunTime:0.015325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926252 LIMIT 4 [ RunTime:0.018742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926252 ORDER BY `minOrder` ASC [ RunTime:0.037723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926252 ORDER BY `unit` DESC [ RunTime:0.018573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926252 LIMIT 2 [ RunTime:0.029626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926252 ORDER BY `minOrder` ASC [ RunTime:0.005798s ]
select * from pdf where partno='228CMVARGBFEWAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEWAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007294s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926252 AND `partno` = '228CMVARGBFEWAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366612 [ RunTime:0.020209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926251 LIMIT 4 [ RunTime:0.013767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926251 ORDER BY `minOrder` ASC [ RunTime:0.016897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926251 ORDER BY `unit` DESC [ RunTime:0.006609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926251 LIMIT 2 [ RunTime:0.005918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926251 ORDER BY `minOrder` ASC [ RunTime:0.012813s ]
select * from pdf where partno='228CMVARGBFEMSAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEMSAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008204s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926251 AND `partno` = '228CMVARGBFEMSAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.051636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449971 [ RunTime:0.019126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926250 LIMIT 4 [ RunTime:0.026071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926250 ORDER BY `minOrder` ASC [ RunTime:0.034015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926250 ORDER BY `unit` DESC [ RunTime:0.003959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926250 LIMIT 2 [ RunTime:0.019069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926250 ORDER BY `minOrder` ASC [ RunTime:0.006600s ]
select * from pdf where partno='228CMVARGBFCACR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCACR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017347s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926250 AND `partno` = '228CMVARGBFCACR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449970 [ RunTime:0.007887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926249 LIMIT 4 [ RunTime:0.014725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926249 ORDER BY `minOrder` ASC [ RunTime:0.001659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926249 ORDER BY `unit` DESC [ RunTime:0.013180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926249 LIMIT 2 [ RunTime:0.007673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926249 ORDER BY `minOrder` ASC [ RunTime:0.003403s ]
select * from pdf where partno='228CMVARGBFCWCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCWCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003158s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926249 AND `partno` = '228CMVARGBFCWCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366611 [ RunTime:0.001107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926248 LIMIT 4 [ RunTime:0.002073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926248 ORDER BY `minOrder` ASC [ RunTime:0.042158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926248 ORDER BY `unit` DESC [ RunTime:0.006393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926248 LIMIT 2 [ RunTime:0.011225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926248 ORDER BY `minOrder` ASC [ RunTime:0.018937s ]
select * from pdf where partno='228CMVARGBFEABR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEABR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008790s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926248 AND `partno` = '228CMVARGBFEABR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926247 LIMIT 4 [ RunTime:0.012654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926247 ORDER BY `minOrder` ASC [ RunTime:0.011725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926247 ORDER BY `unit` DESC [ RunTime:0.020516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926247 LIMIT 2 [ RunTime:0.024854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926247 ORDER BY `minOrder` ASC [ RunTime:0.006916s ]
select * from pdf where partno='228CMVARGBFCAAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCAAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034791s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926247 AND `partno` = '228CMVARGBFCAAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926246 LIMIT 4 [ RunTime:0.019971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926246 ORDER BY `minOrder` ASC [ RunTime:0.026824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926246 ORDER BY `unit` DESC [ RunTime:0.020652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926246 LIMIT 2 [ RunTime:0.028312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926246 ORDER BY `minOrder` ASC [ RunTime:0.002790s ]
select * from pdf where partno='228CMVARGBFABBCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFABBCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007536s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926246 AND `partno` = '228CMVARGBFABBCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926245 LIMIT 4 [ RunTime:0.020987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926245 ORDER BY `minOrder` ASC [ RunTime:0.006767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926245 ORDER BY `unit` DESC [ RunTime:0.018707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926245 LIMIT 2 [ RunTime:0.016730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926245 ORDER BY `minOrder` ASC [ RunTime:0.004094s ]
select * from pdf where partno='228CMVARGBFDBBAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDBBAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020062s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926245 AND `partno` = '228CMVARGBFDBBAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926244 LIMIT 4 [ RunTime:0.018622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926244 ORDER BY `minOrder` ASC [ RunTime:0.009400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926244 ORDER BY `unit` DESC [ RunTime:0.015754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926244 LIMIT 2 [ RunTime:0.009815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926244 ORDER BY `minOrder` ASC [ RunTime:0.004585s ]
select * from pdf where partno='228CMVARGBFDMBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDMBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006585s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926244 AND `partno` = '228CMVARGBFDMBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366610 [ RunTime:0.010697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926243 LIMIT 4 [ RunTime:0.003940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926243 ORDER BY `minOrder` ASC [ RunTime:0.011737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926243 ORDER BY `unit` DESC [ RunTime:0.008028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926243 LIMIT 2 [ RunTime:0.010277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926243 ORDER BY `minOrder` ASC [ RunTime:0.003917s ]
select * from pdf where partno='228CMVARGBFDMSBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDMSBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020815s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926243 AND `partno` = '228CMVARGBFDMSBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449969 [ RunTime:0.006377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926242 LIMIT 4 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926242 ORDER BY `minOrder` ASC [ RunTime:0.015201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926242 ORDER BY `unit` DESC [ RunTime:0.015324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926242 LIMIT 2 [ RunTime:0.032224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926242 ORDER BY `minOrder` ASC [ RunTime:0.004842s ]
select * from pdf where partno='228CMVARGBFFBBAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFBBAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034677s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926242 AND `partno` = '228CMVARGBFFBBAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.028348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366609 [ RunTime:0.021041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926241 LIMIT 4 [ RunTime:0.046400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926241 ORDER BY `minOrder` ASC [ RunTime:0.038425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926241 ORDER BY `unit` DESC [ RunTime:0.069375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926241 LIMIT 2 [ RunTime:0.036889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926241 ORDER BY `minOrder` ASC [ RunTime:0.024979s ]
select * from pdf where partno='228CMVARGBFCMBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCMBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.046870s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926241 AND `partno` = '228CMVARGBFCMBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.057225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449968 [ RunTime:0.021916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926240 LIMIT 4 [ RunTime:0.089221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926240 ORDER BY `minOrder` ASC [ RunTime:0.016713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926240 ORDER BY `unit` DESC [ RunTime:0.028449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926240 LIMIT 2 [ RunTime:0.082570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926240 ORDER BY `minOrder` ASC [ RunTime:0.016130s ]
select * from pdf where partno='228CMVARGBFCBBDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCBBDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.049955s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926240 AND `partno` = '228CMVARGBFCBBDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366608 [ RunTime:0.022160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926239 LIMIT 4 [ RunTime:0.004071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926239 ORDER BY `minOrder` ASC [ RunTime:0.041485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926239 ORDER BY `unit` DESC [ RunTime:0.016800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926239 LIMIT 2 [ RunTime:0.025266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926239 ORDER BY `minOrder` ASC [ RunTime:0.007407s ]
select * from pdf where partno='228CMVARGBFEMSBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEMSBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035385s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926239 AND `partno` = '228CMVARGBFEMSBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449967 [ RunTime:0.002641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926238 LIMIT 4 [ RunTime:0.016043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926238 ORDER BY `minOrder` ASC [ RunTime:0.008985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926238 ORDER BY `unit` DESC [ RunTime:0.003792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926238 LIMIT 2 [ RunTime:0.004856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926238 ORDER BY `minOrder` ASC [ RunTime:0.006721s ]
select * from pdf where partno='228CMVARGBFCWDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCWDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016034s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926238 AND `partno` = '228CMVARGBFCWDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366607 [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926237 LIMIT 4 [ RunTime:0.002889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926237 ORDER BY `minOrder` ASC [ RunTime:0.007302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926237 ORDER BY `unit` DESC [ RunTime:0.016868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926237 LIMIT 2 [ RunTime:0.014501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926237 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
select * from pdf where partno='228CMVARGBFAWBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAWBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026040s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926237 AND `partno` = '228CMVARGBFAWBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366606 [ RunTime:0.015477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926236 LIMIT 4 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926236 ORDER BY `minOrder` ASC [ RunTime:0.002682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926236 ORDER BY `unit` DESC [ RunTime:0.011546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926236 LIMIT 2 [ RunTime:0.006446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926236 ORDER BY `minOrder` ASC [ RunTime:0.003326s ]
select * from pdf where partno='228CMVARGBFFBBDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFBBDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015511s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926236 AND `partno` = '228CMVARGBFFBBDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.058710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449966 [ RunTime:0.015488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926235 LIMIT 4 [ RunTime:0.015098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926235 ORDER BY `minOrder` ASC [ RunTime:0.005284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926235 ORDER BY `unit` DESC [ RunTime:0.008235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926235 LIMIT 2 [ RunTime:0.006958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926235 ORDER BY `minOrder` ASC [ RunTime:0.009393s ]
select * from pdf where partno='228CMVARGBFCMBDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCMBDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012739s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926235 AND `partno` = '228CMVARGBFCMBDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449965 [ RunTime:0.014280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926234 LIMIT 4 [ RunTime:0.006073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926234 ORDER BY `minOrder` ASC [ RunTime:0.055123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926234 ORDER BY `unit` DESC [ RunTime:0.042479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926234 LIMIT 2 [ RunTime:0.019675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926234 ORDER BY `minOrder` ASC [ RunTime:0.006091s ]
select * from pdf where partno='228CMVARGBFBMSCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFBMSCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015734s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926234 AND `partno` = '228CMVARGBFBMSCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449964 [ RunTime:0.006834s ]
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.135563s ]