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

[
  "anal car skinny"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal car skinny' 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
  463839
  494436
  445731
  721249
  401945
  478088
  625771
  565413
  668372
  622587
  538805
  576397
  702699
  443986
  471548
  420147
  542881
  793202
  491614
  668370
  585094
  571439
  566729
  382594
  431805
  514721
  560387
  609909
  537207
  620115
  799002
  523576
  500085
  413518
  554929
  421238
  551183
  793901
  541532
  583759
  673128
  528440
  604103
  422671
  584710
  475957
  443644
  638967
  425473
  586628
  429943
  492608
  542198
  572544
  443503
  494620
  577349
  603247
  541866
  585744
  492598
  552471
  753467
  486445
  564348
  542194
  541748
  541833
  478491
  541804
  486415
  427174
]

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 (463839, 494436, 445731, 721249, 401945, 478088, 625771, 565413, 668372, 622587, 538805, 576397, 702699, 443986, 471548, 420147, 542881, 793202, 491614, 668370, 585094, 571439, 566729, 382594, 431805, 514721, 560387, 609909, 537207, 620115, 799002, 523576, 500085, 413518, 554929, 421238, 551183, 793901, 541532, 583759, 673128, 528440, 604103, 422671, 584710, 475957, 443644, 638967, 425473, 586628, 429943, 492608, 542198, 572544, 443503, 494620, 577349, 603247, 541866, 585744, 492598, 552471, 753467, 486445, 564348, 542194, 541748, 541833, 478491, 541804, 486415, 427174);

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
  382594
  401945
  413518
  420147
  421238
  422671
  425473
  427174
  429943
  431805
  443503
  443644
  443986
  445731
  463839
  471548
  475957
  478088
  478491
  486415
  486445
  491614
  492598
  492608
  494436
  494620
  500085
  514721
  523576
  528440
  537207
  538805
  541532
  541748
  541804
  541833
  541866
  542194
  542198
  542881
  551183
  552471
  554929
  560387
  564348
  565413
  566729
  571439
  572544
  576397
  577349
  583759
  584710
  585094
  585744
  586628
  603247
  604103
  609909
  620115
  622587
  625771
  638967
  668370
  668372
  673128
  702699
  721249
  753467
  793202
  793901
  799002
]

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 (382594, 401945, 413518, 420147, 421238, 422671, 425473, 427174, 429943, 431805, 443503, 443644, 443986, 445731, 463839, 471548, 475957, 478088, 478491, 486415, 486445, 491614, 492598, 492608, 494436, 494620, 500085, 514721, 523576, 528440, 537207, 538805, 541532, 541748, 541804, 541833, 541866, 542194, 542198, 542881, 551183, 552471, 554929, 560387, 564348, 565413, 566729, 571439, 572544, 576397, 577349, 583759, 584710, 585094, 585744, 586628, 603247, 604103, 609909, 620115, 622587, 625771, 638967, 668370, 668372, 673128, 702699, 721249, 753467, 793202, 793901, 799002);

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
  382594
  401945
  413518
  420147
  421238
  422671
  425473
  427174
  429943
  431805
  443503
  443644
  443986
  445731
  463839
  471548
  475957
  478088
  478491
  486415
  486445
  491614
  492598
  492608
  494436
  494620
  500085
  514721
  523576
  528440
  537207
  538805
  541532
  541748
  541804
  541833
  541866
  542194
  542198
  542881
  551183
  552471
  554929
  560387
  564348
  565413
  566729
  571439
  572544
  576397
  577349
  583759
  584710
  585094
  585744
  586628
  603247
  604103
  609909
  620115
  622587
  625771
  638967
  668370
  668372
  673128
  702699
  721249
  753467
  793202
  793901
  799002
]

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 (382594, 401945, 413518, 420147, 421238, 422671, 425473, 427174, 429943, 431805, 443503, 443644, 443986, 445731, 463839, 471548, 475957, 478088, 478491, 486415, 486445, 491614, 492598, 492608, 494436, 494620, 500085, 514721, 523576, 528440, 537207, 538805, 541532, 541748, 541804, 541833, 541866, 542194, 542198, 542881, 551183, 552471, 554929, 560387, 564348, 565413, 566729, 571439, 572544, 576397, 577349, 583759, 584710, 585094, 585744, 586628, 603247, 604103, 609909, 620115, 622587, 625771, 638967, 668370, 668372, 673128, 702699, 721249, 753467, 793202, 793901, 799002);

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 ?

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