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
  449816
  418130
  106483
  414082
  556906
  584991
  398125
  429362
  467840
  451073
  452910
  419445
  567770
  495203
  439130
  493849
  512081
  575391
  475058
  89199
  446562
  544094
  418367
  496816
  573293
  589151
  418123
  496725
  561385
  573729
  431090
  579406
  601962
  531579
  466161
  562052
  661430
  449687
  450518
  434355
  444180
  582189
  509448
  581172
  507561
  430103
  499477
  554242
  568969
  551199
  525612
  472155
  491920
  579344
  434293
  434374
  471115
  414157
  658952
  463470
  488764
  598046
  516078
  601963
  550343
  482704
  603131
  495217
  490852
  595871
]

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 (449816, 418130, 106483, 414082, 556906, 584991, 398125, 429362, 467840, 451073, 452910, 419445, 567770, 495203, 439130, 493849, 512081, 575391, 475058, 89199, 446562, 544094, 418367, 496816, 573293, 589151, 418123, 496725, 561385, 573729, 431090, 579406, 601962, 531579, 466161, 562052, 661430, 449687, 450518, 434355, 444180, 582189, 509448, 581172, 507561, 430103, 499477, 554242, 568969, 551199, 525612, 472155, 491920, 579344, 434293, 434374, 471115, 414157, 658952, 463470, 488764, 598046, 516078, 601963, 550343, 482704, 603131, 495217, 490852, 595871);

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
  89199
  106483
  398125
  414082
  414157
  418123
  418130
  418367
  419445
  429362
  430103
  431090
  434293
  434355
  434374
  439130
  444180
  446562
  449687
  449816
  450518
  451073
  452910
  463470
  466161
  467840
  471115
  472155
  475058
  482704
  488764
  490852
  491920
  493849
  495203
  495217
  496725
  496816
  499477
  507561
  509448
  512081
  516078
  525612
  531579
  544094
  550343
  551199
  554242
  556906
  561385
  562052
  567770
  568969
  573293
  573729
  575391
  579344
  579406
  581172
  582189
  584991
  589151
  595871
  598046
  601962
  601963
  603131
  658952
  661430
]

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 (89199, 106483, 398125, 414082, 414157, 418123, 418130, 418367, 419445, 429362, 430103, 431090, 434293, 434355, 434374, 439130, 444180, 446562, 449687, 449816, 450518, 451073, 452910, 463470, 466161, 467840, 471115, 472155, 475058, 482704, 488764, 490852, 491920, 493849, 495203, 495217, 496725, 496816, 499477, 507561, 509448, 512081, 516078, 525612, 531579, 544094, 550343, 551199, 554242, 556906, 561385, 562052, 567770, 568969, 573293, 573729, 575391, 579344, 579406, 581172, 582189, 584991, 589151, 595871, 598046, 601962, 601963, 603131, 658952, 661430);

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
  89199
  106483
  398125
  414082
  414157
  418123
  418130
  418367
  419445
  429362
  430103
  431090
  434293
  434355
  434374
  439130
  444180
  446562
  449687
  449816
  450518
  451073
  452910
  463470
  466161
  467840
  471115
  472155
  475058
  482704
  488764
  490852
  491920
  493849
  495203
  495217
  496725
  496816
  499477
  507561
  509448
  512081
  516078
  525612
  531579
  544094
  550343
  551199
  554242
  556906
  561385
  562052
  567770
  568969
  573293
  573729
  575391
  579344
  579406
  581172
  582189
  584991
  589151
  595871
  598046
  601962
  601963
  603131
  658952
  661430
]

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 (89199, 106483, 398125, 414082, 414157, 418123, 418130, 418367, 419445, 429362, 430103, 431090, 434293, 434355, 434374, 439130, 444180, 446562, 449687, 449816, 450518, 451073, 452910, 463470, 466161, 467840, 471115, 472155, 475058, 482704, 488764, 490852, 491920, 493849, 495203, 495217, 496725, 496816, 499477, 507561, 509448, 512081, 516078, 525612, 531579, 544094, 550343, 551199, 554242, 556906, 561385, 562052, 567770, 568969, 573293, 573729, 575391, 579344, 579406, 581172, 582189, 584991, 589151, 595871, 598046, 601962, 601963, 603131, 658952, 661430);

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
        ;