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

[
  "girlfriend mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'girlfriend mom' 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
  813533
  524902
  523149
  513397
  521049
  532998
  531221
  532919
  582833
  562773
  660582
  661977
  695117
  701206
  703902
  588126
  589723
  805224
  801292
  779012
  447262
  475780
  517922
  529153
  504927
  813759
  516924
  531496
  545318
  561297
  598846
  612439
  586480
  395714
  488772
  504929
  511141
  413904
  564716
  601103
  605663
  586929
  598890
  596235
  728946
  407148
  420351
  509691
  521045
  520815
  562895
  662423
  623089
  395516
  428509
  472829
  493464
  509033
  449881
  446631
  524142
  632252
  504922
  466928
  566248
  606687
  751565
  601924
  425490
  512952
  521159
]

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 (813533, 524902, 523149, 513397, 521049, 532998, 531221, 532919, 582833, 562773, 660582, 661977, 695117, 701206, 703902, 588126, 589723, 805224, 801292, 779012, 447262, 475780, 517922, 529153, 504927, 813759, 516924, 531496, 545318, 561297, 598846, 612439, 586480, 395714, 488772, 504929, 511141, 413904, 564716, 601103, 605663, 586929, 598890, 596235, 728946, 407148, 420351, 509691, 521045, 520815, 562895, 662423, 623089, 395516, 428509, 472829, 493464, 509033, 449881, 446631, 524142, 632252, 504922, 466928, 566248, 606687, 751565, 601924, 425490, 512952, 521159);

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
  395516
  395714
  407148
  413904
  420351
  425490
  428509
  446631
  447262
  449881
  466928
  472829
  475780
  488772
  493464
  504922
  504927
  504929
  509033
  509691
  511141
  512952
  513397
  516924
  517922
  520815
  521045
  521049
  521159
  523149
  524142
  524902
  529153
  531221
  531496
  532919
  532998
  545318
  561297
  562773
  562895
  564716
  566248
  582833
  586480
  586929
  588126
  589723
  596235
  598846
  598890
  601103
  601924
  605663
  606687
  612439
  623089
  632252
  660582
  661977
  662423
  695117
  701206
  703902
  728946
  751565
  779012
  801292
  805224
  813533
  813759
]

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 (395516, 395714, 407148, 413904, 420351, 425490, 428509, 446631, 447262, 449881, 466928, 472829, 475780, 488772, 493464, 504922, 504927, 504929, 509033, 509691, 511141, 512952, 513397, 516924, 517922, 520815, 521045, 521049, 521159, 523149, 524142, 524902, 529153, 531221, 531496, 532919, 532998, 545318, 561297, 562773, 562895, 564716, 566248, 582833, 586480, 586929, 588126, 589723, 596235, 598846, 598890, 601103, 601924, 605663, 606687, 612439, 623089, 632252, 660582, 661977, 662423, 695117, 701206, 703902, 728946, 751565, 779012, 801292, 805224, 813533, 813759);

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
  395516
  395714
  407148
  413904
  420351
  425490
  428509
  446631
  447262
  449881
  466928
  472829
  475780
  488772
  493464
  504922
  504927
  504929
  509033
  509691
  511141
  512952
  513397
  516924
  517922
  520815
  521045
  521049
  521159
  523149
  524142
  524902
  529153
  531221
  531496
  532919
  532998
  545318
  561297
  562773
  562895
  564716
  566248
  582833
  586480
  586929
  588126
  589723
  596235
  598846
  598890
  601103
  601924
  605663
  606687
  612439
  623089
  632252
  660582
  661977
  662423
  695117
  701206
  703902
  728946
  751565
  779012
  801292
  805224
  813533
  813759
]

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 (395516, 395714, 407148, 413904, 420351, 425490, 428509, 446631, 447262, 449881, 466928, 472829, 475780, 488772, 493464, 504922, 504927, 504929, 509033, 509691, 511141, 512952, 513397, 516924, 517922, 520815, 521045, 521049, 521159, 523149, 524142, 524902, 529153, 531221, 531496, 532919, 532998, 545318, 561297, 562773, 562895, 564716, 566248, 582833, 586480, 586929, 588126, 589723, 596235, 598846, 598890, 601103, 601924, 605663, 606687, 612439, 623089, 632252, 660582, 661977, 662423, 695117, 701206, 703902, 728946, 751565, 779012, 801292, 805224, 813533, 813759);

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

[
  "girlfriend mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'girlfriend mom';

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

[
  "girlfriend mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'girlfriend mom';

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 ?

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