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

[
  "секс балкон"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс балкон' 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
  519718
  468190
  549143
  524610
  525268
  516550
  546577
  562045
  455149
  468547
  500022
  510252
  459105
  758803
  503153
  510855
  460995
  502644
  486077
  544386
  458578
  441016
  466395
  505627
  511603
  524456
  415785
  524455
  438363
  465662
  493193
  484878
  464977
  430559
  498560
  415896
  422493
  449305
  563078
  563074
  541345
  597158
  452324
  509940
  658665
  557599
  572199
  624480
  446909
  480095
  659593
  656415
  441186
  566693
  422592
  522220
  514674
  538473
  589157
  497951
  657680
  596652
  657296
  621414
  620262
  518421
  570998
  654506
  567220
  663347
  543387
  406042
]

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 (519718, 468190, 549143, 524610, 525268, 516550, 546577, 562045, 455149, 468547, 500022, 510252, 459105, 758803, 503153, 510855, 460995, 502644, 486077, 544386, 458578, 441016, 466395, 505627, 511603, 524456, 415785, 524455, 438363, 465662, 493193, 484878, 464977, 430559, 498560, 415896, 422493, 449305, 563078, 563074, 541345, 597158, 452324, 509940, 658665, 557599, 572199, 624480, 446909, 480095, 659593, 656415, 441186, 566693, 422592, 522220, 514674, 538473, 589157, 497951, 657680, 596652, 657296, 621414, 620262, 518421, 570998, 654506, 567220, 663347, 543387, 406042);

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
  406042
  415785
  415896
  422493
  422592
  430559
  438363
  441016
  441186
  446909
  449305
  452324
  455149
  458578
  459105
  460995
  464977
  465662
  466395
  468190
  468547
  480095
  484878
  486077
  493193
  497951
  498560
  500022
  502644
  503153
  505627
  509940
  510252
  510855
  511603
  514674
  516550
  518421
  519718
  522220
  524455
  524456
  524610
  525268
  538473
  543387
  544386
  546577
  549143
  557599
  562045
  563074
  563078
  566693
  567220
  570998
  572199
  589157
  596652
  597158
  620262
  621414
  624480
  654506
  656415
  657296
  657680
  658665
  659593
  663347
  758803
]

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 (406042, 415785, 415896, 422493, 422592, 430559, 438363, 441016, 441186, 446909, 449305, 452324, 455149, 458578, 459105, 460995, 464977, 465662, 466395, 468190, 468547, 480095, 484878, 486077, 493193, 497951, 498560, 500022, 502644, 503153, 505627, 509940, 510252, 510855, 511603, 514674, 516550, 518421, 519718, 522220, 524455, 524456, 524610, 525268, 538473, 543387, 544386, 546577, 549143, 557599, 562045, 563074, 563078, 566693, 567220, 570998, 572199, 589157, 596652, 597158, 620262, 621414, 624480, 654506, 656415, 657296, 657680, 658665, 659593, 663347, 758803);

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
  406042
  415785
  415896
  422493
  422592
  430559
  438363
  441016
  441186
  446909
  449305
  452324
  455149
  458578
  459105
  460995
  464977
  465662
  466395
  468190
  468547
  480095
  484878
  486077
  493193
  497951
  498560
  500022
  502644
  503153
  505627
  509940
  510252
  510855
  511603
  514674
  516550
  518421
  519718
  522220
  524455
  524456
  524610
  525268
  538473
  543387
  544386
  546577
  549143
  557599
  562045
  563074
  563078
  566693
  567220
  570998
  572199
  589157
  596652
  597158
  620262
  621414
  624480
  654506
  656415
  657296
  657680
  658665
  659593
  663347
  758803
]

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 (406042, 415785, 415896, 422493, 422592, 430559, 438363, 441016, 441186, 446909, 449305, 452324, 455149, 458578, 459105, 460995, 464977, 465662, 466395, 468190, 468547, 480095, 484878, 486077, 493193, 497951, 498560, 500022, 502644, 503153, 505627, 509940, 510252, 510855, 511603, 514674, 516550, 518421, 519718, 522220, 524455, 524456, 524610, 525268, 538473, 543387, 544386, 546577, 549143, 557599, 562045, 563074, 563078, 566693, 567220, 570998, 572199, 589157, 596652, 597158, 620262, 621414, 624480, 654506, 656415, 657296, 657680, 658665, 659593, 663347, 758803);

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` = 'секс балкон';