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

[
  "shower busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'shower busty' 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
  486873
  489985
  459954
  478805
  489901
  515182
  472578
  574086
  564486
  568101
  578215
  671753
  564082
  622035
  771924
  411588
  443363
  463942
  447554
  484843
  496820
  520703
  534662
  620398
  464994
  449859
  537946
  515068
  517554
  527881
  570899
  547733
  581602
  564737
  589651
  602002
  604551
  446141
  446258
  468087
  477236
  454567
  454564
  481670
  415948
  528164
  446743
  455077
  582782
  569100
  451804
  263812
  409035
  471446
  486869
  473869
  535805
  529229
  559845
  541656
  554973
  587193
  425625
  464397
  505671
  518985
  543868
  565153
  623940
  551087
  559959
  538745
  453313
  527087
]

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 (486873, 489985, 459954, 478805, 489901, 515182, 472578, 574086, 564486, 568101, 578215, 671753, 564082, 622035, 771924, 411588, 443363, 463942, 447554, 484843, 496820, 520703, 534662, 620398, 464994, 449859, 537946, 515068, 517554, 527881, 570899, 547733, 581602, 564737, 589651, 602002, 604551, 446141, 446258, 468087, 477236, 454567, 454564, 481670, 415948, 528164, 446743, 455077, 582782, 569100, 451804, 263812, 409035, 471446, 486869, 473869, 535805, 529229, 559845, 541656, 554973, 587193, 425625, 464397, 505671, 518985, 543868, 565153, 623940, 551087, 559959, 538745, 453313, 527087);

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
  263812
  409035
  411588
  415948
  425625
  443363
  446141
  446258
  446743
  447554
  449859
  451804
  453313
  454564
  454567
  455077
  459954
  463942
  464397
  464994
  468087
  471446
  472578
  473869
  477236
  478805
  481670
  484843
  486869
  486873
  489901
  489985
  496820
  505671
  515068
  515182
  517554
  518985
  520703
  527087
  527881
  528164
  529229
  534662
  535805
  537946
  538745
  541656
  543868
  547733
  551087
  554973
  559845
  559959
  564082
  564486
  564737
  565153
  568101
  569100
  570899
  574086
  578215
  581602
  582782
  587193
  589651
  602002
  604551
  620398
  622035
  623940
  671753
  771924
]

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 (263812, 409035, 411588, 415948, 425625, 443363, 446141, 446258, 446743, 447554, 449859, 451804, 453313, 454564, 454567, 455077, 459954, 463942, 464397, 464994, 468087, 471446, 472578, 473869, 477236, 478805, 481670, 484843, 486869, 486873, 489901, 489985, 496820, 505671, 515068, 515182, 517554, 518985, 520703, 527087, 527881, 528164, 529229, 534662, 535805, 537946, 538745, 541656, 543868, 547733, 551087, 554973, 559845, 559959, 564082, 564486, 564737, 565153, 568101, 569100, 570899, 574086, 578215, 581602, 582782, 587193, 589651, 602002, 604551, 620398, 622035, 623940, 671753, 771924);

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
  263812
  409035
  411588
  415948
  425625
  443363
  446141
  446258
  446743
  447554
  449859
  451804
  453313
  454564
  454567
  455077
  459954
  463942
  464397
  464994
  468087
  471446
  472578
  473869
  477236
  478805
  481670
  484843
  486869
  486873
  489901
  489985
  496820
  505671
  515068
  515182
  517554
  518985
  520703
  527087
  527881
  528164
  529229
  534662
  535805
  537946
  538745
  541656
  543868
  547733
  551087
  554973
  559845
  559959
  564082
  564486
  564737
  565153
  568101
  569100
  570899
  574086
  578215
  581602
  582782
  587193
  589651
  602002
  604551
  620398
  622035
  623940
  671753
  771924
]

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 (263812, 409035, 411588, 415948, 425625, 443363, 446141, 446258, 446743, 447554, 449859, 451804, 453313, 454564, 454567, 455077, 459954, 463942, 464397, 464994, 468087, 471446, 472578, 473869, 477236, 478805, 481670, 484843, 486869, 486873, 489901, 489985, 496820, 505671, 515068, 515182, 517554, 518985, 520703, 527087, 527881, 528164, 529229, 534662, 535805, 537946, 538745, 541656, 543868, 547733, 551087, 554973, 559845, 559959, 564082, 564486, 564737, 565153, 568101, 569100, 570899, 574086, 578215, 581602, 582782, 587193, 589651, 602002, 604551, 620398, 622035, 623940, 671753, 771924);

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

[
  "shower busty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'shower busty';

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

[
  "shower busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'shower busty';

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 ?

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