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 tits outdoor"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big tits outdoor' 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
  488880
  572840
  500931
  481154
  509024
  520299
  486434
  712964
  445605
  527513
  505081
  547717
  464301
  556001
  558425
  594879
  456182
  578389
  458359
  518223
  533313
  531423
  551235
  552313
  546614
  551944
  646202
  619823
  528913
  557451
  607380
  484084
  452663
  569083
  787586
  510077
  436032
  562269
  436865
  573365
  486086
  457793
  526105
  663288
  484078
  452114
  401933
  577349
  569156
  566729
  455852
  527609
  624480
  646433
  596599
  526428
  527936
  614737
  458775
  417324
  562282
  649912
  469736
  444356
  507309
  637460
  607094
  621449
  484866
  548226
  618806
  562368
  537251
  601954
  416886
  577350
  562367
  599534
  512339
  558472
  659328
  528075
]

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 (488880, 572840, 500931, 481154, 509024, 520299, 486434, 712964, 445605, 527513, 505081, 547717, 464301, 556001, 558425, 594879, 456182, 578389, 458359, 518223, 533313, 531423, 551235, 552313, 546614, 551944, 646202, 619823, 528913, 557451, 607380, 484084, 452663, 569083, 787586, 510077, 436032, 562269, 436865, 573365, 486086, 457793, 526105, 663288, 484078, 452114, 401933, 577349, 569156, 566729, 455852, 527609, 624480, 646433, 596599, 526428, 527936, 614737, 458775, 417324, 562282, 649912, 469736, 444356, 507309, 637460, 607094, 621449, 484866, 548226, 618806, 562368, 537251, 601954, 416886, 577350, 562367, 599534, 512339, 558472, 659328, 528075);

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
  401933
  416886
  417324
  436032
  436865
  444356
  445605
  452114
  452663
  455852
  456182
  457793
  458359
  458775
  464301
  469736
  481154
  484078
  484084
  484866
  486086
  486434
  488880
  500931
  505081
  507309
  509024
  510077
  512339
  518223
  520299
  526105
  526428
  527513
  527609
  527936
  528075
  528913
  531423
  533313
  537251
  546614
  547717
  548226
  551235
  551944
  552313
  556001
  557451
  558425
  558472
  562269
  562282
  562367
  562368
  566729
  569083
  569156
  572840
  573365
  577349
  577350
  578389
  594879
  596599
  599534
  601954
  607094
  607380
  614737
  618806
  619823
  621449
  624480
  637460
  646202
  646433
  649912
  659328
  663288
  712964
  787586
]

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 (401933, 416886, 417324, 436032, 436865, 444356, 445605, 452114, 452663, 455852, 456182, 457793, 458359, 458775, 464301, 469736, 481154, 484078, 484084, 484866, 486086, 486434, 488880, 500931, 505081, 507309, 509024, 510077, 512339, 518223, 520299, 526105, 526428, 527513, 527609, 527936, 528075, 528913, 531423, 533313, 537251, 546614, 547717, 548226, 551235, 551944, 552313, 556001, 557451, 558425, 558472, 562269, 562282, 562367, 562368, 566729, 569083, 569156, 572840, 573365, 577349, 577350, 578389, 594879, 596599, 599534, 601954, 607094, 607380, 614737, 618806, 619823, 621449, 624480, 637460, 646202, 646433, 649912, 659328, 663288, 712964, 787586);

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
  401933
  416886
  417324
  436032
  436865
  444356
  445605
  452114
  452663
  455852
  456182
  457793
  458359
  458775
  464301
  469736
  481154
  484078
  484084
  484866
  486086
  486434
  488880
  500931
  505081
  507309
  509024
  510077
  512339
  518223
  520299
  526105
  526428
  527513
  527609
  527936
  528075
  528913
  531423
  533313
  537251
  546614
  547717
  548226
  551235
  551944
  552313
  556001
  557451
  558425
  558472
  562269
  562282
  562367
  562368
  566729
  569083
  569156
  572840
  573365
  577349
  577350
  578389
  594879
  596599
  599534
  601954
  607094
  607380
  614737
  618806
  619823
  621449
  624480
  637460
  646202
  646433
  649912
  659328
  663288
  712964
  787586
]

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 (401933, 416886, 417324, 436032, 436865, 444356, 445605, 452114, 452663, 455852, 456182, 457793, 458359, 458775, 464301, 469736, 481154, 484078, 484084, 484866, 486086, 486434, 488880, 500931, 505081, 507309, 509024, 510077, 512339, 518223, 520299, 526105, 526428, 527513, 527609, 527936, 528075, 528913, 531423, 533313, 537251, 546614, 547717, 548226, 551235, 551944, 552313, 556001, 557451, 558425, 558472, 562269, 562282, 562367, 562368, 566729, 569083, 569156, 572840, 573365, 577349, 577350, 578389, 594879, 596599, 599534, 601954, 607094, 607380, 614737, 618806, 619823, 621449, 624480, 637460, 646202, 646433, 649912, 659328, 663288, 712964, 787586);

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

[
  "большие сиськ outdoor"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большие сиськ outdoor';

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

[
  "большие сиськ outdoor"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большие сиськ outdoor';