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

[
  "wife blowjob outdoor"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'wife blowjob 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
  561509
  487872
  527814
  507095
  787586
  577679
  643315
  601543
  709052
  452663
  572290
  480597
  455565
  510077
  596599
  514969
  553674
  444698
  427262
  583984
  546637
  561927
  619012
  614209
  528140
  525955
  497236
  547427
  548316
  458076
  472859
  445605
  459689
  497829
  527609
  476468
  457786
  456607
  488880
  619823
  458775
  569153
  555233
  511066
  458359
  457735
  503695
  628730
  486639
  469704
  469618
  493062
  486086
  509591
  427942
  547717
  552369
  528416
  458925
  618239
  573365
  601990
  476597
  457578
  526134
  484084
  587267
  562368
  537251
  444356
  558425
  562358
  621449
  464301
  599534
  562367
  591202
  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 (561509, 487872, 527814, 507095, 787586, 577679, 643315, 601543, 709052, 452663, 572290, 480597, 455565, 510077, 596599, 514969, 553674, 444698, 427262, 583984, 546637, 561927, 619012, 614209, 528140, 525955, 497236, 547427, 548316, 458076, 472859, 445605, 459689, 497829, 527609, 476468, 457786, 456607, 488880, 619823, 458775, 569153, 555233, 511066, 458359, 457735, 503695, 628730, 486639, 469704, 469618, 493062, 486086, 509591, 427942, 547717, 552369, 528416, 458925, 618239, 573365, 601990, 476597, 457578, 526134, 484084, 587267, 562368, 537251, 444356, 558425, 562358, 621449, 464301, 599534, 562367, 591202, 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
  427262
  427942
  444356
  444698
  445605
  452663
  455565
  456607
  457578
  457735
  457786
  458076
  458359
  458775
  458925
  459689
  464301
  469618
  469704
  472859
  476468
  476597
  480597
  484084
  486086
  486639
  487872
  488880
  493062
  497236
  497829
  503695
  507095
  509591
  510077
  511066
  514969
  525955
  526134
  527609
  527814
  528075
  528140
  528416
  537251
  546637
  547427
  547717
  548316
  552369
  553674
  555233
  558425
  561509
  561927
  562358
  562367
  562368
  569153
  572290
  573365
  577679
  583984
  587267
  591202
  596599
  599534
  601543
  601990
  614209
  618239
  619012
  619823
  621449
  628730
  643315
  709052
  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 (427262, 427942, 444356, 444698, 445605, 452663, 455565, 456607, 457578, 457735, 457786, 458076, 458359, 458775, 458925, 459689, 464301, 469618, 469704, 472859, 476468, 476597, 480597, 484084, 486086, 486639, 487872, 488880, 493062, 497236, 497829, 503695, 507095, 509591, 510077, 511066, 514969, 525955, 526134, 527609, 527814, 528075, 528140, 528416, 537251, 546637, 547427, 547717, 548316, 552369, 553674, 555233, 558425, 561509, 561927, 562358, 562367, 562368, 569153, 572290, 573365, 577679, 583984, 587267, 591202, 596599, 599534, 601543, 601990, 614209, 618239, 619012, 619823, 621449, 628730, 643315, 709052, 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
  427262
  427942
  444356
  444698
  445605
  452663
  455565
  456607
  457578
  457735
  457786
  458076
  458359
  458775
  458925
  459689
  464301
  469618
  469704
  472859
  476468
  476597
  480597
  484084
  486086
  486639
  487872
  488880
  493062
  497236
  497829
  503695
  507095
  509591
  510077
  511066
  514969
  525955
  526134
  527609
  527814
  528075
  528140
  528416
  537251
  546637
  547427
  547717
  548316
  552369
  553674
  555233
  558425
  561509
  561927
  562358
  562367
  562368
  569153
  572290
  573365
  577679
  583984
  587267
  591202
  596599
  599534
  601543
  601990
  614209
  618239
  619012
  619823
  621449
  628730
  643315
  709052
  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 (427262, 427942, 444356, 444698, 445605, 452663, 455565, 456607, 457578, 457735, 457786, 458076, 458359, 458775, 458925, 459689, 464301, 469618, 469704, 472859, 476468, 476597, 480597, 484084, 486086, 486639, 487872, 488880, 493062, 497236, 497829, 503695, 507095, 509591, 510077, 511066, 514969, 525955, 526134, 527609, 527814, 528075, 528140, 528416, 537251, 546637, 547427, 547717, 548316, 552369, 553674, 555233, 558425, 561509, 561927, 562358, 562367, 562368, 569153, 572290, 573365, 577679, 583984, 587267, 591202, 596599, 599534, 601543, 601990, 614209, 618239, 619012, 619823, 621449, 628730, 643315, 709052, 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';