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

[
  "big booty anal"
]

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

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