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

[
  "между сисек"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'между сисек' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"""
    \x01Æ│Øs░qïüWctæÔ\n
    █
    """
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0192B39D73B0718B8157637491E20ADB LIMIT 1;

SELECT COUNT(*)
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)
            WHERE p.type = ? AND `p`.`status` = ? AND `t0`.`is_tested` = 1

[
  b"""
    \x01Æ│Øs░qïüWctæÔ\n
    █
    """
  0
  10
]

SELECT
  COUNT(*)
FROM
  `trend_has_post` as `t0`
  INNER JOIN `post` as `p` ON (
    trend_id = ?
    AND p.post_id = t0.post_id
  )
WHERE
  p.type = ?
  AND `p`.`status` = ?
  AND `t0`.`is_tested` = 1

SELECT COUNT(*)
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = 0x0192B39D73B0718B8157637491E20ADB AND p.post_id = t0.post_id)
            WHERE p.type = 0 AND `p`.`status` = 10 AND `t0`.`is_tested` = 1
        ;

SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = ? AND p.post_id = t0.post_id WHERE (p.type = ? AND p.status = ?) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120 OFFSET 480

[
  b"""
    \x01Æ│Øs░qïüWctæÔ\n
    █
    """
  0
  10
]

SELECT
  t0.post_id
FROM
  trend_has_post t0
  INNER JOIN post p ON trend_id = ?
  AND p.post_id = t0.post_id
WHERE
  (
    p.type = ?
    AND p.status = ?
  )
  AND (t0.is_tested = 0)
ORDER BY
  t0.ctr DESC
LIMIT
  120
OFFSET
  480

SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = 0x0192B39D73B0718B8157637491E20ADB AND p.post_id = t0.post_id WHERE (p.type = 0 AND p.status = 10) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120 OFFSET 480;

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
  383483
  383347
  382962
  382878
  381949
  381823
  370905
  365293
  364076
  360336
  358438
  350664
  350425
  318378
  310742
  288510
  281574
  280631
  278442
  239555
  234067
  208999
  204834
  197527
  194309
  191529
  190891
  190869
  185563
  181926
  170215
  170069
  163762
  154692
  131772
  108925
  107606
  96503
  95808
  81091
  79469
  72755
  72267
  68658
  38263
  34087
  33714
  21143
  7748
  7335
  7161
  7092
  7065
  4450
  4245
]

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 (383483, 383347, 382962, 382878, 381949, 381823, 370905, 365293, 364076, 360336, 358438, 350664, 350425, 318378, 310742, 288510, 281574, 280631, 278442, 239555, 234067, 208999, 204834, 197527, 194309, 191529, 190891, 190869, 185563, 181926, 170215, 170069, 163762, 154692, 131772, 108925, 107606, 96503, 95808, 81091, 79469, 72755, 72267, 68658, 38263, 34087, 33714, 21143, 7748, 7335, 7161, 7092, 7065, 4450, 4245);

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
  4245
  4450
  7065
  7092
  7161
  7335
  7748
  21143
  33714
  34087
  38263
  68658
  72267
  72755
  79469
  81091
  95808
  96503
  107606
  108925
  131772
  154692
  163762
  170069
  170215
  181926
  185563
  190869
  190891
  191529
  194309
  197527
  204834
  208999
  234067
  239555
  278442
  280631
  281574
  288510
  310742
  318378
  350425
  350664
  358438
  360336
  364076
  365293
  370905
  381823
  381949
  382878
  382962
  383347
  383483
]

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 (4245, 4450, 7065, 7092, 7161, 7335, 7748, 21143, 33714, 34087, 38263, 68658, 72267, 72755, 79469, 81091, 95808, 96503, 107606, 108925, 131772, 154692, 163762, 170069, 170215, 181926, 185563, 190869, 190891, 191529, 194309, 197527, 204834, 208999, 234067, 239555, 278442, 280631, 281574, 288510, 310742, 318378, 350425, 350664, 358438, 360336, 364076, 365293, 370905, 381823, 381949, 382878, 382962, 383347, 383483);

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
  4245
  4450
  7065
  7092
  7161
  7335
  7748
  21143
  33714
  34087
  38263
  68658
  72267
  72755
  79469
  81091
  95808
  96503
  107606
  108925
  131772
  154692
  163762
  170069
  170215
  181926
  185563
  190869
  190891
  191529
  194309
  197527
  204834
  208999
  234067
  239555
  278442
  280631
  281574
  288510
  310742
  318378
  350425
  350664
  358438
  360336
  364076
  365293
  370905
  381823
  381949
  382878
  382962
  383347
  383483
]

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 (4245, 4450, 7065, 7092, 7161, 7335, 7748, 21143, 33714, 34087, 38263, 68658, 72267, 72755, 79469, 81091, 95808, 96503, 107606, 108925, 131772, 154692, 163762, 170069, 170215, 181926, 185563, 190869, 190891, 191529, 194309, 197527, 204834, 208999, 234067, 239555, 278442, 280631, 281574, 288510, 310742, 318378, 350425, 350664, 358438, 360336, 364076, 365293, 370905, 381823, 381949, 382878, 382962, 383347, 383483);

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` = 'межд сиськ';