{"action":"created","issue":{"url":"https://api.github.com/repos/contao/core/issues/8210","repository_url":"https://api.github.com/repos/contao/core","labels_url":"https://api.github.com/repos/contao/core/issues/8210/labels{/name}","comments_url":"https://api.github.com/repos/contao/core/issues/8210/comments","events_url":"https://api.github.com/repos/contao/core/issues/8210/events","html_url":"https://github.com/contao/core/issues/8210","id":130990526,"number":8210,"title":"Search index race condition under load? / Suchindex","user":{"login":"amenk","id":1087128,"avatar_url":"https://avatars.githubusercontent.com/u/1087128?v=3","gravatar_id":"","url":"https://api.github.com/users/amenk","html_url":"https://github.com/amenk","followers_url":"https://api.github.com/users/amenk/followers","following_url":"https://api.github.com/users/amenk/following{/other_user}","gists_url":"https://api.github.com/users/amenk/gists{/gist_id}","starred_url":"https://api.github.com/users/amenk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amenk/subscriptions","organizations_url":"https://api.github.com/users/amenk/orgs","repos_url":"https://api.github.com/users/amenk/repos","events_url":"https://api.github.com/users/amenk/events{/privacy}","received_events_url":"https://api.github.com/users/amenk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2016-02-03T10:57:45Z","updated_at":"2016-04-15T15:00:55Z","closed_at":null,"body":"_Our ticket: 12239_\r\n\r\nUnder heavy load of the website we have lots of search index related queries in `SHOW FULL PROCESSLIST`.\r\n\r\nContao Version = 3.4.2\r\n\r\n\tmysql> show full processlist;\r\n\t+--------+-------------+-----------+-------------------+---------+------+------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n\t| Id     | User        | Host      | db                | Command | Time | State                        | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |\r\n\t+--------+-------------+-----------+-------------------+---------+------+------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n\t| 819074 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'your', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |\r\n\t| 819077 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'unsere', 5, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |\r\n\t| 819078 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'unsere', 5, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |\r\n\t| 819083 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'neuen', 12, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |\r\n\t| 819084 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('418', 'hohen', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |\r\n\t| 819088 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('517', 'größere', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819089 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'to', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |\r\n\t| 819100 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('502', 'vorgeschlagene', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |\r\n\t| 819106 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('484', 'alias-vorschlag', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\r\n\t| 819113 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'key', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |\r\n\t| 819118 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('480', 'höchster', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |\r\n\t| 819120 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'product', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819122 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('23663', 'maßgefertigten', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |\r\n\t| 819125 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'kein', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |\r\n\t| 819133 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('38129', 'regeltechnik', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |\r\n\t| 819135 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'to', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |\r\n\t| 819154 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'unsere', 5, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |\r\n\t| 819155 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'unseren', 12, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |\r\n\t| 819159 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'desired', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819164 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'product', 1, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819167 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | INSERT INTO tl_search_index (pid, word, relevance, language) VALUES ('148', 'unsere', 5, 'de')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |\r\n\t| 819183 | -prod | localhost | example-production | Query   |  421 | Sending data                 | SELECT tl_search_index.pid AS sid, GROUP_CONCAT(word) AS matches, (SELECT COUNT(*) FROM tl_search_index WHERE (word LIKE '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%') AND pid=sid) AS wildcards, COUNT(*) AS count, SUM(relevance) AS relevance, tl_search.* FROM tl_search_index LEFT JOIN tl_search ON(tl_search_index.pid=tl_search.id) WHERE (word LIKE '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%') AND tl_search_index.pid IN(SELECT id FROM tl_search WHERE pid IN(2,32,4,5,10,11,12,13,14,15,26,79,80,519,524,690,709,749,751,756,791,803,886,29,30,554,696,784,785,786,798,838,839,846,860,884,885,8,9,19,18,20,21,22,23,24,25,74,484,485,548,908,71,723,6,7,27,28,57,716,717,837,35,37,39,40,41,42,46,48,51,52,87,652,683,686,692,33,34,36,38,43,47,50,53,54,55,682,685,687,688,689,61,64,86,88,906,907,541,805,868,77,78,72,73,703,60,62,63,65,66,67,68,69,70,815,526,527,536,710,816,817,818,820,819,821,81,82,83,76,75)) GROUP BY tl_search_index.pid HAVING count >= 0 + IF(wildcards>1, wildcards, 1) ORDER BY relevance DESC LIMIT 0,10                                  |\r\n\t| 819192 | example-prod | localhost | example-production | Query   |  419 | Waiting for table level lock | UPDATE tl_search SET url='de/', title='example – example example', protected='', filesize='54.32', groups=0, pid='2', language='de', checksum='3f490805db6a084d673cbb383bd6c90a', text='example – example  example  example  example  example  example  example  example  example ...', tstamp=1446215437 WHERE id='148' |\r\n\t| 819200 | example-prod | localhost | example-production | Query   |  419 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='en/e-catalog/vona2/result/?Keyword=MSP-16-SS' AND pid='767' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |\r\n\t| 819203 | example-prod | localhost | example-production | Query   |  419 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='vcommon/spec/img/sprite_spec.png'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |\r\n\t| 819208 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='vcommon/common/img/button_arrow_updown.png'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819209 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='de/e-catalog/vona2/mech/' AND pid='756' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819210 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | SELECT tl_search_index.pid AS sid, GROUP_CONCAT(word) AS matches, COUNT(*) AS count, SUM(relevance) AS relevance, tl_search.* FROM tl_search_index LEFT JOIN tl_search ON(tl_search_index.pid=tl_search.id) WHERE (word='pjlh') AND tl_search_index.pid IN(SELECT id FROM tl_search WHERE pid IN(2,32,4,5,10,11,12,13,14,15,26,79,80,519,524,690,709,749,751,756,791,803,886,29,30,554,696,784,785,786,798,838,839,846,860,884,885,8,9,19,18,20,21,22,23,24,25,74,484,485,548,908,71,723,6,7,27,28,57,716,717,837,35,37,39,40,41,42,46,48,51,52,87,652,683,686,692,33,34,36,38,43,47,50,53,54,55,682,685,687,688,689,61,64,86,88,906,907,541,805,868,77,78,72,73,703,60,62,63,65,66,67,68,69,70,815,526,527,536,710,816,817,818,820,819,821,81,82,83,76,75)) GROUP BY tl_search_index.pid HAVING count >= 1 ORDER BY relevance DESC LIMIT 0,10                                                                                                                                                                                                                   |\r\n\t| 819212 | example-prod | localhost | example-production | Query   |  416 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='de/bestseller/lineareinheiten' AND pid='40' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |\r\n\t| 819213 | example-prod | localhost | example-production | Query   |  417 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='de/results/hash/e7cf3b0062bfbd309cf7d6751c6dd30436bbc565' AND pid='519' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819214 | example-prod | localhost | example-production | Query   |  418 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='vcommon/common/img/button_arrow_updown.png'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819216 | example-prod | localhost | example-production | Query   |  417 | Waiting for table level lock | SELECT tl_search_index.pid AS sid, GROUP_CONCAT(word) AS matches, COUNT(*) AS count, SUM(relevance) AS relevance, tl_search.* FROM tl_search_index LEFT JOIN tl_search ON(tl_search_index.pid=tl_search.id) WHERE (word='gscc') GROUP BY tl_search_index.pid HAVING count >= 1 ORDER BY relevance DESC LIMIT 0,10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |\r\n\t| 819217 | example-prod | localhost | example-production | Query   |  415 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='de/online-shop/proxy/gewindespindel' AND pid='71' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |\r\n\t| 819221 | example-prod | localhost | example-production | Query   |  413 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='de/vcommon/common/img/sprite_head_parts_150115.png'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\r\n\t| 819222 | example-prod | localhost | example-production | Query   |  413 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='it/' AND pid='327' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |\r\n\t| 819224 | example-prod | localhost | example-production | Query   |  413 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='img/icons/favicon.ico'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |\r\n\t| 819225 | example-prod | localhost | example-production | Query   |  413 | Waiting for table level lock | SELECT tl_search_index.pid AS sid, GROUP_CONCAT(word) AS matches, COUNT(*) AS count, SUM(relevance) AS relevance, tl_search.* FROM tl_search_index LEFT JOIN tl_search ON(tl_search_index.pid=tl_search.id) WHERE (word='po') AND tl_search_index.pid IN(SELECT id FROM tl_search WHERE pid IN(248,249,250,251,269,272,293,294,295,296,297,299,323,521,753,768,793,889,910,252,253,254,257,258,261,264,265,266,267,268,488,489,550,270,271,273,283,284,289,779,780,298,727,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,902,903,324,325,556,698,757,758,788,813,866,867,872,255,256,259,260,262,263,274,275,276,277,278,279,280,281,282,824,538,530,531,705,712,840,841,842,843,844,845,285,286,287,288,543,808,290,291,292)) GROUP BY tl_search_index.pid HAVING count >= 1 ORDER BY relevance DESC LIMIT 0,10                                                                                                                                                                                                   |\r\n\t| 819226 | example-prod | localhost | example-production | Query   |  412 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='de/e-catalog/vona2/mech/' AND pid='756' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819227 | example-prod | localhost | example-production | Query   |  411 | Waiting for table level lock | SELECT tl_search_index.pid AS sid, GROUP_CONCAT(word) AS matches, COUNT(*) AS count, SUM(relevance) AS relevance, tl_search.* FROM tl_search_index LEFT JOIN tl_search ON(tl_search_index.pid=tl_search.id) WHERE (word='psfu20-762') GROUP BY tl_search_index.pid HAVING count >= 1 ORDER BY relevance DESC LIMIT 0,10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\r\n\t| 819228 | example-prod | localhost | example-production | Query   |  410 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='en/news/news-cost-efficient-products' AND pid='812' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |\r\n\t| 819229 | example-prod | localhost | example-production | Query   |  408 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='vcommon/common/img/tooltip_arrow.gif'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |\r\n\t| 819230 | example-prod | localhost | example-production | Query   |  407 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='en/news/news-cost-efficient-products' AND pid='812' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |\r\n\t| 819232 | example-prod | localhost | example-production | Query   |  399 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='vcommon/common/img/tooltip_arrow.gif'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |\r\n\t| 819233 | example-prod | localhost | example-production | Query   |  395 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='en/news/news-cost-efficient-products' AND pid='812' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |\r\n\t| 819234 | example-prod | localhost | example-production | Query   |  395 | Waiting for table level lock | SELECT id, checksum FROM tl_search WHERE url='en/customer-service/cad-data' AND pid='190' LIMIT 0,1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |\r\n\t| 819237 | example-prod | localhost | example-production | Query   |  381 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='de/vcommon/category/img/line_dot_x.png'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |\r\n\t| 819238 | example-prod | localhost | example-production | Query   |  375 | Waiting for table level lock | SELECT id FROM tl_search WHERE url='vcommon/common/img/button_arrow_updown.png'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |\r\n\t| 819240 | example-prod | localhost | example-production | Sleep   |  123 |                              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |\r\n\t| 819243 | example-prod | localhost | example-production | Query   |  123 | Waiting for table level lock | SELECT tl_search_index.pid AS sid, GROUP_CONCAT(word) AS matches, COUNT(*) AS count, SUM(relevance) AS relevance, tl_search.* FROM tl_search_index LEFT JOIN tl_search ON(tl_search_index.pid=tl_search.id) WHERE (word='g') AND tl_search_index.pid IN(SELECT id FROM tl_search WHERE pid IN(2,32,4,5,10,11,12,13,14,15,26,79,80,519,524,690,709,749,751,756,791,803,886,29,30,554,696,784,785,786,798,838,839,846,860,884,885,8,9,19,18,20,21,22,23,24,25,74,484,485,548,908,71,723,6,7,27,28,57,716,717,837,35,37,39,40,41,42,46,48,51,52,87,652,683,686,692,33,34,36,38,43,47,50,53,54,55,682,685,687,688,689,61,64,86,88,906,907,541,805,868,77,78,72,73,703,60,62,63,65,66,67,68,69,70,815,526,527,536,710,816,817,818,820,819,821,81,82,83,76,75)) GROUP BY tl_search_index.pid HAVING count >= 1 ORDER BY relevance DESC LIMIT 0,10                                                                                                                                                                                                                      |\r\n\t| 819245 | example-prod | localhost | example-production | Sleep   |    1 |                              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |\r\n\t| 819246 | example-prod | localhost | example-production | Query   |    0 | NULL                         | show full processlist                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |\r\n\t+--------+-------------+-----------+-------------------+---------+------+------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n\t51 rows in set (0.00 sec)\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/contao/core/issues/comments/210495197","html_url":"https://github.com/contao/core/issues/8210#issuecomment-210495197","issue_url":"https://api.github.com/repos/contao/core/issues/8210","id":210495197,"user":{"login":"leofeyer","id":1192057,"avatar_url":"https://avatars.githubusercontent.com/u/1192057?v=3","gravatar_id":"","url":"https://api.github.com/users/leofeyer","html_url":"https://github.com/leofeyer","followers_url":"https://api.github.com/users/leofeyer/followers","following_url":"https://api.github.com/users/leofeyer/following{/other_user}","gists_url":"https://api.github.com/users/leofeyer/gists{/gist_id}","starred_url":"https://api.github.com/users/leofeyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leofeyer/subscriptions","organizations_url":"https://api.github.com/users/leofeyer/orgs","repos_url":"https://api.github.com/users/leofeyer/repos","events_url":"https://api.github.com/users/leofeyer/events{/privacy}","received_events_url":"https://api.github.com/users/leofeyer/received_events","type":"User","site_admin":false},"created_at":"2016-04-15T15:00:55Z","updated_at":"2016-04-15T15:00:55Z","body":"Was meinst Du mit \"Dead Locks\"?"}}