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

[
  "massage pussy ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'massage pussy ass' 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
  430236
  456058
  464107
  516063
  527451
  525116
  457934
  407365
  592944
  810900
  599052
  492506
  473286
  398824
  585345
  721560
  440701
  395249
  480064
  30454
  814787
  588647
  599712
  761875
  607079
  442552
  430377
  449438
  584797
  574572
  798645
  435941
  668501
  461108
  454982
  476691
  552372
  565947
  676149
  689622
  454135
  456291
  508555
  523029
  610995
  413273
  467957
  493270
  484553
  499800
  465519
  468721
  509972
  513521
  620797
  452100
  498211
  525349
  529524
  766625
  429084
  496870
  476909
  522287
  484807
  440569
  413806
  564007
  510571
  624847
]

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 (430236, 456058, 464107, 516063, 527451, 525116, 457934, 407365, 592944, 810900, 599052, 492506, 473286, 398824, 585345, 721560, 440701, 395249, 480064, 30454, 814787, 588647, 599712, 761875, 607079, 442552, 430377, 449438, 584797, 574572, 798645, 435941, 668501, 461108, 454982, 476691, 552372, 565947, 676149, 689622, 454135, 456291, 508555, 523029, 610995, 413273, 467957, 493270, 484553, 499800, 465519, 468721, 509972, 513521, 620797, 452100, 498211, 525349, 529524, 766625, 429084, 496870, 476909, 522287, 484807, 440569, 413806, 564007, 510571, 624847);

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
  30454
  395249
  398824
  407365
  413273
  413806
  429084
  430236
  430377
  435941
  440569
  440701
  442552
  449438
  452100
  454135
  454982
  456058
  456291
  457934
  461108
  464107
  465519
  467957
  468721
  473286
  476691
  476909
  480064
  484553
  484807
  492506
  493270
  496870
  498211
  499800
  508555
  509972
  510571
  513521
  516063
  522287
  523029
  525116
  525349
  527451
  529524
  552372
  564007
  565947
  574572
  584797
  585345
  588647
  592944
  599052
  599712
  607079
  610995
  620797
  624847
  668501
  676149
  689622
  721560
  761875
  766625
  798645
  810900
  814787
]

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 (30454, 395249, 398824, 407365, 413273, 413806, 429084, 430236, 430377, 435941, 440569, 440701, 442552, 449438, 452100, 454135, 454982, 456058, 456291, 457934, 461108, 464107, 465519, 467957, 468721, 473286, 476691, 476909, 480064, 484553, 484807, 492506, 493270, 496870, 498211, 499800, 508555, 509972, 510571, 513521, 516063, 522287, 523029, 525116, 525349, 527451, 529524, 552372, 564007, 565947, 574572, 584797, 585345, 588647, 592944, 599052, 599712, 607079, 610995, 620797, 624847, 668501, 676149, 689622, 721560, 761875, 766625, 798645, 810900, 814787);

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
  30454
  395249
  398824
  407365
  413273
  413806
  429084
  430236
  430377
  435941
  440569
  440701
  442552
  449438
  452100
  454135
  454982
  456058
  456291
  457934
  461108
  464107
  465519
  467957
  468721
  473286
  476691
  476909
  480064
  484553
  484807
  492506
  493270
  496870
  498211
  499800
  508555
  509972
  510571
  513521
  516063
  522287
  523029
  525116
  525349
  527451
  529524
  552372
  564007
  565947
  574572
  584797
  585345
  588647
  592944
  599052
  599712
  607079
  610995
  620797
  624847
  668501
  676149
  689622
  721560
  761875
  766625
  798645
  810900
  814787
]

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 (30454, 395249, 398824, 407365, 413273, 413806, 429084, 430236, 430377, 435941, 440569, 440701, 442552, 449438, 452100, 454135, 454982, 456058, 456291, 457934, 461108, 464107, 465519, 467957, 468721, 473286, 476691, 476909, 480064, 484553, 484807, 492506, 493270, 496870, 498211, 499800, 508555, 509972, 510571, 513521, 516063, 522287, 523029, 525116, 525349, 527451, 529524, 552372, 564007, 565947, 574572, 584797, 585345, 588647, 592944, 599052, 599712, 607079, 610995, 620797, 624847, 668501, 676149, 689622, 721560, 761875, 766625, 798645, 810900, 814787);

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

[
  "массаж pussy жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'массаж pussy жоп';

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

[
  "массаж pussy жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'массаж pussy жоп';

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 ?

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