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

[
  "busty solo shower"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'busty solo shower' 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
  790337
  754896
  678924
  593545
  775668
  784001
  628756
  808540
  825800
  604121
  604881
  672369
  649487
  618680
  775669
  536762
  680576
  594152
  641071
  645388
  652984
  754293
  24034
  826719
  537332
  565082
  668706
  622077
  512997
  570415
  622592
  535985
  678761
  594227
  88274
  23003
  524475
  536468
  536567
  607434
  771984
  740258
  759115
  767267
  465553
  476754
  383388
  579785
  587163
  594250
  781884
  629243
  466452
  536514
  670695
  671560
  594131
  630254
  447504
  463509
  710771
  561979
  611259
  632289
  428955
  564486
  597545
  476776
  461787
  574086
  568101
  409035
]

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 (790337, 754896, 678924, 593545, 775668, 784001, 628756, 808540, 825800, 604121, 604881, 672369, 649487, 618680, 775669, 536762, 680576, 594152, 641071, 645388, 652984, 754293, 24034, 826719, 537332, 565082, 668706, 622077, 512997, 570415, 622592, 535985, 678761, 594227, 88274, 23003, 524475, 536468, 536567, 607434, 771984, 740258, 759115, 767267, 465553, 476754, 383388, 579785, 587163, 594250, 781884, 629243, 466452, 536514, 670695, 671560, 594131, 630254, 447504, 463509, 710771, 561979, 611259, 632289, 428955, 564486, 597545, 476776, 461787, 574086, 568101, 409035);

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
  23003
  24034
  88274
  383388
  409035
  428955
  447504
  461787
  463509
  465553
  466452
  476754
  476776
  512997
  524475
  535985
  536468
  536514
  536567
  536762
  537332
  561979
  564486
  565082
  568101
  570415
  574086
  579785
  587163
  593545
  594131
  594152
  594227
  594250
  597545
  604121
  604881
  607434
  611259
  618680
  622077
  622592
  628756
  629243
  630254
  632289
  641071
  645388
  649487
  652984
  668706
  670695
  671560
  672369
  678761
  678924
  680576
  710771
  740258
  754293
  754896
  759115
  767267
  771984
  775668
  775669
  781884
  784001
  790337
  808540
  825800
  826719
]

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 (23003, 24034, 88274, 383388, 409035, 428955, 447504, 461787, 463509, 465553, 466452, 476754, 476776, 512997, 524475, 535985, 536468, 536514, 536567, 536762, 537332, 561979, 564486, 565082, 568101, 570415, 574086, 579785, 587163, 593545, 594131, 594152, 594227, 594250, 597545, 604121, 604881, 607434, 611259, 618680, 622077, 622592, 628756, 629243, 630254, 632289, 641071, 645388, 649487, 652984, 668706, 670695, 671560, 672369, 678761, 678924, 680576, 710771, 740258, 754293, 754896, 759115, 767267, 771984, 775668, 775669, 781884, 784001, 790337, 808540, 825800, 826719);

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
  23003
  24034
  88274
  383388
  409035
  428955
  447504
  461787
  463509
  465553
  466452
  476754
  476776
  512997
  524475
  535985
  536468
  536514
  536567
  536762
  537332
  561979
  564486
  565082
  568101
  570415
  574086
  579785
  587163
  593545
  594131
  594152
  594227
  594250
  597545
  604121
  604881
  607434
  611259
  618680
  622077
  622592
  628756
  629243
  630254
  632289
  641071
  645388
  649487
  652984
  668706
  670695
  671560
  672369
  678761
  678924
  680576
  710771
  740258
  754293
  754896
  759115
  767267
  771984
  775668
  775669
  781884
  784001
  790337
  808540
  825800
  826719
]

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 (23003, 24034, 88274, 383388, 409035, 428955, 447504, 461787, 463509, 465553, 466452, 476754, 476776, 512997, 524475, 535985, 536468, 536514, 536567, 536762, 537332, 561979, 564486, 565082, 568101, 570415, 574086, 579785, 587163, 593545, 594131, 594152, 594227, 594250, 597545, 604121, 604881, 607434, 611259, 618680, 622077, 622592, 628756, 629243, 630254, 632289, 641071, 645388, 649487, 652984, 668706, 670695, 671560, 672369, 678761, 678924, 680576, 710771, 740258, 754293, 754896, 759115, 767267, 771984, 775668, 775669, 781884, 784001, 790337, 808540, 825800, 826719);

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

[
  "busty соло shower"
]

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

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

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

[
  "busty соло shower"
]

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

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

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 ?

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