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

[
  "mother cooking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mother cooking' 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
  455381
  767776
  635193
  639593
  495672
  723738
  813675
  499367
  707584
  465676
  687704
  565307
  796535
  768068
  788714
  559289
  543283
  719479
  712624
  669758
  620630
  720844
  621217
  642371
  642291
  576176
  557062
  580490
  591529
  787864
  457612
  583534
  581143
  458802
  613347
  461690
  460476
  506270
  489943
  514590
  406176
  450259
  553230
  618589
  511219
  464111
  546849
  764003
  440815
  463296
  547661
  634244
  455392
  523226
  566320
  514110
  494936
  504751
  511779
  591453
  619511
  489330
  578678
  641414
  608620
  471633
  620067
  562346
  420925
  521838
  543565
  491753
  621348
]

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 (455381, 767776, 635193, 639593, 495672, 723738, 813675, 499367, 707584, 465676, 687704, 565307, 796535, 768068, 788714, 559289, 543283, 719479, 712624, 669758, 620630, 720844, 621217, 642371, 642291, 576176, 557062, 580490, 591529, 787864, 457612, 583534, 581143, 458802, 613347, 461690, 460476, 506270, 489943, 514590, 406176, 450259, 553230, 618589, 511219, 464111, 546849, 764003, 440815, 463296, 547661, 634244, 455392, 523226, 566320, 514110, 494936, 504751, 511779, 591453, 619511, 489330, 578678, 641414, 608620, 471633, 620067, 562346, 420925, 521838, 543565, 491753, 621348);

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
  406176
  420925
  440815
  450259
  455381
  455392
  457612
  458802
  460476
  461690
  463296
  464111
  465676
  471633
  489330
  489943
  491753
  494936
  495672
  499367
  504751
  506270
  511219
  511779
  514110
  514590
  521838
  523226
  543283
  543565
  546849
  547661
  553230
  557062
  559289
  562346
  565307
  566320
  576176
  578678
  580490
  581143
  583534
  591453
  591529
  608620
  613347
  618589
  619511
  620067
  620630
  621217
  621348
  634244
  635193
  639593
  641414
  642291
  642371
  669758
  687704
  707584
  712624
  719479
  720844
  723738
  764003
  767776
  768068
  787864
  788714
  796535
  813675
]

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 (406176, 420925, 440815, 450259, 455381, 455392, 457612, 458802, 460476, 461690, 463296, 464111, 465676, 471633, 489330, 489943, 491753, 494936, 495672, 499367, 504751, 506270, 511219, 511779, 514110, 514590, 521838, 523226, 543283, 543565, 546849, 547661, 553230, 557062, 559289, 562346, 565307, 566320, 576176, 578678, 580490, 581143, 583534, 591453, 591529, 608620, 613347, 618589, 619511, 620067, 620630, 621217, 621348, 634244, 635193, 639593, 641414, 642291, 642371, 669758, 687704, 707584, 712624, 719479, 720844, 723738, 764003, 767776, 768068, 787864, 788714, 796535, 813675);

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
  406176
  420925
  440815
  450259
  455381
  455392
  457612
  458802
  460476
  461690
  463296
  464111
  465676
  471633
  489330
  489943
  491753
  494936
  495672
  499367
  504751
  506270
  511219
  511779
  514110
  514590
  521838
  523226
  543283
  543565
  546849
  547661
  553230
  557062
  559289
  562346
  565307
  566320
  576176
  578678
  580490
  581143
  583534
  591453
  591529
  608620
  613347
  618589
  619511
  620067
  620630
  621217
  621348
  634244
  635193
  639593
  641414
  642291
  642371
  669758
  687704
  707584
  712624
  719479
  720844
  723738
  764003
  767776
  768068
  787864
  788714
  796535
  813675
]

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 (406176, 420925, 440815, 450259, 455381, 455392, 457612, 458802, 460476, 461690, 463296, 464111, 465676, 471633, 489330, 489943, 491753, 494936, 495672, 499367, 504751, 506270, 511219, 511779, 514110, 514590, 521838, 523226, 543283, 543565, 546849, 547661, 553230, 557062, 559289, 562346, 565307, 566320, 576176, 578678, 580490, 581143, 583534, 591453, 591529, 608620, 613347, 618589, 619511, 620067, 620630, 621217, 621348, 634244, 635193, 639593, 641414, 642291, 642371, 669758, 687704, 707584, 712624, 719479, 720844, 723738, 764003, 767776, 768068, 787864, 788714, 796535, 813675);

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

[
  "мам женщин cooking"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'мам женщин cooking';

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

[
  "мам женщин cooking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'мам женщин cooking';

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 ?

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