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

[
  "worship pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'worship pussy' 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
  640906
  551912
  548879
  614942
  825371
  745310
  747566
  770607
  548876
  827299
  460969
  740554
  533430
  812116
  745241
  460961
  710875
  6997
  749085
  761248
  66264
  533500
  380621
  825030
  532718
  517018
  785075
  422817
  482573
  569564
  424870
  666713
  782769
  664160
  616400
  427142
  733271
  650489
  444280
  470364
  343369
  413612
  482590
  521233
  540360
  576437
  541509
  727571
  539086
  446783
  732236
  540095
  426413
  442236
  448043
  472216
  521221
  533264
  554548
  542522
  589673
  588930
  606750
  521201
  516975
  419840
  576514
  557577
  446090
  482872
  715282
  576519
  586026
  761463
  408974
  464209
  450286
  439492
  505318
  624166
  523169
  597134
]

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 (640906, 551912, 548879, 614942, 825371, 745310, 747566, 770607, 548876, 827299, 460969, 740554, 533430, 812116, 745241, 460961, 710875, 6997, 749085, 761248, 66264, 533500, 380621, 825030, 532718, 517018, 785075, 422817, 482573, 569564, 424870, 666713, 782769, 664160, 616400, 427142, 733271, 650489, 444280, 470364, 343369, 413612, 482590, 521233, 540360, 576437, 541509, 727571, 539086, 446783, 732236, 540095, 426413, 442236, 448043, 472216, 521221, 533264, 554548, 542522, 589673, 588930, 606750, 521201, 516975, 419840, 576514, 557577, 446090, 482872, 715282, 576519, 586026, 761463, 408974, 464209, 450286, 439492, 505318, 624166, 523169, 597134);

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
  6997
  66264
  343369
  380621
  408974
  413612
  419840
  422817
  424870
  426413
  427142
  439492
  442236
  444280
  446090
  446783
  448043
  450286
  460961
  460969
  464209
  470364
  472216
  482573
  482590
  482872
  505318
  516975
  517018
  521201
  521221
  521233
  523169
  532718
  533264
  533430
  533500
  539086
  540095
  540360
  541509
  542522
  548876
  548879
  551912
  554548
  557577
  569564
  576437
  576514
  576519
  586026
  588930
  589673
  597134
  606750
  614942
  616400
  624166
  640906
  650489
  664160
  666713
  710875
  715282
  727571
  732236
  733271
  740554
  745241
  745310
  747566
  749085
  761248
  761463
  770607
  782769
  785075
  812116
  825030
  825371
  827299
]

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 (6997, 66264, 343369, 380621, 408974, 413612, 419840, 422817, 424870, 426413, 427142, 439492, 442236, 444280, 446090, 446783, 448043, 450286, 460961, 460969, 464209, 470364, 472216, 482573, 482590, 482872, 505318, 516975, 517018, 521201, 521221, 521233, 523169, 532718, 533264, 533430, 533500, 539086, 540095, 540360, 541509, 542522, 548876, 548879, 551912, 554548, 557577, 569564, 576437, 576514, 576519, 586026, 588930, 589673, 597134, 606750, 614942, 616400, 624166, 640906, 650489, 664160, 666713, 710875, 715282, 727571, 732236, 733271, 740554, 745241, 745310, 747566, 749085, 761248, 761463, 770607, 782769, 785075, 812116, 825030, 825371, 827299);

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
  6997
  66264
  343369
  380621
  408974
  413612
  419840
  422817
  424870
  426413
  427142
  439492
  442236
  444280
  446090
  446783
  448043
  450286
  460961
  460969
  464209
  470364
  472216
  482573
  482590
  482872
  505318
  516975
  517018
  521201
  521221
  521233
  523169
  532718
  533264
  533430
  533500
  539086
  540095
  540360
  541509
  542522
  548876
  548879
  551912
  554548
  557577
  569564
  576437
  576514
  576519
  586026
  588930
  589673
  597134
  606750
  614942
  616400
  624166
  640906
  650489
  664160
  666713
  710875
  715282
  727571
  732236
  733271
  740554
  745241
  745310
  747566
  749085
  761248
  761463
  770607
  782769
  785075
  812116
  825030
  825371
  827299
]

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 (6997, 66264, 343369, 380621, 408974, 413612, 419840, 422817, 424870, 426413, 427142, 439492, 442236, 444280, 446090, 446783, 448043, 450286, 460961, 460969, 464209, 470364, 472216, 482573, 482590, 482872, 505318, 516975, 517018, 521201, 521221, 521233, 523169, 532718, 533264, 533430, 533500, 539086, 540095, 540360, 541509, 542522, 548876, 548879, 551912, 554548, 557577, 569564, 576437, 576514, 576519, 586026, 588930, 589673, 597134, 606750, 614942, 616400, 624166, 640906, 650489, 664160, 666713, 710875, 715282, 727571, 732236, 733271, 740554, 745241, 745310, 747566, 749085, 761248, 761463, 770607, 782769, 785075, 812116, 825030, 825371, 827299);

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

[
  "worship pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'worship pussy';

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

[
  "worship pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'worship pussy';