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

[
  "just anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'just 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
  519652
  716987
  441126
  418395
  444558
  502089
  533634
  558381
  467889
  11582
  526904
  554225
  446166
  447218
  524526
  507887
  435551
  454399
  477069
  535986
  563009
  686658
  638605
  747583
  507665
  435245
  460859
  408928
  544860
  779896
  692716
  640401
  751984
  484529
  514797
  450288
  587578
  703492
  421448
  799548
  742415
  400960
  442356
  564706
  580214
  688582
  451129
  512088
  487677
  572031
  504072
  540542
  425753
  456687
  411320
  598436
  596891
  418597
  486409
  709748
  473189
  502324
  544863
  421157
  496794
  585396
  477533
  654449
  556535
  484673
  527949
  643252
  593125
  457676
]

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 (519652, 716987, 441126, 418395, 444558, 502089, 533634, 558381, 467889, 11582, 526904, 554225, 446166, 447218, 524526, 507887, 435551, 454399, 477069, 535986, 563009, 686658, 638605, 747583, 507665, 435245, 460859, 408928, 544860, 779896, 692716, 640401, 751984, 484529, 514797, 450288, 587578, 703492, 421448, 799548, 742415, 400960, 442356, 564706, 580214, 688582, 451129, 512088, 487677, 572031, 504072, 540542, 425753, 456687, 411320, 598436, 596891, 418597, 486409, 709748, 473189, 502324, 544863, 421157, 496794, 585396, 477533, 654449, 556535, 484673, 527949, 643252, 593125, 457676);

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
  11582
  400960
  408928
  411320
  418395
  418597
  421157
  421448
  425753
  435245
  435551
  441126
  442356
  444558
  446166
  447218
  450288
  451129
  454399
  456687
  457676
  460859
  467889
  473189
  477069
  477533
  484529
  484673
  486409
  487677
  496794
  502089
  502324
  504072
  507665
  507887
  512088
  514797
  519652
  524526
  526904
  527949
  533634
  535986
  540542
  544860
  544863
  554225
  556535
  558381
  563009
  564706
  572031
  580214
  585396
  587578
  593125
  596891
  598436
  638605
  640401
  643252
  654449
  686658
  688582
  692716
  703492
  709748
  716987
  742415
  747583
  751984
  779896
  799548
]

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 (11582, 400960, 408928, 411320, 418395, 418597, 421157, 421448, 425753, 435245, 435551, 441126, 442356, 444558, 446166, 447218, 450288, 451129, 454399, 456687, 457676, 460859, 467889, 473189, 477069, 477533, 484529, 484673, 486409, 487677, 496794, 502089, 502324, 504072, 507665, 507887, 512088, 514797, 519652, 524526, 526904, 527949, 533634, 535986, 540542, 544860, 544863, 554225, 556535, 558381, 563009, 564706, 572031, 580214, 585396, 587578, 593125, 596891, 598436, 638605, 640401, 643252, 654449, 686658, 688582, 692716, 703492, 709748, 716987, 742415, 747583, 751984, 779896, 799548);

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
  11582
  400960
  408928
  411320
  418395
  418597
  421157
  421448
  425753
  435245
  435551
  441126
  442356
  444558
  446166
  447218
  450288
  451129
  454399
  456687
  457676
  460859
  467889
  473189
  477069
  477533
  484529
  484673
  486409
  487677
  496794
  502089
  502324
  504072
  507665
  507887
  512088
  514797
  519652
  524526
  526904
  527949
  533634
  535986
  540542
  544860
  544863
  554225
  556535
  558381
  563009
  564706
  572031
  580214
  585396
  587578
  593125
  596891
  598436
  638605
  640401
  643252
  654449
  686658
  688582
  692716
  703492
  709748
  716987
  742415
  747583
  751984
  779896
  799548
]

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 (11582, 400960, 408928, 411320, 418395, 418597, 421157, 421448, 425753, 435245, 435551, 441126, 442356, 444558, 446166, 447218, 450288, 451129, 454399, 456687, 457676, 460859, 467889, 473189, 477069, 477533, 484529, 484673, 486409, 487677, 496794, 502089, 502324, 504072, 507665, 507887, 512088, 514797, 519652, 524526, 526904, 527949, 533634, 535986, 540542, 544860, 544863, 554225, 556535, 558381, 563009, 564706, 572031, 580214, 585396, 587578, 593125, 596891, 598436, 638605, 640401, 643252, 654449, 686658, 688582, 692716, 703492, 709748, 716987, 742415, 747583, 751984, 779896, 799548);

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

[
  "just анал"
]

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

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

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

[
  "just анал"
]

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

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

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 ?

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