/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: 170209 18:13:20
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.833888 Lock_time: 0.000689 Rows_sent: 992 Rows_examined: 1984
use youl;
SET timestamp=1486642400;
SELECT t.*
FROM
field_data_body t
WHERE (entity_type = 'node') AND (entity_id IN ('47035', '47036', '47037', '47039', '47040', '47041', '47043', '47044', '47046', '47048', '47049', '47051', '47056', '47058', '47059', '47060', '47061', '47062', '47063', '47064', '47065', '47066', '47067', '47068', '47069', '47074', '47076', '47077', '47080', '47081', '47083', '47085', '47086', '47088', '47091', '47093', '47094', '47096', '47097', '47099', '47101', '47102', '47103', '47105', '47106', '47107', '47109', '47110', '47111', '47112', '47113', '47114', '47115', '47116', '47117', '47118', '47121', '47124', '47125', '47126', '47128', '47129', '47130', '47131', '47132', '47133', '47134', '47135', '47136', '47137', '47138', '47139', '47140', '47142', '47143', '47144', '47145', '47146', '47147', '47148', '47149', '47150', '47151', '47153', '47156', '47158', '47159', '47161', '47164', '47165', '47166', '47167', '47169', '47171', '47173', '47177', '47178', '47179', '47181', '47182', '47183', '47184', '47185', '47186', '47187', '47192', '47193', '47195', '47197', '47199', '47214', '47217', '47218', '47219', '47220', '47222', '47223', '47224', '47225', '47226', '47227', '47228', '47229', '47230', '47231', '47232', '47235', '47238', '47239', '47242', '47243', '47244', '47247', '47253', '47256', '47258', '47259', '47260', '47261', '47263', '47264', '47266', '47268', '47269', '47271', '47274', '47275', '47283', '47284', '47285', '47286', '47288', '47291', '47292', '47294', '47295', '47296', '47298', '47300', '47301', '47303', '47307', '47308', '47309', '47312', '47313', '47314', '47317', '47318', '47319', '47320', '47321', '47322', '47323', '47324', '47326', '47327', '47328', '47329', '47330', '47331', '47334', '47336', '47338', '47339', '47343', '47345', '47346', '47348', '47349', '47350', '47352', '47354', '47356', '47357', '47359', '47361', '47362', '47363', '47364', '47365', '47366', '47367', '47368', '47369', '47370', '47373', '47374', '47376', '47377', '47378', '47379', '47381', '47382', '47383', '47384', '47385', '47387', '47388', '47398', '47399', '47400', '47401', '47404', '47405', '47406', '47407', '47408', '47409', '47412', '47414', '47415', '47416', '47417', '47418', '47419', '47420', '47421', '47423', '47426', '47427', '47428', '47429', '47430', '47431', '47433', '47434', '47435', '47436', '47438', '47439', '47441', '47442', '47443', '47444', '47445', '47446', '47447', '47448', '47449', '47450', '47451', '47452', '47453', '47454', '47455', '47456', '47458', '47459', '47462', '47463', '47464', '47465', '47466', '47467', '47468', '47469', '47470', '47471', '47472', '47473', '47493', '47494', '47495', '47496', '47497', '47498', '47499', '47500', '47501', '47502', '47503', '47504', '47510', '47511', '47512', '47513', '47514', '47515', '47516', '47517', '47518', '47519', '47520', '47521', '47522', '47523', '47524', '47525', '47526', '47527', '47528', '47529', '47531', '47532', '47533', '47561', '47564', '47569', '47570', '47571', '47573', '47576', '47579', '47580', '47584', '47586', '47588', '47589', '47591', '47594', '47599', '47600', '47607', '47608', '47612', '47614', '47616', '47694', '47695', '47702', '47705', '47707', '47710', '47711', '47715', '47716', '47718', '47722', '47723', '47729', '47732', '47735', '47738', '47744', '47745', '47749', '47750', '47751', '47753', '47754', '47755', '47762', '47763', '47764', '47768', '47771', '47774', '47777', '47785', '47789', '47794', '47796', '47799', '47804', '47808', '47815', '47818', '47824', '47835', '47843', '47867', '47880', '47882', '47892', '47898', '47901', '47906', '47914', '47929', '47985', '47996', '48006', '48023', '48032', '48036', '48039', '48040', '48041', '48047', '48051', '48061', '48076', '48078', '48083', '48086', '48089', '48093', '48095', '48096', '48101', '48103', '48109', '48116', '48127', '48137', '48138', '48155', '48157', '48172', '48189', '48195', '48199', '48201', '48206', '48212', '48230', '48236', '48237', '48241', '48242', '48244', '48250', '48253', '48261', '48263', '48266', '48273', '48276', '48284', '48331', '48332', '48339', '48343', '48395', '48404', '48406', '48407', '48408', '48409', '48411', '48413', '48443', '48447', '48448', '48454', '48461', '48468', '48474', '48475', '48480', '48481', '48491', '48498', '48499', '48500', '48506', '48512', '48517', '48519', '48521', '48522', '48523', '48532', '48535', '48536', '48538', '48540', '48541', '48542', '48551', '48553', '48554', '48557', '48560', '48562', '48564', '48577', '48585', '48586', '48603', '48607', '48608', '48613', '48614', '48619', '48633', '48638', '48639', '48641', '48642', '48652', '48657', '48659', '48666', '48672', '48677', '48680', '48683', '48686', '48687', '48691', '48692', '48697', '48701', '48702', '48706', '48712', '48719', '48720', '48727', '48731', '48732', '48736', '48740', '48742', '48743', '48745', '48750', '48755', '48758', '48761', '48765', '48768', '48771', '48777', '48782', '48786', '48824', '48832', '48833', '48834', '48840', '48844', '48851', '48856', '48911', '48921', '48923', '48927', '48932', '48935', '48937', '48938', '48940', '48947', '48950', '48953', '48954', '48987', '48989', '48991', '48992', '48994', '48996', '48997', '49054', '49062', '49069', '49074', '49076', '49077', '49087', '49090', '49093', '49096', '49101', '49106', '49109', '49111', '49139', '49166', '49202', '49206', '49208', '49216', '49223', '49229', '49237', '49242', '49248', '49250', '49255', '49258', '49261', '49265', '49266', '49278', '49287', '49291', '49293', '49296', '49297', '49299', '49301', '49308', '49309', '49324', '49326', '49328', '49337', '49343', '49344', '49367', '49368', '49373', '49383', '49384', '49385', '49388', '49389', '49399', '49450', '49456', '49665', '49674', '49675', '49677', '49678', '49679', '49681', '49682', '49684', '49685', '49719', '49720', '49798', '49854', '49855', '49869', '49890', '49899', '49986', '50006', '50008', '50012', '50013', '50015', '50017', '50018', '50023', '50026', '50029', '50032', '50034', '50035', '50036', '50037', '50040', '50041', '50047', '50056', '50058', '50061', '50062', '50065', '50066', '50067', '50068', '50070', '50071', '50080', '50082', '50083', '50085', '50087', '50088', '50089', '50096', '50105', '50107', '50109', '50111', '50112', '50116', '50137', '50156', '50157', '50165', '50171', '50232', '50234', '50244', '50247', '50249', '50253', '50261', '50264', '50268', '50269', '50270', '50271', '50272', '50273', '50501', '50503', '50504', '50506', '50507', '50512', '50513', '50517', '50518', '50520', '50523', '50555', '50593', '50598', '50622', '50659', '50668', '50876', '51100', '51215', '51216', '51226', '51229', '51230', '51288', '51289', '51293', '51295', '51297', '51397', '51399', '51402', '51411', '51418', '51452', '51546', '51558', '51635', '51675', '51971', '52143', '52211', '52216', '52237', '52243', '52249', '52252', '52255', '52257', '52477', '52479', '52482', '52483', '52485', '52488', '52495', '52496', '52505', '52508', '52511', '52515', '52519', '52526', '52528', '52531', '52537', '52540', '52541', '52560', '52562', '52577', '52579', '52582', '52583', '52585', '52586', '52587', '52589', '52590', '52591', '52593', '52594', '52595', '52597', '52598', '52601', '52602', '52604', '52605', '52606', '52609', '52612', '52613', '52616', '52617', '52618', '52621', '52683', '52685', '52686', '52687', '52688', '52689', '52690', '52692', '52693', '52696', '52697', '52698', '52699', '52703', '52705', '52719', '52721', '52725', '52726', '52727', '52730', '52733', '52734', '52735', '52736', '52738', '52739', '52741', '52742', '52743', '52745', '52746', '52747', '52748', '52749', '52751', '52753', '52756', '52760', '52763', '52764', '52766', '52767', '52768', '52769', '52770', '52771', '52774', '52775', '52777', '52778', '52779', '52780', '52782', '52783', '52785', '52820', '52822', '52857', '52919', '52921', '52923', '52924', '52932', '52935', '52937', '52941', '52951', '52955', '52966', '52977', '52981', '52983', '52989', '52996', '53001', '53002', '53003', '53005', '53006', '53008', '53011', '53040', '53041', '53042', '53050', '53051', '53052', '53053', '53054', '53056', '53083', '53120', '53208', '53209', '53276', '53282', '53308', '53365', '53368', '53369', '53370', '53371', '53373', '53381', '53393', '53397', '53400', '53405', '53407', '53408', '53410', '53412', '53418', '53434', '53457', '53459', '53499', '53506', '53512', '53552', '53556', '53575', '53581', '53721', '53722', '53726', '53747', '53762', '53794', '53817', '53824', '53834', '53835', '53837', '53862', '53868', '53912', '53916', '53920', '53926', '53935', '53937', '53941', '53948', '53957', '53974', '54032', '54060', '54078', '54085', '54089', '54124', '54125', '54149', '54154', '54157', '54173', '54196', '54209', '54216', '54225', '54300', '54301', '54303', '54305', '54306', '54309', '54312', '54316', '54319', '54321', '54324', '54326', '54327', '54338', '54352', '54353', '54369', '54375', '54385', '54439', '54500', '54572', '54631', '54695', '54696', '54736', '54739', '54747', '54752')) AND (language IN ('en', 'ru', 'kk', 'es', 'fr', 'ar', 'zh-hans', 'und')) AND (deleted = '0')
ORDER BY delta ASC;
# Time: 170209 18:13:57
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.337267 Lock_time: 0.000051 Rows_sent: 1 Rows_examined: 511
SET timestamp=1486642437;
SELECT SUM(t.visits) AS expression
FROM
access_counter t
WHERE (t.entity_type = 'node') AND (t.entity_id = '29220');
# Time: 170209 18:13:59
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.131874 Lock_time: 0.000051 Rows_sent: 1 Rows_examined: 1485
SET timestamp=1486642439;
SELECT SUM(t.visits) AS expression
FROM
access_counter t
WHERE (t.entity_type = 'node') AND (t.entity_id = '21412');
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.786722 Lock_time: 0.000086 Rows_sent: 30330 Rows_examined: 75966
SET timestamp=1486642439;
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 = 'es' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# Time: 170209 18:14:11
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 3.188942 Lock_time: 0.000257 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642451;
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 = 'energiya') OR (i.word = 'budushchego') )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 '% energiya %' ESCAPE '\\') AND (d.data LIKE '% budushchego %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:14:13
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.743460 Lock_time: 0.000212 Rows_sent: 10 Rows_examined: 11327
SET timestamp=1486642453;
SELECT i.type AS type, i.sid AS sid, SUM((82.4245116088 * 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 = 'energiya') OR (i.word = 'budushchego') )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 '% energiya %' ESCAPE '\\') AND (d.data LIKE '% budushchego %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 20;
# Time: 170209 18:14:36
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.985532 Lock_time: 0.000088 Rows_sent: 30330 Rows_examined: 75967
SET timestamp=1486642476;
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 = 'ar' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# Time: 170209 18:14:47
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 5.125734 Lock_time: 0.000226 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642487;
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 = 'energetika') OR (i.word = 'budushchego') )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 '% energetika %' ESCAPE '\\') AND (d.data LIKE '% budushchego %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:14:48
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.684839 Lock_time: 0.000178 Rows_sent: 10 Rows_examined: 11163
SET timestamp=1486642488;
SELECT i.type AS type, i.sid AS sid, SUM((95.7923508028 * 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 = 'energetika') OR (i.word = 'budushchego') )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 '% energetika %' ESCAPE '\\') AND (d.data LIKE '% budushchego %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 30;
# Time: 170209 18:15:08
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 4.386070 Lock_time: 0.000201 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642508;
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 = 'energiya') OR (i.word = 'budushchego') )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 '% energiya %' ESCAPE '\\') AND (d.data LIKE '% budushchego %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:15:28
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.491503 Lock_time: 0.000109 Rows_sent: 30330 Rows_examined: 75967
SET timestamp=1486642528;
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 = 'zh-hans' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.676387 Lock_time: 0.000136 Rows_sent: 15 Rows_examined: 3035
SET timestamp=1486642528;
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_teaser_node_entity_type
FROM
node node
WHERE (( (node.status = '1') AND (node.type IN ('news')) AND (node.language IN ('ru')) ))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 (node.nid = na.nid) ))
ORDER BY node_created DESC
LIMIT 15 OFFSET 0;
# Time: 170209 18:15:29
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 3.273322 Lock_time: 0.000162 Rows_sent: 1 Rows_examined: 15552
SET timestamp=1486642529;
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 = 'zan') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' 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(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 1 OFFSET 0;
# Time: 170209 18:15:31
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.294442 Lock_time: 0.000177 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642531;
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 = 'zan') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# Time: 170209 18:15:33
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.519244 Lock_time: 0.000148 Rows_sent: 10 Rows_examined: 17491
SET timestamp=1486642533;
SELECT i.type AS type, i.sid AS sid, SUM((167.4470044450 * 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 = 'zan') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 1930;
# Time: 170209 18:16:03
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 4.005227 Lock_time: 0.000194 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642563;
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 = 'bilim') )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 '% bilim %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# Time: 170209 18:16:04
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.644969 Lock_time: 0.000167 Rows_sent: 10 Rows_examined: 21633
SET timestamp=1486642564;
SELECT i.type AS type, i.sid AS sid, SUM((428.0545545281 * 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 = 'bilim') )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 '% bilim %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 2860;
# Time: 170209 18:16:25
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 4.634720 Lock_time: 0.000188 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642585;
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 = 'bilim') )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 '% bilim %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# Time: 170209 18:16:27
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.160448 Lock_time: 0.002608 Rows_sent: 3799 Rows_examined: 3799
SET timestamp=1486642587;
SELECT base.fid AS fid, base.uid AS uid, base.filename AS filename, base.uri AS uri, base.filemime AS filemime, base.filesize AS filesize, base.status AS status, base.timestamp AS timestamp
FROM
file_managed base
WHERE (base.fid IN ('7954', '7963', '7966', '7969', '8004', '8005', '8018', '8080', '8107', '8113', '8143', '8162', '8220', '8225', '8226', '8260', '8272', '8286', '8295', '8296', '8328', '8346', '8352', '8382', '8383', '8420', '8427', '8452', '8505', '8511', '8514', '8641', '8649', '8696', '8788', '8843', '8913', '8914', '8944', '8985', '8995', '9030', '9037', '9118', '9133', '9153', '9154', '0', '9188', '9200', '9231', '9236', '9243', '9250', '9253', '9274', '9311', '9341', '9375', '9390', '9453', '9456', '9472', '9495', '9564', '9585', '0', '9598', '9607', '9625', '9652', '9666', '9682', '9710', '9724', '9731', '9734', '9753', '9755', '9758', '0', '9783', '9854', '9890', '9905', '9928', '10193', '10018', '10036', '10046', '10083', '10102', '10156', '10224', '10234', '10237', '10260', '10270', '10324', '10376', '10383', '10389', '10407', '10408', '10445', '10448', '10457', '10496', '10505', '10509', '10565', '10642', '10661', '10668', '10718', '10719', '10722', '10769', '10802', '10836', '10838', '10867', '10878', '10906', '10917', '10954', '10997', '11010', '11020', '11025', '11028', '11036', '11053', '11059', '0', '11147', '11149', '11173', '11174', '11193', '11194', '11202', '11230', '11233', '11238', '11241', '11277', '11287', '11299', '11303', '0', '11314', '11320', '11331', '11334', '11337', '11338', '11343', '11344', '11354', '11355', '11357', '11370', '11382', '11403', '11404', '11405', '11408', '11410', '11416', '11417', '11425', '11430', '11444', '11458', '11465', '11468', '11480', '11483', '11486', '11487', '11493', '11495', '11499', '11505', '11507', '11508', '11509', '11517', '11519', '11534', '11540', '11541', '11542', '11549', '11570', '11571', '11572', '11573', '11577', '11632', '11641', '11642', '11643', '11677', '11719', '11767', '11833', '11834', '11843', '11850', '11915', '12004', '12011', '12021', '12034', '12037', '12045', '12057', '12059', '12065', '12067', '12088', '12089', '12091', '12093', '12101', '12104', '12111', '12118', '12148', '12152', '12159', '12194', '12219', '12239', '12245', '12258', '12260', '12281', '12287', '12289', '12292', '12296', '12300', '12301', '12304', '12307', '12314', '12318', '12359', '12361', '12377', '12382', '12387', '12391', '12393', '12396', '12397', '12404', '12406', '12409', '12412', '12424', '12430', '12439', '12442', '12443', '12447', '12449', '12451', '12456', '12459', '12460', '12468', '12470', '12486', '12495', '12498', '12501', '12505', '12506', '12509', '12513', '12528', '12529', '12530', '12531', '12532', '12550', '12551', '12555', '12557', '12562', '12565', '12574', '12575', '12577', '12578', '12581', '12582', '12584', '12585', '12589', '0', '12593', '12594', '12599', '12600', '12605', '12607', '12608', '12612', '12613', '12614', '12617', '12623', '12626', '12629', '12631', '12632', '12643', '12653', '12655', '12658', '12662', '12669', '12673', '12680', '12685', '12688', '12695', '12697', '12700', '12706', '12719', '12734', '12738', '12747', '12748', '12752', '12753', '12796', '12819', '12820', '12826', '12828', '12835', '12837', '12876', '12878', '12879', '12885', '12887', '12893', '12897', '12904', '12910', '12929', '12938', '12969', '12979', '12980', '12982', '12995', '12998', '13018', '13022', '13025', '13028', '13032', '13034', '13042', '13043', '13050', '13051', '13066', '13075', '13081', '13083', '13084', '13086', '13098', '13101', '13105', '13109', '13123', '13137', '13148', '13149', '13154', '13171', '13172', '13173', '13175', '13185', '13201', '13207', '13231', '13240', '13246', '13268', '13295', '13338', '13361', '13362', '13369', '13382', '13404', '13407', '13414', '13418', '13427', '13454', '13459', '13470', '13476', '13480', '13505', '13512', '13520', '13530', '13539', '13547', '13563', '13580', '13581', '13586', '13590', '13592', '13600', '13606', '13611', '13637', '13643', '13648', '13660', '13670', '13673', '13676', '13677', '13684', '13691', '13730', '13733', '13756', '13770', '13781', '13782', '13787', '13791', '13795', '13800', '13809', '13811', '13812', '13821', '13823', '13835', '13854', '13857', '13876', '13878', '13879', '13890', '13891', '13897', '13898', '13900', '13901', '13911', '13913', '13930', '13959', '13960', '13964', '13966', '13976', '14003', '14006', '14028', '14031', '14037', '14058', '14069', '14099', '14124', '14129', '14133', '14149', '14159', '14163', '14164', '14166', '14167', '14168', '14203', '14213', '14214', '14234', '14237', '14241', '14244', '14245', '14246', '14247', '14249', '14255', '14269', '14274', '14282', '14284', '14294', '14295', '14314', '14318', '14321', '14323', '14326', '14344', '14355', '14376', '14377', '14379', '14388', '14397', '14400', '14415', '14425', '14426', '14434', '14457', '14461', '14469', '14490', '14491', '14492', '14501', '14503', '14524', '14525', '14529', '14531', '14532', '14534', '14540', '14559', '14571', '14576', '14582', '14587', '14592', '14650', '14653', '14658', '14660', '14664', '14681', '14688', '14716', '14723', '14730', '14749', '14763', '14770', '14772', '14781', '14786', '0', '14795', '14848', '14855', '14857', '14859', '14869', '14872', '14874', '14878', '14883', '14885', '14887', '14888', '14889', '14891', '14893', '14894', '14897', '14900', '14911', '14919', '14920', '14936', '14942', '14943', '14947', '14975', '14977', '14984', '15004', '15005', '15008', '15014', '15018', '15019', '15020', '15024', '15041', '15043', '15048', '15049', '15061', '15069', '15072', '15086', '15088', '15089', '15096', '15106', '15115', '15125', '15142', '15143', '15153', '15159', '15162', '15166', '15170', '15173', '15183', '15211', '15215', '15216', '15222', '15223', '15224', '15230', '15231', '15239', '15294', '15297', '15299', '15307', '15337', '15358', '15362', '15371', '15378', '15379', '15381', '15405', '15407', '15411', '15414', '15418', '15422', '15425', '15429', '15431', '15432', '15433', '15439', '15447', '15449', '15460', '15462', '15468', '15511', '15513', '15515', '15516', '15517', '15519', '15521', '15525', '15526', '15528', '15530', '15537', '15539', '15544', '15558', '15571', '15581', '15586', '15587', '15598', '15608', '15609', '15617', '15619', '15636', '15642', '15648', '15651', '15653', '15657', '15661', '15665', '15688', '15700', '15702', '15704', '15707', '15711', '15712', '15713', '15715', '15718', '15723', '15725', '15727', '15739', '15765', '15796', '15804', '15810', '15817', '15839', '15855', '15913', '15930', '16124', '16130', '16132', '16133', '16137', '0', '16187', '16216', '16217', '16219', '16222', '31093', '16232', '16246', '16260', '16261', '16279', '16280', '16282', '16292', '16301', '16305', '16317', '16334', '16337', '16354', '16411', '16471', '16508', '16529', '16532', '16539', '16573', '16599', '16603', '16605', '16629', '16637', '16662', '16664', '16674', '16679', '16754', '16756', '16781', '16792', '16802', '16811', '16819', '16824', '16829', '16849', '16853', '16866', '16870', '16876', '16886', '16887', '16891', '16903', '16918', '16920', '16949', '16971', '16987', '16989', '16995', '17033', '17071', '17072', '17081', '17082', '17104', '17158', '17162', '17164', '17187', '17196', '17229', '17236', '17242', '17302', '17304', '17311', '17319', '17328', '17333', '17376', '17379', '17380', '17386', '17394', '17397', '17421', '17422', '17527', '17530', '17535', '17562', '17566', '17582', '17592', '17598', '17602', '17607', '17611', '17612', '17613', '17614', '17618', '0', '17643', '17644', '17654', '17662', '17665', '17667', '17683', '17687', '17695', '17716', '17719', '17724', '17734', '17736', '17737', '17739', '17742', '17744', '17745', '17746', '17749', '17769', '17770', '17772', '17794', '17799', '17800', '17805', '17828', '17838', '17840', '17848', '17859', '17877', '17891', '17903', '17914', '17929', '17941', '17949', '17964', '18025', '18032', '18036', '18046', '18049', '18051', '18074', '18092', '18141', '18146', '18167', '18170', '18174', '18206', '18210', '18217', '18245', '18247', '18250', '18266', '18289', '18336', '18343', '18350', '18359', '18371', '18373', '18382', '18386', '18388', '18424', '18430', '18434', '18468', '18487', '18528', '18546', '18623', '18624', '18643', '18646', '18668', '18673', '18714', '18733', '18761', '18850', '18852', '18854', '18867', '18901', '18924', '18926', '18932', '18935', '18943', '18946', '18951', '18967', '18981', '18983', '19017', '19020', '19054', '19116', '19123', '19130', '19153', '19162', '19172', '19200', '19204', '19225', '19227', '19243', '19247', '19263', '19267', '19282', '19292', '19305', '19309', '19318', '19351', '19371', '19404', '19421', '19422', '19423', '19439', '19441', '19444', '19456', '19464', '19473', '19475', '19488', '19494', '19501', '19508', '19511', '19563', '19576', '19580', '19598', '19599', '19620', '19627', '19631', '19640', '19673', '19678', '19716', '19729', '19741', '19783', '19787', '19795', '19827', '19841', '19854', '19858', '19879', '19880', '19886', '19890', '19892', '19902', '19904', '19908', '19911', '19927', '19939', '19944', '19949', '19951', '19955', '19957', '19958', '19967', '19969', '19971', '19978', '19980', '19982', '19987', '19993', '19996', '20015', '20023', '20028', '20031', '20036', '20050', '20061', '20062', '20079', '20081', '20095', '20104', '20105', '20155', '20164', '20166', '20173', '20183', '20184', '20186', '20190', '20196', '20202', '20213', '20216', '20221', '20265', '20310', '20316', '20320', '20333', '20343', '20345', '20352', '20358', '20371', '20388', '20395', '20407', '20411', '20431', '20500', '20502', '20505', '20506', '20511', '20524', '20528', '20534', '20546', '20562', '20603', '20605', '20611', '20619', '20630', '20638', '20651', '20685', '20710', '20725', '20752', '20770', '20805', '20814', '20815', '20829', '20831', '20839', '20878', '20935', '20946', '20948', '20965', '20974', '20980', '20988', '20990', '20994', '20999', '21000', '21003', '21028', '21045', '21078', '21098', '21104', '21137', '21140', '21141', '21147', '21164', '21166', '21177', '21199', '21234', '21236', '21238', '21265', '21301', '21305', '21308', '21319', '21321', '21349', '21366', '21369', '21371', '21375', '21376', '21397', '21403', '21410', '21424', '21456', '21460', '21461', '21476', '21495', '21496', '21504', '21517', '21522', '21526', '21529', '21531', '21571', '21572', '21580', '21585', '21622', '21628', '21630', '21637', '21653', '21663', '21665', '21690', '21694', '21710', '21715', '21718', '21728', '21736', '21737', '21741', '21744', '21745', '21746', '21754', '21758', '21761', '21767', '21768', '21819', '21845', '21875', '21915', '21918', '21919', '21957', '21959', '21973', '21987', '21990', '22764', '21993', '22006', '22012', '22018', '22025', '22030', '22033', '22043', '22062', '22063', '22067', '22068', '22079', '22094', '22136', '22150', '22151', '22185', '22190', '22213', '22214', '22217', '22242', '0', '22264', '22270', '22288', '22318', '22343', '22353', '22364', '22368', '22387', '22441', '22453', '22472', '22482', '22577', '22591', '22594', '22597', '22635', '22678', '22691', '22698', '0', '22706', '22770', '22779', '22788', '22802', '22819', '22843', '22867', '22924', '22975', '23012', '23014', '23020', '23037', '23039', '23041', '23043', '23089', '23114', '23118', '23149', '23151', '23190', '23192', '23200', '23220', '23221', '23238', '23239', '23240', '23242', '23243', '23257', '23266', '23275', '23329', '23330', '23331', '23336', '23338', '23339', '23356', '23362', '23388', '23397', '23399', '23424', '23427', '23430', '23453', '23469', '23479', '23483', '23498', '23516', '23523', '23533', '23584', '23597', '23603', '23604', '23617', '23619', '23651', '23652', '23663', '23664', '23667', '23675', '23696', '23706', '23710', '23729', '23766', '23800', '23809', '23815', '23825', '23896', '23901', '23904', '23905', '23906', '23907', '23912', '23942', '23957', '23960', '23963', '23964', '23986', '24005', '24009', '24010', '24033', '24092', '24203', '24255', '24268', '24307', '24325', '24439', '24443', '24485', '24488', '24553', '24578', '24601', '24691', '24805', '24870', '24871', '24907', '24916', '24929', '24953', '25010', '25026', '25050', '25069', '25150', '25352', '25407', '25473', '25491', '25514', '25521', '25534', '25555', '25574', '25606', '25633', '25692', '25798', '25888', '25948', '25992', '25996', '26001', '26042', '26136', '26145', '26168', '26176', '26194', '26209', '26218', '26266', '26281', '26290', '29113', '26373', '26374', '26375', '26412', '26572', '26621', '26629', '26694', '26711', '26837', '26850', '26852', '27054', '27176', '27224', '27296', '27329', '27376', '27379', '27388', '27397', '27415', '27445', '27557', '27580', '27693', '27871', '27993', '28003', '28019', '28049', '28056', '28129', '28148', '28191', '28206', '28241', '28255', '28279', '28313', '28359', '28377', '28387', '28392', '28449', '28450', '28686', '28774', '28798', '28817', '28828', '28930', '28933', '28970', '28975', '29023', '29026', '29039', '0', '29298', '29344', '29428', '29545', '29671', '29709', '29777', '29804', '29827', '29835', '30032', '30064', '30070', '30080', '30091', '30197', '30204', '30290', '30356', '30358', '30416', '30425', '30432', '30434', '30441', '30473', '30474', '30493', '30494', '30523', '30594', '30607', '30622', '30630', '30643', '30651', '30671', '30683', '30704', '30711', '30723', '30725', '30745', '30753', '30760', '30794', '30817', '30826', '30842', '30862', '30873', '30876', '30886', '30893', '30900', '30905', '30910', '30911', '30913', '30918', '30924', '30925', '30954', '30974', '30976', '30983', '31011', '31025', '31082', '31099', '31144', '31159', '31160', '31218', '31220', '31227', '31238', '31249', '31262', '31267', '31282', '31284', '31292', '31316', '31364', '31378', '31386', '31392', '31396', '0', '31405', '31409', '31461', '31481', '31542', '31543', '31610', '31612', '31624', '31629', '31667', '31668', '31683', '31733', '31747', '31787', '31856', '31861', '31865', '31892', '31893', '31911', '31914', '31918', '31919', '31921', '31930', '31934', '31937', '31950', '31966', '31973', '31980', '31982', '31983', '31987', '31992', '31999', '32001', '32003', '32004', '32005', '32008', '32017', '32021', '32026', '32028', '32032', '32043', '32044', '32076', '32093', '32095', '32101', '32103', '32131', '32135', '32139', '32148', '32155', '32162', '32183', '32193', '32230', '32231', '32234', '32263', '32265', '32272', '32275', '32286', '32291', '32294', '32302', '32349', '32356', '32387', '32425', '32459', '32463', '32500', '32514', '32530', '32533', '32610', '32623', '32624', '32637', '32659', '32665', '32668', '32679', '32687', '32696', '32698', '32700', '32723', '32778', '32800', '32805', '32814', '32824', '32864', '32865', '32870', '32906', '32924', '32937', '32949', '32951', '32964', '32965', '32966', '32971', '32978', '32993', '33023', '33042', '33043', '33047', '33055', '33082', '33089', '33091', '33093', '33103', '33123', '33189', '33195', '33199', '33202', '33217', '33270', '33272', '33277', '33281', '33289', '33293', '33299', '33317', '33321', '33330', '33343', '33350', '33351', '33384', '33393', '33394', '33424', '33432', '33469', '33514', '33520', '33532', '33538', '33555', '33574', '33575', '33588', '33590', '33595', '33600', '33618', '33623', '33626', '33630', '33632', '33653', '33659', '33664', '33674', '33680', '33693', '33751', '33765', '33777', '33784', '33787', '33807', '33809', '33810', '33832', '33835', '33846', '33873', '33906', '33907', '33909', '33936', '33938', '33965', '33970', '33978', '33980', '33982', '33988', '33989', '34007', '34013', '34027', '34058', '34063', '34072', '34079', '34110', '34144', '34148', '34157', '34163', '34174', '34185', '34194', '34217', '34229', '34233', '34241', '34272', '34277', '34289', '34291', '34340', '34347', '34409', '34434', '34456', '34468', '34480', '34490', '34517', '34532', '34535', '34536', '34612', '34620', '34638', '34639', '34644', '34649', '34686', '34736', '34746', '34750', '34751', '34757', '34776', '34777', '34789', '34804', '34805', '34827', '34829', '34830', '34833', '34869', '34884', '34901', '34902', '34909', '34910', '34920', '34955', '34993', '34999', '35006', '35032', '35049', '35070', '35113', '35163', '35179', '35226', '35241', '35243', '35246', '35256', '35284', '35306', '35315', '35338', '35346', '35347', '35350', '35362', '35364', '35375', '35380', '35395', '35405', '35417', '35421', '35427', '35460', '35462', '35471', '35490', '35510', '35523', '35527', '35538', '35558', '35567', '35573', '35583', '35638', '35650', '35651', '35655', '35688', '35710', '35729', '35777', '35804', '35818', '35827', '35914', '35925', '35943', '0', '0', '35965', '35991', '36003', '36020', '36101', '36149', '36164', '36186', '36189', '36199', '36208', '36244', '36299', '36302', '36310', '36319', '36346', '36355', '36364', '36375', '36390', '36391', '36441', '36488', '36489', '36494', '36495', '36500', '36501', '36552', '36596', '36597', '36629', '36669', '36670', '36718', '36725', '36774', '36788', '36789', '36826', '36834', '36841', '36861', '36911', '36917', '36926', '36927', '36929', '36940', '36943', '36944', '36947', '36968', '37003', '37004', '37039', '37045', '37048', '37075', '37103', '37224', '37232', '37233', '37263', '37296', '37314', '37322', '37327', '37353', '37372', '37422', '37427', '37438', '37447', '37479', '37482', '37483', '37521', '37537', '37543', '37555', '37562', '37563', '37583', '37589', '37593', '37595', '37600', '37610', '37645', '37720', '37738', '37739', '37769', '37781', '37799', '37811', '37833', '37840', '37847', '37848', '37855', '37901', '37927', '37935', '37957', '37960', '37966', '37982', '38010', '38011', '38013', '38038', '38058', '38117', '38119', '38121', '38164', '38186', '38187', '38198', '38208', '38222', '38225', '38226', '38232', '38234', '38245', '38249', '38250', '38255', '38286', '38289', '38331', '38430', '38474', '38527', '38661', '38697', '38755', '38758', '38777', '38828', '38930', '38941', '38976', '38985', '39012', '39021', '39053', '39093', '39142', '39145', '39158', '39164', '39176', '39177', '39191', '39195', '39197', '39212', '39222', '39233', '39256', '39261', '39311', '39312', '39345', '39364', '39384', '39391', '39393', '39397', '39399', '39410', '39423', '39469', '39527', '39610', '39624', '39634', '39657', '39658', '39699', '39712', '39724', '39733', '39744', '39761', '39779', '39838', '39869', '39870', '39877', '39880', '39881', '39882', '39884', '39885', '39887', '39890', '39891', '39898', '39914', '39928', '39942', '39979', '40007', '40013', '40031', '40042', '40058', '40062', '40132', '40133', '40138', '40146', '40148', '40152', '40178', '40179', '40183', '40184', '40185', '40187', '40188', '40189', '40196', '40199', '40200', '40210', '40211', '40212', '40214', '40215', '40217', '40223', '40228', '40232', '40233', '40238', '40243', '40244', '40245', '40299', '40300', '40302', '40321', '40322', '40323', '40332', '40356', '40362', '40371', '40372', '40383', '40391', '40394', '40398', '40405', '40406', '40408', '40409', '40422', '40429', '40450', '40453', '40455', '40497', '40499', '40513', '40517', '40518', '40521', '40527', '40531', '40533', '40540', '40589', '40590', '40594', '40595', '40601', '40664', '40665', '40667', '40668', '40686', '40698', '40700', '40702', '40704', '40705', '40706', '40713', '40721', '40724', '40725', '40727', '40731', '40746', '40758', '40760', '40761', '40765', '40766', '40769', '40775', '40776', '40777', '40788', '40793', '40795', '40798', '40799', '40802', '40811', '40813', '40819', '40844', '40855', '40856', '40860', '40862', '40865', '40928', '40944', '40959', '40980', '40983', '40987', '40993', '41007', '41008', '41010', '41039', '41052', '41112', '41128', '41131', '41132', '41133', '41134', '41135', '41137', '41142', '41153', '41154', '41189', '41194', '41201', '41221', '41222', '41225', '41250', '41262', '41266', '41269', '41282', '41291', '41293', '41305', '41306', '41308', '41317', '41318', '41330', '41336', '41340', '41344', '41364', '41431', '41434', '41441', '41442', '41486', '41503', '41522', '41524', '41525', '41527', '41528', '41530', '41536', '41601', '41612', '0', '41618', '41620', '41642', '41647', '41648', '41713', '41737', '41749', '41758', '41765', '41819', '41820', '41834', '41849', '41876', '41881', '41911', '41923', '41949', '41971', '42013', '42032', '42097', '42103', '42110', '42128', '42135', '42275', '42288', '42322', '42354', '42360', '42359', '42363', '42370', '42371', '42375', '42379', '42388', '42392', '42396', '42399', '42424', '42471', '42490', '42515', '42522', '42608', '42704', '42782', '42793', '42794', '42798', '42821', '42841', '42966', '42972', '43026', '43052', '43053', '43058', '0', '43070', '43079', '43080', '43086', '43090', '43091', '43093', '43096', '43120', '43130', '43133', '43142', '43143', '43145', '43146', '43153', '43154', '43161', '43162', '43164', '43165', '43185', '43189', '43197', '43203', '43206', '43216', '43218', '43224', '43227', '43233', '43235', '43236', '43242', '43246', '43251', '43255', '43260', '43262', '43279', '43280', '43288', '43294', '43295', '43301', '43303', '43304', '43311', '43317', '43322', '43323', '43324', '43329', '43333', '43334', '43336', '43337', '43343', '43348', '43351', '43352', '43353', '43364', '43365', '43369', '43370', '43371', '43375', '43381', '43392', '43396', '43398', '43400', '43404', '43415', '43418', '43429', '43438', '43444', '43451', '43458', '43461', '0', '0', '0', '43466', '43473', '43467', '43471', '43491', '43492', '43532', '43535', '43542', '43567', '43568', '43569', '43570', '43581', '43635', '43615', '43617', '43671', '43677', '43680', '43712', '43730', '43738', '43770', '43785', '43786', '43801', '43865', '43878', '43981', '43996', '43997', '44021', '44052', '44060', '44070', '44107', '44142', '44149', '44157', '44168', '44189', '44190', '44256', '44267', '44289', '44358', '0', '44442', '44445', '0', '44488', '44528', '44580', '44585', '0', '44593', '44597', '44612', '44616', '44627', '44628', '0', '44660', '0', '44774', '44828', '44866', '44867', '44888', '44907', '44958', '44973', '45050', '45080', '45140', '45222', '45298', '0', '45316', '45362', '45392', '45436', '45485', '45639', '45655', '45722', '45724', '45737', '45744', '0', '45764', '45796', '45799', '45859', '45866', '0', '45923', '45926', '0', '45964', '0', '0', '45976', '45988', '46026', '46046', '46049', '46057', '46058', '0', '0', '46092', '46094', '46095', '46096', '46113', '46114', '0', '46159', '0', '46168', '46169', '46173', '46182', '46187', '46189', '46190', '46197', '46200', '46202', '46207', '46216', '46218', '46224', '46228', '46231', '0', '46243', '46246', '46256', '46275', '46281', '46285', '46304', '46310', '46314', '0', '0', '0', '0', '46385', '46390', '46392', '46402', '46403', '46412', '46422', '46423', '0', '46477', '46489', '46492', '0', '0', '46528', '46529', '46530', '46532', '46537', '0', '46564', '46570', '46602', '46608', '46676', '0', '0', '46782', '46789', '46790', '46838', '46850', '46875', '46881', '46928', '46961', '46967', '46980', '46984', '46999', '47000', '47011', '47022', '47055', '47093', '47100', '47102', '47114', '47118', '47129', '47142', '47159', '0', '47176', '47229', '47233', '47244', '47250', '47253', '47322', '47339', '47343', '47346', '47347', '47348', '47371', '47386', '47413', '0', '47472', '47477', '47481', '47493', '47520', '47521', '0', '47559', '47556', '47601', '0', '47622', '47628', '47633', '47651', '47680', '0', '47777', '47787', '47792', '47794', '47811', '47818', '47830', '47844', '0', '0', '0', '48825', '47891', '47892', '47895', '0', '47975', '47983', '47991', '48008', '0', '48182', '0', '48251', '48291', '48295', '48361', '48376', '48390', '48397', '48400', '48401', '48403', '48535', '48575', '48609', '48626', '48627', '48631', '48654', '48669', '48677', '48682', '48689', '48692', '48698', '48717', '48720', '48732', '48777', '48818', '48834', '48835', '48843', '48845', '48850', '48902', '48915', '48929', '48933', '48946', '48947', '48954', '48964', '48995', '49016', '49019', '49022', '49042', '49063', '49078', '49080', '49085', '49096', '49099', '49106', '49116', '49121', '49126', '49142', '49156', '49163', '49173', '49178', '0', '49202', '49230', '49257', '49311', '49371', '49375', '49383', '49425', '49429', '49455', '49459', '49469', '67145', '49495', '66742', '49523', '49540', '49547', '49560', '49562', '49585', '49621', '49634', '49641', '49642', '49645', '0', '49659', '49663', '49672', '49681', '49683', '49687', '49695', '49712', '49716', '49720', '49725', '49728', '49729', '49730', '49742', '49743', '49751', '49746', '49747', '49766', '49769', '49787', '49803', '49806', '49814', '0', '0', '0', '49850', '49873', '49874', '0', '49948', '49950', '49969', '49988', '50006', '50048', '50059', '50115', '0', '50158', '50159', '50163', '51743', '50179', '50345', '50258', '50301', '0', '50304', '50305', '50307', '50316', '50320', '50347', '50377', '50414', '50434', '50460', '50492', '50497', '50498', '50499', '50508', '50512', '50513', '50515', '50532', '50533', '50552', '50560', '50575', '50576', '50590', '50591', '50595', '50599', '50610', '50621', '50634', '50635', '50639', '50730', '50731', '50750', '50762', '50766', '50775', '50781', '50787', '50793', '50795', '50843', '50852', '50893', '50898', '50906', '50917', '50921', '50923', '50927', '50930', '50935', '50941', '50942', '50946', '50966', '50974', '50976', '50977', '50983', '50984', '50991', '50996', '50999', '51002', '0', '51009', '51018', '51028', '51045', '51048', '51061', '51063', '51077', '51136', '51180', '51196', '51200', '51215', '51221', '51232', '51240', '51248', '51250', '51259', '51267', '0', '51271', '51274', '51311', '51364', '51373', '51403', '51405', '51413', '51422', '0', '51431', '51432', '51451', '51454', '51460', '51461', '51470', '51473', '0', '51484', '51485', '51491', '51509', '51629', '0', '51700', '51752', '51878', '51889', '51913', '51934', '51993', '52000', '52063', '52216', '55695', '0', '52262', '52269', '52329', '52414', '52474', '52498', '52500', '52653', '52669', '52690', '52698', '52705', '52748', '0', '52803', '52809', '52815', '52827', '52864', '52941', '52978', '53009', '53191', '53229', '53314', '53336', '53339', '0', '53366', '53386', '53407', '53437', '53453', '53524', '53558', '53622', '53648', '53703', '53728', '53764', '53778', '53786', '53797', '53808', '53822', '53845', '53855', '53859', '53873', '53874', '53878', '53932', '53940', '53948', '53951', '54030', '54064', '54066', '54067', '54071', '54072', '54077', '54079', '54082', '54083', '54087', '54111', '54113', '54182', '54185', '54274', '54296', '54336', '54351', '54374', '54407', '54418', '54420', '54489', '54490', '54491', '54492', '54697', '54843', '54846', '54870', '54971', '54982', '54990', '55006', '0', '0', '55044', '55061', '55070', '55143', '55162', '55164', '0', '55218', '55224', '55262', '55271', '55283', '55294', '55320', '55348', '55400', '55416', '55421', '55489', '55491', '55496', '55497', '55498', '55538', '55542', '55555', '55581', '55608', '55625', '55639', '55641', '55645', '55647', '55649', '55704', '55735', '55771', '55775', '55799', '55808', '55837', '55865', '55874', '55894', '55987', '56044', '56062', '56063', '56174', '56188', '56236', '0', '0', '0', '56340', '56384', '56386', '56403', '56412', '56413', '56500', '56521', '56528', '56614', '56616', '56641', '56643', '56645', '56648', '56653', '56667', '56686', '56719', '56730', '56798', '56821', '56840', '56890', '56912', '56917', '56932', '56952', '56953', '56954', '0', '56964', '56972', '57007', '57009', '57042', '57143', '57193', '57198', '57203', '57238', '57239', '57250', '57259', '57266', '57281', '57287', '57324', '57346', '57352', '57354', '57358', '57361', '57362', '57365', '57367', '57375', '57377', '57379', '57381', '57384', '57421', '57444', '57449', '57457', '57459', '57465', '57474', '57523', '57636', '57661', '57679', '57709', '57727', '57786', '57802', '57808', '57856', '57905', '57907', '57932', '57933', '57937', '57946', '57947', '57955', '57991', '57998', '58007', '58049', '58051', '58060', '58087', '58144', '58147', '58192', '58206', '58214', '58216', '58220', '58304', '58346', '58351', '58393', '58456', '58469', '58476', '58520', '58683', '58796', '58804', '58831', '58875', '58878', '58922', '59041', '59042', '59081', '59082', '59094', '59107', '59114', '59122', '59247', '59306', '59311', '59402', '59416', '59431', '59494', '59512', '59526', '59537', '59571', '59603', '59615', '59622', '59669', '59720', '59735', '59736', '59739', '59741', '59746', '0', '59823', '59839', '59882', '59977', '0', '60024', '0', '0', '0', '60139', '60163', '60172', '60189', '60195', '60204', '60211', '60223', '60254', '60259', '60277', '60279', '60280', '60300', '60357', '60378', '60390', '60426', '60440', '60442', '60446', '60487', '60491', '60496', '60506', '60508', '60511', '60519', '60543', '60548', '60571', '60582', '60589', '60598', '60633', '60664', '60666', '60715', '60730', '60737', '60754', '60761', '60762', '60782', '60841', '60870', '60884', '60896', '60915', '60939', '60963', '60978', '61004', '61050', '61058', '61070', '61073', '61086', '61097', '61101', '61115', '61121', '61156', '61184', '61190', '61230', '61245', '61281', '61292', '61294', '61300', '61308', '61350', '61363', '61387', '61394', '61414', '61432', '61434', '61446', '61449', '61450', '61510', '61532', '61534', '61541', '61543', '61552', '61582', '61593', '61597', '61606', '61651', '61657', '61666', '61688', '61696', '61733', '61741', '61800', '61821', '61907', '61967', '61968', '61982', '62003', '62012', '62016', '62035', '62041', '62063', '62069', '62076', '62096', '62105', '62107', '62111', '62127', '62145', '62147', '62149', '62169', '62182', '62190', '62202', '62206', '62208', '62212', '62213', '62214', '62238', '62241', '62242', '62243', '62264', '62265', '62274', '62276', '62285', '62292', '62294', '62298', '62302', '62315', '62328', '62374', '62385', '62416', '62425', '62436', '62440', '62450', '62459', '62463', '62465', '0', '62470', '62484', '62567', '62573', '62626', '62642', '62659', '62665', '62669', '62671', '62672', '62695', '62740', '62797', '62799', '62800', '62811', '62813', '62815', '62821', '62839', '62841', '62842', '62843', '62847', '62850', '62854', '62858', '62860', '62863', '0', '62872', '62899', '62902', '62926', '62965', '62992', '62996', '62997', '63008', '63010', '63016', '63026', '63029', '63036', '63037', '63038', '63046', '63048', '63049', '63061', '63068', '63070', '63072', '63075', '63080', '63082', '63093', '63094', '63103', '63104', '63119', '63122', '63125', '63143', '63156', '0', '63163', '63193', '63211', '63228', '63258', '63287', '63296', '63317', '63333', '63365', '63370', '63372', '63375', '63386', '63391', '0', '63424', '63427', '63448', '63456', '63509', '63541', '63556', '63576', '63599', '63603', '63647', '63698', '63699', '63703', '63705', '63717', '63727', '63756', '63773', '63794', '63797', '63798', '63800', '63834', '63999', '64003', '64026', '64077', '64084', '64101', '64102', '64128', '64133', '64173', '64190', '64204', '0', '64222', '64256', '64260', '64279', '64281', '64325', '64328', '64329', '64338', '64347', '64350', '64355', '64358', '64374', '64380', '64402', '64470', '64472', '64486', '64494', '64497', '64498', '64531', '64544', '64554', '64576', '64580', '64584', '64594', '64595', '64601', '64614', '64620', '64630', '64639', '64641', '64832', '0', '64867', '64904', '64920', '64944', '64971', '65011', '65019', '65027', '65080', '65085', '65090', '65097', '65111', '65128', '65143', '65156', '65162', '65176', '65195', '65205', '65237', '65252', '65343', '65393', '65420', '65455', '65466', '65468', '65483', '65516', '65537', '65564', '65571', '65573', '65590', '65605', '0', '65621', '65628', '65631', '65640', '65671', '65674', '65692', '65693', '65733', '65744', '65751', '65755', '65768', '65780', '65781', '65798', '65804', '65807', '65823', '65827', '65829', '65864', '65870', '65887', '65895', '65899', '65929', '65954', '65970', '65977', '65978', '65987', '65992', '66003', '66005', '66015', '66031', '66034', '66043', '66047', '66081', '66097', '66102', '66105', '66113', '66132', '66142', '0', '0', '66239', '66248', '66249', '66259', '66313', '66315', '66320', '66335', '66340', '66349', '66366', '66386', '66404', '66406', '66429', '66437', '0', '66525', '66527', '66531', '66532', '66534', '66556', '66572', '66630', '0', '66638', '66640', '66645', '66656', '0', '66674', '66685', '66708', '66714', '66715', '66716', '66717', '66720', '66730', '66738', '66739', '66797', '66814', '66831', '66875', '66850', '66863', '66948', '66953', '66981', '66982', '66983', '66988', '67011', '67058', '67075', '67076', '67091', '67139', '67144', '67146', '67151', '67159', '67163', '67174', '67183', '0', '67196', '67200', '67203', '67210', '67218', '67221', '67227', '67230', '67231', '67247', '67258', '67282', '67332', '67339', '67344', '67345', '67368', '67410', '67421', '0', '67512', '67593', '67594', '67613', '67617', '67628', '67643', '67644', '67651', '67669', '67712', '67750', '67758', '67760', '0', '67767', '67770', '67773', '67779', '67799', '67808', '67815', '67819', '67833', '67835', '67838', '67841', '67846', '67852', '67856', '67863', '67867', '67879', '67883', '67886', '67888', '67899', '67941', '67942', '68014', '68027', '68039', '68041', '68052', '68063', '68071', '68091', '68108', '68111', '68114', '68113', '68122', '68129', '68132', '68136', '68139', '68152', '68153', '68162', '68173', '68180', '68186', '68192', '68242', '68246', '68247', '68248', '68250', '68263', '68269', '68275', '0', '68997', '68323', '68330', '0', '68357', '68360', '68364', '68368', '68370', '68386', '68418', '68433', '68437', '68443', '68446', '68448', '68466', '68469', '68474', '68478', '68497', '68529', '68535', '68540', '68544', '68548', '68555', '68557', '68578', '68584', '68620', '68631', '68633', '68634', '68641', '68642', '68644', '68648', '68649', '68652', '68653', '68659', '68663', '68668', '0', '68717', '68720', '68722', '68725', '68802', '68810', '68812', '68822', '68830', '68834', '68911', '68937', '0', '68974', '68981', '69001', '69016', '69087', '69098', '69108', '69118', '69140', '69150', '69180', '69198', '69211', '69215', '0', '69217', '69245', '69262', '69266', '69268', '69292', '69306', '69344', '69363', '69372', '69374', '69375', '0', '69429', '69444', '69466', '69495', '0', '69519', '69534', '69580', '69581', '69601', '69628', '69659', '69683', '69713', '69725', '69733', '69737', '69803', '69811', '69852', '69858', '69875', '69898', '69899', '69903', '69940', '69958', '69963', '69984', '0', '69991', '69992', '70003', '70025', '70044', '70100', '70130', '70149', '70151', '70169', '70174', '70194', '70200', '70204', '70205', '70214', '70218', '70249', '70251', '0'));
# Time: 170209 18:16:28
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.279504 Lock_time: 0.000181 Rows_sent: 10 Rows_examined: 21593
SET timestamp=1486642588;
SELECT i.type AS type, i.sid AS sid, SUM((428.0545545281 * 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 = 'bilim') )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 '% bilim %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 2820;
# Time: 170209 18:16:55
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 12.256455 Lock_time: 0.000174 Rows_sent: 1 Rows_examined: 53321
SET timestamp=1486642615;
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 = 'obrazovanie') OR (i.word = 'nauka') )AND (i.type = 'node') AND( (d.data LIKE '% obrazovanie %' ESCAPE '\\') AND (d.data LIKE '% i %' ESCAPE '\\') AND (d.data LIKE '% nauka %' 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: 170209 18:17:03
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 8.234595 Lock_time: 0.000207 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642623;
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 = 'obrazovanie') OR (i.word = 'nauka') )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 '% obrazovanie %' ESCAPE '\\') AND (d.data LIKE '% i %' ESCAPE '\\') AND (d.data LIKE '% nauka %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:17:11
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 7.427346 Lock_time: 0.000210 Rows_sent: 10 Rows_examined: 53350
SET timestamp=1486642631;
SELECT i.type AS type, i.sid AS sid, SUM((721.3970490993 * 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 = 'obrazovanie') OR (i.word = 'nauka') )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 '% obrazovanie %' ESCAPE '\\') AND (d.data LIKE '% i %' ESCAPE '\\') AND (d.data LIKE '% nauka %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 20;
# Time: 170209 18:18:02
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.589626 Lock_time: 0.000063 Rows_sent: 1 Rows_examined: 2407
SET timestamp=1486642682;
SELECT SUM(t.visits) AS expression
FROM
access_counter t
WHERE (t.entity_type = 'node') AND (t.entity_id = '25840');
# Time: 170209 18:18:03
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.024955 Lock_time: 0.000143 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642683;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
field_data_field_status field_data_field_status0
INNER JOIN field_data_field_views field_data_field_views1 ON field_data_field_views1.entity_type = field_data_field_status0.entity_type AND field_data_field_views1.entity_id = field_data_field_status0.entity_id
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 <= '1486643588') 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: 170209 18:18:12
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.027193 Lock_time: 0.000082 Rows_sent: 30330 Rows_examined: 78344
SET timestamp=1486642692;
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: 170209 18:18:31
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.667785 Lock_time: 0.000088 Rows_sent: 30330 Rows_examined: 77197
SET timestamp=1486642711;
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 = 'kk' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# Time: 170209 18:18:35
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.416251 Lock_time: 0.000169 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642715;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
field_data_field_status field_data_field_status0
INNER JOIN field_data_field_views field_data_field_views1 ON field_data_field_views1.entity_type = field_data_field_status0.entity_type AND field_data_field_views1.entity_id = field_data_field_status0.entity_id
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 <= '1486643619') 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: 170209 18:18:37
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.563733 Lock_time: 0.000076 Rows_sent: 30330 Rows_examined: 75968
SET timestamp=1486642717;
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 = 'ar' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 6.375259 Lock_time: 0.000177 Rows_sent: 1 Rows_examined: 14523
SET timestamp=1486642717;
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 = 'arag') OR (i.word = 'andy') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' 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: 170209 18:18:39
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.107547 Lock_time: 0.000186 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642719;
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 = 'arag') OR (i.word = 'andy') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:18:42
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.319502 Lock_time: 0.000196 Rows_sent: 10 Rows_examined: 15112
SET timestamp=1486642722;
SELECT i.type AS type, i.sid AS sid, SUM((49.3354352830 * 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 = 'arag') OR (i.word = 'andy') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 580;
# Time: 170209 18:19:01
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 4.895471 Lock_time: 0.000165 Rows_sent: 1 Rows_examined: 14523
SET timestamp=1486642741;
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 = 'arag') OR (i.word = 'andy') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' 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: 170209 18:19:03
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.728162 Lock_time: 0.000166 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642743;
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 = 'arag') OR (i.word = 'andy') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:19:06
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.527989 Lock_time: 0.000175 Rows_sent: 10 Rows_examined: 14732
SET timestamp=1486642746;
SELECT i.type AS type, i.sid AS sid, SUM((49.3354352830 * 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 = 'arag') OR (i.word = 'andy') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 200;
# Time: 170209 18:19:13
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 3.599251 Lock_time: 0.000157 Rows_sent: 1 Rows_examined: 14523
SET timestamp=1486642753;
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 = 'arag') OR (i.word = 'andy') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' 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: 170209 18:19:15
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.332402 Lock_time: 0.000175 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642755;
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 = 'arag') OR (i.word = 'andy') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:19:16
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.437225 Lock_time: 0.000241 Rows_sent: 10 Rows_examined: 15142
SET timestamp=1486642756;
SELECT i.type AS type, i.sid AS sid, SUM((49.3354352830 * 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 = 'arag') OR (i.word = 'andy') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% arag %' ESCAPE '\\') AND (d.data LIKE '% andy %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 610;
# Time: 170209 18:19:34
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.407612 Lock_time: 0.000182 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642774;
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: 170209 18:19:35
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 4.125985 Lock_time: 0.000158 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642775;
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 = 'bilim') )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 '% bilim %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# Time: 170209 18:19:37
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.366761 Lock_time: 0.000157 Rows_sent: 10 Rows_examined: 21603
SET timestamp=1486642777;
SELECT i.type AS type, i.sid AS sid, SUM((428.0545545281 * 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 = 'bilim') )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 '% bilim %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 2830;
# Time: 170209 18:19:57
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.536549 Lock_time: 0.000117 Rows_sent: 24926 Rows_examined: 24926
SET timestamp=1486642797;
SELECT td.tid AS tid, BIT_OR(COALESCE(ta.grant_list, tad.grant_list, tadg.grant_list)) AS grant_list
FROM
taxonomy_term_data td
INNER JOIN taxonomy_access_default tadg ON tadg.vid = 0
LEFT OUTER JOIN taxonomy_access_default tad ON tad.vid = td.vid AND tad.rid = tadg.rid
LEFT OUTER JOIN taxonomy_access_term ta ON ta.tid = td.tid AND ta.rid = tadg.rid
WHERE (tadg.rid IN ('2'))
GROUP BY td.tid;
# Time: 170209 18:19:58
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 4.412619 Lock_time: 0.000173 Rows_sent: 1 Rows_examined: 15552
SET timestamp=1486642798;
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 = 'zan') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' 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(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 1 OFFSET 0;
# Time: 170209 18:20:00
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.387565 Lock_time: 0.000171 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642800;
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 = 'zan') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# Time: 170209 18:20:02
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.282616 Lock_time: 0.000189 Rows_sent: 10 Rows_examined: 17471
SET timestamp=1486642802;
SELECT i.type AS type, i.sid AS sid, SUM((167.4470044450 * 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 = 'zan') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 1910;
# Time: 170209 18:20:19
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.939184 Lock_time: 0.000183 Rows_sent: 1 Rows_examined: 15552
SET timestamp=1486642819;
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 = 'zan') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' 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(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 1 OFFSET 0;
# Time: 170209 18:20:20
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.550343 Lock_time: 0.000203 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642820;
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 = 'zan') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1') ) subquery;
# Time: 170209 18:20:21
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.146327 Lock_time: 0.000065 Rows_sent: 1 Rows_examined: 4155
SET timestamp=1486642821;
SELECT SUM(t.visits) AS expression
FROM
access_counter t
WHERE (t.entity_type = 'node') AND (t.entity_id = '24998');
# Time: 170209 18:20:23
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 3.032594 Lock_time: 0.000170 Rows_sent: 10 Rows_examined: 16611
SET timestamp=1486642823;
SELECT i.type AS type, i.sid AS sid, SUM((167.4470044450 * 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 = 'zan') )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 '% k %' ESCAPE '\\') AND (d.data LIKE '% u %' ESCAPE '\\') AND (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% yk %' ESCAPE '\\') AND (d.data LIKE '% zan %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '1')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 1050;
# Time: 170209 18:20:44
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.272189 Lock_time: 0.000167 Rows_sent: 1 Rows_examined: 10934
SET timestamp=1486642844;
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 = 'sipkerlik') OR (i.word = 'turleri') )AND (i.type = 'node') AND( (d.data LIKE '% k %' ESCAPE '\\') AND (d.data LIKE '% sipkerlik %' ESCAPE '\\') AND (d.data LIKE '% turleri %' 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(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 1 OFFSET 0;
# Time: 170209 18:20:47
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 2.082135 Lock_time: 0.000154 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642847;
SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
field_data_field_status field_data_field_status0
INNER JOIN field_data_field_views field_data_field_views1 ON field_data_field_views1.entity_type = field_data_field_status0.entity_type AND field_data_field_views1.entity_id = field_data_field_status0.entity_id
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 <= '1486643751') 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: 170209 18:20:52
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 3.029841 Lock_time: 0.000214 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642852;
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 = 'dag') OR (i.word = 'darys') )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 '% dag %' ESCAPE '\\') AND (d.data LIKE '% darys %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2') ) subquery;
# Time: 170209 18:20:54
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.957148 Lock_time: 0.000219 Rows_sent: 10 Rows_examined: 15527
SET timestamp=1486642854;
SELECT i.type AS type, i.sid AS sid, SUM((50.7806065068 * 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 = 'dag') OR (i.word = 'darys') )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 '% dag %' ESCAPE '\\') AND (d.data LIKE '% darys %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '2')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 380;
# Time: 170209 18:21:41
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.333740 Lock_time: 0.000267 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642901;
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 = 'karagandinskiy') OR (i.word = 'medicinskiy') 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 = '2') AND (na.realm = 'taxonomy_access_role') ))AND (na.grant_view >= '1') AND (n.nid = na.nid) )) AND( (d.data LIKE '% karagandinskiy %' ESCAPE '\\') AND (d.data LIKE '% medicinskiy %' ESCAPE '\\') AND (d.data LIKE '% universitet %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '3') ) subquery;
# Time: 170209 18:21:43
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 9.963376 Lock_time: 0.000175 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486642903;
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 = 'lemdik') OR (i.word = 'ekonomika') OR (i.word = 'adam') )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 '% lemdik %' ESCAPE '\\') AND (d.data LIKE '% ekonomika %' ESCAPE '\\') AND (d.data LIKE '% adam %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '3') ) subquery;
# Time: 170209 18:21:48
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 5.373096 Lock_time: 0.000234 Rows_sent: 10 Rows_examined: 47260
SET timestamp=1486642908;
SELECT i.type AS type, i.sid AS sid, SUM((263.2234225772 * 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 = 'lemdik') OR (i.word = 'ekonomika') OR (i.word = 'adam') )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 '% lemdik %' ESCAPE '\\') AND (d.data LIKE '% ekonomika %' ESCAPE '\\') AND (d.data LIKE '% adam %' ESCAPE '\\') )
GROUP BY i.type, i.sid
HAVING (COUNT(*) >= '3')
ORDER BY calculated_score DESC
LIMIT 10 OFFSET 50;
# Time: 170209 18:22:36
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.448173 Lock_time: 0.000094 Rows_sent: 30330 Rows_examined: 75973
SET timestamp=1486642956;
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 = 'es' WHERE s.textgroup = 'default' AND s.version = '7.36' AND LENGTH(s.source) < '75';
# Time: 170209 18:23:42
# User@Host: root[root] @ [192.168.0.56]
# Query_time: 1.041878 Lock_time: 0.000104 Rows_sent: 1 Rows_examined: 0
SET timestamp=1486643022;
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: 170209 18:24:07