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
  72802
  433981
  449081
  427338
  417081
  419696
  449675
  415992
  390729
  429147
  416607
  450215
  459895
  416696
  455080
  427126
  447555
  445945
  464861
  420607
  444418
  365863
  407705
  81174
  450649
  419075
  409577
  541186
  547673
  566631
  804352
  422487
  420380
  444773
  446250
  449561
  574032
  357830
  389262
  435263
  444627
  560093
  383238
  419188
  426217
  441758
  411840
  429750
  460246
  519847
  612937
  466236
  442921
  470764
  437518
  418846
  445498
  580521
  419421
  455435
  386535
  388426
  444562
  441297
  452462
  561286
  385562
  556684
  590488
  421865
  410520
  428959
  416998
]

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 (72802, 433981, 449081, 427338, 417081, 419696, 449675, 415992, 390729, 429147, 416607, 450215, 459895, 416696, 455080, 427126, 447555, 445945, 464861, 420607, 444418, 365863, 407705, 81174, 450649, 419075, 409577, 541186, 547673, 566631, 804352, 422487, 420380, 444773, 446250, 449561, 574032, 357830, 389262, 435263, 444627, 560093, 383238, 419188, 426217, 441758, 411840, 429750, 460246, 519847, 612937, 466236, 442921, 470764, 437518, 418846, 445498, 580521, 419421, 455435, 386535, 388426, 444562, 441297, 452462, 561286, 385562, 556684, 590488, 421865, 410520, 428959, 416998);

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
  72802
  81174
  357830
  365863
  383238
  385562
  386535
  388426
  389262
  390729
  407705
  409577
  410520
  411840
  415992
  416607
  416696
  416998
  417081
  418846
  419075
  419188
  419421
  419696
  420380
  420607
  421865
  422487
  426217
  427126
  427338
  428959
  429147
  429750
  433981
  435263
  437518
  441297
  441758
  442921
  444418
  444562
  444627
  444773
  445498
  445945
  446250
  447555
  449081
  449561
  449675
  450215
  450649
  452462
  455080
  455435
  459895
  460246
  464861
  466236
  470764
  519847
  541186
  547673
  556684
  560093
  561286
  566631
  574032
  580521
  590488
  612937
  804352
]

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 (72802, 81174, 357830, 365863, 383238, 385562, 386535, 388426, 389262, 390729, 407705, 409577, 410520, 411840, 415992, 416607, 416696, 416998, 417081, 418846, 419075, 419188, 419421, 419696, 420380, 420607, 421865, 422487, 426217, 427126, 427338, 428959, 429147, 429750, 433981, 435263, 437518, 441297, 441758, 442921, 444418, 444562, 444627, 444773, 445498, 445945, 446250, 447555, 449081, 449561, 449675, 450215, 450649, 452462, 455080, 455435, 459895, 460246, 464861, 466236, 470764, 519847, 541186, 547673, 556684, 560093, 561286, 566631, 574032, 580521, 590488, 612937, 804352);

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
  72802
  81174
  357830
  365863
  383238
  385562
  386535
  388426
  389262
  390729
  407705
  409577
  410520
  411840
  415992
  416607
  416696
  416998
  417081
  418846
  419075
  419188
  419421
  419696
  420380
  420607
  421865
  422487
  426217
  427126
  427338
  428959
  429147
  429750
  433981
  435263
  437518
  441297
  441758
  442921
  444418
  444562
  444627
  444773
  445498
  445945
  446250
  447555
  449081
  449561
  449675
  450215
  450649
  452462
  455080
  455435
  459895
  460246
  464861
  466236
  470764
  519847
  541186
  547673
  556684
  560093
  561286
  566631
  574032
  580521
  590488
  612937
  804352
]

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 (72802, 81174, 357830, 365863, 383238, 385562, 386535, 388426, 389262, 390729, 407705, 409577, 410520, 411840, 415992, 416607, 416696, 416998, 417081, 418846, 419075, 419188, 419421, 419696, 420380, 420607, 421865, 422487, 426217, 427126, 427338, 428959, 429147, 429750, 433981, 435263, 437518, 441297, 441758, 442921, 444418, 444562, 444627, 444773, 445498, 445945, 446250, 447555, 449081, 449561, 449675, 450215, 450649, 452462, 455080, 455435, 459895, 460246, 464861, 466236, 470764, 519847, 541186, 547673, 556684, 560093, 561286, 566631, 574032, 580521, 590488, 612937, 804352);

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
        ;