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

[
  "drive"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'drive' 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
  740339
  540916
  824694
  826515
  566417
  828247
  691933
  828335
  810932
  796516
  730740
  777439
  519401
  718007
  787449
  724435
  745113
  732753
  721132
  806478
  638968
  736520
  724326
  818781
  648958
  608706
  608912
  618367
  624969
  696892
  537518
  653624
  811415
  725094
  761222
  811785
  724819
  722727
  382252
  420647
  527303
  573737
  626298
  806720
  761792
  738917
  726049
  617588
  702488
  696309
  782896
  457073
  516963
  544600
  679196
  592852
  597455
  798743
  480869
  418577
  468606
  599802
  502366
  521017
  524387
  569085
  606142
  486903
  568871
  633750
  452385
  626311
  561375
  621275
  516078
]

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 (740339, 540916, 824694, 826515, 566417, 828247, 691933, 828335, 810932, 796516, 730740, 777439, 519401, 718007, 787449, 724435, 745113, 732753, 721132, 806478, 638968, 736520, 724326, 818781, 648958, 608706, 608912, 618367, 624969, 696892, 537518, 653624, 811415, 725094, 761222, 811785, 724819, 722727, 382252, 420647, 527303, 573737, 626298, 806720, 761792, 738917, 726049, 617588, 702488, 696309, 782896, 457073, 516963, 544600, 679196, 592852, 597455, 798743, 480869, 418577, 468606, 599802, 502366, 521017, 524387, 569085, 606142, 486903, 568871, 633750, 452385, 626311, 561375, 621275, 516078);

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
  382252
  418577
  420647
  452385
  457073
  468606
  480869
  486903
  502366
  516078
  516963
  519401
  521017
  524387
  527303
  537518
  540916
  544600
  561375
  566417
  568871
  569085
  573737
  592852
  597455
  599802
  606142
  608706
  608912
  617588
  618367
  621275
  624969
  626298
  626311
  633750
  638968
  648958
  653624
  679196
  691933
  696309
  696892
  702488
  718007
  721132
  722727
  724326
  724435
  724819
  725094
  726049
  730740
  732753
  736520
  738917
  740339
  745113
  761222
  761792
  777439
  782896
  787449
  796516
  798743
  806478
  806720
  810932
  811415
  811785
  818781
  826515
  828247
  828335
]

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 (382252, 418577, 420647, 452385, 457073, 468606, 480869, 486903, 502366, 516078, 516963, 519401, 521017, 524387, 527303, 537518, 540916, 544600, 561375, 566417, 568871, 569085, 573737, 592852, 597455, 599802, 606142, 608706, 608912, 617588, 618367, 621275, 624969, 626298, 626311, 633750, 638968, 648958, 653624, 679196, 691933, 696309, 696892, 702488, 718007, 721132, 722727, 724326, 724435, 724819, 725094, 726049, 730740, 732753, 736520, 738917, 740339, 745113, 761222, 761792, 777439, 782896, 787449, 796516, 798743, 806478, 806720, 810932, 811415, 811785, 818781, 826515, 828247, 828335);

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
  382252
  418577
  420647
  452385
  457073
  468606
  480869
  486903
  502366
  516078
  516963
  519401
  521017
  524387
  527303
  537518
  540916
  544600
  561375
  566417
  568871
  569085
  573737
  592852
  597455
  599802
  606142
  608706
  608912
  617588
  618367
  621275
  624969
  626298
  626311
  633750
  638968
  648958
  653624
  679196
  691933
  696309
  696892
  702488
  718007
  721132
  722727
  724326
  724435
  724819
  725094
  726049
  730740
  732753
  736520
  738917
  740339
  745113
  761222
  761792
  777439
  782896
  787449
  796516
  798743
  806478
  806720
  810932
  811415
  811785
  818781
  826515
  828247
  828335
]

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 (382252, 418577, 420647, 452385, 457073, 468606, 480869, 486903, 502366, 516078, 516963, 519401, 521017, 524387, 527303, 537518, 540916, 544600, 561375, 566417, 568871, 569085, 573737, 592852, 597455, 599802, 606142, 608706, 608912, 617588, 618367, 621275, 624969, 626298, 626311, 633750, 638968, 648958, 653624, 679196, 691933, 696309, 696892, 702488, 718007, 721132, 722727, 724326, 724435, 724819, 725094, 726049, 730740, 732753, 736520, 738917, 740339, 745113, 761222, 761792, 777439, 782896, 787449, 796516, 798743, 806478, 806720, 810932, 811415, 811785, 818781, 826515, 828247, 828335);

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

[
  "drive"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'drive';

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

[
  "drive"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'drive';

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 ?

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