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 anal cuckold"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur anal cuckold' 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
  466355
  546720
  790754
  421833
  451108
  715388
  768758
  767804
  496794
  559486
  791233
  578411
  508180
  484628
  766982
  505447
  796523
  581433
  528682
  726248
  508208
  733239
  524235
  761203
  579797
  720163
  443634
  460486
  628654
  756845
  791351
  595731
  774692
  773963
  586564
  588746
  531807
  587864
  639277
  447038
  760859
  699398
  644059
  766623
  467571
  516590
  729826
  493260
  514265
  464834
  471596
  590620
  610695
  623149
  443659
  414184
  549239
  520127
  496603
  545216
  439649
  809147
  453841
  657504
  550667
  654352
  597452
  583723
  528081
  524613
]

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 (466355, 546720, 790754, 421833, 451108, 715388, 768758, 767804, 496794, 559486, 791233, 578411, 508180, 484628, 766982, 505447, 796523, 581433, 528682, 726248, 508208, 733239, 524235, 761203, 579797, 720163, 443634, 460486, 628654, 756845, 791351, 595731, 774692, 773963, 586564, 588746, 531807, 587864, 639277, 447038, 760859, 699398, 644059, 766623, 467571, 516590, 729826, 493260, 514265, 464834, 471596, 590620, 610695, 623149, 443659, 414184, 549239, 520127, 496603, 545216, 439649, 809147, 453841, 657504, 550667, 654352, 597452, 583723, 528081, 524613);

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
  414184
  421833
  439649
  443634
  443659
  447038
  451108
  453841
  460486
  464834
  466355
  467571
  471596
  484628
  493260
  496603
  496794
  505447
  508180
  508208
  514265
  516590
  520127
  524235
  524613
  528081
  528682
  531807
  545216
  546720
  549239
  550667
  559486
  578411
  579797
  581433
  583723
  586564
  587864
  588746
  590620
  595731
  597452
  610695
  623149
  628654
  639277
  644059
  654352
  657504
  699398
  715388
  720163
  726248
  729826
  733239
  756845
  760859
  761203
  766623
  766982
  767804
  768758
  773963
  774692
  790754
  791233
  791351
  796523
  809147
]

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 (414184, 421833, 439649, 443634, 443659, 447038, 451108, 453841, 460486, 464834, 466355, 467571, 471596, 484628, 493260, 496603, 496794, 505447, 508180, 508208, 514265, 516590, 520127, 524235, 524613, 528081, 528682, 531807, 545216, 546720, 549239, 550667, 559486, 578411, 579797, 581433, 583723, 586564, 587864, 588746, 590620, 595731, 597452, 610695, 623149, 628654, 639277, 644059, 654352, 657504, 699398, 715388, 720163, 726248, 729826, 733239, 756845, 760859, 761203, 766623, 766982, 767804, 768758, 773963, 774692, 790754, 791233, 791351, 796523, 809147);

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
  414184
  421833
  439649
  443634
  443659
  447038
  451108
  453841
  460486
  464834
  466355
  467571
  471596
  484628
  493260
  496603
  496794
  505447
  508180
  508208
  514265
  516590
  520127
  524235
  524613
  528081
  528682
  531807
  545216
  546720
  549239
  550667
  559486
  578411
  579797
  581433
  583723
  586564
  587864
  588746
  590620
  595731
  597452
  610695
  623149
  628654
  639277
  644059
  654352
  657504
  699398
  715388
  720163
  726248
  729826
  733239
  756845
  760859
  761203
  766623
  766982
  767804
  768758
  773963
  774692
  790754
  791233
  791351
  796523
  809147
]

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 (414184, 421833, 439649, 443634, 443659, 447038, 451108, 453841, 460486, 464834, 466355, 467571, 471596, 484628, 493260, 496603, 496794, 505447, 508180, 508208, 514265, 516590, 520127, 524235, 524613, 528081, 528682, 531807, 545216, 546720, 549239, 550667, 559486, 578411, 579797, 581433, 583723, 586564, 587864, 588746, 590620, 595731, 597452, 610695, 623149, 628654, 639277, 644059, 654352, 657504, 699398, 715388, 720163, 726248, 729826, 733239, 756845, 760859, 761203, 766623, 766982, 767804, 768758, 773963, 774692, 790754, 791233, 791351, 796523, 809147);

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 ?

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