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

[
  "milf fat"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf fat' 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
  587874
  613977
  608437
  805638
  453400
  457000
  458974
  466875
  392754
  444917
  454271
  451248
  523861
  508721
  484316
  459512
  425834
  411227
  444916
  445047
  452195
  521367
  506941
  535464
  517722
  522783
  473205
  569960
  560385
  650614
  646895
  595532
  624843
  617116
  599299
  603605
  643370
  457428
  465552
  455436
  482094
  430301
  528877
  491762
  483357
  509988
  443635
  452284
  455685
  466007
  514576
  496802
  490608
  569132
  623641
  411189
  457473
  452363
  484807
  571734
  603612
  625770
  482808
  518012
  518131
  520413
  597689
  607413
  455912
  539354
  493122
  526211
  553300
  506269
]

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 (587874, 613977, 608437, 805638, 453400, 457000, 458974, 466875, 392754, 444917, 454271, 451248, 523861, 508721, 484316, 459512, 425834, 411227, 444916, 445047, 452195, 521367, 506941, 535464, 517722, 522783, 473205, 569960, 560385, 650614, 646895, 595532, 624843, 617116, 599299, 603605, 643370, 457428, 465552, 455436, 482094, 430301, 528877, 491762, 483357, 509988, 443635, 452284, 455685, 466007, 514576, 496802, 490608, 569132, 623641, 411189, 457473, 452363, 484807, 571734, 603612, 625770, 482808, 518012, 518131, 520413, 597689, 607413, 455912, 539354, 493122, 526211, 553300, 506269);

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
  392754
  411189
  411227
  425834
  430301
  443635
  444916
  444917
  445047
  451248
  452195
  452284
  452363
  453400
  454271
  455436
  455685
  455912
  457000
  457428
  457473
  458974
  459512
  465552
  466007
  466875
  473205
  482094
  482808
  483357
  484316
  484807
  490608
  491762
  493122
  496802
  506269
  506941
  508721
  509988
  514576
  517722
  518012
  518131
  520413
  521367
  522783
  523861
  526211
  528877
  535464
  539354
  553300
  560385
  569132
  569960
  571734
  587874
  595532
  597689
  599299
  603605
  603612
  607413
  608437
  613977
  617116
  623641
  624843
  625770
  643370
  646895
  650614
  805638
]

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 (392754, 411189, 411227, 425834, 430301, 443635, 444916, 444917, 445047, 451248, 452195, 452284, 452363, 453400, 454271, 455436, 455685, 455912, 457000, 457428, 457473, 458974, 459512, 465552, 466007, 466875, 473205, 482094, 482808, 483357, 484316, 484807, 490608, 491762, 493122, 496802, 506269, 506941, 508721, 509988, 514576, 517722, 518012, 518131, 520413, 521367, 522783, 523861, 526211, 528877, 535464, 539354, 553300, 560385, 569132, 569960, 571734, 587874, 595532, 597689, 599299, 603605, 603612, 607413, 608437, 613977, 617116, 623641, 624843, 625770, 643370, 646895, 650614, 805638);

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
  392754
  411189
  411227
  425834
  430301
  443635
  444916
  444917
  445047
  451248
  452195
  452284
  452363
  453400
  454271
  455436
  455685
  455912
  457000
  457428
  457473
  458974
  459512
  465552
  466007
  466875
  473205
  482094
  482808
  483357
  484316
  484807
  490608
  491762
  493122
  496802
  506269
  506941
  508721
  509988
  514576
  517722
  518012
  518131
  520413
  521367
  522783
  523861
  526211
  528877
  535464
  539354
  553300
  560385
  569132
  569960
  571734
  587874
  595532
  597689
  599299
  603605
  603612
  607413
  608437
  613977
  617116
  623641
  624843
  625770
  643370
  646895
  650614
  805638
]

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 (392754, 411189, 411227, 425834, 430301, 443635, 444916, 444917, 445047, 451248, 452195, 452284, 452363, 453400, 454271, 455436, 455685, 455912, 457000, 457428, 457473, 458974, 459512, 465552, 466007, 466875, 473205, 482094, 482808, 483357, 484316, 484807, 490608, 491762, 493122, 496802, 506269, 506941, 508721, 509988, 514576, 517722, 518012, 518131, 520413, 521367, 522783, 523861, 526211, 528877, 535464, 539354, 553300, 560385, 569132, 569960, 571734, 587874, 595532, 597689, 599299, 603605, 603612, 607413, 608437, 613977, 617116, 623641, 624843, 625770, 643370, 646895, 650614, 805638);

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

[
  "milf fat"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf fat';

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

[
  "milf fat"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf fat';

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 ?

[
  "milf fat"
  "milf fat"
  "milf fat"
  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 ('milf fat') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('milf fat')
              AND `query` <> 'milf fat'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;