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
  619259
  589229
  799600
  803489
  767040
  731005
  776613
  809009
  535374
  600251
  530434
  510995
  535072
  576522
  641554
  742350
  550241
  790218
  514390
  526518
  715365
  663548
  586161
  606088
  539905
  577674
  716624
  708247
  591548
  604082
  587533
  611186
  636656
  630890
  709286
  502250
  782516
  485234
  533926
  469116
  639731
  529704
  523422
  646872
  575329
  621342
  537531
  565612
  577661
  580401
  562291
  606946
  783452
  643027
  535164
  595054
  542730
  696430
  799591
  522191
  526884
  640888
  442363
  562346
  626810
  638380
  662020
  599803
  497155
  567155
  529290
  593872
  484807
]

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 (619259, 589229, 799600, 803489, 767040, 731005, 776613, 809009, 535374, 600251, 530434, 510995, 535072, 576522, 641554, 742350, 550241, 790218, 514390, 526518, 715365, 663548, 586161, 606088, 539905, 577674, 716624, 708247, 591548, 604082, 587533, 611186, 636656, 630890, 709286, 502250, 782516, 485234, 533926, 469116, 639731, 529704, 523422, 646872, 575329, 621342, 537531, 565612, 577661, 580401, 562291, 606946, 783452, 643027, 535164, 595054, 542730, 696430, 799591, 522191, 526884, 640888, 442363, 562346, 626810, 638380, 662020, 599803, 497155, 567155, 529290, 593872, 484807);

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
  442363
  469116
  484807
  485234
  497155
  502250
  510995
  514390
  522191
  523422
  526518
  526884
  529290
  529704
  530434
  533926
  535072
  535164
  535374
  537531
  539905
  542730
  550241
  562291
  562346
  565612
  567155
  575329
  576522
  577661
  577674
  580401
  586161
  587533
  589229
  591548
  593872
  595054
  599803
  600251
  604082
  606088
  606946
  611186
  619259
  621342
  626810
  630890
  636656
  638380
  639731
  640888
  641554
  643027
  646872
  662020
  663548
  696430
  708247
  709286
  715365
  716624
  731005
  742350
  767040
  776613
  782516
  783452
  790218
  799591
  799600
  803489
  809009
]

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 (442363, 469116, 484807, 485234, 497155, 502250, 510995, 514390, 522191, 523422, 526518, 526884, 529290, 529704, 530434, 533926, 535072, 535164, 535374, 537531, 539905, 542730, 550241, 562291, 562346, 565612, 567155, 575329, 576522, 577661, 577674, 580401, 586161, 587533, 589229, 591548, 593872, 595054, 599803, 600251, 604082, 606088, 606946, 611186, 619259, 621342, 626810, 630890, 636656, 638380, 639731, 640888, 641554, 643027, 646872, 662020, 663548, 696430, 708247, 709286, 715365, 716624, 731005, 742350, 767040, 776613, 782516, 783452, 790218, 799591, 799600, 803489, 809009);

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
  442363
  469116
  484807
  485234
  497155
  502250
  510995
  514390
  522191
  523422
  526518
  526884
  529290
  529704
  530434
  533926
  535072
  535164
  535374
  537531
  539905
  542730
  550241
  562291
  562346
  565612
  567155
  575329
  576522
  577661
  577674
  580401
  586161
  587533
  589229
  591548
  593872
  595054
  599803
  600251
  604082
  606088
  606946
  611186
  619259
  621342
  626810
  630890
  636656
  638380
  639731
  640888
  641554
  643027
  646872
  662020
  663548
  696430
  708247
  709286
  715365
  716624
  731005
  742350
  767040
  776613
  782516
  783452
  790218
  799591
  799600
  803489
  809009
]

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 (442363, 469116, 484807, 485234, 497155, 502250, 510995, 514390, 522191, 523422, 526518, 526884, 529290, 529704, 530434, 533926, 535072, 535164, 535374, 537531, 539905, 542730, 550241, 562291, 562346, 565612, 567155, 575329, 576522, 577661, 577674, 580401, 586161, 587533, 589229, 591548, 593872, 595054, 599803, 600251, 604082, 606088, 606946, 611186, 619259, 621342, 626810, 630890, 636656, 638380, 639731, 640888, 641554, 643027, 646872, 662020, 663548, 696430, 708247, 709286, 715365, 716624, 731005, 742350, 767040, 776613, 782516, 783452, 790218, 799591, 799600, 803489, 809009);

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
        ;