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
  495494
  402611
  420326
  577418
  477382
  498869
  502726
  552947
  479308
  494578
  189004
  506714
  449447
  443006
  453865
  432743
  565855
  563820
  470567
  522506
  488203
  528445
  474923
  596622
  409085
  553545
  525881
  438110
  273182
  402341
  397144
  388709
  474224
  437985
  455194
  453595
  443852
  392214
  444958
  519322
  466299
  443711
  522337
  490155
  544199
  627120
  460484
  479415
  745946
  495491
  462556
  457767
  531282
  505678
  469303
  479498
  699796
  475524
  557978
  581618
  557977
  601551
  457649
  395780
  388725
  472003
  482946
  516819
  517189
  619728
  482910
  488514
]

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 (495494, 402611, 420326, 577418, 477382, 498869, 502726, 552947, 479308, 494578, 189004, 506714, 449447, 443006, 453865, 432743, 565855, 563820, 470567, 522506, 488203, 528445, 474923, 596622, 409085, 553545, 525881, 438110, 273182, 402341, 397144, 388709, 474224, 437985, 455194, 453595, 443852, 392214, 444958, 519322, 466299, 443711, 522337, 490155, 544199, 627120, 460484, 479415, 745946, 495491, 462556, 457767, 531282, 505678, 469303, 479498, 699796, 475524, 557978, 581618, 557977, 601551, 457649, 395780, 388725, 472003, 482946, 516819, 517189, 619728, 482910, 488514);

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
  189004
  273182
  388709
  388725
  392214
  395780
  397144
  402341
  402611
  409085
  420326
  432743
  437985
  438110
  443006
  443711
  443852
  444958
  449447
  453595
  453865
  455194
  457649
  457767
  460484
  462556
  466299
  469303
  470567
  472003
  474224
  474923
  475524
  477382
  479308
  479415
  479498
  482910
  482946
  488203
  488514
  490155
  494578
  495491
  495494
  498869
  502726
  505678
  506714
  516819
  517189
  519322
  522337
  522506
  525881
  528445
  531282
  544199
  552947
  553545
  557977
  557978
  563820
  565855
  577418
  581618
  596622
  601551
  619728
  627120
  699796
  745946
]

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 (189004, 273182, 388709, 388725, 392214, 395780, 397144, 402341, 402611, 409085, 420326, 432743, 437985, 438110, 443006, 443711, 443852, 444958, 449447, 453595, 453865, 455194, 457649, 457767, 460484, 462556, 466299, 469303, 470567, 472003, 474224, 474923, 475524, 477382, 479308, 479415, 479498, 482910, 482946, 488203, 488514, 490155, 494578, 495491, 495494, 498869, 502726, 505678, 506714, 516819, 517189, 519322, 522337, 522506, 525881, 528445, 531282, 544199, 552947, 553545, 557977, 557978, 563820, 565855, 577418, 581618, 596622, 601551, 619728, 627120, 699796, 745946);

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
  189004
  273182
  388709
  388725
  392214
  395780
  397144
  402341
  402611
  409085
  420326
  432743
  437985
  438110
  443006
  443711
  443852
  444958
  449447
  453595
  453865
  455194
  457649
  457767
  460484
  462556
  466299
  469303
  470567
  472003
  474224
  474923
  475524
  477382
  479308
  479415
  479498
  482910
  482946
  488203
  488514
  490155
  494578
  495491
  495494
  498869
  502726
  505678
  506714
  516819
  517189
  519322
  522337
  522506
  525881
  528445
  531282
  544199
  552947
  553545
  557977
  557978
  563820
  565855
  577418
  581618
  596622
  601551
  619728
  627120
  699796
  745946
]

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 (189004, 273182, 388709, 388725, 392214, 395780, 397144, 402341, 402611, 409085, 420326, 432743, 437985, 438110, 443006, 443711, 443852, 444958, 449447, 453595, 453865, 455194, 457649, 457767, 460484, 462556, 466299, 469303, 470567, 472003, 474224, 474923, 475524, 477382, 479308, 479415, 479498, 482910, 482946, 488203, 488514, 490155, 494578, 495491, 495494, 498869, 502726, 505678, 506714, 516819, 517189, 519322, 522337, 522506, 525881, 528445, 531282, 544199, 552947, 553545, 557977, 557978, 563820, 565855, 577418, 581618, 596622, 601551, 619728, 627120, 699796, 745946);

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
        ;