/usr/sbin/mysqld, Version: 5.5.50-log (MySQL Community Server (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 170214 15:34:14
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 21.172618 Lock_time: 0.011895 Rows_sent: 1 Rows_examined: 0
use youl;
SET timestamp=1487064854;
SELECT COUNT(*) AS expression
FROM
(SELECT i.sid AS sid
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'assortiment') OR (i.word = 'farmacevticheskih') OR (i.word = 'tovarov') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND(( (d.data LIKE '% assortiment %' ESCAPE '\\') OR (d.data LIKE '% farmacevticheskih %' ESCAPE '\\') )AND (d.data LIKE '% tovarov %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170214 15:34:26
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 31.890500 Lock_time: 0.000153 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487064866;
SELECT COUNT(*) AS expression
FROM
(SELECT i.sid AS sid
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'evraziyskiy') OR (i.word = 'nacionalnyy') OR (i.word = 'universitet') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND( (d.data LIKE '% evraziyskiy %' ESCAPE '\\') AND (d.data LIKE '% nacionalnyy %' ESCAPE '\\') AND (d.data LIKE '% universitet %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '3') ) subquery;
# Time: 170214 15:34:30
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 15.243130 Lock_time: 0.000160 Rows_sent: 10 Rows_examined: 8788
SET timestamp=1487064870;
SELECT i.type AS type, i.sid AS sid, SUM((23.4646357290 * i.score * t.count)) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'assortiment') OR (i.word = 'farmacevticheskih') OR (i.word = 'tovarov') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND(( (d.data LIKE '% assortiment %' ESCAPE '\\') OR (d.data LIKE '% farmacevticheskih %' ESCAPE '\\') )AND (d.data LIKE '% tovarov %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 10;
# Time: 170214 15:34:55
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 12.907704 Lock_time: 0.000060 Rows_sent: 1 Rows_examined: 965
SET timestamp=1487064895;
SELECT SUM(t.visits) AS expression
FROM
access_counter t
WHERE (t.entity_type = 'node') AND (t.entity_id = '17639');
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 12.905223 Lock_time: 0.000060 Rows_sent: 1 Rows_examined: 965
SET timestamp=1487064895;
SELECT SUM(t.visits) AS expression
FROM
access_counter t
WHERE (t.entity_type = 'node') AND (t.entity_id = '17639');
# Time: 170214 15:35:06
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 28.781413 Lock_time: 0.000134 Rows_sent: 1 Rows_examined: 120202
SET timestamp=1487064906;
SELECT node.title AS node_title, node.nid AS nid, node.language AS node_language, node.created AS node_created, 'node' AS field_data_field_authors_node_entity_type, 'node' AS field_data_field_summary_node_entity_type, 'node' AS field_data_field_category_node_entity_type, 'node' AS field_data_field_photo_node_entity_type
FROM
node node
INNER JOIN field_data_field_status field_data_field_status ON node.nid = field_data_field_status.entity_id AND (field_data_field_status.entity_type = 'node' AND field_data_field_status.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN ('publication')) AND (field_data_field_status.field_status_value = '2') ))AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (node.nid = na.nid) ))
ORDER BY node_created DESC
LIMIT 1 OFFSET 0;
# Time: 170214 15:35:11
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 44.377444 Lock_time: 0.000157 Rows_sent: 10 Rows_examined: 18190
SET timestamp=1487064911;
SELECT i.type AS type, i.sid AS sid, SUM((143.4959069587 * i.score * t.count)) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'evraziyskiy') OR (i.word = 'nacionalnyy') OR (i.word = 'universitet') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND( (d.data LIKE '% evraziyskiy %' ESCAPE '\\') AND (d.data LIKE '% nacionalnyy %' ESCAPE '\\') AND (d.data LIKE '% universitet %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '3')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 0;
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 13.413882 Lock_time: 0.000089 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487064911;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
node n
WHERE (n.promote = '1') AND (n.status = '1') AND (n.language IN ('ru', 'und')) AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) ) subquery;
# Time: 170214 15:35:28
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 10.968992 Lock_time: 0.000102 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487064928;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
node n
WHERE (n.promote = '1') AND (n.status = '1') AND (n.language IN ('ru', 'und')) AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) ) subquery;
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 10.931247 Lock_time: 0.000176 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487064928;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
taxonomy_term_data taxonomy_term_data
LEFT JOIN node node_taxonomy_term_data ON (SELECT nodeINNER.nid AS nidINNER
FROM
node nodeINNER
LEFT JOIN taxonomy_index taxonomy_indexINNER ON nodeINNER.nid = taxonomy_indexINNER.nid
LEFT JOIN taxonomy_term_data taxonomy_term_data_nodeINNER ON taxonomy_indexINNER.tid = taxonomy_term_data_nodeINNER.tid
WHERE (( (taxonomy_term_data_nodeINNER.tid = taxonomy_term_data.tid ) ))
ORDER BY nodeINNER.nid DESC
LIMIT 1 OFFSET 0) = node_taxonomy_term_data.nid
LEFT JOIN taxonomy_vocabulary taxonomy_vocabulary ON taxonomy_term_data.vid = taxonomy_vocabulary.vid
LEFT JOIN field_data_field_views field_data_field_views ON taxonomy_term_data.tid = field_data_field_views.entity_id AND (field_data_field_views.entity_type = 'taxonomy_term' AND field_data_field_views.deleted = '0')
WHERE (( (taxonomy_vocabulary.machine_name IN ('univeritys')) ))) subquery;
# Time: 170214 15:36:06
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 13.696401 Lock_time: 0.000163 Rows_sent: 10 Rows_examined: 6079
SET timestamp=1487064966;
SELECT i.type AS type, i.sid AS sid, SUM((264.8679994764 * i.score * t.count)) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'enu') OR (i.word = 'turizm') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND( (d.data LIKE '% enu %' ESCAPE '\\') AND (d.data LIKE '% turizm %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 0;
# Time: 170214 15:37:10
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 18.145190 Lock_time: 0.000260 Rows_sent: 1 Rows_examined: 10426
SET timestamp=1487065030;
SELECT SUM(i.score * t.count) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'assortiment') OR (i.word = 'medicinskih') OR (i.word = 'tovarov') )AND (i.type = 'node') AND(( (d.data LIKE '% assortiment %' ESCAPE '\\') OR (d.data LIKE '% medicinskih %' ESCAPE '\\') )AND (d.data LIKE '% tovarov %' ESCAPE '\\') )AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) ))
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 1 OFFSET 0;
# Time: 170214 15:37:41
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 11.728692 Lock_time: 0.000159 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065061;
SELECT COUNT(*) AS expression
FROM
(SELECT i.sid AS sid
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'enu') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND( (d.data LIKE '% enu %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 10.167995 Lock_time: 0.000154 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065061;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
field_data_field_status field_data_field_status0
INNER JOIN node node ON node.nid = field_data_field_status0.entity_id
WHERE (field_data_field_status0.field_status_value = '2') AND (field_data_field_status0.deleted = '0') AND (node.status = '1') AND (node.language = 'ru') AND (node.created >= '0') AND (node.created <= '1487065976') AND (field_data_field_status0.entity_type = 'node') AND (field_data_field_status0.bundle = 'publication') AND(( ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (field_data_field_status0.entity_id = na.nid) )) AND (field_data_field_status0.entity_type = 'node') )OR (field_data_field_status0.entity_type <> 'node') )) subquery;
# Time: 170214 15:37:53
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 10.247234 Lock_time: 0.000135 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065073;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
field_data_field_status field_data_field_status0
INNER JOIN node node ON node.nid = field_data_field_status0.entity_id
WHERE (field_data_field_status0.field_status_value = '2') AND (field_data_field_status0.deleted = '0') AND (node.status = '1') AND (node.language = 'ru') AND (node.created >= '0') AND (node.created <= '1487065988') AND (field_data_field_status0.entity_type = 'node') AND (field_data_field_status0.bundle = 'publication') AND(( ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (field_data_field_status0.entity_id = na.nid) )) AND (field_data_field_status0.entity_type = 'node') )OR (field_data_field_status0.entity_type <> 'node') )) subquery;
# Time: 170214 15:37:54
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 13.378434 Lock_time: 0.000122 Rows_sent: 31676 Rows_examined: 81383
SET timestamp=1487065074;
SELECT s.source, s.context, t.translation, t.language FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'ru' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# Time: 170214 15:37:55
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 14.106020 Lock_time: 0.000147 Rows_sent: 10 Rows_examined: 2881
SET timestamp=1487065075;
SELECT i.type AS type, i.sid AS sid, SUM((69.5721772833 * i.score * t.count)) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'enu') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND( (d.data LIKE '% enu %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 0;
# Time: 170214 15:37:56
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 13.136384 Lock_time: 0.000100 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065076;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
node n
WHERE (n.promote = '1') AND (n.status = '1') AND (n.language IN ('ru', 'und')) AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) ) subquery;
# Time: 170214 15:38:00
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 12.423724 Lock_time: 0.000175 Rows_sent: 10 Rows_examined: 111606
SET timestamp=1487065080;
SELECT taxonomy_term_data.tid AS tid, taxonomy_term_data.name AS taxonomy_term_data_name, taxonomy_term_data.vid AS taxonomy_term_data_vid, taxonomy_vocabulary.machine_name AS taxonomy_vocabulary_machine_name, field_data_field_views.field_views_value AS field_data_field_views_field_views_value, 'taxonomy_term' AS field_data_field_photo_taxonomy_term_entity_type, 'taxonomy_term' AS field_data_field_rector_taxonomy_term_entity_type, 'taxonomy_term' AS field_data_field_views_taxonomy_term_entity_type
FROM
taxonomy_term_data taxonomy_term_data
LEFT JOIN node node_taxonomy_term_data ON (SELECT nodeINNER.nid AS nidINNER
FROM
node nodeINNER
LEFT JOIN taxonomy_index taxonomy_indexINNER ON nodeINNER.nid = taxonomy_indexINNER.nid
LEFT JOIN taxonomy_term_data taxonomy_term_data_nodeINNER ON taxonomy_indexINNER.tid = taxonomy_term_data_nodeINNER.tid
WHERE (( (taxonomy_term_data_nodeINNER.tid = taxonomy_term_data.tid ) ))
ORDER BY nodeINNER.nid DESC
LIMIT 1 OFFSET 0) = node_taxonomy_term_data.nid
LEFT JOIN taxonomy_vocabulary taxonomy_vocabulary ON taxonomy_term_data.vid = taxonomy_vocabulary.vid
LEFT JOIN field_data_field_views field_data_field_views ON taxonomy_term_data.tid = field_data_field_views.entity_id AND (field_data_field_views.entity_type = 'taxonomy_term' AND field_data_field_views.deleted = '0')
WHERE (( (taxonomy_vocabulary.machine_name IN ('univeritys')) ))
ORDER BY field_data_field_views_field_views_value DESC
LIMIT 10 OFFSET 0;
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 10.225878 Lock_time: 0.000278 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065080;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
taxonomy_term_data taxonomy_term_data
LEFT JOIN node node_taxonomy_term_data ON (SELECT nodeINNER.nid AS nidINNER
FROM
node nodeINNER
LEFT JOIN taxonomy_index taxonomy_indexINNER ON nodeINNER.nid = taxonomy_indexINNER.nid
LEFT JOIN taxonomy_term_data taxonomy_term_data_nodeINNER ON taxonomy_indexINNER.tid = taxonomy_term_data_nodeINNER.tid
WHERE (( (taxonomy_term_data_nodeINNER.tid = taxonomy_term_data.tid ) ))
ORDER BY nodeINNER.nid DESC
LIMIT 1 OFFSET 0) = node_taxonomy_term_data.nid
LEFT JOIN taxonomy_vocabulary taxonomy_vocabulary ON taxonomy_term_data.vid = taxonomy_vocabulary.vid
LEFT JOIN field_data_field_views field_data_field_views ON taxonomy_term_data.tid = field_data_field_views.entity_id AND (field_data_field_views.entity_type = 'taxonomy_term' AND field_data_field_views.deleted = '0')
WHERE (( (taxonomy_vocabulary.machine_name IN ('univeritys')) ))) subquery;
# Time: 170214 15:38:03
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 53.506313 Lock_time: 0.000162 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065083;
SELECT COUNT(*) AS expression
FROM
(SELECT i.sid AS sid
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'assortiment') OR (i.word = 'medicinskih') OR (i.word = 'tovarov') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND(( (d.data LIKE '% assortiment %' ESCAPE '\\') OR (d.data LIKE '% medicinskih %' ESCAPE '\\') )AND (d.data LIKE '% tovarov %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 11.982617 Lock_time: 0.000103 Rows_sent: 1 Rows_examined: 0
SET timestamp=1487065083;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
node n
WHERE (n.promote = '1') AND (n.status = '1') AND (n.language IN ('ru', 'und')) AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) ) subquery;
# Time: 170214 15:38:20
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 16.989781 Lock_time: 0.000268 Rows_sent: 10 Rows_examined: 10435
SET timestamp=1487065100;
SELECT i.type AS type, i.sid AS sid, SUM((23.4646357290 * i.score * t.count)) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'assortiment') OR (i.word = 'medicinskih') OR (i.word = 'tovarov') )AND (i.type = 'node') AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND(( (d.data LIKE '% assortiment %' ESCAPE '\\') OR (d.data LIKE '% medicinskih %' ESCAPE '\\') )AND (d.data LIKE '% tovarov %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 0;
# Time: 170214 15:41:03
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 44.636846 Lock_time: 0.000217 Rows_sent: 0 Rows_examined: 75791
SET timestamp=1487065263;
SELECT SUM(i.score * t.count) AS calculated_score
FROM
search_index i
INNER JOIN node n ON n.nid = i.sid
INNER JOIN search_total t ON i.word = t.word
INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type
WHERE (n.status = '1') AND( (i.word = 'effektivnost') OR (i.word = 'formirovaniya') OR (i.word = 'dvigatelnyh') OR (i.word = 'sposobnostey') OR (i.word = 'devochek') OR (i.word = 'srednih') OR (i.word = 'klassov') OR (i.word = 'usloviyah') OR (i.word = 'variativnogo') OR (i.word = 'komponenta') OR (i.word = 'urokov') OR (i.word = 'fizkultury') )AND (i.type = 'node') AND( (d.data LIKE '% effektivnost %' ESCAPE '\\') AND (d.data LIKE '% formirovaniya %' ESCAPE '\\') AND (d.data LIKE '% dvigatelnyh %' ESCAPE '\\') AND (d.data LIKE '% sposobnostey %' ESCAPE '\\') AND (d.data LIKE '% devochek %' ESCAPE '\\') AND (d.data LIKE '% srednih %' ESCAPE '\\') AND (d.data LIKE '% klassov %' ESCAPE '\\') AND (d.data LIKE '% v %' ESCAPE '\\') AND (d.data LIKE '% usloviyah %' ESCAPE '\\') AND (d.data LIKE '% variativnogo %' ESCAPE '\\') AND (d.data LIKE '% komponenta %' ESCAPE '\\') AND (d.data LIKE '% urokov %' ESCAPE '\\') AND (d.data LIKE '% fizkultury %' ESCAPE '\\') )AND ( EXISTS (SELECT na.nid AS nid
FROM
node_access na
WHERE (( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) ))
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '12')
ORDER BY calculated_score DESC
LIMIT 1 OFFSET 0;