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

[
  "pov swallow"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pov swallow' 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
  466757
  528263
  500210
  510855
  436938
  521785
  444838
  540631
  566295
  682866
  611299
  436933
  456695
  457629
  464661
  455837
  512846
  528882
  584752
  586615
  461635
  452324
  419912
  484283
  457884
  466376
  450851
  486870
  560784
  553239
  426495
  434470
  486881
  498670
  486911
  523154
  529144
  602618
  573800
  572337
  586658
  562763
  616089
  428020
  553992
  591176
  525941
  424190
]

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 (466757, 528263, 500210, 510855, 436938, 521785, 444838, 540631, 566295, 682866, 611299, 436933, 456695, 457629, 464661, 455837, 512846, 528882, 584752, 586615, 461635, 452324, 419912, 484283, 457884, 466376, 450851, 486870, 560784, 553239, 426495, 434470, 486881, 498670, 486911, 523154, 529144, 602618, 573800, 572337, 586658, 562763, 616089, 428020, 553992, 591176, 525941, 424190);

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
  419912
  424190
  426495
  428020
  434470
  436933
  436938
  444838
  450851
  452324
  455837
  456695
  457629
  457884
  461635
  464661
  466376
  466757
  484283
  486870
  486881
  486911
  498670
  500210
  510855
  512846
  521785
  523154
  525941
  528263
  528882
  529144
  540631
  553239
  553992
  560784
  562763
  566295
  572337
  573800
  584752
  586615
  586658
  591176
  602618
  611299
  616089
  682866
]

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 (419912, 424190, 426495, 428020, 434470, 436933, 436938, 444838, 450851, 452324, 455837, 456695, 457629, 457884, 461635, 464661, 466376, 466757, 484283, 486870, 486881, 486911, 498670, 500210, 510855, 512846, 521785, 523154, 525941, 528263, 528882, 529144, 540631, 553239, 553992, 560784, 562763, 566295, 572337, 573800, 584752, 586615, 586658, 591176, 602618, 611299, 616089, 682866);

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
  419912
  424190
  426495
  428020
  434470
  436933
  436938
  444838
  450851
  452324
  455837
  456695
  457629
  457884
  461635
  464661
  466376
  466757
  484283
  486870
  486881
  486911
  498670
  500210
  510855
  512846
  521785
  523154
  525941
  528263
  528882
  529144
  540631
  553239
  553992
  560784
  562763
  566295
  572337
  573800
  584752
  586615
  586658
  591176
  602618
  611299
  616089
  682866
]

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 (419912, 424190, 426495, 428020, 434470, 436933, 436938, 444838, 450851, 452324, 455837, 456695, 457629, 457884, 461635, 464661, 466376, 466757, 484283, 486870, 486881, 486911, 498670, 500210, 510855, 512846, 521785, 523154, 525941, 528263, 528882, 529144, 540631, 553239, 553992, 560784, 562763, 566295, 572337, 573800, 584752, 586615, 586658, 591176, 602618, 611299, 616089, 682866);

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` = 'пов глота';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "pov swallow"
  "pov swallow"
  "pov swallow"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('pov swallow') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('pov swallow')
              AND `query` <> 'pov swallow'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;