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

[
  "amateur skinny oral"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur skinny oral' 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
  625546
  648697
  668737
  648700
  584664
  420425
  546434
  551585
  780770
  749735
  824972
  685789
  566513
  754260
  514953
  551625
  795632
  418435
  511213
  419158
  520901
  483842
  521992
  480334
  491096
  441217
  397389
  570348
  602509
  602783
  504321
  582566
  555740
  417945
  570325
  571596
  572048
  427490
  411319
  449344
  539894
  448095
  416300
  426496
  516245
  450547
  504276
  602521
  594151
  426663
  437440
  415811
  497179
  486134
  488282
  488567
  464716
  477358
  492670
  519859
  570214
  572373
  551268
  476423
  462863
  571618
  497950
  559017
  586386
  522806
  586118
]

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 (625546, 648697, 668737, 648700, 584664, 420425, 546434, 551585, 780770, 749735, 824972, 685789, 566513, 754260, 514953, 551625, 795632, 418435, 511213, 419158, 520901, 483842, 521992, 480334, 491096, 441217, 397389, 570348, 602509, 602783, 504321, 582566, 555740, 417945, 570325, 571596, 572048, 427490, 411319, 449344, 539894, 448095, 416300, 426496, 516245, 450547, 504276, 602521, 594151, 426663, 437440, 415811, 497179, 486134, 488282, 488567, 464716, 477358, 492670, 519859, 570214, 572373, 551268, 476423, 462863, 571618, 497950, 559017, 586386, 522806, 586118);

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
  397389
  411319
  415811
  416300
  417945
  418435
  419158
  420425
  426496
  426663
  427490
  437440
  441217
  448095
  449344
  450547
  462863
  464716
  476423
  477358
  480334
  483842
  486134
  488282
  488567
  491096
  492670
  497179
  497950
  504276
  504321
  511213
  514953
  516245
  519859
  520901
  521992
  522806
  539894
  546434
  551268
  551585
  551625
  555740
  559017
  566513
  570214
  570325
  570348
  571596
  571618
  572048
  572373
  582566
  584664
  586118
  586386
  594151
  602509
  602521
  602783
  625546
  648697
  648700
  668737
  685789
  749735
  754260
  780770
  795632
  824972
]

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 (397389, 411319, 415811, 416300, 417945, 418435, 419158, 420425, 426496, 426663, 427490, 437440, 441217, 448095, 449344, 450547, 462863, 464716, 476423, 477358, 480334, 483842, 486134, 488282, 488567, 491096, 492670, 497179, 497950, 504276, 504321, 511213, 514953, 516245, 519859, 520901, 521992, 522806, 539894, 546434, 551268, 551585, 551625, 555740, 559017, 566513, 570214, 570325, 570348, 571596, 571618, 572048, 572373, 582566, 584664, 586118, 586386, 594151, 602509, 602521, 602783, 625546, 648697, 648700, 668737, 685789, 749735, 754260, 780770, 795632, 824972);

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
  397389
  411319
  415811
  416300
  417945
  418435
  419158
  420425
  426496
  426663
  427490
  437440
  441217
  448095
  449344
  450547
  462863
  464716
  476423
  477358
  480334
  483842
  486134
  488282
  488567
  491096
  492670
  497179
  497950
  504276
  504321
  511213
  514953
  516245
  519859
  520901
  521992
  522806
  539894
  546434
  551268
  551585
  551625
  555740
  559017
  566513
  570214
  570325
  570348
  571596
  571618
  572048
  572373
  582566
  584664
  586118
  586386
  594151
  602509
  602521
  602783
  625546
  648697
  648700
  668737
  685789
  749735
  754260
  780770
  795632
  824972
]

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 (397389, 411319, 415811, 416300, 417945, 418435, 419158, 420425, 426496, 426663, 427490, 437440, 441217, 448095, 449344, 450547, 462863, 464716, 476423, 477358, 480334, 483842, 486134, 488282, 488567, 491096, 492670, 497179, 497950, 504276, 504321, 511213, 514953, 516245, 519859, 520901, 521992, 522806, 539894, 546434, 551268, 551585, 551625, 555740, 559017, 566513, 570214, 570325, 570348, 571596, 571618, 572048, 572373, 582566, 584664, 586118, 586386, 594151, 602509, 602521, 602783, 625546, 648697, 648700, 668737, 685789, 749735, 754260, 780770, 795632, 824972);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "любительск худые oral"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск худые oral';

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

[
  "любительск худые oral"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск худые oral';

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 ?

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