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

[
  "cuckold car wife"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cuckold car wife' 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
  734680
  725089
  618214
  625552
  738957
  734388
  760217
  599792
  769245
  745800
  725094
  734383
  734368
  733561
  667436
  734387
  603669
  656852
  603609
  619073
  635624
  619061
  520405
  789064
  604052
  740301
  725971
  506118
  627846
  723971
  729578
  725974
  788697
  726034
  723344
  796523
  618954
  554649
  635686
  694203
  726003
  725825
  620692
  675280
  573492
  699413
  506775
  668382
  578132
  522439
  811964
  811955
  749488
  554414
  525095
  615394
  761145
  532187
  525524
  512137
  561095
  520062
  798867
  606533
  635633
  627877
  586397
  513880
  734385
  613951
  528019
  488198
]

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 (734680, 725089, 618214, 625552, 738957, 734388, 760217, 599792, 769245, 745800, 725094, 734383, 734368, 733561, 667436, 734387, 603669, 656852, 603609, 619073, 635624, 619061, 520405, 789064, 604052, 740301, 725971, 506118, 627846, 723971, 729578, 725974, 788697, 726034, 723344, 796523, 618954, 554649, 635686, 694203, 726003, 725825, 620692, 675280, 573492, 699413, 506775, 668382, 578132, 522439, 811964, 811955, 749488, 554414, 525095, 615394, 761145, 532187, 525524, 512137, 561095, 520062, 798867, 606533, 635633, 627877, 586397, 513880, 734385, 613951, 528019, 488198);

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
  488198
  506118
  506775
  512137
  513880
  520062
  520405
  522439
  525095
  525524
  528019
  532187
  554414
  554649
  561095
  573492
  578132
  586397
  599792
  603609
  603669
  604052
  606533
  613951
  615394
  618214
  618954
  619061
  619073
  620692
  625552
  627846
  627877
  635624
  635633
  635686
  656852
  667436
  668382
  675280
  694203
  699413
  723344
  723971
  725089
  725094
  725825
  725971
  725974
  726003
  726034
  729578
  733561
  734368
  734383
  734385
  734387
  734388
  734680
  738957
  740301
  745800
  749488
  760217
  761145
  769245
  788697
  789064
  796523
  798867
  811955
  811964
]

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 (488198, 506118, 506775, 512137, 513880, 520062, 520405, 522439, 525095, 525524, 528019, 532187, 554414, 554649, 561095, 573492, 578132, 586397, 599792, 603609, 603669, 604052, 606533, 613951, 615394, 618214, 618954, 619061, 619073, 620692, 625552, 627846, 627877, 635624, 635633, 635686, 656852, 667436, 668382, 675280, 694203, 699413, 723344, 723971, 725089, 725094, 725825, 725971, 725974, 726003, 726034, 729578, 733561, 734368, 734383, 734385, 734387, 734388, 734680, 738957, 740301, 745800, 749488, 760217, 761145, 769245, 788697, 789064, 796523, 798867, 811955, 811964);

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
  488198
  506118
  506775
  512137
  513880
  520062
  520405
  522439
  525095
  525524
  528019
  532187
  554414
  554649
  561095
  573492
  578132
  586397
  599792
  603609
  603669
  604052
  606533
  613951
  615394
  618214
  618954
  619061
  619073
  620692
  625552
  627846
  627877
  635624
  635633
  635686
  656852
  667436
  668382
  675280
  694203
  699413
  723344
  723971
  725089
  725094
  725825
  725971
  725974
  726003
  726034
  729578
  733561
  734368
  734383
  734385
  734387
  734388
  734680
  738957
  740301
  745800
  749488
  760217
  761145
  769245
  788697
  789064
  796523
  798867
  811955
  811964
]

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 (488198, 506118, 506775, 512137, 513880, 520062, 520405, 522439, 525095, 525524, 528019, 532187, 554414, 554649, 561095, 573492, 578132, 586397, 599792, 603609, 603669, 604052, 606533, 613951, 615394, 618214, 618954, 619061, 619073, 620692, 625552, 627846, 627877, 635624, 635633, 635686, 656852, 667436, 668382, 675280, 694203, 699413, 723344, 723971, 725089, 725094, 725825, 725971, 725974, 726003, 726034, 729578, 733561, 734368, 734383, 734385, 734387, 734388, 734680, 738957, 740301, 745800, 749488, 760217, 761145, 769245, 788697, 789064, 796523, 798867, 811955, 811964);

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 ?

[
  "cuckold car wife"
  "cuckold car wife"
  "cuckold car wife"
  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 ('cuckold car wife') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('cuckold car wife')
              AND `query` <> 'cuckold car wife'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;