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

[
  b"Ðüð¥ð╗ð¥ ð▓ð¥ð╗ð¥Ðüð░ÐéÐïðÁ ðÀÐÇðÁð╗ð║ð%ÔǪ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD181D0BED0BBD0BE20D0B2D0BED0BBD0BED181D0B0D182D18BD0B520D0B7D180D0B5D0BBD0BAD025E280A6 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
  523622
  664559
  714335
  598840
  600859
  601672
  628698
  601174
  801560
  728469
  614831
  555031
  469117
  424548
  555963
  455392
  455381
  520138
  497665
  521798
  553208
  559350
  614857
  442196
  464978
  502467
  523358
  595165
  742636
  462840
  446038
  446533
  589683
  827656
  827652
  426399
  475289
  605172
  517808
  513636
  517511
  580921
  714349
  588052
  592756
  586566
  607709
  796804
  746126
  614827
  555055
  825437
  825324
  827143
  827724
  551987
  569309
  791738
  511372
  609161
  509983
  634071
  499564
  522448
  468232
  555983
  593032
  705424
  598649
  473391
  526531
  392676
  431793
  407442
  444918
  434309
  407527
  458008
  490767
  620754
  560385
  483474
]

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 (523622, 664559, 714335, 598840, 600859, 601672, 628698, 601174, 801560, 728469, 614831, 555031, 469117, 424548, 555963, 455392, 455381, 520138, 497665, 521798, 553208, 559350, 614857, 442196, 464978, 502467, 523358, 595165, 742636, 462840, 446038, 446533, 589683, 827656, 827652, 426399, 475289, 605172, 517808, 513636, 517511, 580921, 714349, 588052, 592756, 586566, 607709, 796804, 746126, 614827, 555055, 825437, 825324, 827143, 827724, 551987, 569309, 791738, 511372, 609161, 509983, 634071, 499564, 522448, 468232, 555983, 593032, 705424, 598649, 473391, 526531, 392676, 431793, 407442, 444918, 434309, 407527, 458008, 490767, 620754, 560385, 483474);

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
  392676
  407442
  407527
  424548
  426399
  431793
  434309
  442196
  444918
  446038
  446533
  455381
  455392
  458008
  462840
  464978
  468232
  469117
  473391
  475289
  483474
  490767
  497665
  499564
  502467
  509983
  511372
  513636
  517511
  517808
  520138
  521798
  522448
  523358
  523622
  526531
  551987
  553208
  555031
  555055
  555963
  555983
  559350
  560385
  569309
  580921
  586566
  588052
  589683
  592756
  593032
  595165
  598649
  598840
  600859
  601174
  601672
  605172
  607709
  609161
  614827
  614831
  614857
  620754
  628698
  634071
  664559
  705424
  714335
  728469
  742636
  746126
  791738
  796804
  801560
  825324
  825437
  827143
  827652
  827656
  827724
]

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 (392676, 407442, 407527, 424548, 426399, 431793, 434309, 442196, 444918, 446038, 446533, 455381, 455392, 458008, 462840, 464978, 468232, 469117, 473391, 475289, 483474, 490767, 497665, 499564, 502467, 509983, 511372, 513636, 517511, 517808, 520138, 521798, 522448, 523358, 523622, 526531, 551987, 553208, 555031, 555055, 555963, 555983, 559350, 560385, 569309, 580921, 586566, 588052, 589683, 592756, 593032, 595165, 598649, 598840, 600859, 601174, 601672, 605172, 607709, 609161, 614827, 614831, 614857, 620754, 628698, 634071, 664559, 705424, 714335, 728469, 742636, 746126, 791738, 796804, 801560, 825324, 825437, 827143, 827652, 827656, 827724);

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
  392676
  407442
  407527
  424548
  426399
  431793
  434309
  442196
  444918
  446038
  446533
  455381
  455392
  458008
  462840
  464978
  468232
  469117
  473391
  475289
  483474
  490767
  497665
  499564
  502467
  509983
  511372
  513636
  517511
  517808
  520138
  521798
  522448
  523358
  523622
  526531
  551987
  553208
  555031
  555055
  555963
  555983
  559350
  560385
  569309
  580921
  586566
  588052
  589683
  592756
  593032
  595165
  598649
  598840
  600859
  601174
  601672
  605172
  607709
  609161
  614827
  614831
  614857
  620754
  628698
  634071
  664559
  705424
  714335
  728469
  742636
  746126
  791738
  796804
  801560
  825324
  825437
  827143
  827652
  827656
  827724
]

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 (392676, 407442, 407527, 424548, 426399, 431793, 434309, 442196, 444918, 446038, 446533, 455381, 455392, 458008, 462840, 464978, 468232, 469117, 473391, 475289, 483474, 490767, 497665, 499564, 502467, 509983, 511372, 513636, 517511, 517808, 520138, 521798, 522448, 523358, 523622, 526531, 551987, 553208, 555031, 555055, 555963, 555983, 559350, 560385, 569309, 580921, 586566, 588052, 589683, 592756, 593032, 595165, 598649, 598840, 600859, 601174, 601672, 605172, 607709, 609161, 614827, 614831, 614857, 620754, 628698, 634071, 664559, 705424, 714335, 728469, 742636, 746126, 791738, 796804, 801560, 825324, 825437, 827143, 827652, 827656, 827724);

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

[
  "соло волосатая зрелая женщин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'соло волосатая зрелая женщин';

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

[
  "соло волосатая зрелая женщин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'соло волосатая зрелая женщин';