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

[
  "anal chubby mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal chubby mom' 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
  824685
  531393
  481910
  478372
  421890
  411884
  422340
  668528
  439677
  455337
  526966
  521758
  483626
  428116
  460281
  518957
  539351
  563450
  421833
  422202
  425982
  470472
  421882
  439672
  466189
  422208
  433323
  705450
  422201
  420125
  476676
  566110
  602672
  634885
  439767
  426991
  439673
  506132
  490409
  526951
  424721
  454968
  599272
  401916
  519942
  483569
  518858
  583913
  558176
  531182
  587833
  610588
  425490
  623264
  466982
  633741
  634856
  474784
  466928
  667736
  675022
  422172
  433362
  502741
  637148
  447276
  582468
  574384
  400497
  421900
  439799
  489175
]

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 (824685, 531393, 481910, 478372, 421890, 411884, 422340, 668528, 439677, 455337, 526966, 521758, 483626, 428116, 460281, 518957, 539351, 563450, 421833, 422202, 425982, 470472, 421882, 439672, 466189, 422208, 433323, 705450, 422201, 420125, 476676, 566110, 602672, 634885, 439767, 426991, 439673, 506132, 490409, 526951, 424721, 454968, 599272, 401916, 519942, 483569, 518858, 583913, 558176, 531182, 587833, 610588, 425490, 623264, 466982, 633741, 634856, 474784, 466928, 667736, 675022, 422172, 433362, 502741, 637148, 447276, 582468, 574384, 400497, 421900, 439799, 489175);

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
  400497
  401916
  411884
  420125
  421833
  421882
  421890
  421900
  422172
  422201
  422202
  422208
  422340
  424721
  425490
  425982
  426991
  428116
  433323
  433362
  439672
  439673
  439677
  439767
  439799
  447276
  454968
  455337
  460281
  466189
  466928
  466982
  470472
  474784
  476676
  478372
  481910
  483569
  483626
  489175
  490409
  502741
  506132
  518858
  518957
  519942
  521758
  526951
  526966
  531182
  531393
  539351
  558176
  563450
  566110
  574384
  582468
  583913
  587833
  599272
  602672
  610588
  623264
  633741
  634856
  634885
  637148
  667736
  668528
  675022
  705450
  824685
]

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 (400497, 401916, 411884, 420125, 421833, 421882, 421890, 421900, 422172, 422201, 422202, 422208, 422340, 424721, 425490, 425982, 426991, 428116, 433323, 433362, 439672, 439673, 439677, 439767, 439799, 447276, 454968, 455337, 460281, 466189, 466928, 466982, 470472, 474784, 476676, 478372, 481910, 483569, 483626, 489175, 490409, 502741, 506132, 518858, 518957, 519942, 521758, 526951, 526966, 531182, 531393, 539351, 558176, 563450, 566110, 574384, 582468, 583913, 587833, 599272, 602672, 610588, 623264, 633741, 634856, 634885, 637148, 667736, 668528, 675022, 705450, 824685);

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
  400497
  401916
  411884
  420125
  421833
  421882
  421890
  421900
  422172
  422201
  422202
  422208
  422340
  424721
  425490
  425982
  426991
  428116
  433323
  433362
  439672
  439673
  439677
  439767
  439799
  447276
  454968
  455337
  460281
  466189
  466928
  466982
  470472
  474784
  476676
  478372
  481910
  483569
  483626
  489175
  490409
  502741
  506132
  518858
  518957
  519942
  521758
  526951
  526966
  531182
  531393
  539351
  558176
  563450
  566110
  574384
  582468
  583913
  587833
  599272
  602672
  610588
  623264
  633741
  634856
  634885
  637148
  667736
  668528
  675022
  705450
  824685
]

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 (400497, 401916, 411884, 420125, 421833, 421882, 421890, 421900, 422172, 422201, 422202, 422208, 422340, 424721, 425490, 425982, 426991, 428116, 433323, 433362, 439672, 439673, 439677, 439767, 439799, 447276, 454968, 455337, 460281, 466189, 466928, 466982, 470472, 474784, 476676, 478372, 481910, 483569, 483626, 489175, 490409, 502741, 506132, 518858, 518957, 519942, 521758, 526951, 526966, 531182, 531393, 539351, 558176, 563450, 566110, 574384, 582468, 583913, 587833, 599272, 602672, 610588, 623264, 633741, 634856, 634885, 637148, 667736, 668528, 675022, 705450, 824685);

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

[
  "анал chubby mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал chubby mom';

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

[
  "анал chubby mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал chubby mom';

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 ?

[
  "anal chubby mom"
  "anal chubby mom"
  "anal chubby mom"
  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 ('anal chubby mom') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('anal chubby mom')
              AND `query` <> 'anal chubby mom'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;