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

[
  "sleep russian mother"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sleep russian mother' 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
  546904
  626067
  791425
  454398
  445884
  519408
  625235
  398958
  685736
  619107
  618982
  428884
  466253
  439620
  626367
  620230
  465356
  484484
  518851
  605736
  484739
  484581
  444890
  499341
  599371
  726882
  461837
  464232
  564647
  518604
  485709
  575241
  552268
  662426
  520878
  507047
  466081
  511162
  519337
  516930
  609225
  624429
  615689
  473670
  517105
  470018
  474418
  800704
  443737
  420635
  724966
  462949
  490944
  788866
  476003
  439819
  606567
  489281
  478981
  411328
  567316
  468897
  583146
  466213
  526118
  620754
  556002
  526730
  590135
  559950
  614521
  466103
]

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 (546904, 626067, 791425, 454398, 445884, 519408, 625235, 398958, 685736, 619107, 618982, 428884, 466253, 439620, 626367, 620230, 465356, 484484, 518851, 605736, 484739, 484581, 444890, 499341, 599371, 726882, 461837, 464232, 564647, 518604, 485709, 575241, 552268, 662426, 520878, 507047, 466081, 511162, 519337, 516930, 609225, 624429, 615689, 473670, 517105, 470018, 474418, 800704, 443737, 420635, 724966, 462949, 490944, 788866, 476003, 439819, 606567, 489281, 478981, 411328, 567316, 468897, 583146, 466213, 526118, 620754, 556002, 526730, 590135, 559950, 614521, 466103);

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
  398958
  411328
  420635
  428884
  439620
  439819
  443737
  444890
  445884
  454398
  461837
  462949
  464232
  465356
  466081
  466103
  466213
  466253
  468897
  470018
  473670
  474418
  476003
  478981
  484484
  484581
  484739
  485709
  489281
  490944
  499341
  507047
  511162
  516930
  517105
  518604
  518851
  519337
  519408
  520878
  526118
  526730
  546904
  552268
  556002
  559950
  564647
  567316
  575241
  583146
  590135
  599371
  605736
  606567
  609225
  614521
  615689
  618982
  619107
  620230
  620754
  624429
  625235
  626067
  626367
  662426
  685736
  724966
  726882
  788866
  791425
  800704
]

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 (398958, 411328, 420635, 428884, 439620, 439819, 443737, 444890, 445884, 454398, 461837, 462949, 464232, 465356, 466081, 466103, 466213, 466253, 468897, 470018, 473670, 474418, 476003, 478981, 484484, 484581, 484739, 485709, 489281, 490944, 499341, 507047, 511162, 516930, 517105, 518604, 518851, 519337, 519408, 520878, 526118, 526730, 546904, 552268, 556002, 559950, 564647, 567316, 575241, 583146, 590135, 599371, 605736, 606567, 609225, 614521, 615689, 618982, 619107, 620230, 620754, 624429, 625235, 626067, 626367, 662426, 685736, 724966, 726882, 788866, 791425, 800704);

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
  398958
  411328
  420635
  428884
  439620
  439819
  443737
  444890
  445884
  454398
  461837
  462949
  464232
  465356
  466081
  466103
  466213
  466253
  468897
  470018
  473670
  474418
  476003
  478981
  484484
  484581
  484739
  485709
  489281
  490944
  499341
  507047
  511162
  516930
  517105
  518604
  518851
  519337
  519408
  520878
  526118
  526730
  546904
  552268
  556002
  559950
  564647
  567316
  575241
  583146
  590135
  599371
  605736
  606567
  609225
  614521
  615689
  618982
  619107
  620230
  620754
  624429
  625235
  626067
  626367
  662426
  685736
  724966
  726882
  788866
  791425
  800704
]

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 (398958, 411328, 420635, 428884, 439620, 439819, 443737, 444890, 445884, 454398, 461837, 462949, 464232, 465356, 466081, 466103, 466213, 466253, 468897, 470018, 473670, 474418, 476003, 478981, 484484, 484581, 484739, 485709, 489281, 490944, 499341, 507047, 511162, 516930, 517105, 518604, 518851, 519337, 519408, 520878, 526118, 526730, 546904, 552268, 556002, 559950, 564647, 567316, 575241, 583146, 590135, 599371, 605736, 606567, 609225, 614521, 615689, 618982, 619107, 620230, 620754, 624429, 625235, 626067, 626367, 662426, 685736, 724966, 726882, 788866, 791425, 800704);

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

[
  "спящ русск мам женщин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'спящ русск мам женщин';

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

[
  "спящ русск мам женщин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'спящ русск мам женщин';