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

[
  "group mom party"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'group mom party' 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
  775833
  645249
  820962
  603190
  603174
  760309
  823313
  691830
  720939
  612062
  630861
  603215
  806447
  775872
  822287
  705144
  401251
  411953
  814893
  692506
  561365
  588262
  634477
  605525
  775810
  748243
  533351
  539105
  541561
  668480
  673358
  718968
  595735
  634468
  591329
  775858
  797667
  641055
  419382
  533855
  528698
  553912
  637746
  643935
  595786
  622044
  586652
  634475
  526060
  813759
  604094
  619468
  424695
  494430
  571018
  612431
  634487
  641141
  404925
  532676
  492760
  648853
  662137
  582540
  634472
  544800
  647932
  401919
  432751
  611558
  535016
  543419
]

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 (775833, 645249, 820962, 603190, 603174, 760309, 823313, 691830, 720939, 612062, 630861, 603215, 806447, 775872, 822287, 705144, 401251, 411953, 814893, 692506, 561365, 588262, 634477, 605525, 775810, 748243, 533351, 539105, 541561, 668480, 673358, 718968, 595735, 634468, 591329, 775858, 797667, 641055, 419382, 533855, 528698, 553912, 637746, 643935, 595786, 622044, 586652, 634475, 526060, 813759, 604094, 619468, 424695, 494430, 571018, 612431, 634487, 641141, 404925, 532676, 492760, 648853, 662137, 582540, 634472, 544800, 647932, 401919, 432751, 611558, 535016, 543419);

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
  401251
  401919
  404925
  411953
  419382
  424695
  432751
  492760
  494430
  526060
  528698
  532676
  533351
  533855
  535016
  539105
  541561
  543419
  544800
  553912
  561365
  571018
  582540
  586652
  588262
  591329
  595735
  595786
  603174
  603190
  603215
  604094
  605525
  611558
  612062
  612431
  619468
  622044
  630861
  634468
  634472
  634475
  634477
  634487
  637746
  641055
  641141
  643935
  645249
  647932
  648853
  662137
  668480
  673358
  691830
  692506
  705144
  718968
  720939
  748243
  760309
  775810
  775833
  775858
  775872
  797667
  806447
  813759
  814893
  820962
  822287
  823313
]

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 (401251, 401919, 404925, 411953, 419382, 424695, 432751, 492760, 494430, 526060, 528698, 532676, 533351, 533855, 535016, 539105, 541561, 543419, 544800, 553912, 561365, 571018, 582540, 586652, 588262, 591329, 595735, 595786, 603174, 603190, 603215, 604094, 605525, 611558, 612062, 612431, 619468, 622044, 630861, 634468, 634472, 634475, 634477, 634487, 637746, 641055, 641141, 643935, 645249, 647932, 648853, 662137, 668480, 673358, 691830, 692506, 705144, 718968, 720939, 748243, 760309, 775810, 775833, 775858, 775872, 797667, 806447, 813759, 814893, 820962, 822287, 823313);

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
  401251
  401919
  404925
  411953
  419382
  424695
  432751
  492760
  494430
  526060
  528698
  532676
  533351
  533855
  535016
  539105
  541561
  543419
  544800
  553912
  561365
  571018
  582540
  586652
  588262
  591329
  595735
  595786
  603174
  603190
  603215
  604094
  605525
  611558
  612062
  612431
  619468
  622044
  630861
  634468
  634472
  634475
  634477
  634487
  637746
  641055
  641141
  643935
  645249
  647932
  648853
  662137
  668480
  673358
  691830
  692506
  705144
  718968
  720939
  748243
  760309
  775810
  775833
  775858
  775872
  797667
  806447
  813759
  814893
  820962
  822287
  823313
]

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 (401251, 401919, 404925, 411953, 419382, 424695, 432751, 492760, 494430, 526060, 528698, 532676, 533351, 533855, 535016, 539105, 541561, 543419, 544800, 553912, 561365, 571018, 582540, 586652, 588262, 591329, 595735, 595786, 603174, 603190, 603215, 604094, 605525, 611558, 612062, 612431, 619468, 622044, 630861, 634468, 634472, 634475, 634477, 634487, 637746, 641055, 641141, 643935, 645249, 647932, 648853, 662137, 668480, 673358, 691830, 692506, 705144, 718968, 720939, 748243, 760309, 775810, 775833, 775858, 775872, 797667, 806447, 813759, 814893, 820962, 822287, 823313);

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

[
  "group mom party"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'group mom party';

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

[
  "group mom party"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'group mom party';

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 ?

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