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

[
  "домохозяйки жмж анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'домохозяйки жмж анал' 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
  719001
  606587
  753255
  386658
  671734
  584721
  665771
  741097
  758201
  766274
  677407
  390192
  790862
  463780
  671757
  805069
  743375
  789959
  555782
  797849
  727769
  473846
  505041
  789986
  732052
  699625
  726654
  758496
  463777
  532999
  382437
  728452
  722900
  483582
  674414
  502326
  712694
  16971
  393481
  385911
  473900
  815600
  699610
  593269
  573765
  492606
  482088
  438095
  531231
  472319
  541751
  625519
  598745
  480757
  583533
  625342
  421871
  534021
  610108
  486685
  735778
  501497
  724823
  463094
  452136
  472956
  536695
  512059
  607374
  532357
  463757
  430437
]

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 (719001, 606587, 753255, 386658, 671734, 584721, 665771, 741097, 758201, 766274, 677407, 390192, 790862, 463780, 671757, 805069, 743375, 789959, 555782, 797849, 727769, 473846, 505041, 789986, 732052, 699625, 726654, 758496, 463777, 532999, 382437, 728452, 722900, 483582, 674414, 502326, 712694, 16971, 393481, 385911, 473900, 815600, 699610, 593269, 573765, 492606, 482088, 438095, 531231, 472319, 541751, 625519, 598745, 480757, 583533, 625342, 421871, 534021, 610108, 486685, 735778, 501497, 724823, 463094, 452136, 472956, 536695, 512059, 607374, 532357, 463757, 430437);

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
  16971
  382437
  385911
  386658
  390192
  393481
  421871
  430437
  438095
  452136
  463094
  463757
  463777
  463780
  472319
  472956
  473846
  473900
  480757
  482088
  483582
  486685
  492606
  501497
  502326
  505041
  512059
  531231
  532357
  532999
  534021
  536695
  541751
  555782
  573765
  583533
  584721
  593269
  598745
  606587
  607374
  610108
  625342
  625519
  665771
  671734
  671757
  674414
  677407
  699610
  699625
  712694
  719001
  722900
  724823
  726654
  727769
  728452
  732052
  735778
  741097
  743375
  753255
  758201
  758496
  766274
  789959
  789986
  790862
  797849
  805069
  815600
]

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 (16971, 382437, 385911, 386658, 390192, 393481, 421871, 430437, 438095, 452136, 463094, 463757, 463777, 463780, 472319, 472956, 473846, 473900, 480757, 482088, 483582, 486685, 492606, 501497, 502326, 505041, 512059, 531231, 532357, 532999, 534021, 536695, 541751, 555782, 573765, 583533, 584721, 593269, 598745, 606587, 607374, 610108, 625342, 625519, 665771, 671734, 671757, 674414, 677407, 699610, 699625, 712694, 719001, 722900, 724823, 726654, 727769, 728452, 732052, 735778, 741097, 743375, 753255, 758201, 758496, 766274, 789959, 789986, 790862, 797849, 805069, 815600);

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
  16971
  382437
  385911
  386658
  390192
  393481
  421871
  430437
  438095
  452136
  463094
  463757
  463777
  463780
  472319
  472956
  473846
  473900
  480757
  482088
  483582
  486685
  492606
  501497
  502326
  505041
  512059
  531231
  532357
  532999
  534021
  536695
  541751
  555782
  573765
  583533
  584721
  593269
  598745
  606587
  607374
  610108
  625342
  625519
  665771
  671734
  671757
  674414
  677407
  699610
  699625
  712694
  719001
  722900
  724823
  726654
  727769
  728452
  732052
  735778
  741097
  743375
  753255
  758201
  758496
  766274
  789959
  789986
  790862
  797849
  805069
  815600
]

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 (16971, 382437, 385911, 386658, 390192, 393481, 421871, 430437, 438095, 452136, 463094, 463757, 463777, 463780, 472319, 472956, 473846, 473900, 480757, 482088, 483582, 486685, 492606, 501497, 502326, 505041, 512059, 531231, 532357, 532999, 534021, 536695, 541751, 555782, 573765, 583533, 584721, 593269, 598745, 606587, 607374, 610108, 625342, 625519, 665771, 671734, 671757, 674414, 677407, 699610, 699625, 712694, 719001, 722900, 724823, 726654, 727769, 728452, 732052, 735778, 741097, 743375, 753255, 758201, 758496, 766274, 789959, 789986, 790862, 797849, 805069, 815600);

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 ?

[
  "домохозяйки жмж анал"
  "домохозяйки жмж анал"
  "домохозяйки жмж анал"
  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 ('домохозяйки жмж анал') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('домохозяйки жмж анал')
              AND `query` <> 'домохозяйки жмж анал'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;