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

[
  "triple milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'triple milf' 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
  586965
  823470
  414337
  548455
  784988
  752621
  603611
  615307
  775878
  761530
  755364
  728872
  707452
  801000
  680215
  709261
  794185
  720138
  797006
  820768
  820778
  660369
  672952
  588717
  397302
  666532
  601548
  797667
  409652
  409641
  439467
  820772
  531226
  544831
  666551
  666912
  788789
  536339
  530837
  423655
  469555
  531262
  540944
  583693
  679742
  680174
  634202
  391023
  421564
  419861
  425263
  530010
  676110
  636321
  778359
  510395
  426368
  421352
  440713
  647994
  637044
  636309
  639717
  535456
  583989
  565154
  668505
  632663
  666906
  803455
  636985
  600011
  599940
  523924
]

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 (586965, 823470, 414337, 548455, 784988, 752621, 603611, 615307, 775878, 761530, 755364, 728872, 707452, 801000, 680215, 709261, 794185, 720138, 797006, 820768, 820778, 660369, 672952, 588717, 397302, 666532, 601548, 797667, 409652, 409641, 439467, 820772, 531226, 544831, 666551, 666912, 788789, 536339, 530837, 423655, 469555, 531262, 540944, 583693, 679742, 680174, 634202, 391023, 421564, 419861, 425263, 530010, 676110, 636321, 778359, 510395, 426368, 421352, 440713, 647994, 637044, 636309, 639717, 535456, 583989, 565154, 668505, 632663, 666906, 803455, 636985, 600011, 599940, 523924);

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
  391023
  397302
  409641
  409652
  414337
  419861
  421352
  421564
  423655
  425263
  426368
  439467
  440713
  469555
  510395
  523924
  530010
  530837
  531226
  531262
  535456
  536339
  540944
  544831
  548455
  565154
  583693
  583989
  586965
  588717
  599940
  600011
  601548
  603611
  615307
  632663
  634202
  636309
  636321
  636985
  637044
  639717
  647994
  660369
  666532
  666551
  666906
  666912
  668505
  672952
  676110
  679742
  680174
  680215
  707452
  709261
  720138
  728872
  752621
  755364
  761530
  775878
  778359
  784988
  788789
  794185
  797006
  797667
  801000
  803455
  820768
  820772
  820778
]

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 (391023, 397302, 409641, 409652, 414337, 419861, 421352, 421564, 423655, 425263, 426368, 439467, 440713, 469555, 510395, 523924, 530010, 530837, 531226, 531262, 535456, 536339, 540944, 544831, 548455, 565154, 583693, 583989, 586965, 588717, 599940, 600011, 601548, 603611, 615307, 632663, 634202, 636309, 636321, 636985, 637044, 639717, 647994, 660369, 666532, 666551, 666906, 666912, 668505, 672952, 676110, 679742, 680174, 680215, 707452, 709261, 720138, 728872, 752621, 755364, 761530, 775878, 778359, 784988, 788789, 794185, 797006, 797667, 801000, 803455, 820768, 820772, 820778);

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
  391023
  397302
  409641
  409652
  414337
  419861
  421352
  421564
  423655
  425263
  426368
  439467
  440713
  469555
  510395
  523924
  530010
  530837
  531226
  531262
  535456
  536339
  540944
  544831
  548455
  565154
  583693
  583989
  586965
  588717
  599940
  600011
  601548
  603611
  615307
  632663
  634202
  636309
  636321
  636985
  637044
  639717
  647994
  660369
  666532
  666551
  666906
  666912
  668505
  672952
  676110
  679742
  680174
  680215
  707452
  709261
  720138
  728872
  752621
  755364
  761530
  775878
  778359
  784988
  788789
  794185
  797006
  797667
  801000
  803455
  820768
  820772
  820778
]

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 (391023, 397302, 409641, 409652, 414337, 419861, 421352, 421564, 423655, 425263, 426368, 439467, 440713, 469555, 510395, 523924, 530010, 530837, 531226, 531262, 535456, 536339, 540944, 544831, 548455, 565154, 583693, 583989, 586965, 588717, 599940, 600011, 601548, 603611, 615307, 632663, 634202, 636309, 636321, 636985, 637044, 639717, 647994, 660369, 666532, 666551, 666906, 666912, 668505, 672952, 676110, 679742, 680174, 680215, 707452, 709261, 720138, 728872, 752621, 755364, 761530, 775878, 778359, 784988, 788789, 794185, 797006, 797667, 801000, 803455, 820768, 820772, 820778);

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

[
  "triple milf"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'triple milf';

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

[
  "triple milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'triple milf';

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 ?

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