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“y(&\n
    p\x12’\x1E\x15Í\x1DVaâ
    """
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01937928260A7012921E15CD1D5661E2 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“y(&\n
    p\x12’\x1E\x15Í\x1DVaâ
    """
  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 = 0x01937928260A7012921E15CD1D5661E2 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 720

[
  b"""
    \x01“y(&\n
    p\x12’\x1E\x15Í\x1DVaâ
    """
  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
  720

SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = 0x01937928260A7012921E15CD1D5661E2 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 720;

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
  387773
  387742
  386218
  385486
  385474
  385123
  383650
  383595
  383290
  382823
  382726
  382465
  382202
  382071
  342450
  320078
  318132
  307654
  305328
  278428
  263929
  263752
  263389
  205133
  201531
  191057
  190925
  190869
  185249
  153358
  146317
  144379
  106347
  102235
  97290
  81585
  75896
  58336
  33714
  30454
  24158
  17180
  7335
  7157
  6981
  6941
  6656
  6609
]

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 (387773, 387742, 386218, 385486, 385474, 385123, 383650, 383595, 383290, 382823, 382726, 382465, 382202, 382071, 342450, 320078, 318132, 307654, 305328, 278428, 263929, 263752, 263389, 205133, 201531, 191057, 190925, 190869, 185249, 153358, 146317, 144379, 106347, 102235, 97290, 81585, 75896, 58336, 33714, 30454, 24158, 17180, 7335, 7157, 6981, 6941, 6656, 6609);

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
  6609
  6656
  6941
  6981
  7157
  7335
  17180
  24158
  30454
  33714
  58336
  75896
  81585
  97290
  102235
  106347
  144379
  146317
  153358
  185249
  190869
  190925
  191057
  201531
  205133
  263389
  263752
  263929
  278428
  305328
  307654
  318132
  320078
  342450
  382071
  382202
  382465
  382726
  382823
  383290
  383595
  383650
  385123
  385474
  385486
  386218
  387742
  387773
]

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 (6609, 6656, 6941, 6981, 7157, 7335, 17180, 24158, 30454, 33714, 58336, 75896, 81585, 97290, 102235, 106347, 144379, 146317, 153358, 185249, 190869, 190925, 191057, 201531, 205133, 263389, 263752, 263929, 278428, 305328, 307654, 318132, 320078, 342450, 382071, 382202, 382465, 382726, 382823, 383290, 383595, 383650, 385123, 385474, 385486, 386218, 387742, 387773);

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
  6609
  6656
  6941
  6981
  7157
  7335
  17180
  24158
  30454
  33714
  58336
  75896
  81585
  97290
  102235
  106347
  144379
  146317
  153358
  185249
  190869
  190925
  191057
  201531
  205133
  263389
  263752
  263929
  278428
  305328
  307654
  318132
  320078
  342450
  382071
  382202
  382465
  382726
  382823
  383290
  383595
  383650
  385123
  385474
  385486
  386218
  387742
  387773
]

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 (6609, 6656, 6941, 6981, 7157, 7335, 17180, 24158, 30454, 33714, 58336, 75896, 81585, 97290, 102235, 106347, 144379, 146317, 153358, 185249, 190869, 190925, 191057, 201531, 205133, 263389, 263752, 263929, 278428, 305328, 307654, 318132, 320078, 342450, 382071, 382202, 382465, 382726, 382823, 383290, 383595, 383650, 385123, 385474, 385486, 386218, 387742, 387773);

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

[
  "brazzers"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'brazzers';

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

[
  "brazzers"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'brazzers';