SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001434s ]
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=430&srecordnum=10000' [ RunTime:0.007672s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001998s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001502s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001565s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001358s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002699s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.005823s ]
UPDATE `stock_search` SET `count` = 1990 , `updatetime` = '2026-06-12 14:29:40' WHERE `partno` = '228' [ RunTime:0.006313s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001582s ]
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 `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 8580,20 [ RunTime:0.197068s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920245 LIMIT 4 [ RunTime:0.019862s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920245 ORDER BY `minOrder` ASC [ RunTime:0.008603s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920245 ORDER BY `unit` DESC [ RunTime:0.012968s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920245 LIMIT 2 [ RunTime:0.001225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920245 ORDER BY `minOrder` ASC [ RunTime:0.004197s ]
select * from pdf where partno='228ADVARFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013030s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.047444s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920245 AND `partno` = '228ADVARFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367118 [ RunTime:0.024867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920246 LIMIT 4 [ RunTime:0.006942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920246 ORDER BY `minOrder` ASC [ RunTime:0.016523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920246 ORDER BY `unit` DESC [ RunTime:0.041485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920246 LIMIT 2 [ RunTime:0.001048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920246 ORDER BY `minOrder` ASC [ RunTime:0.009380s ]
select * from pdf where partno='228ADVAWFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016596s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920246 AND `partno` = '228ADVAWFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.042975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450859 [ RunTime:0.025541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920247 LIMIT 4 [ RunTime:0.031925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920247 ORDER BY `minOrder` ASC [ RunTime:0.063056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920247 ORDER BY `unit` DESC [ RunTime:0.024557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920247 LIMIT 2 [ RunTime:0.032047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920247 ORDER BY `minOrder` ASC [ RunTime:0.032191s ]
select * from pdf where partno='228ADVAAFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.043083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036253s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920247 AND `partno` = '228ADVAAFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367119 [ RunTime:0.044894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920248 LIMIT 4 [ RunTime:0.041497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920248 ORDER BY `minOrder` ASC [ RunTime:0.036474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920248 ORDER BY `unit` DESC [ RunTime:0.015326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920248 LIMIT 2 [ RunTime:0.055575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920248 ORDER BY `minOrder` ASC [ RunTime:0.054533s ]
select * from pdf where partno='228ADVABCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026913s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920248 AND `partno` = '228ADVABCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367120 [ RunTime:0.026257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920249 LIMIT 4 [ RunTime:0.011046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920249 ORDER BY `minOrder` ASC [ RunTime:0.013765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920249 ORDER BY `unit` DESC [ RunTime:0.041285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920249 LIMIT 2 [ RunTime:0.026280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920249 ORDER BY `minOrder` ASC [ RunTime:0.028622s ]
select * from pdf where partno='228ADVARFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.071364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023467s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920249 AND `partno` = '228ADVARFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450860 [ RunTime:0.056525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920250 LIMIT 4 [ RunTime:0.032148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920250 ORDER BY `minOrder` ASC [ RunTime:0.011863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920250 ORDER BY `unit` DESC [ RunTime:0.012976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920250 LIMIT 2 [ RunTime:0.014883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920250 ORDER BY `minOrder` ASC [ RunTime:0.005568s ]
select * from pdf where partno='228ADVAYGFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYGFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020771s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920250 AND `partno` = '228ADVAYGFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367121 [ RunTime:0.002643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920251 LIMIT 4 [ RunTime:0.034993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920251 ORDER BY `minOrder` ASC [ RunTime:0.011502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920251 ORDER BY `unit` DESC [ RunTime:0.037112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920251 LIMIT 2 [ RunTime:0.005912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920251 ORDER BY `minOrder` ASC [ RunTime:0.008621s ]
select * from pdf where partno='228ADVABCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026761s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920251 AND `partno` = '228ADVABCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450861 [ RunTime:0.010251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920252 LIMIT 4 [ RunTime:0.008909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920252 ORDER BY `minOrder` ASC [ RunTime:0.017126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920252 ORDER BY `unit` DESC [ RunTime:0.021412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920252 LIMIT 2 [ RunTime:0.023755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920252 ORDER BY `minOrder` ASC [ RunTime:0.018030s ]
select * from pdf where partno='228ADVABBMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABBMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.040420s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920252 AND `partno` = '228ADVABBMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367122 [ RunTime:0.010149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920253 LIMIT 4 [ RunTime:0.039105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920253 ORDER BY `minOrder` ASC [ RunTime:0.033232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920253 ORDER BY `unit` DESC [ RunTime:0.040345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920253 LIMIT 2 [ RunTime:0.048489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920253 ORDER BY `minOrder` ASC [ RunTime:0.010389s ]
select * from pdf where partno='228ADVAGFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020495s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920253 AND `partno` = '228ADVAGFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920254 LIMIT 4 [ RunTime:0.029994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920254 ORDER BY `minOrder` ASC [ RunTime:0.024776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920254 ORDER BY `unit` DESC [ RunTime:0.016456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920254 LIMIT 2 [ RunTime:0.032640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920254 ORDER BY `minOrder` ASC [ RunTime:0.006059s ]
select * from pdf where partno='228ADVABAWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.039208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABAWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.048066s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920254 AND `partno` = '228ADVABAWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.069984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920255 LIMIT 4 [ RunTime:0.064921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920255 ORDER BY `minOrder` ASC [ RunTime:0.070743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920255 ORDER BY `unit` DESC [ RunTime:0.068502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920255 LIMIT 2 [ RunTime:0.048279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920255 ORDER BY `minOrder` ASC [ RunTime:0.010242s ]
select * from pdf where partno='228ADVAWFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.051156s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920255 AND `partno` = '228ADVAWFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.078442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450862 [ RunTime:0.056088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920256 LIMIT 4 [ RunTime:0.043056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920256 ORDER BY `minOrder` ASC [ RunTime:0.033628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920256 ORDER BY `unit` DESC [ RunTime:0.039732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920256 LIMIT 2 [ RunTime:0.036801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920256 ORDER BY `minOrder` ASC [ RunTime:0.037268s ]
select * from pdf where partno='228ADVAYCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.050315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.076183s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920256 AND `partno` = '228ADVAYCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920257 LIMIT 4 [ RunTime:0.014054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920257 ORDER BY `minOrder` ASC [ RunTime:0.024785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920257 ORDER BY `unit` DESC [ RunTime:0.028349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920257 LIMIT 2 [ RunTime:0.024602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920257 ORDER BY `minOrder` ASC [ RunTime:0.038993s ]
select * from pdf where partno='228ADVAGFAWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.064523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFAWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021166s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920257 AND `partno` = '228ADVAGFAWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920258 LIMIT 4 [ RunTime:0.055425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920258 ORDER BY `minOrder` ASC [ RunTime:0.037010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920258 ORDER BY `unit` DESC [ RunTime:0.021130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920258 LIMIT 2 [ RunTime:0.041618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920258 ORDER BY `minOrder` ASC [ RunTime:0.044617s ]
select * from pdf where partno='228ADVAAWFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.042680s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920258 AND `partno` = '228ADVAAWFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367123 [ RunTime:0.023237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920259 LIMIT 4 [ RunTime:0.014002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920259 ORDER BY `minOrder` ASC [ RunTime:0.014441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920259 ORDER BY `unit` DESC [ RunTime:0.020737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920259 LIMIT 2 [ RunTime:0.015730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920259 ORDER BY `minOrder` ASC [ RunTime:0.006886s ]
select * from pdf where partno='228ADVAAWFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012179s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920259 AND `partno` = '228ADVAAWFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450863 [ RunTime:0.012446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920260 LIMIT 4 [ RunTime:0.016404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920260 ORDER BY `minOrder` ASC [ RunTime:0.003862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920260 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920260 LIMIT 2 [ RunTime:0.003387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920260 ORDER BY `minOrder` ASC [ RunTime:0.005861s ]
select * from pdf where partno='228ADVABCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004781s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920260 AND `partno` = '228ADVABCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450864 [ RunTime:0.005454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920261 LIMIT 4 [ RunTime:0.003307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920261 ORDER BY `minOrder` ASC [ RunTime:0.006940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920261 ORDER BY `unit` DESC [ RunTime:0.003531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920261 LIMIT 2 [ RunTime:0.005877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920261 ORDER BY `minOrder` ASC [ RunTime:0.002869s ]
select * from pdf where partno='228ADVARFBWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFBWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016267s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920261 AND `partno` = '228ADVARFBWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450865 [ RunTime:0.047435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920262 LIMIT 4 [ RunTime:0.031778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920262 ORDER BY `minOrder` ASC [ RunTime:0.027726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920262 ORDER BY `unit` DESC [ RunTime:0.035876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920262 LIMIT 2 [ RunTime:0.020819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920262 ORDER BY `minOrder` ASC [ RunTime:0.010455s ]
select * from pdf where partno='228ADVARCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.041031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036577s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920262 AND `partno` = '228ADVARCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367124 [ RunTime:0.023176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920263 LIMIT 4 [ RunTime:0.009227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920263 ORDER BY `minOrder` ASC [ RunTime:0.008362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920263 ORDER BY `unit` DESC [ RunTime:0.009830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920263 LIMIT 2 [ RunTime:0.021888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920263 ORDER BY `minOrder` ASC [ RunTime:0.057723s ]
select * from pdf where partno='228ADVARFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006471s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920263 AND `partno` = '228ADVARFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450866 [ RunTime:0.007679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920264 LIMIT 4 [ RunTime:0.012711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920264 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920264 ORDER BY `unit` DESC [ RunTime:0.007335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920264 LIMIT 2 [ RunTime:0.004567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920264 ORDER BY `minOrder` ASC [ RunTime:0.004350s ]
select * from pdf where partno='228ADVAGFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006330s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920264 AND `partno` = '228ADVAGFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367125 [ RunTime:0.010317s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 8580,20 [ RunTime:0.130756s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.119423s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.076521s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 643 [ RunTime:0.000365s ]