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 big booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal big booty' 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
  439822
  503152
  472659
  487726
  796646
  457512
  528143
  685389
  815002
  475303
  410088
  468282
  507785
  397855
  433248
  481584
  385062
  512331
  524687
  619288
  530039
  533556
  538416
  533848
  463280
  619109
  433301
  473500
  493159
  484710
  407019
  503274
  539292
  526494
  495795
  503119
  447068
  405181
  503127
  530836
  406350
  460024
  619592
  438768
  583923
  426592
  397401
  538567
  117890
  453349
  459513
  566312
  473391
  545383
  587167
  519497
  526951
  427950
  396015
  483569
  809508
  742926
  498611
  629359
  475275
  406933
  604517
  811826
  404629
  419468
  518996
  554774
  425903
  450274
  596862
  487703
  545834
]

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 (439822, 503152, 472659, 487726, 796646, 457512, 528143, 685389, 815002, 475303, 410088, 468282, 507785, 397855, 433248, 481584, 385062, 512331, 524687, 619288, 530039, 533556, 538416, 533848, 463280, 619109, 433301, 473500, 493159, 484710, 407019, 503274, 539292, 526494, 495795, 503119, 447068, 405181, 503127, 530836, 406350, 460024, 619592, 438768, 583923, 426592, 397401, 538567, 117890, 453349, 459513, 566312, 473391, 545383, 587167, 519497, 526951, 427950, 396015, 483569, 809508, 742926, 498611, 629359, 475275, 406933, 604517, 811826, 404629, 419468, 518996, 554774, 425903, 450274, 596862, 487703, 545834);

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
  117890
  385062
  396015
  397401
  397855
  404629
  405181
  406350
  406933
  407019
  410088
  419468
  425903
  426592
  427950
  433248
  433301
  438768
  439822
  447068
  450274
  453349
  457512
  459513
  460024
  463280
  468282
  472659
  473391
  473500
  475275
  475303
  481584
  483569
  484710
  487703
  487726
  493159
  495795
  498611
  503119
  503127
  503152
  503274
  507785
  512331
  518996
  519497
  524687
  526494
  526951
  528143
  530039
  530836
  533556
  533848
  538416
  538567
  539292
  545383
  545834
  554774
  566312
  583923
  587167
  596862
  604517
  619109
  619288
  619592
  629359
  685389
  742926
  796646
  809508
  811826
  815002
]

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 (117890, 385062, 396015, 397401, 397855, 404629, 405181, 406350, 406933, 407019, 410088, 419468, 425903, 426592, 427950, 433248, 433301, 438768, 439822, 447068, 450274, 453349, 457512, 459513, 460024, 463280, 468282, 472659, 473391, 473500, 475275, 475303, 481584, 483569, 484710, 487703, 487726, 493159, 495795, 498611, 503119, 503127, 503152, 503274, 507785, 512331, 518996, 519497, 524687, 526494, 526951, 528143, 530039, 530836, 533556, 533848, 538416, 538567, 539292, 545383, 545834, 554774, 566312, 583923, 587167, 596862, 604517, 619109, 619288, 619592, 629359, 685389, 742926, 796646, 809508, 811826, 815002);

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
  117890
  385062
  396015
  397401
  397855
  404629
  405181
  406350
  406933
  407019
  410088
  419468
  425903
  426592
  427950
  433248
  433301
  438768
  439822
  447068
  450274
  453349
  457512
  459513
  460024
  463280
  468282
  472659
  473391
  473500
  475275
  475303
  481584
  483569
  484710
  487703
  487726
  493159
  495795
  498611
  503119
  503127
  503152
  503274
  507785
  512331
  518996
  519497
  524687
  526494
  526951
  528143
  530039
  530836
  533556
  533848
  538416
  538567
  539292
  545383
  545834
  554774
  566312
  583923
  587167
  596862
  604517
  619109
  619288
  619592
  629359
  685389
  742926
  796646
  809508
  811826
  815002
]

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 (117890, 385062, 396015, 397401, 397855, 404629, 405181, 406350, 406933, 407019, 410088, 419468, 425903, 426592, 427950, 433248, 433301, 438768, 439822, 447068, 450274, 453349, 457512, 459513, 460024, 463280, 468282, 472659, 473391, 473500, 475275, 475303, 481584, 483569, 484710, 487703, 487726, 493159, 495795, 498611, 503119, 503127, 503152, 503274, 507785, 512331, 518996, 519497, 524687, 526494, 526951, 528143, 530039, 530836, 533556, 533848, 538416, 538567, 539292, 545383, 545834, 554774, 566312, 583923, 587167, 596862, 604517, 619109, 619288, 619592, 629359, 685389, 742926, 796646, 809508, 811826, 815002);

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

[
  "анал большие booty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал большие booty';

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

[
  "анал большие booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал большие booty';