Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "село в лицо"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'село в лицо' LIMIT 1;

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  619333
  548245
  549630
  551940
  470686
  546366
  554640
  513239
  551933
  489015
  624570
  461265
  528913
  542224
  549220
  528917
  562343
  616766
  533961
  782767
  560035
  506167
  621713
  391884
  572286
  528447
  385231
  584482
  554631
  483424
  593102
  458361
  623471
  604190
  590265
  551582
  554655
  550427
  507017
  548235
  559132
  580715
  551916
  600616
  625210
  630702
  619399
  622373
  619082
  584094
  527048
  559127
  686753
  554639
  548228
  596791
  571201
  551935
  562836
  671746
  577356
  604560
  550329
  667253
  500959
  489068
  523641
  680653
  549605
  603010
  684769
  615394
]

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.search_field,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (619333, 548245, 549630, 551940, 470686, 546366, 554640, 513239, 551933, 489015, 624570, 461265, 528913, 542224, 549220, 528917, 562343, 616766, 533961, 782767, 560035, 506167, 621713, 391884, 572286, 528447, 385231, 584482, 554631, 483424, 593102, 458361, 623471, 604190, 590265, 551582, 554655, 550427, 507017, 548235, 559132, 580715, 551916, 600616, 625210, 630702, 619399, 622373, 619082, 584094, 527048, 559127, 686753, 554639, 548228, 596791, 571201, 551935, 562836, 671746, 577356, 604560, 550329, 667253, 500959, 489068, 523641, 680653, 549605, 603010, 684769, 615394);

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  385231
  391884
  458361
  461265
  470686
  483424
  489015
  489068
  500959
  506167
  507017
  513239
  523641
  527048
  528447
  528913
  528917
  533961
  542224
  546366
  548228
  548235
  548245
  549220
  549605
  549630
  550329
  550427
  551582
  551916
  551933
  551935
  551940
  554631
  554639
  554640
  554655
  559127
  559132
  560035
  562343
  562836
  571201
  572286
  577356
  580715
  584094
  584482
  590265
  593102
  596791
  600616
  603010
  604190
  604560
  615394
  616766
  619082
  619333
  619399
  621713
  622373
  623471
  624570
  625210
  630702
  667253
  671746
  680653
  684769
  686753
  782767
]

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (385231, 391884, 458361, 461265, 470686, 483424, 489015, 489068, 500959, 506167, 507017, 513239, 523641, 527048, 528447, 528913, 528917, 533961, 542224, 546366, 548228, 548235, 548245, 549220, 549605, 549630, 550329, 550427, 551582, 551916, 551933, 551935, 551940, 554631, 554639, 554640, 554655, 559127, 559132, 560035, 562343, 562836, 571201, 572286, 577356, 580715, 584094, 584482, 590265, 593102, 596791, 600616, 603010, 604190, 604560, 615394, 616766, 619082, 619333, 619399, 621713, 622373, 623471, 624570, 625210, 630702, 667253, 671746, 680653, 684769, 686753, 782767);

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  385231
  391884
  458361
  461265
  470686
  483424
  489015
  489068
  500959
  506167
  507017
  513239
  523641
  527048
  528447
  528913
  528917
  533961
  542224
  546366
  548228
  548235
  548245
  549220
  549605
  549630
  550329
  550427
  551582
  551916
  551933
  551935
  551940
  554631
  554639
  554640
  554655
  559127
  559132
  560035
  562343
  562836
  571201
  572286
  577356
  580715
  584094
  584482
  590265
  593102
  596791
  600616
  603010
  604190
  604560
  615394
  616766
  619082
  619333
  619399
  621713
  622373
  623471
  624570
  625210
  630702
  667253
  671746
  680653
  684769
  686753
  782767
]

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (385231, 391884, 458361, 461265, 470686, 483424, 489015, 489068, 500959, 506167, 507017, 513239, 523641, 527048, 528447, 528913, 528917, 533961, 542224, 546366, 548228, 548235, 548245, 549220, 549605, 549630, 550329, 550427, 551582, 551916, 551933, 551935, 551940, 554631, 554639, 554640, 554655, 559127, 559132, 560035, 562343, 562836, 571201, 572286, 577356, 580715, 584094, 584482, 590265, 593102, 596791, 600616, 603010, 604190, 604560, 615394, 616766, 619082, 619333, 619399, 621713, 622373, 623471, 624570, 625210, 630702, 667253, 671746, 680653, 684769, 686753, 782767);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "деревня в лиц"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'деревня в лиц';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "деревня в лиц"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'деревня в лиц';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "село в лицо"
  "село в лицо"
  "село в лицо"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('село в лицо') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('село в лицо')
              AND `query` <> 'село в лицо'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;