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
  627144
  515908
  582828
  601655
  573390
  615214
  520145
  540792
  599803
  491858
  507813
  568059
  613263
  602739
  619308
  658433
  662435
  624150
  567139
  663372
  586431
  656477
  466213
  575713
  621515
  591249
  599534
  466500
  620009
  498043
  622778
  560569
  567053
  620001
  589769
  589671
  599478
  623251
  584636
  556524
  604429
  656465
  596424
  565156
  549736
  474125
  484632
  492682
  520355
  482507
  653544
  655714
  596526
  600060
  618476
  465336
  629445
  512050
  526439
  546913
  654503
  655322
  655609
  657402
  614717
  600035
  618334
  447089
  511837
  524524
  491823
  513141
  623357
  577108
  617004
  463957
  468065
]

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 (627144, 515908, 582828, 601655, 573390, 615214, 520145, 540792, 599803, 491858, 507813, 568059, 613263, 602739, 619308, 658433, 662435, 624150, 567139, 663372, 586431, 656477, 466213, 575713, 621515, 591249, 599534, 466500, 620009, 498043, 622778, 560569, 567053, 620001, 589769, 589671, 599478, 623251, 584636, 556524, 604429, 656465, 596424, 565156, 549736, 474125, 484632, 492682, 520355, 482507, 653544, 655714, 596526, 600060, 618476, 465336, 629445, 512050, 526439, 546913, 654503, 655322, 655609, 657402, 614717, 600035, 618334, 447089, 511837, 524524, 491823, 513141, 623357, 577108, 617004, 463957, 468065);

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
  447089
  463957
  465336
  466213
  466500
  468065
  474125
  482507
  484632
  491823
  491858
  492682
  498043
  507813
  511837
  512050
  513141
  515908
  520145
  520355
  524524
  526439
  540792
  546913
  549736
  556524
  560569
  565156
  567053
  567139
  568059
  573390
  575713
  577108
  582828
  584636
  586431
  589671
  589769
  591249
  596424
  596526
  599478
  599534
  599803
  600035
  600060
  601655
  602739
  604429
  613263
  614717
  615214
  617004
  618334
  618476
  619308
  620001
  620009
  621515
  622778
  623251
  623357
  624150
  627144
  629445
  653544
  654503
  655322
  655609
  655714
  656465
  656477
  657402
  658433
  662435
  663372
]

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 (447089, 463957, 465336, 466213, 466500, 468065, 474125, 482507, 484632, 491823, 491858, 492682, 498043, 507813, 511837, 512050, 513141, 515908, 520145, 520355, 524524, 526439, 540792, 546913, 549736, 556524, 560569, 565156, 567053, 567139, 568059, 573390, 575713, 577108, 582828, 584636, 586431, 589671, 589769, 591249, 596424, 596526, 599478, 599534, 599803, 600035, 600060, 601655, 602739, 604429, 613263, 614717, 615214, 617004, 618334, 618476, 619308, 620001, 620009, 621515, 622778, 623251, 623357, 624150, 627144, 629445, 653544, 654503, 655322, 655609, 655714, 656465, 656477, 657402, 658433, 662435, 663372);

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
  447089
  463957
  465336
  466213
  466500
  468065
  474125
  482507
  484632
  491823
  491858
  492682
  498043
  507813
  511837
  512050
  513141
  515908
  520145
  520355
  524524
  526439
  540792
  546913
  549736
  556524
  560569
  565156
  567053
  567139
  568059
  573390
  575713
  577108
  582828
  584636
  586431
  589671
  589769
  591249
  596424
  596526
  599478
  599534
  599803
  600035
  600060
  601655
  602739
  604429
  613263
  614717
  615214
  617004
  618334
  618476
  619308
  620001
  620009
  621515
  622778
  623251
  623357
  624150
  627144
  629445
  653544
  654503
  655322
  655609
  655714
  656465
  656477
  657402
  658433
  662435
  663372
]

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 (447089, 463957, 465336, 466213, 466500, 468065, 474125, 482507, 484632, 491823, 491858, 492682, 498043, 507813, 511837, 512050, 513141, 515908, 520145, 520355, 524524, 526439, 540792, 546913, 549736, 556524, 560569, 565156, 567053, 567139, 568059, 573390, 575713, 577108, 582828, 584636, 586431, 589671, 589769, 591249, 596424, 596526, 599478, 599534, 599803, 600035, 600060, 601655, 602739, 604429, 613263, 614717, 615214, 617004, 618334, 618476, 619308, 620001, 620009, 621515, 622778, 623251, 623357, 624150, 627144, 629445, 653544, 654503, 655322, 655609, 655714, 656465, 656477, 657402, 658433, 662435, 663372);

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` = 'стон жен';