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 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
  760218
  420613
  523532
  761592
  747956
  488929
  604475
  804524
  761007
  609866
  811128
  503144
  680251
  704212
  680260
  752132
  619375
  720701
  761083
  642779
  612363
  524089
  620205
  624282
  801305
  713834
  798990
  624299
  750499
  543013
  511268
  616025
  761585
  619367
  703089
  556015
  815002
  608425
  608765
  775962
  617408
  714500
  622391
  656575
  695127
  585990
  685001
  622402
  666540
  666550
  790754
  666546
  811497
  495665
  523205
  634482
  613832
  666883
  547366
  748531
  508430
  545410
  489653
  584492
  545389
  545611
  694641
  582229
]

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 (760218, 420613, 523532, 761592, 747956, 488929, 604475, 804524, 761007, 609866, 811128, 503144, 680251, 704212, 680260, 752132, 619375, 720701, 761083, 642779, 612363, 524089, 620205, 624282, 801305, 713834, 798990, 624299, 750499, 543013, 511268, 616025, 761585, 619367, 703089, 556015, 815002, 608425, 608765, 775962, 617408, 714500, 622391, 656575, 695127, 585990, 685001, 622402, 666540, 666550, 790754, 666546, 811497, 495665, 523205, 634482, 613832, 666883, 547366, 748531, 508430, 545410, 489653, 584492, 545389, 545611, 694641, 582229);

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
  420613
  488929
  489653
  495665
  503144
  508430
  511268
  523205
  523532
  524089
  543013
  545389
  545410
  545611
  547366
  556015
  582229
  584492
  585990
  604475
  608425
  608765
  609866
  612363
  613832
  616025
  617408
  619367
  619375
  620205
  622391
  622402
  624282
  624299
  634482
  642779
  656575
  666540
  666546
  666550
  666883
  680251
  680260
  685001
  694641
  695127
  703089
  704212
  713834
  714500
  720701
  747956
  748531
  750499
  752132
  760218
  761007
  761083
  761585
  761592
  775962
  790754
  798990
  801305
  804524
  811128
  811497
  815002
]

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 (420613, 488929, 489653, 495665, 503144, 508430, 511268, 523205, 523532, 524089, 543013, 545389, 545410, 545611, 547366, 556015, 582229, 584492, 585990, 604475, 608425, 608765, 609866, 612363, 613832, 616025, 617408, 619367, 619375, 620205, 622391, 622402, 624282, 624299, 634482, 642779, 656575, 666540, 666546, 666550, 666883, 680251, 680260, 685001, 694641, 695127, 703089, 704212, 713834, 714500, 720701, 747956, 748531, 750499, 752132, 760218, 761007, 761083, 761585, 761592, 775962, 790754, 798990, 801305, 804524, 811128, 811497, 815002);

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
  420613
  488929
  489653
  495665
  503144
  508430
  511268
  523205
  523532
  524089
  543013
  545389
  545410
  545611
  547366
  556015
  582229
  584492
  585990
  604475
  608425
  608765
  609866
  612363
  613832
  616025
  617408
  619367
  619375
  620205
  622391
  622402
  624282
  624299
  634482
  642779
  656575
  666540
  666546
  666550
  666883
  680251
  680260
  685001
  694641
  695127
  703089
  704212
  713834
  714500
  720701
  747956
  748531
  750499
  752132
  760218
  761007
  761083
  761585
  761592
  775962
  790754
  798990
  801305
  804524
  811128
  811497
  815002
]

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 (420613, 488929, 489653, 495665, 503144, 508430, 511268, 523205, 523532, 524089, 543013, 545389, 545410, 545611, 547366, 556015, 582229, 584492, 585990, 604475, 608425, 608765, 609866, 612363, 613832, 616025, 617408, 619367, 619375, 620205, 622391, 622402, 624282, 624299, 634482, 642779, 656575, 666540, 666546, 666550, 666883, 680251, 680260, 685001, 694641, 695127, 703089, 704212, 713834, 714500, 720701, 747956, 748531, 750499, 752132, 760218, 761007, 761083, 761585, 761592, 775962, 790754, 798990, 801305, 804524, 811128, 811497, 815002);

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 ?

[
  "зрелый анальный кремпай"
  "зрелый анальный кремпай"
  "зрелый анальный кремпай"
  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 ('зрелый анальный кремпай') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('зрелый анальный кремпай')
              AND `query` <> 'зрелый анальный кремпай'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;