1.
SET CHARACTER
SET '
cp1251'
execution time: 0.00019693374633789 seconds
affected rows: 1
function: query
file: /opt/join/new.join.com.ua/news/copy/index.php
line: 16
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
2.
SELECT SQL_CALC_FOUND_ROWS id
FROM category
WHERE category_path
= '
main>'
execution time: 0.00025296211242676 seconds
affected rows: 1
function: dlookup
file: /opt/join/new.join.com.ua/news/copy/index.php
line: 31
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
3.
SELECT SQL_CALC_FOUND_ROWS
* FROM `news_blocks`
ORDER BY id
execution time: 0.00020599365234375 seconds
returned rows: 11 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
news_blocks
|
ALL
|
|
|
|
|
11
|
Using filesort
|
function: query
file: /opt/join/new.join.com.ua/news/copy/index.php
line: 47
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
4.
SELECT SQL_CALC_FOUND_ROWS category_path
, name
, name_ua
, link
, search
, topnews
, photonews
, simple
FROM category
WHERE id
= '
'
execution time: 0.00036287307739258 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: GetBlockCategoryId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 23
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
5.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
news
.id
AS link_old
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
news
.descr
AS `
desc`
,
news
.text
,
news
.site_id
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
(SELECT news
.* FROM news
INNER JOIN category
ON (news
.category_id
= category
.id
)
WHERE
news
.moderated
= 1
AND
category_path LIKE '
%'
AND
(category
.adult !
= 1
OR category_path
= '
'
)
ORDER BY `Date`
DESC LIMIT 100
) AS news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
category_path LIKE '
%'
AND
(category
.adult !
= 1
OR category_path
= '
'
)
GROUP BY
news
.`site_id`
ORDER BY
news
.`date`
DESC
LIMIT 0
,9
execution time: 0.64225292205811 seconds
returned rows: 9 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
PRIMARY
|
<derived2>
|
ALL
|
|
|
|
|
100
|
Using where; Using temporary; Using filesort
|
1
|
PRIMARY
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
news.category_id
|
1
|
Using where
|
1
|
PRIMARY
|
rss
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
news.rss_id
|
1
|
|
1
|
PRIMARY
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
2
|
DERIVED
|
news
|
ALL
|
|
|
|
|
168287
|
Using filesort
|
2
|
DERIVED
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetBlockCategoryId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 103
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
6.
SELECT SQL_CALC_FOUND_ROWS category_path
FROM category
WHERE id
= '
'
execution time: 0.00031304359436035 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: GetNewsFromCategory
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 367
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
7.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615817'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
471'
LIMIT 3
execution time: 1.9856879711151 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
8.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615814'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
531'
LIMIT 3
execution time: 0.00038003921508789 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
9.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615808'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
460'
LIMIT 3
execution time: 1.5643749237061 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
10.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615806'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
143'
LIMIT 3
execution time: 1.2856929302216 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
11.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615807'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
197'
LIMIT 3
execution time: 1.9065589904785 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
12.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615810'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
126'
LIMIT 3
execution time: 1.0730919837952 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
13.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615815'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
137'
LIMIT 3
execution time: 1.6517238616943 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
14.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615801'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
493'
LIMIT 3
execution time: 2.4002180099487 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
15.
SELECT SQL_CALC_FOUND_ROWS
news
.`date`
,
CONCAT
(SUBSTRING
(news
.id
,1
,2
),'
'
,SUBSTRING
(news
.id
,7
)) AS link
,
news
.id
AS link_old
,
news
.id
,
news
.title
,
news
.img
AS `image`
,
news
.img_75x75
AS `image_75x75`
,
news
.descr
AS `
desc`
,
news
.img_100x100
AS `image_100x100`
,
news
.img_50x
AS `image_50x`
,
sites
.url
AS fromLink
,
sites
.name
AS `
from`
,
category_path
,
category_path_ua
,
category_path_ru
FROM
news
INNER JOIN category
ON (news
.category_id
= category
.id
)
INNER JOIN rss
ON (news
.rss_id
= rss
.id
)
LEFT OUTER JOIN sites
ON (rss
.site_id
= sites
.id
)
WHERE
news
.moderated
= 1
AND
news
.id !
= '
1615798'
AND
category_path LIKE '
%'
AND
news
.site_id
= '
559'
LIMIT 3
execution time: 2.2473990917206 seconds
returned rows: 3 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
rss
|
ALL
|
PRIMARY
|
|
|
|
424
|
|
1
|
SIMPLE
|
sites
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.rss.site_id
|
1
|
|
1
|
SIMPLE
|
news
|
ref
|
PRIMARY,rss_id
|
rss_id
|
4
|
join_partner.rss.id
|
343
|
Using where
|
1
|
SIMPLE
|
category
|
eq_ref
|
PRIMARY
|
PRIMARY
|
4
|
join_partner.news.category_id
|
1
|
Using where
|
function: GetNewsSimilarId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 415
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
16.
SELECT SQL_CALC_FOUND_ROWS category_path
FROM category
WHERE id
= '
'
execution time: 0.00027894973754883 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: dlookup
file: /opt/join/new.join.com.ua/news/copy/index.php
line: 68
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
17.
SELECT SQL_CALC_FOUND_ROWS category_path
, category_path_ru
FROM category
WHERE id
= '
'
execution time: 0.00017690658569336 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: GetCategoryPathId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 454
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
18.
SELECT SQL_CALC_FOUND_ROWS parent_id
FROM category
WHERE id
='
'
execution time: 0.00022602081298828 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: GetCategoryTreeId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 481
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
19.
SELECT SQL_CALC_FOUND_ROWS name
FROM category
WHERE id
='
'
execution time: 0.0001370906829834 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: GetCategoryTreeId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 485
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
20.
SELECT SQL_CALC_FOUND_ROWS
* FROM `category`
WHERE `parent_id`
='
'
ORDER BY priority
execution time: 0.00017404556274414 seconds
returned rows: 15 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
ALL
|
|
|
|
|
88
|
Using where; Using filesort
|
function: GetCategoryTreeId
file: /opt/join/new.join.com.ua/news/copy/includes/NewsBlock.class.php
line: 487
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all
21.
SELECT SQL_CALC_FOUND_ROWS adult
FROM category
WHERE id
= '
'
execution time: 0.00014591217041016 seconds
returned rows: 1 ««
show |
explain
|
|
|
|
|
|
|
|
|
|
1
|
SIMPLE
|
category
|
const
|
PRIMARY
|
PRIMARY
|
4
|
const
|
1
|
|
function: dlookup
file: /opt/join/new.join.com.ua/news/copy/index.php
line: 151
WARNING: The exact results returned by this query are already returned by another query! (for a total of 21 times)
close all