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

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big ass 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
  471442
  526105
  555233
  567549
  459128
  514969
  522610
  476597
  500931
  501551
  467733
  596599
  441546
  457735
  447004
  456893
  518223
  523047
  520299
  507095
  519895
  527814
  472402
  476227
  566694
  552955
  581025
  628730
  619486
  787586
  451990
  444698
  451950
  510077
  525955
  531423
  527602
  528416
  509591
  526134
  582944
  445881
  452114
  486639
  417324
  452080
  458925
  464956
  515555
  624480
  443587
  456607
  457786
  527609
  511066
  526428
  458359
  545943
  572840
  594879
  451943
  427262
  565391
  461668
  527936
  464301
  556001
  577349
  424312
  637460
  573365
  562358
  599534
  555616
  537251
  469736
  458775
  457793
  486086
  562368
  499774
  577350
  646433
  444356
  562367
  614737
  562282
  484866
]

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 (471442, 526105, 555233, 567549, 459128, 514969, 522610, 476597, 500931, 501551, 467733, 596599, 441546, 457735, 447004, 456893, 518223, 523047, 520299, 507095, 519895, 527814, 472402, 476227, 566694, 552955, 581025, 628730, 619486, 787586, 451990, 444698, 451950, 510077, 525955, 531423, 527602, 528416, 509591, 526134, 582944, 445881, 452114, 486639, 417324, 452080, 458925, 464956, 515555, 624480, 443587, 456607, 457786, 527609, 511066, 526428, 458359, 545943, 572840, 594879, 451943, 427262, 565391, 461668, 527936, 464301, 556001, 577349, 424312, 637460, 573365, 562358, 599534, 555616, 537251, 469736, 458775, 457793, 486086, 562368, 499774, 577350, 646433, 444356, 562367, 614737, 562282, 484866);

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
  417324
  424312
  427262
  441546
  443587
  444356
  444698
  445881
  447004
  451943
  451950
  451990
  452080
  452114
  456607
  456893
  457735
  457786
  457793
  458359
  458775
  458925
  459128
  461668
  464301
  464956
  467733
  469736
  471442
  472402
  476227
  476597
  484866
  486086
  486639
  499774
  500931
  501551
  507095
  509591
  510077
  511066
  514969
  515555
  518223
  519895
  520299
  522610
  523047
  525955
  526105
  526134
  526428
  527602
  527609
  527814
  527936
  528416
  531423
  537251
  545943
  552955
  555233
  555616
  556001
  562282
  562358
  562367
  562368
  565391
  566694
  567549
  572840
  573365
  577349
  577350
  581025
  582944
  594879
  596599
  599534
  614737
  619486
  624480
  628730
  637460
  646433
  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 (417324, 424312, 427262, 441546, 443587, 444356, 444698, 445881, 447004, 451943, 451950, 451990, 452080, 452114, 456607, 456893, 457735, 457786, 457793, 458359, 458775, 458925, 459128, 461668, 464301, 464956, 467733, 469736, 471442, 472402, 476227, 476597, 484866, 486086, 486639, 499774, 500931, 501551, 507095, 509591, 510077, 511066, 514969, 515555, 518223, 519895, 520299, 522610, 523047, 525955, 526105, 526134, 526428, 527602, 527609, 527814, 527936, 528416, 531423, 537251, 545943, 552955, 555233, 555616, 556001, 562282, 562358, 562367, 562368, 565391, 566694, 567549, 572840, 573365, 577349, 577350, 581025, 582944, 594879, 596599, 599534, 614737, 619486, 624480, 628730, 637460, 646433, 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
  417324
  424312
  427262
  441546
  443587
  444356
  444698
  445881
  447004
  451943
  451950
  451990
  452080
  452114
  456607
  456893
  457735
  457786
  457793
  458359
  458775
  458925
  459128
  461668
  464301
  464956
  467733
  469736
  471442
  472402
  476227
  476597
  484866
  486086
  486639
  499774
  500931
  501551
  507095
  509591
  510077
  511066
  514969
  515555
  518223
  519895
  520299
  522610
  523047
  525955
  526105
  526134
  526428
  527602
  527609
  527814
  527936
  528416
  531423
  537251
  545943
  552955
  555233
  555616
  556001
  562282
  562358
  562367
  562368
  565391
  566694
  567549
  572840
  573365
  577349
  577350
  581025
  582944
  594879
  596599
  599534
  614737
  619486
  624480
  628730
  637460
  646433
  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 (417324, 424312, 427262, 441546, 443587, 444356, 444698, 445881, 447004, 451943, 451950, 451990, 452080, 452114, 456607, 456893, 457735, 457786, 457793, 458359, 458775, 458925, 459128, 461668, 464301, 464956, 467733, 469736, 471442, 472402, 476227, 476597, 484866, 486086, 486639, 499774, 500931, 501551, 507095, 509591, 510077, 511066, 514969, 515555, 518223, 519895, 520299, 522610, 523047, 525955, 526105, 526134, 526428, 527602, 527609, 527814, 527936, 528416, 531423, 537251, 545943, 552955, 555233, 555616, 556001, 562282, 562358, 562367, 562368, 565391, 566694, 567549, 572840, 573365, 577349, 577350, 581025, 582944, 594879, 596599, 599534, 614737, 619486, 624480, 628730, 637460, 646433, 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';