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
  673537
  550020
  576712
  581266
  598348
  592376
  592477
  587817
  615738
  615751
  615734
  621306
  430479
  422525
  474859
  510874
  469272
  494426
  554787
  559127
  541871
  620135
  490011
  491403
  522696
  522939
  519230
  522342
  524949
  511464
  518591
  542480
  576707
  554132
  560085
  543480
  580258
  690783
  648204
  648256
  590954
  592444
  620148
  621305
  615748
  523454
  423633
  400143
  461211
  527568
  560924
  620130
  416975
  513030
  519246
  518588
  581300
  581398
  583885
  592437
  592440
  622953
  592530
  478596
  571135
  554626
  577371
  566243
  573765
  576691
  576704
  671746
  620157
  603247
  576720
  560190
  621992
  470546
  522382
]

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 (673537, 550020, 576712, 581266, 598348, 592376, 592477, 587817, 615738, 615751, 615734, 621306, 430479, 422525, 474859, 510874, 469272, 494426, 554787, 559127, 541871, 620135, 490011, 491403, 522696, 522939, 519230, 522342, 524949, 511464, 518591, 542480, 576707, 554132, 560085, 543480, 580258, 690783, 648204, 648256, 590954, 592444, 620148, 621305, 615748, 523454, 423633, 400143, 461211, 527568, 560924, 620130, 416975, 513030, 519246, 518588, 581300, 581398, 583885, 592437, 592440, 622953, 592530, 478596, 571135, 554626, 577371, 566243, 573765, 576691, 576704, 671746, 620157, 603247, 576720, 560190, 621992, 470546, 522382);

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
  400143
  416975
  422525
  423633
  430479
  461211
  469272
  470546
  474859
  478596
  490011
  491403
  494426
  510874
  511464
  513030
  518588
  518591
  519230
  519246
  522342
  522382
  522696
  522939
  523454
  524949
  527568
  541871
  542480
  543480
  550020
  554132
  554626
  554787
  559127
  560085
  560190
  560924
  566243
  571135
  573765
  576691
  576704
  576707
  576712
  576720
  577371
  580258
  581266
  581300
  581398
  583885
  587817
  590954
  592376
  592437
  592440
  592444
  592477
  592530
  598348
  603247
  615734
  615738
  615748
  615751
  620130
  620135
  620148
  620157
  621305
  621306
  621992
  622953
  648204
  648256
  671746
  673537
  690783
]

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 (400143, 416975, 422525, 423633, 430479, 461211, 469272, 470546, 474859, 478596, 490011, 491403, 494426, 510874, 511464, 513030, 518588, 518591, 519230, 519246, 522342, 522382, 522696, 522939, 523454, 524949, 527568, 541871, 542480, 543480, 550020, 554132, 554626, 554787, 559127, 560085, 560190, 560924, 566243, 571135, 573765, 576691, 576704, 576707, 576712, 576720, 577371, 580258, 581266, 581300, 581398, 583885, 587817, 590954, 592376, 592437, 592440, 592444, 592477, 592530, 598348, 603247, 615734, 615738, 615748, 615751, 620130, 620135, 620148, 620157, 621305, 621306, 621992, 622953, 648204, 648256, 671746, 673537, 690783);

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
  400143
  416975
  422525
  423633
  430479
  461211
  469272
  470546
  474859
  478596
  490011
  491403
  494426
  510874
  511464
  513030
  518588
  518591
  519230
  519246
  522342
  522382
  522696
  522939
  523454
  524949
  527568
  541871
  542480
  543480
  550020
  554132
  554626
  554787
  559127
  560085
  560190
  560924
  566243
  571135
  573765
  576691
  576704
  576707
  576712
  576720
  577371
  580258
  581266
  581300
  581398
  583885
  587817
  590954
  592376
  592437
  592440
  592444
  592477
  592530
  598348
  603247
  615734
  615738
  615748
  615751
  620130
  620135
  620148
  620157
  621305
  621306
  621992
  622953
  648204
  648256
  671746
  673537
  690783
]

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 (400143, 416975, 422525, 423633, 430479, 461211, 469272, 470546, 474859, 478596, 490011, 491403, 494426, 510874, 511464, 513030, 518588, 518591, 519230, 519246, 522342, 522382, 522696, 522939, 523454, 524949, 527568, 541871, 542480, 543480, 550020, 554132, 554626, 554787, 559127, 560085, 560190, 560924, 566243, 571135, 573765, 576691, 576704, 576707, 576712, 576720, 577371, 580258, 581266, 581300, 581398, 583885, 587817, 590954, 592376, 592437, 592440, 592444, 592477, 592530, 598348, 603247, 615734, 615738, 615748, 615751, 620130, 620135, 620148, 620157, 621305, 621306, 621992, 622953, 648204, 648256, 671746, 673537, 690783);

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` = 'волосатая порн фильм';