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

[
  "shorts facesitting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'shorts facesitting' 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
  417272
  555574
  464245
  426632
  745307
  464190
  427131
  436827
  156014
  532344
  479246
  516991
  547623
  454639
  514985
  462513
  428122
  419793
  425662
  523700
  388100
  387915
  575702
  651920
  600651
  448068
  539441
  468540
  515123
  517683
  576400
  583617
  563211
  406457
  484342
  531446
  393751
  443644
  500469
  521525
  458578
  459389
  508128
  444908
  515234
  559106
  583654
  681310
  624859
  603724
  528571
  621273
  521523
  517784
  534320
  691196
  450935
  524029
  576310
  516291
  543884
  651877
  579301
  471629
  487435
  576089
  519198
  620290
  476844
  415419
  589148
  503840
  490308
]

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 (417272, 555574, 464245, 426632, 745307, 464190, 427131, 436827, 156014, 532344, 479246, 516991, 547623, 454639, 514985, 462513, 428122, 419793, 425662, 523700, 388100, 387915, 575702, 651920, 600651, 448068, 539441, 468540, 515123, 517683, 576400, 583617, 563211, 406457, 484342, 531446, 393751, 443644, 500469, 521525, 458578, 459389, 508128, 444908, 515234, 559106, 583654, 681310, 624859, 603724, 528571, 621273, 521523, 517784, 534320, 691196, 450935, 524029, 576310, 516291, 543884, 651877, 579301, 471629, 487435, 576089, 519198, 620290, 476844, 415419, 589148, 503840, 490308);

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
  156014
  387915
  388100
  393751
  406457
  415419
  417272
  419793
  425662
  426632
  427131
  428122
  436827
  443644
  444908
  448068
  450935
  454639
  458578
  459389
  462513
  464190
  464245
  468540
  471629
  476844
  479246
  484342
  487435
  490308
  500469
  503840
  508128
  514985
  515123
  515234
  516291
  516991
  517683
  517784
  519198
  521523
  521525
  523700
  524029
  528571
  531446
  532344
  534320
  539441
  543884
  547623
  555574
  559106
  563211
  575702
  576089
  576310
  576400
  579301
  583617
  583654
  589148
  600651
  603724
  620290
  621273
  624859
  651877
  651920
  681310
  691196
  745307
]

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 (156014, 387915, 388100, 393751, 406457, 415419, 417272, 419793, 425662, 426632, 427131, 428122, 436827, 443644, 444908, 448068, 450935, 454639, 458578, 459389, 462513, 464190, 464245, 468540, 471629, 476844, 479246, 484342, 487435, 490308, 500469, 503840, 508128, 514985, 515123, 515234, 516291, 516991, 517683, 517784, 519198, 521523, 521525, 523700, 524029, 528571, 531446, 532344, 534320, 539441, 543884, 547623, 555574, 559106, 563211, 575702, 576089, 576310, 576400, 579301, 583617, 583654, 589148, 600651, 603724, 620290, 621273, 624859, 651877, 651920, 681310, 691196, 745307);

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
  156014
  387915
  388100
  393751
  406457
  415419
  417272
  419793
  425662
  426632
  427131
  428122
  436827
  443644
  444908
  448068
  450935
  454639
  458578
  459389
  462513
  464190
  464245
  468540
  471629
  476844
  479246
  484342
  487435
  490308
  500469
  503840
  508128
  514985
  515123
  515234
  516291
  516991
  517683
  517784
  519198
  521523
  521525
  523700
  524029
  528571
  531446
  532344
  534320
  539441
  543884
  547623
  555574
  559106
  563211
  575702
  576089
  576310
  576400
  579301
  583617
  583654
  589148
  600651
  603724
  620290
  621273
  624859
  651877
  651920
  681310
  691196
  745307
]

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 (156014, 387915, 388100, 393751, 406457, 415419, 417272, 419793, 425662, 426632, 427131, 428122, 436827, 443644, 444908, 448068, 450935, 454639, 458578, 459389, 462513, 464190, 464245, 468540, 471629, 476844, 479246, 484342, 487435, 490308, 500469, 503840, 508128, 514985, 515123, 515234, 516291, 516991, 517683, 517784, 519198, 521523, 521525, 523700, 524029, 528571, 531446, 532344, 534320, 539441, 543884, 547623, 555574, 559106, 563211, 575702, 576089, 576310, 576400, 579301, 583617, 583654, 589148, 600651, 603724, 620290, 621273, 624859, 651877, 651920, 681310, 691196, 745307);

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 ?

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