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
  516140
  382791
  466731
  498697
  811914
  452637
  548525
  465553
  460336
  383947
  41888
  730118
  753244
  781754
  802347
  559377
  388722
  463803
  529323
  800571
  788594
  590289
  188560
  728385
  474874
  678757
  695635
  792600
  233025
  460533
  672954
  559062
  782268
  513971
  811013
  382993
  674087
  678788
  546129
  540509
  794669
  782281
  538530
  154133
  401204
  808168
  735906
  486432
  476164
  720289
  681298
  583033
  515089
  544498
  742849
  782236
  426550
  460338
  541570
  154410
  545982
  587987
  391943
  448696
  465317
  454210
  480757
  454221
]

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 (516140, 382791, 466731, 498697, 811914, 452637, 548525, 465553, 460336, 383947, 41888, 730118, 753244, 781754, 802347, 559377, 388722, 463803, 529323, 800571, 788594, 590289, 188560, 728385, 474874, 678757, 695635, 792600, 233025, 460533, 672954, 559062, 782268, 513971, 811013, 382993, 674087, 678788, 546129, 540509, 794669, 782281, 538530, 154133, 401204, 808168, 735906, 486432, 476164, 720289, 681298, 583033, 515089, 544498, 742849, 782236, 426550, 460338, 541570, 154410, 545982, 587987, 391943, 448696, 465317, 454210, 480757, 454221);

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
  41888
  154133
  154410
  188560
  233025
  382791
  382993
  383947
  388722
  391943
  401204
  426550
  448696
  452637
  454210
  454221
  460336
  460338
  460533
  463803
  465317
  465553
  466731
  474874
  476164
  480757
  486432
  498697
  513971
  515089
  516140
  529323
  538530
  540509
  541570
  544498
  545982
  546129
  548525
  559062
  559377
  583033
  587987
  590289
  672954
  674087
  678757
  678788
  681298
  695635
  720289
  728385
  730118
  735906
  742849
  753244
  781754
  782236
  782268
  782281
  788594
  792600
  794669
  800571
  802347
  808168
  811013
  811914
]

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 (41888, 154133, 154410, 188560, 233025, 382791, 382993, 383947, 388722, 391943, 401204, 426550, 448696, 452637, 454210, 454221, 460336, 460338, 460533, 463803, 465317, 465553, 466731, 474874, 476164, 480757, 486432, 498697, 513971, 515089, 516140, 529323, 538530, 540509, 541570, 544498, 545982, 546129, 548525, 559062, 559377, 583033, 587987, 590289, 672954, 674087, 678757, 678788, 681298, 695635, 720289, 728385, 730118, 735906, 742849, 753244, 781754, 782236, 782268, 782281, 788594, 792600, 794669, 800571, 802347, 808168, 811013, 811914);

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
  41888
  154133
  154410
  188560
  233025
  382791
  382993
  383947
  388722
  391943
  401204
  426550
  448696
  452637
  454210
  454221
  460336
  460338
  460533
  463803
  465317
  465553
  466731
  474874
  476164
  480757
  486432
  498697
  513971
  515089
  516140
  529323
  538530
  540509
  541570
  544498
  545982
  546129
  548525
  559062
  559377
  583033
  587987
  590289
  672954
  674087
  678757
  678788
  681298
  695635
  720289
  728385
  730118
  735906
  742849
  753244
  781754
  782236
  782268
  782281
  788594
  792600
  794669
  800571
  802347
  808168
  811013
  811914
]

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 (41888, 154133, 154410, 188560, 233025, 382791, 382993, 383947, 388722, 391943, 401204, 426550, 448696, 452637, 454210, 454221, 460336, 460338, 460533, 463803, 465317, 465553, 466731, 474874, 476164, 480757, 486432, 498697, 513971, 515089, 516140, 529323, 538530, 540509, 541570, 544498, 545982, 546129, 548525, 559062, 559377, 583033, 587987, 590289, 672954, 674087, 678757, 678788, 681298, 695635, 720289, 728385, 730118, 735906, 742849, 753244, 781754, 782236, 782268, 782281, 788594, 792600, 794669, 800571, 802347, 808168, 811013, 811914);

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
        ;