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

[
  "mom chubby russian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mom chubby russian' 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
  439799
  444361
  454212
  454420
  454439
  457454
  457459
  465222
  465534
  455337
  457457
  457472
  514110
  526520
  483628
  483639
  489379
  512455
  519346
  521758
  485273
  493167
  494315
  507245
  523840
  526524
  521127
  521134
  526454
  528345
  464542
  428202
  490409
  539351
  565691
  599272
  400845
  421833
  422195
  422202
  439738
  440726
  470472
  421882
  439772
  451492
  457418
  460734
  466189
  470302
  422203
  422208
  457470
  457473
  426988
  454501
  465572
  433323
  471046
  516484
  526512
  483569
  493176
  506278
  484456
  485276
  671395
  558176
  602672
  474784
  426991
  478372
  439673
  528927
  506132
  421890
  422270
  582269
  526951
  543579
]

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 (439799, 444361, 454212, 454420, 454439, 457454, 457459, 465222, 465534, 455337, 457457, 457472, 514110, 526520, 483628, 483639, 489379, 512455, 519346, 521758, 485273, 493167, 494315, 507245, 523840, 526524, 521127, 521134, 526454, 528345, 464542, 428202, 490409, 539351, 565691, 599272, 400845, 421833, 422195, 422202, 439738, 440726, 470472, 421882, 439772, 451492, 457418, 460734, 466189, 470302, 422203, 422208, 457470, 457473, 426988, 454501, 465572, 433323, 471046, 516484, 526512, 483569, 493176, 506278, 484456, 485276, 671395, 558176, 602672, 474784, 426991, 478372, 439673, 528927, 506132, 421890, 422270, 582269, 526951, 543579);

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
  400845
  421833
  421882
  421890
  422195
  422202
  422203
  422208
  422270
  426988
  426991
  428202
  433323
  439673
  439738
  439772
  439799
  440726
  444361
  451492
  454212
  454420
  454439
  454501
  455337
  457418
  457454
  457457
  457459
  457470
  457472
  457473
  460734
  464542
  465222
  465534
  465572
  466189
  470302
  470472
  471046
  474784
  478372
  483569
  483628
  483639
  484456
  485273
  485276
  489379
  490409
  493167
  493176
  494315
  506132
  506278
  507245
  512455
  514110
  516484
  519346
  521127
  521134
  521758
  523840
  526454
  526512
  526520
  526524
  526951
  528345
  528927
  539351
  543579
  558176
  565691
  582269
  599272
  602672
  671395
]

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 (400845, 421833, 421882, 421890, 422195, 422202, 422203, 422208, 422270, 426988, 426991, 428202, 433323, 439673, 439738, 439772, 439799, 440726, 444361, 451492, 454212, 454420, 454439, 454501, 455337, 457418, 457454, 457457, 457459, 457470, 457472, 457473, 460734, 464542, 465222, 465534, 465572, 466189, 470302, 470472, 471046, 474784, 478372, 483569, 483628, 483639, 484456, 485273, 485276, 489379, 490409, 493167, 493176, 494315, 506132, 506278, 507245, 512455, 514110, 516484, 519346, 521127, 521134, 521758, 523840, 526454, 526512, 526520, 526524, 526951, 528345, 528927, 539351, 543579, 558176, 565691, 582269, 599272, 602672, 671395);

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
  400845
  421833
  421882
  421890
  422195
  422202
  422203
  422208
  422270
  426988
  426991
  428202
  433323
  439673
  439738
  439772
  439799
  440726
  444361
  451492
  454212
  454420
  454439
  454501
  455337
  457418
  457454
  457457
  457459
  457470
  457472
  457473
  460734
  464542
  465222
  465534
  465572
  466189
  470302
  470472
  471046
  474784
  478372
  483569
  483628
  483639
  484456
  485273
  485276
  489379
  490409
  493167
  493176
  494315
  506132
  506278
  507245
  512455
  514110
  516484
  519346
  521127
  521134
  521758
  523840
  526454
  526512
  526520
  526524
  526951
  528345
  528927
  539351
  543579
  558176
  565691
  582269
  599272
  602672
  671395
]

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 (400845, 421833, 421882, 421890, 422195, 422202, 422203, 422208, 422270, 426988, 426991, 428202, 433323, 439673, 439738, 439772, 439799, 440726, 444361, 451492, 454212, 454420, 454439, 454501, 455337, 457418, 457454, 457457, 457459, 457470, 457472, 457473, 460734, 464542, 465222, 465534, 465572, 466189, 470302, 470472, 471046, 474784, 478372, 483569, 483628, 483639, 484456, 485273, 485276, 489379, 490409, 493167, 493176, 494315, 506132, 506278, 507245, 512455, 514110, 516484, 519346, 521127, 521134, 521758, 523840, 526454, 526512, 526520, 526524, 526951, 528345, 528927, 539351, 543579, 558176, 565691, 582269, 599272, 602672, 671395);

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

[
  "mom chubby русск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mom chubby русск';

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

[
  "mom chubby русск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mom chubby русск';