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
  459429
  547803
  546284
  626044
  439034
  602832
  506321
  559789
  397655
  493490
  456229
  592362
  619710
  738348
  461704
  788521
  608491
  407436
  416000
  416527
  794236
  451337
  547788
  542142
  591805
  801639
  760381
  739119
  760392
  51911
  396784
  521831
  465132
  533897
  476163
  739125
  717514
  476164
  493494
  555024
  620648
  808155
  766335
  459198
  498114
  416025
  554235
  444513
  514231
  489310
  415749
  442064
  413373
  434376
  501258
  529234
  418102
  497665
  493411
  541832
  599478
  731063
  613515
  484359
  546794
  491665
]

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 (459429, 547803, 546284, 626044, 439034, 602832, 506321, 559789, 397655, 493490, 456229, 592362, 619710, 738348, 461704, 788521, 608491, 407436, 416000, 416527, 794236, 451337, 547788, 542142, 591805, 801639, 760381, 739119, 760392, 51911, 396784, 521831, 465132, 533897, 476163, 739125, 717514, 476164, 493494, 555024, 620648, 808155, 766335, 459198, 498114, 416025, 554235, 444513, 514231, 489310, 415749, 442064, 413373, 434376, 501258, 529234, 418102, 497665, 493411, 541832, 599478, 731063, 613515, 484359, 546794, 491665);

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
  51911
  396784
  397655
  407436
  413373
  415749
  416000
  416025
  416527
  418102
  434376
  439034
  442064
  444513
  451337
  456229
  459198
  459429
  461704
  465132
  476163
  476164
  484359
  489310
  491665
  493411
  493490
  493494
  497665
  498114
  501258
  506321
  514231
  521831
  529234
  533897
  541832
  542142
  546284
  546794
  547788
  547803
  554235
  555024
  559789
  591805
  592362
  599478
  602832
  608491
  613515
  619710
  620648
  626044
  717514
  731063
  738348
  739119
  739125
  760381
  760392
  766335
  788521
  794236
  801639
  808155
]

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 (51911, 396784, 397655, 407436, 413373, 415749, 416000, 416025, 416527, 418102, 434376, 439034, 442064, 444513, 451337, 456229, 459198, 459429, 461704, 465132, 476163, 476164, 484359, 489310, 491665, 493411, 493490, 493494, 497665, 498114, 501258, 506321, 514231, 521831, 529234, 533897, 541832, 542142, 546284, 546794, 547788, 547803, 554235, 555024, 559789, 591805, 592362, 599478, 602832, 608491, 613515, 619710, 620648, 626044, 717514, 731063, 738348, 739119, 739125, 760381, 760392, 766335, 788521, 794236, 801639, 808155);

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
  51911
  396784
  397655
  407436
  413373
  415749
  416000
  416025
  416527
  418102
  434376
  439034
  442064
  444513
  451337
  456229
  459198
  459429
  461704
  465132
  476163
  476164
  484359
  489310
  491665
  493411
  493490
  493494
  497665
  498114
  501258
  506321
  514231
  521831
  529234
  533897
  541832
  542142
  546284
  546794
  547788
  547803
  554235
  555024
  559789
  591805
  592362
  599478
  602832
  608491
  613515
  619710
  620648
  626044
  717514
  731063
  738348
  739119
  739125
  760381
  760392
  766335
  788521
  794236
  801639
  808155
]

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 (51911, 396784, 397655, 407436, 413373, 415749, 416000, 416025, 416527, 418102, 434376, 439034, 442064, 444513, 451337, 456229, 459198, 459429, 461704, 465132, 476163, 476164, 484359, 489310, 491665, 493411, 493490, 493494, 497665, 498114, 501258, 506321, 514231, 521831, 529234, 533897, 541832, 542142, 546284, 546794, 547788, 547803, 554235, 555024, 559789, 591805, 592362, 599478, 602832, 608491, 613515, 619710, 620648, 626044, 717514, 731063, 738348, 739119, 739125, 760381, 760392, 766335, 788521, 794236, 801639, 808155);

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
        ;