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
  562523
  564174
  716787
  587176
  587578
  599609
  625541
  790852
  519486
  511295
  530480
  536266
  545384
  674980
  678125
  641950
  596960
  603154
  595897
  635988
  607154
  732735
  635219
  416365
  451973
  482575
  487001
  537929
  509554
  530476
  537910
  666549
  675021
  676624
  564205
  644273
  632561
  625526
  530272
  536251
  530941
  535006
  536233
  536262
  666871
  674959
  545586
  602183
  602960
  808526
  530482
  674966
  674988
  651666
  523190
  525464
  540570
  530026
  580219
  675001
  676634
  674983
  676636
  625519
  536783
  497874
  559959
  666865
  674943
  642044
  600006
  642687
  632642
  526041
  665328
]

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 (562523, 564174, 716787, 587176, 587578, 599609, 625541, 790852, 519486, 511295, 530480, 536266, 545384, 674980, 678125, 641950, 596960, 603154, 595897, 635988, 607154, 732735, 635219, 416365, 451973, 482575, 487001, 537929, 509554, 530476, 537910, 666549, 675021, 676624, 564205, 644273, 632561, 625526, 530272, 536251, 530941, 535006, 536233, 536262, 666871, 674959, 545586, 602183, 602960, 808526, 530482, 674966, 674988, 651666, 523190, 525464, 540570, 530026, 580219, 675001, 676634, 674983, 676636, 625519, 536783, 497874, 559959, 666865, 674943, 642044, 600006, 642687, 632642, 526041, 665328);

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
  416365
  451973
  482575
  487001
  497874
  509554
  511295
  519486
  523190
  525464
  526041
  530026
  530272
  530476
  530480
  530482
  530941
  535006
  536233
  536251
  536262
  536266
  536783
  537910
  537929
  540570
  545384
  545586
  559959
  562523
  564174
  564205
  580219
  587176
  587578
  595897
  596960
  599609
  600006
  602183
  602960
  603154
  607154
  625519
  625526
  625541
  632561
  632642
  635219
  635988
  641950
  642044
  642687
  644273
  651666
  665328
  666549
  666865
  666871
  674943
  674959
  674966
  674980
  674983
  674988
  675001
  675021
  676624
  676634
  676636
  678125
  716787
  732735
  790852
  808526
]

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 (416365, 451973, 482575, 487001, 497874, 509554, 511295, 519486, 523190, 525464, 526041, 530026, 530272, 530476, 530480, 530482, 530941, 535006, 536233, 536251, 536262, 536266, 536783, 537910, 537929, 540570, 545384, 545586, 559959, 562523, 564174, 564205, 580219, 587176, 587578, 595897, 596960, 599609, 600006, 602183, 602960, 603154, 607154, 625519, 625526, 625541, 632561, 632642, 635219, 635988, 641950, 642044, 642687, 644273, 651666, 665328, 666549, 666865, 666871, 674943, 674959, 674966, 674980, 674983, 674988, 675001, 675021, 676624, 676634, 676636, 678125, 716787, 732735, 790852, 808526);

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
  416365
  451973
  482575
  487001
  497874
  509554
  511295
  519486
  523190
  525464
  526041
  530026
  530272
  530476
  530480
  530482
  530941
  535006
  536233
  536251
  536262
  536266
  536783
  537910
  537929
  540570
  545384
  545586
  559959
  562523
  564174
  564205
  580219
  587176
  587578
  595897
  596960
  599609
  600006
  602183
  602960
  603154
  607154
  625519
  625526
  625541
  632561
  632642
  635219
  635988
  641950
  642044
  642687
  644273
  651666
  665328
  666549
  666865
  666871
  674943
  674959
  674966
  674980
  674983
  674988
  675001
  675021
  676624
  676634
  676636
  678125
  716787
  732735
  790852
  808526
]

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 (416365, 451973, 482575, 487001, 497874, 509554, 511295, 519486, 523190, 525464, 526041, 530026, 530272, 530476, 530480, 530482, 530941, 535006, 536233, 536251, 536262, 536266, 536783, 537910, 537929, 540570, 545384, 545586, 559959, 562523, 564174, 564205, 580219, 587176, 587578, 595897, 596960, 599609, 600006, 602183, 602960, 603154, 607154, 625519, 625526, 625541, 632561, 632642, 635219, 635988, 641950, 642044, 642687, 644273, 651666, 665328, 666549, 666865, 666871, 674943, 674959, 674966, 674980, 674983, 674988, 675001, 675021, 676624, 676634, 676636, 678125, 716787, 732735, 790852, 808526);

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
        ;