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

[
  "lucky old man"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'lucky old man' 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
  828819
  596468
  776745
  503870
  596543
  781990
  596453
  366321
  740610
  722676
  818316
  734840
  407851
  401778
  678803
  725914
  560853
  477396
  390772
  561357
  396954
  720483
  693883
  621359
  729883
  80777
  419050
  748681
  401362
  818444
  718264
  596353
  792059
  792686
  741602
  559386
  486215
  574538
  596360
  11385
  398244
  468938
  721554
  398224
  398178
  453621
  415388
  562523
  715719
  699611
  579279
  603243
  808756
  720885
  595897
  792530
  807688
  508527
  483368
  472142
  567156
  483328
  550976
  468941
  466994
  520803
  383616
  590405
  497865
  489950
  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 (828819, 596468, 776745, 503870, 596543, 781990, 596453, 366321, 740610, 722676, 818316, 734840, 407851, 401778, 678803, 725914, 560853, 477396, 390772, 561357, 396954, 720483, 693883, 621359, 729883, 80777, 419050, 748681, 401362, 818444, 718264, 596353, 792059, 792686, 741602, 559386, 486215, 574538, 596360, 11385, 398244, 468938, 721554, 398224, 398178, 453621, 415388, 562523, 715719, 699611, 579279, 603243, 808756, 720885, 595897, 792530, 807688, 508527, 483368, 472142, 567156, 483328, 550976, 468941, 466994, 520803, 383616, 590405, 497865, 489950, 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
  11385
  80777
  366321
  383616
  390772
  396954
  398178
  398224
  398244
  401362
  401778
  407851
  415388
  419050
  453621
  466994
  468938
  468941
  472142
  477396
  483328
  483368
  486215
  489950
  497865
  503870
  508527
  520803
  550976
  559386
  560853
  561357
  562523
  567156
  574538
  579279
  590405
  595897
  596353
  596360
  596453
  596468
  596543
  599988
  603243
  621359
  678803
  693883
  699611
  715719
  718264
  720483
  720885
  721554
  722676
  725914
  729883
  734840
  740610
  741602
  748681
  776745
  781990
  792059
  792530
  792686
  807688
  808756
  818316
  818444
  828819
]

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 (11385, 80777, 366321, 383616, 390772, 396954, 398178, 398224, 398244, 401362, 401778, 407851, 415388, 419050, 453621, 466994, 468938, 468941, 472142, 477396, 483328, 483368, 486215, 489950, 497865, 503870, 508527, 520803, 550976, 559386, 560853, 561357, 562523, 567156, 574538, 579279, 590405, 595897, 596353, 596360, 596453, 596468, 596543, 599988, 603243, 621359, 678803, 693883, 699611, 715719, 718264, 720483, 720885, 721554, 722676, 725914, 729883, 734840, 740610, 741602, 748681, 776745, 781990, 792059, 792530, 792686, 807688, 808756, 818316, 818444, 828819);

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
  11385
  80777
  366321
  383616
  390772
  396954
  398178
  398224
  398244
  401362
  401778
  407851
  415388
  419050
  453621
  466994
  468938
  468941
  472142
  477396
  483328
  483368
  486215
  489950
  497865
  503870
  508527
  520803
  550976
  559386
  560853
  561357
  562523
  567156
  574538
  579279
  590405
  595897
  596353
  596360
  596453
  596468
  596543
  599988
  603243
  621359
  678803
  693883
  699611
  715719
  718264
  720483
  720885
  721554
  722676
  725914
  729883
  734840
  740610
  741602
  748681
  776745
  781990
  792059
  792530
  792686
  807688
  808756
  818316
  818444
  828819
]

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 (11385, 80777, 366321, 383616, 390772, 396954, 398178, 398224, 398244, 401362, 401778, 407851, 415388, 419050, 453621, 466994, 468938, 468941, 472142, 477396, 483328, 483368, 486215, 489950, 497865, 503870, 508527, 520803, 550976, 559386, 560853, 561357, 562523, 567156, 574538, 579279, 590405, 595897, 596353, 596360, 596453, 596468, 596543, 599988, 603243, 621359, 678803, 693883, 699611, 715719, 718264, 720483, 720885, 721554, 722676, 725914, 729883, 734840, 740610, 741602, 748681, 776745, 781990, 792059, 792530, 792686, 807688, 808756, 818316, 818444, 828819);

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

[
  "lucky old мужчин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'lucky old мужчин';

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

[
  "lucky old мужчин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'lucky old мужчин';

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 ?

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