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

[
  "homemade bbw ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'homemade bbw ass' 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
  494325
  569138
  575031
  654634
  554374
  582449
  595097
  425724
  460294
  517690
  525468
  485763
  478381
  577211
  584366
  463152
  467029
  781812
  571102
  464985
  443637
  428174
  400993
  471190
  453539
  515350
  527418
  527885
  571823
  520666
  467705
  465698
  476260
  529378
  582444
  475592
  509842
  507640
  562030
  523169
  413286
  453242
  454447
  477717
  582694
  651609
  588591
  464023
  476339
  420132
  444940
  511086
  527424
  761039
  507643
  527426
  443134
  476015
  662879
  698124
  419979
  458761
  447942
  549754
  496017
  491436
  562973
  695163
  446964
  589290
  454968
  763136
  463973
  427543
  401921
  592979
  564244
  662896
  716811
  472943
  453408
  490304
  474923
  474089
  583371
  589671
  587833
]

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 (494325, 569138, 575031, 654634, 554374, 582449, 595097, 425724, 460294, 517690, 525468, 485763, 478381, 577211, 584366, 463152, 467029, 781812, 571102, 464985, 443637, 428174, 400993, 471190, 453539, 515350, 527418, 527885, 571823, 520666, 467705, 465698, 476260, 529378, 582444, 475592, 509842, 507640, 562030, 523169, 413286, 453242, 454447, 477717, 582694, 651609, 588591, 464023, 476339, 420132, 444940, 511086, 527424, 761039, 507643, 527426, 443134, 476015, 662879, 698124, 419979, 458761, 447942, 549754, 496017, 491436, 562973, 695163, 446964, 589290, 454968, 763136, 463973, 427543, 401921, 592979, 564244, 662896, 716811, 472943, 453408, 490304, 474923, 474089, 583371, 589671, 587833);

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
  400993
  401921
  413286
  419979
  420132
  425724
  427543
  428174
  443134
  443637
  444940
  446964
  447942
  453242
  453408
  453539
  454447
  454968
  458761
  460294
  463152
  463973
  464023
  464985
  465698
  467029
  467705
  471190
  472943
  474089
  474923
  475592
  476015
  476260
  476339
  477717
  478381
  485763
  490304
  491436
  494325
  496017
  507640
  507643
  509842
  511086
  515350
  517690
  520666
  523169
  525468
  527418
  527424
  527426
  527885
  529378
  549754
  554374
  562030
  562973
  564244
  569138
  571102
  571823
  575031
  577211
  582444
  582449
  582694
  583371
  584366
  587833
  588591
  589290
  589671
  592979
  595097
  651609
  654634
  662879
  662896
  695163
  698124
  716811
  761039
  763136
  781812
]

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 (400993, 401921, 413286, 419979, 420132, 425724, 427543, 428174, 443134, 443637, 444940, 446964, 447942, 453242, 453408, 453539, 454447, 454968, 458761, 460294, 463152, 463973, 464023, 464985, 465698, 467029, 467705, 471190, 472943, 474089, 474923, 475592, 476015, 476260, 476339, 477717, 478381, 485763, 490304, 491436, 494325, 496017, 507640, 507643, 509842, 511086, 515350, 517690, 520666, 523169, 525468, 527418, 527424, 527426, 527885, 529378, 549754, 554374, 562030, 562973, 564244, 569138, 571102, 571823, 575031, 577211, 582444, 582449, 582694, 583371, 584366, 587833, 588591, 589290, 589671, 592979, 595097, 651609, 654634, 662879, 662896, 695163, 698124, 716811, 761039, 763136, 781812);

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
  400993
  401921
  413286
  419979
  420132
  425724
  427543
  428174
  443134
  443637
  444940
  446964
  447942
  453242
  453408
  453539
  454447
  454968
  458761
  460294
  463152
  463973
  464023
  464985
  465698
  467029
  467705
  471190
  472943
  474089
  474923
  475592
  476015
  476260
  476339
  477717
  478381
  485763
  490304
  491436
  494325
  496017
  507640
  507643
  509842
  511086
  515350
  517690
  520666
  523169
  525468
  527418
  527424
  527426
  527885
  529378
  549754
  554374
  562030
  562973
  564244
  569138
  571102
  571823
  575031
  577211
  582444
  582449
  582694
  583371
  584366
  587833
  588591
  589290
  589671
  592979
  595097
  651609
  654634
  662879
  662896
  695163
  698124
  716811
  761039
  763136
  781812
]

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 (400993, 401921, 413286, 419979, 420132, 425724, 427543, 428174, 443134, 443637, 444940, 446964, 447942, 453242, 453408, 453539, 454447, 454968, 458761, 460294, 463152, 463973, 464023, 464985, 465698, 467029, 467705, 471190, 472943, 474089, 474923, 475592, 476015, 476260, 476339, 477717, 478381, 485763, 490304, 491436, 494325, 496017, 507640, 507643, 509842, 511086, 515350, 517690, 520666, 523169, 525468, 527418, 527424, 527426, 527885, 529378, 549754, 554374, 562030, 562973, 564244, 569138, 571102, 571823, 575031, 577211, 582444, 582449, 582694, 583371, 584366, 587833, 588591, 589290, 589671, 592979, 595097, 651609, 654634, 662879, 662896, 695163, 698124, 716811, 761039, 763136, 781812);

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

[
  "домашн любительск bbw жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'домашн любительск bbw жоп';

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

[
  "домашн любительск bbw жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'домашн любительск bbw жоп';