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

[
  "husband friend anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'husband friend anal' 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
  607023
  820156
  770592
  654303
  727829
  734185
  455715
  575625
  766702
  788592
  447732
  707144
  796497
  753255
  715410
  720163
  712959
  730928
  577155
  455539
  741076
  408423
  579557
  757622
  429857
  687362
  793877
  744368
  737465
  742685
  385830
  761850
  712278
  436719
  604243
  720878
  796143
  515339
  414974
  519092
  391034
  478525
  440901
  489299
  585332
  515709
  395970
  519261
  720257
  440974
  494857
  522768
  396253
  536684
  561135
  426710
  515645
  593860
  623306
  494036
  543536
  545216
  523537
  513126
  578631
  482506
  591416
  542789
  514809
  622778
  591415
]

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 (607023, 820156, 770592, 654303, 727829, 734185, 455715, 575625, 766702, 788592, 447732, 707144, 796497, 753255, 715410, 720163, 712959, 730928, 577155, 455539, 741076, 408423, 579557, 757622, 429857, 687362, 793877, 744368, 737465, 742685, 385830, 761850, 712278, 436719, 604243, 720878, 796143, 515339, 414974, 519092, 391034, 478525, 440901, 489299, 585332, 515709, 395970, 519261, 720257, 440974, 494857, 522768, 396253, 536684, 561135, 426710, 515645, 593860, 623306, 494036, 543536, 545216, 523537, 513126, 578631, 482506, 591416, 542789, 514809, 622778, 591415);

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
  385830
  391034
  395970
  396253
  408423
  414974
  426710
  429857
  436719
  440901
  440974
  447732
  455539
  455715
  478525
  482506
  489299
  494036
  494857
  513126
  514809
  515339
  515645
  515709
  519092
  519261
  522768
  523537
  536684
  542789
  543536
  545216
  561135
  575625
  577155
  578631
  579557
  585332
  591415
  591416
  593860
  604243
  607023
  622778
  623306
  654303
  687362
  707144
  712278
  712959
  715410
  720163
  720257
  720878
  727829
  730928
  734185
  737465
  741076
  742685
  744368
  753255
  757622
  761850
  766702
  770592
  788592
  793877
  796143
  796497
  820156
]

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 (385830, 391034, 395970, 396253, 408423, 414974, 426710, 429857, 436719, 440901, 440974, 447732, 455539, 455715, 478525, 482506, 489299, 494036, 494857, 513126, 514809, 515339, 515645, 515709, 519092, 519261, 522768, 523537, 536684, 542789, 543536, 545216, 561135, 575625, 577155, 578631, 579557, 585332, 591415, 591416, 593860, 604243, 607023, 622778, 623306, 654303, 687362, 707144, 712278, 712959, 715410, 720163, 720257, 720878, 727829, 730928, 734185, 737465, 741076, 742685, 744368, 753255, 757622, 761850, 766702, 770592, 788592, 793877, 796143, 796497, 820156);

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
  385830
  391034
  395970
  396253
  408423
  414974
  426710
  429857
  436719
  440901
  440974
  447732
  455539
  455715
  478525
  482506
  489299
  494036
  494857
  513126
  514809
  515339
  515645
  515709
  519092
  519261
  522768
  523537
  536684
  542789
  543536
  545216
  561135
  575625
  577155
  578631
  579557
  585332
  591415
  591416
  593860
  604243
  607023
  622778
  623306
  654303
  687362
  707144
  712278
  712959
  715410
  720163
  720257
  720878
  727829
  730928
  734185
  737465
  741076
  742685
  744368
  753255
  757622
  761850
  766702
  770592
  788592
  793877
  796143
  796497
  820156
]

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 (385830, 391034, 395970, 396253, 408423, 414974, 426710, 429857, 436719, 440901, 440974, 447732, 455539, 455715, 478525, 482506, 489299, 494036, 494857, 513126, 514809, 515339, 515645, 515709, 519092, 519261, 522768, 523537, 536684, 542789, 543536, 545216, 561135, 575625, 577155, 578631, 579557, 585332, 591415, 591416, 593860, 604243, 607023, 622778, 623306, 654303, 687362, 707144, 712278, 712959, 715410, 720163, 720257, 720878, 727829, 730928, 734185, 737465, 741076, 742685, 744368, 753255, 757622, 761850, 766702, 770592, 788592, 793877, 796143, 796497, 820156);

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

[
  "husband friend анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'husband friend анал';

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

[
  "husband friend анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'husband friend анал';

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 ?

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