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

[
  "bbc gangbang skinny"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc gangbang skinny' 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
  603252
  617410
  628091
  426417
  517844
  429805
  452018
  454802
  536638
  532360
  536590
  537660
  530501
  536653
  533773
  551222
  581193
  545341
  583989
  551223
  649525
  647355
  650158
  545393
  569922
  584006
  632649
  637093
  599913
  637008
  601595
  627808
  633446
  633775
  520775
  497870
  531247
  534984
  543858
  565277
  677783
  557676
  633445
  634774
  615717
  632595
  634769
  628082
  632269
  632616
  507880
  545389
  545488
  553272
  707391
  650316
  666880
  666868
  680176
  680197
  695127
  634187
  617132
  630869
  628371
  634218
  633449
  541643
  545418
  628333
  530369
  617420
]

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 (603252, 617410, 628091, 426417, 517844, 429805, 452018, 454802, 536638, 532360, 536590, 537660, 530501, 536653, 533773, 551222, 581193, 545341, 583989, 551223, 649525, 647355, 650158, 545393, 569922, 584006, 632649, 637093, 599913, 637008, 601595, 627808, 633446, 633775, 520775, 497870, 531247, 534984, 543858, 565277, 677783, 557676, 633445, 634774, 615717, 632595, 634769, 628082, 632269, 632616, 507880, 545389, 545488, 553272, 707391, 650316, 666880, 666868, 680176, 680197, 695127, 634187, 617132, 630869, 628371, 634218, 633449, 541643, 545418, 628333, 530369, 617420);

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
  426417
  429805
  452018
  454802
  497870
  507880
  517844
  520775
  530369
  530501
  531247
  532360
  533773
  534984
  536590
  536638
  536653
  537660
  541643
  543858
  545341
  545389
  545393
  545418
  545488
  551222
  551223
  553272
  557676
  565277
  569922
  581193
  583989
  584006
  599913
  601595
  603252
  615717
  617132
  617410
  617420
  627808
  628082
  628091
  628333
  628371
  630869
  632269
  632595
  632616
  632649
  633445
  633446
  633449
  633775
  634187
  634218
  634769
  634774
  637008
  637093
  647355
  649525
  650158
  650316
  666868
  666880
  677783
  680176
  680197
  695127
  707391
]

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 (426417, 429805, 452018, 454802, 497870, 507880, 517844, 520775, 530369, 530501, 531247, 532360, 533773, 534984, 536590, 536638, 536653, 537660, 541643, 543858, 545341, 545389, 545393, 545418, 545488, 551222, 551223, 553272, 557676, 565277, 569922, 581193, 583989, 584006, 599913, 601595, 603252, 615717, 617132, 617410, 617420, 627808, 628082, 628091, 628333, 628371, 630869, 632269, 632595, 632616, 632649, 633445, 633446, 633449, 633775, 634187, 634218, 634769, 634774, 637008, 637093, 647355, 649525, 650158, 650316, 666868, 666880, 677783, 680176, 680197, 695127, 707391);

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
  426417
  429805
  452018
  454802
  497870
  507880
  517844
  520775
  530369
  530501
  531247
  532360
  533773
  534984
  536590
  536638
  536653
  537660
  541643
  543858
  545341
  545389
  545393
  545418
  545488
  551222
  551223
  553272
  557676
  565277
  569922
  581193
  583989
  584006
  599913
  601595
  603252
  615717
  617132
  617410
  617420
  627808
  628082
  628091
  628333
  628371
  630869
  632269
  632595
  632616
  632649
  633445
  633446
  633449
  633775
  634187
  634218
  634769
  634774
  637008
  637093
  647355
  649525
  650158
  650316
  666868
  666880
  677783
  680176
  680197
  695127
  707391
]

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 (426417, 429805, 452018, 454802, 497870, 507880, 517844, 520775, 530369, 530501, 531247, 532360, 533773, 534984, 536590, 536638, 536653, 537660, 541643, 543858, 545341, 545389, 545393, 545418, 545488, 551222, 551223, 553272, 557676, 565277, 569922, 581193, 583989, 584006, 599913, 601595, 603252, 615717, 617132, 617410, 617420, 627808, 628082, 628091, 628333, 628371, 630869, 632269, 632595, 632616, 632649, 633445, 633446, 633449, 633775, 634187, 634218, 634769, 634774, 637008, 637093, 647355, 649525, 650158, 650316, 666868, 666880, 677783, 680176, 680197, 695127, 707391);

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

[
  "bbc gangbang худые"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbc gangbang худые';

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

[
  "bbc gangbang худые"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc gangbang худые';

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 ?

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