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

[
  "bbc mom teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc mom teen' 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
  805367
  817793
  698959
  566300
  536233
  576980
  529209
  600995
  530272
  597863
  681313
  666869
  605544
  537670
  616336
  632690
  595421
  792569
  418363
  472299
  543918
  704560
  606599
  480417
  464654
  601514
  605442
  481047
  492576
  675006
  676634
  814991
  679728
  788264
  629918
  632694
  537672
  656303
  621656
  616411
  458907
  517844
  517743
  469616
  646849
  632641
  536712
  530912
  532645
  676638
  667748
  571680
  614308
  632595
  666894
  651601
  635243
  639732
  639739
  617427
  419370
  406381
  489328
  532755
  646448
  666850
  675008
  469534
  466404
  532666
  599988
]

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 (805367, 817793, 698959, 566300, 536233, 576980, 529209, 600995, 530272, 597863, 681313, 666869, 605544, 537670, 616336, 632690, 595421, 792569, 418363, 472299, 543918, 704560, 606599, 480417, 464654, 601514, 605442, 481047, 492576, 675006, 676634, 814991, 679728, 788264, 629918, 632694, 537672, 656303, 621656, 616411, 458907, 517844, 517743, 469616, 646849, 632641, 536712, 530912, 532645, 676638, 667748, 571680, 614308, 632595, 666894, 651601, 635243, 639732, 639739, 617427, 419370, 406381, 489328, 532755, 646448, 666850, 675008, 469534, 466404, 532666, 599988);

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
  406381
  418363
  419370
  458907
  464654
  466404
  469534
  469616
  472299
  480417
  481047
  489328
  492576
  517743
  517844
  529209
  530272
  530912
  532645
  532666
  532755
  536233
  536712
  537670
  537672
  543918
  566300
  571680
  576980
  595421
  597863
  599988
  600995
  601514
  605442
  605544
  606599
  614308
  616336
  616411
  617427
  621656
  629918
  632595
  632641
  632690
  632694
  635243
  639732
  639739
  646448
  646849
  651601
  656303
  666850
  666869
  666894
  667748
  675006
  675008
  676634
  676638
  679728
  681313
  698959
  704560
  788264
  792569
  805367
  814991
  817793
]

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 (406381, 418363, 419370, 458907, 464654, 466404, 469534, 469616, 472299, 480417, 481047, 489328, 492576, 517743, 517844, 529209, 530272, 530912, 532645, 532666, 532755, 536233, 536712, 537670, 537672, 543918, 566300, 571680, 576980, 595421, 597863, 599988, 600995, 601514, 605442, 605544, 606599, 614308, 616336, 616411, 617427, 621656, 629918, 632595, 632641, 632690, 632694, 635243, 639732, 639739, 646448, 646849, 651601, 656303, 666850, 666869, 666894, 667748, 675006, 675008, 676634, 676638, 679728, 681313, 698959, 704560, 788264, 792569, 805367, 814991, 817793);

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
  406381
  418363
  419370
  458907
  464654
  466404
  469534
  469616
  472299
  480417
  481047
  489328
  492576
  517743
  517844
  529209
  530272
  530912
  532645
  532666
  532755
  536233
  536712
  537670
  537672
  543918
  566300
  571680
  576980
  595421
  597863
  599988
  600995
  601514
  605442
  605544
  606599
  614308
  616336
  616411
  617427
  621656
  629918
  632595
  632641
  632690
  632694
  635243
  639732
  639739
  646448
  646849
  651601
  656303
  666850
  666869
  666894
  667748
  675006
  675008
  676634
  676638
  679728
  681313
  698959
  704560
  788264
  792569
  805367
  814991
  817793
]

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 (406381, 418363, 419370, 458907, 464654, 466404, 469534, 469616, 472299, 480417, 481047, 489328, 492576, 517743, 517844, 529209, 530272, 530912, 532645, 532666, 532755, 536233, 536712, 537670, 537672, 543918, 566300, 571680, 576980, 595421, 597863, 599988, 600995, 601514, 605442, 605544, 606599, 614308, 616336, 616411, 617427, 621656, 629918, 632595, 632641, 632690, 632694, 635243, 639732, 639739, 646448, 646849, 651601, 656303, 666850, 666869, 666894, 667748, 675006, 675008, 676634, 676638, 679728, 681313, 698959, 704560, 788264, 792569, 805367, 814991, 817793);

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

[
  "bbc mom teen"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbc mom teen';

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

[
  "bbc mom teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc mom teen';

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 ?

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