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
  384177
  445249
  644203
  486864
  428342
  487424
  627774
  573757
  433229
  580449
  599466
  591885
  479965
  591674
  473226
  565534
  551038
  794947
  598142
  518633
  497834
  511562
  599192
  417960
  443107
  406685
  625001
  612792
  515119
  493958
  559374
  654502
  469763
  487439
  492827
  509855
  624552
  471636
  473102
  523474
  514997
  626881
  603527
  437815
  510596
  527767
  563472
  626485
  514648
  558003
  550415
  652263
  621965
  624927
  607329
  591439
  590884
  620262
  465487
  494702
  497921
  529290
  546701
  559392
  557249
  624846
  590667
  622184
  614921
  491250
  597240
  610606
  472750
]

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 (384177, 445249, 644203, 486864, 428342, 487424, 627774, 573757, 433229, 580449, 599466, 591885, 479965, 591674, 473226, 565534, 551038, 794947, 598142, 518633, 497834, 511562, 599192, 417960, 443107, 406685, 625001, 612792, 515119, 493958, 559374, 654502, 469763, 487439, 492827, 509855, 624552, 471636, 473102, 523474, 514997, 626881, 603527, 437815, 510596, 527767, 563472, 626485, 514648, 558003, 550415, 652263, 621965, 624927, 607329, 591439, 590884, 620262, 465487, 494702, 497921, 529290, 546701, 559392, 557249, 624846, 590667, 622184, 614921, 491250, 597240, 610606, 472750);

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
  384177
  406685
  417960
  428342
  433229
  437815
  443107
  445249
  465487
  469763
  471636
  472750
  473102
  473226
  479965
  486864
  487424
  487439
  491250
  492827
  493958
  494702
  497834
  497921
  509855
  510596
  511562
  514648
  514997
  515119
  518633
  523474
  527767
  529290
  546701
  550415
  551038
  557249
  558003
  559374
  559392
  563472
  565534
  573757
  580449
  590667
  590884
  591439
  591674
  591885
  597240
  598142
  599192
  599466
  603527
  607329
  610606
  612792
  614921
  620262
  621965
  622184
  624552
  624846
  624927
  625001
  626485
  626881
  627774
  644203
  652263
  654502
  794947
]

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 (384177, 406685, 417960, 428342, 433229, 437815, 443107, 445249, 465487, 469763, 471636, 472750, 473102, 473226, 479965, 486864, 487424, 487439, 491250, 492827, 493958, 494702, 497834, 497921, 509855, 510596, 511562, 514648, 514997, 515119, 518633, 523474, 527767, 529290, 546701, 550415, 551038, 557249, 558003, 559374, 559392, 563472, 565534, 573757, 580449, 590667, 590884, 591439, 591674, 591885, 597240, 598142, 599192, 599466, 603527, 607329, 610606, 612792, 614921, 620262, 621965, 622184, 624552, 624846, 624927, 625001, 626485, 626881, 627774, 644203, 652263, 654502, 794947);

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
  384177
  406685
  417960
  428342
  433229
  437815
  443107
  445249
  465487
  469763
  471636
  472750
  473102
  473226
  479965
  486864
  487424
  487439
  491250
  492827
  493958
  494702
  497834
  497921
  509855
  510596
  511562
  514648
  514997
  515119
  518633
  523474
  527767
  529290
  546701
  550415
  551038
  557249
  558003
  559374
  559392
  563472
  565534
  573757
  580449
  590667
  590884
  591439
  591674
  591885
  597240
  598142
  599192
  599466
  603527
  607329
  610606
  612792
  614921
  620262
  621965
  622184
  624552
  624846
  624927
  625001
  626485
  626881
  627774
  644203
  652263
  654502
  794947
]

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 (384177, 406685, 417960, 428342, 433229, 437815, 443107, 445249, 465487, 469763, 471636, 472750, 473102, 473226, 479965, 486864, 487424, 487439, 491250, 492827, 493958, 494702, 497834, 497921, 509855, 510596, 511562, 514648, 514997, 515119, 518633, 523474, 527767, 529290, 546701, 550415, 551038, 557249, 558003, 559374, 559392, 563472, 565534, 573757, 580449, 590667, 590884, 591439, 591674, 591885, 597240, 598142, 599192, 599466, 603527, 607329, 610606, 612792, 614921, 620262, 621965, 622184, 624552, 624846, 624927, 625001, 626485, 626881, 627774, 644203, 652263, 654502, 794947);

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
        ;