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

[
  "mature big pawg"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature big pawg' 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
  475277
  519173
  420774
  623655
  761039
  591997
  441359
  484224
  601672
  591357
  696557
  463984
  788881
  467058
  440687
  549725
  498420
  453683
  564244
  508257
  554376
  549723
  600381
  469568
  549754
  468514
  515354
  472484
  591968
  752506
  505460
  441454
  592570
  401742
  455411
  459513
  455085
  473467
  514908
  797541
  465431
  472665
  596048
  410058
  517405
  464152
  559952
  651609
  431341
  413836
  455436
  536628
  571751
  420530
  676622
  586331
  427543
  571102
  581620
  593238
  401927
  464861
  576970
  676014
  596192
  430623
  676088
  591033
  448954
  502512
  698124
  584887
  527908
]

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 (475277, 519173, 420774, 623655, 761039, 591997, 441359, 484224, 601672, 591357, 696557, 463984, 788881, 467058, 440687, 549725, 498420, 453683, 564244, 508257, 554376, 549723, 600381, 469568, 549754, 468514, 515354, 472484, 591968, 752506, 505460, 441454, 592570, 401742, 455411, 459513, 455085, 473467, 514908, 797541, 465431, 472665, 596048, 410058, 517405, 464152, 559952, 651609, 431341, 413836, 455436, 536628, 571751, 420530, 676622, 586331, 427543, 571102, 581620, 593238, 401927, 464861, 576970, 676014, 596192, 430623, 676088, 591033, 448954, 502512, 698124, 584887, 527908);

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
  401742
  401927
  410058
  413836
  420530
  420774
  427543
  430623
  431341
  440687
  441359
  441454
  448954
  453683
  455085
  455411
  455436
  459513
  463984
  464152
  464861
  465431
  467058
  468514
  469568
  472484
  472665
  473467
  475277
  484224
  498420
  502512
  505460
  508257
  514908
  515354
  517405
  519173
  527908
  536628
  549723
  549725
  549754
  554376
  559952
  564244
  571102
  571751
  576970
  581620
  584887
  586331
  591033
  591357
  591968
  591997
  592570
  593238
  596048
  596192
  600381
  601672
  623655
  651609
  676014
  676088
  676622
  696557
  698124
  752506
  761039
  788881
  797541
]

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 (401742, 401927, 410058, 413836, 420530, 420774, 427543, 430623, 431341, 440687, 441359, 441454, 448954, 453683, 455085, 455411, 455436, 459513, 463984, 464152, 464861, 465431, 467058, 468514, 469568, 472484, 472665, 473467, 475277, 484224, 498420, 502512, 505460, 508257, 514908, 515354, 517405, 519173, 527908, 536628, 549723, 549725, 549754, 554376, 559952, 564244, 571102, 571751, 576970, 581620, 584887, 586331, 591033, 591357, 591968, 591997, 592570, 593238, 596048, 596192, 600381, 601672, 623655, 651609, 676014, 676088, 676622, 696557, 698124, 752506, 761039, 788881, 797541);

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
  401742
  401927
  410058
  413836
  420530
  420774
  427543
  430623
  431341
  440687
  441359
  441454
  448954
  453683
  455085
  455411
  455436
  459513
  463984
  464152
  464861
  465431
  467058
  468514
  469568
  472484
  472665
  473467
  475277
  484224
  498420
  502512
  505460
  508257
  514908
  515354
  517405
  519173
  527908
  536628
  549723
  549725
  549754
  554376
  559952
  564244
  571102
  571751
  576970
  581620
  584887
  586331
  591033
  591357
  591968
  591997
  592570
  593238
  596048
  596192
  600381
  601672
  623655
  651609
  676014
  676088
  676622
  696557
  698124
  752506
  761039
  788881
  797541
]

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 (401742, 401927, 410058, 413836, 420530, 420774, 427543, 430623, 431341, 440687, 441359, 441454, 448954, 453683, 455085, 455411, 455436, 459513, 463984, 464152, 464861, 465431, 467058, 468514, 469568, 472484, 472665, 473467, 475277, 484224, 498420, 502512, 505460, 508257, 514908, 515354, 517405, 519173, 527908, 536628, 549723, 549725, 549754, 554376, 559952, 564244, 571102, 571751, 576970, 581620, 584887, 586331, 591033, 591357, 591968, 591997, 592570, 593238, 596048, 596192, 600381, 601672, 623655, 651609, 676014, 676088, 676622, 696557, 698124, 752506, 761039, 788881, 797541);

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

[
  "mature большие pawg"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature большие pawg';

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

[
  "mature большие pawg"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature большие pawg';

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 ?

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