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

[
  "milf dirty talk"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf dirty talk' 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
  683047
  719461
  555448
  578858
  607481
  616448
  625946
  638688
  812768
  739089
  451514
  479963
  436942
  517299
  475556
  584999
  458760
  502751
  460428
  492138
  554544
  675441
  675654
  667942
  675691
  636461
  778508
  517332
  518605
  524360
  511162
  630609
  526070
  584481
  543317
  571042
  675107
  675109
  675660
  675703
  585959
  798219
  602793
  477147
  489061
  675429
  675431
  675696
  675430
  675725
  693338
  611032
  596960
  599529
  813532
  488957
  566761
  608787
  423572
  508701
  537672
  525727
  536689
  675435
  590425
  595315
  600995
  599938
  495400
  589683
  619007
]

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 (683047, 719461, 555448, 578858, 607481, 616448, 625946, 638688, 812768, 739089, 451514, 479963, 436942, 517299, 475556, 584999, 458760, 502751, 460428, 492138, 554544, 675441, 675654, 667942, 675691, 636461, 778508, 517332, 518605, 524360, 511162, 630609, 526070, 584481, 543317, 571042, 675107, 675109, 675660, 675703, 585959, 798219, 602793, 477147, 489061, 675429, 675431, 675696, 675430, 675725, 693338, 611032, 596960, 599529, 813532, 488957, 566761, 608787, 423572, 508701, 537672, 525727, 536689, 675435, 590425, 595315, 600995, 599938, 495400, 589683, 619007);

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
  423572
  436942
  451514
  458760
  460428
  475556
  477147
  479963
  488957
  489061
  492138
  495400
  502751
  508701
  511162
  517299
  517332
  518605
  524360
  525727
  526070
  536689
  537672
  543317
  554544
  555448
  566761
  571042
  578858
  584481
  584999
  585959
  589683
  590425
  595315
  596960
  599529
  599938
  600995
  602793
  607481
  608787
  611032
  616448
  619007
  625946
  630609
  636461
  638688
  667942
  675107
  675109
  675429
  675430
  675431
  675435
  675441
  675654
  675660
  675691
  675696
  675703
  675725
  683047
  693338
  719461
  739089
  778508
  798219
  812768
  813532
]

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 (423572, 436942, 451514, 458760, 460428, 475556, 477147, 479963, 488957, 489061, 492138, 495400, 502751, 508701, 511162, 517299, 517332, 518605, 524360, 525727, 526070, 536689, 537672, 543317, 554544, 555448, 566761, 571042, 578858, 584481, 584999, 585959, 589683, 590425, 595315, 596960, 599529, 599938, 600995, 602793, 607481, 608787, 611032, 616448, 619007, 625946, 630609, 636461, 638688, 667942, 675107, 675109, 675429, 675430, 675431, 675435, 675441, 675654, 675660, 675691, 675696, 675703, 675725, 683047, 693338, 719461, 739089, 778508, 798219, 812768, 813532);

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
  423572
  436942
  451514
  458760
  460428
  475556
  477147
  479963
  488957
  489061
  492138
  495400
  502751
  508701
  511162
  517299
  517332
  518605
  524360
  525727
  526070
  536689
  537672
  543317
  554544
  555448
  566761
  571042
  578858
  584481
  584999
  585959
  589683
  590425
  595315
  596960
  599529
  599938
  600995
  602793
  607481
  608787
  611032
  616448
  619007
  625946
  630609
  636461
  638688
  667942
  675107
  675109
  675429
  675430
  675431
  675435
  675441
  675654
  675660
  675691
  675696
  675703
  675725
  683047
  693338
  719461
  739089
  778508
  798219
  812768
  813532
]

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 (423572, 436942, 451514, 458760, 460428, 475556, 477147, 479963, 488957, 489061, 492138, 495400, 502751, 508701, 511162, 517299, 517332, 518605, 524360, 525727, 526070, 536689, 537672, 543317, 554544, 555448, 566761, 571042, 578858, 584481, 584999, 585959, 589683, 590425, 595315, 596960, 599529, 599938, 600995, 602793, 607481, 608787, 611032, 616448, 619007, 625946, 630609, 636461, 638688, 667942, 675107, 675109, 675429, 675430, 675431, 675435, 675441, 675654, 675660, 675691, 675696, 675703, 675725, 683047, 693338, 719461, 739089, 778508, 798219, 812768, 813532);

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

[
  "milf dirty talk"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf dirty talk';

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

[
  "milf dirty talk"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf dirty talk';

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 ?

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