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 ebony anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big ebony 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
  565168
  418363
  541634
  623198
  756390
  637460
  580277
  589524
  427263
  545305
  687158
  540570
  666525
  495273
  430404
  674988
  639824
  477210
  487746
  691509
  635243
  643020
  533966
  559959
  430700
  496283
  632579
  639744
  674983
  676636
  452097
  649514
  636033
  771620
  643067
  740732
  554774
  426294
  589211
  638967
  741427
  675012
  680751
  756836
  672275
  462911
  519392
  466499
  521897
  821066
  467960
  720336
  725115
  642700
  432777
  483461
  583550
  525942
  202032
  597600
  353401
  746994
  600642
  427174
  521885
  503269
  412541
  579629
  465548
  460208
  472299
  391715
  503274
  545747
  513215
  636304
  545763
  574384
]

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 (565168, 418363, 541634, 623198, 756390, 637460, 580277, 589524, 427263, 545305, 687158, 540570, 666525, 495273, 430404, 674988, 639824, 477210, 487746, 691509, 635243, 643020, 533966, 559959, 430700, 496283, 632579, 639744, 674983, 676636, 452097, 649514, 636033, 771620, 643067, 740732, 554774, 426294, 589211, 638967, 741427, 675012, 680751, 756836, 672275, 462911, 519392, 466499, 521897, 821066, 467960, 720336, 725115, 642700, 432777, 483461, 583550, 525942, 202032, 597600, 353401, 746994, 600642, 427174, 521885, 503269, 412541, 579629, 465548, 460208, 472299, 391715, 503274, 545747, 513215, 636304, 545763, 574384);

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
  202032
  353401
  391715
  412541
  418363
  426294
  427174
  427263
  430404
  430700
  432777
  452097
  460208
  462911
  465548
  466499
  467960
  472299
  477210
  483461
  487746
  495273
  496283
  503269
  503274
  513215
  519392
  521885
  521897
  525942
  533966
  540570
  541634
  545305
  545747
  545763
  554774
  559959
  565168
  574384
  579629
  580277
  583550
  589211
  589524
  597600
  600642
  623198
  632579
  635243
  636033
  636304
  637460
  638967
  639744
  639824
  642700
  643020
  643067
  649514
  666525
  672275
  674983
  674988
  675012
  676636
  680751
  687158
  691509
  720336
  725115
  740732
  741427
  746994
  756390
  756836
  771620
  821066
]

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 (202032, 353401, 391715, 412541, 418363, 426294, 427174, 427263, 430404, 430700, 432777, 452097, 460208, 462911, 465548, 466499, 467960, 472299, 477210, 483461, 487746, 495273, 496283, 503269, 503274, 513215, 519392, 521885, 521897, 525942, 533966, 540570, 541634, 545305, 545747, 545763, 554774, 559959, 565168, 574384, 579629, 580277, 583550, 589211, 589524, 597600, 600642, 623198, 632579, 635243, 636033, 636304, 637460, 638967, 639744, 639824, 642700, 643020, 643067, 649514, 666525, 672275, 674983, 674988, 675012, 676636, 680751, 687158, 691509, 720336, 725115, 740732, 741427, 746994, 756390, 756836, 771620, 821066);

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
  202032
  353401
  391715
  412541
  418363
  426294
  427174
  427263
  430404
  430700
  432777
  452097
  460208
  462911
  465548
  466499
  467960
  472299
  477210
  483461
  487746
  495273
  496283
  503269
  503274
  513215
  519392
  521885
  521897
  525942
  533966
  540570
  541634
  545305
  545747
  545763
  554774
  559959
  565168
  574384
  579629
  580277
  583550
  589211
  589524
  597600
  600642
  623198
  632579
  635243
  636033
  636304
  637460
  638967
  639744
  639824
  642700
  643020
  643067
  649514
  666525
  672275
  674983
  674988
  675012
  676636
  680751
  687158
  691509
  720336
  725115
  740732
  741427
  746994
  756390
  756836
  771620
  821066
]

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 (202032, 353401, 391715, 412541, 418363, 426294, 427174, 427263, 430404, 430700, 432777, 452097, 460208, 462911, 465548, 466499, 467960, 472299, 477210, 483461, 487746, 495273, 496283, 503269, 503274, 513215, 519392, 521885, 521897, 525942, 533966, 540570, 541634, 545305, 545747, 545763, 554774, 559959, 565168, 574384, 579629, 580277, 583550, 589211, 589524, 597600, 600642, 623198, 632579, 635243, 636033, 636304, 637460, 638967, 639744, 639824, 642700, 643020, 643067, 649514, 666525, 672275, 674983, 674988, 675012, 676636, 680751, 687158, 691509, 720336, 725115, 740732, 741427, 746994, 756390, 756836, 771620, 821066);

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` = 'большие чернокожая анал';