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

[
  "erotic show"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'erotic show' 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
  585077
  457179
  448646
  491288
  536099
  535252
  539114
  547521
  572765
  578771
  550032
  557463
  717410
  584065
  600986
  602314
  615910
  595867
  600822
  601174
  598061
  598129
  625737
  790193
  800677
  812564
  602343
  781857
  459481
  425502
  458672
  471969
  435522
  525373
  492433
  525758
  512552
  540889
  470058
  527178
  515356
  582574
  556850
  650748
  661365
  551872
  579539
  621472
  587216
  602338
  614830
  605094
  784657
  465985
  515464
  466779
  507787
  541465
  579624
  559430
  680706
  677416
  609164
  602186
  590418
  574243
  564643
  602092
  618949
  585889
  513000
]

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 (585077, 457179, 448646, 491288, 536099, 535252, 539114, 547521, 572765, 578771, 550032, 557463, 717410, 584065, 600986, 602314, 615910, 595867, 600822, 601174, 598061, 598129, 625737, 790193, 800677, 812564, 602343, 781857, 459481, 425502, 458672, 471969, 435522, 525373, 492433, 525758, 512552, 540889, 470058, 527178, 515356, 582574, 556850, 650748, 661365, 551872, 579539, 621472, 587216, 602338, 614830, 605094, 784657, 465985, 515464, 466779, 507787, 541465, 579624, 559430, 680706, 677416, 609164, 602186, 590418, 574243, 564643, 602092, 618949, 585889, 513000);

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
  425502
  435522
  448646
  457179
  458672
  459481
  465985
  466779
  470058
  471969
  491288
  492433
  507787
  512552
  513000
  515356
  515464
  525373
  525758
  527178
  535252
  536099
  539114
  540889
  541465
  547521
  550032
  551872
  556850
  557463
  559430
  564643
  572765
  574243
  578771
  579539
  579624
  582574
  584065
  585077
  585889
  587216
  590418
  595867
  598061
  598129
  600822
  600986
  601174
  602092
  602186
  602314
  602338
  602343
  605094
  609164
  614830
  615910
  618949
  621472
  625737
  650748
  661365
  677416
  680706
  717410
  781857
  784657
  790193
  800677
  812564
]

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 (425502, 435522, 448646, 457179, 458672, 459481, 465985, 466779, 470058, 471969, 491288, 492433, 507787, 512552, 513000, 515356, 515464, 525373, 525758, 527178, 535252, 536099, 539114, 540889, 541465, 547521, 550032, 551872, 556850, 557463, 559430, 564643, 572765, 574243, 578771, 579539, 579624, 582574, 584065, 585077, 585889, 587216, 590418, 595867, 598061, 598129, 600822, 600986, 601174, 602092, 602186, 602314, 602338, 602343, 605094, 609164, 614830, 615910, 618949, 621472, 625737, 650748, 661365, 677416, 680706, 717410, 781857, 784657, 790193, 800677, 812564);

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
  425502
  435522
  448646
  457179
  458672
  459481
  465985
  466779
  470058
  471969
  491288
  492433
  507787
  512552
  513000
  515356
  515464
  525373
  525758
  527178
  535252
  536099
  539114
  540889
  541465
  547521
  550032
  551872
  556850
  557463
  559430
  564643
  572765
  574243
  578771
  579539
  579624
  582574
  584065
  585077
  585889
  587216
  590418
  595867
  598061
  598129
  600822
  600986
  601174
  602092
  602186
  602314
  602338
  602343
  605094
  609164
  614830
  615910
  618949
  621472
  625737
  650748
  661365
  677416
  680706
  717410
  781857
  784657
  790193
  800677
  812564
]

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 (425502, 435522, 448646, 457179, 458672, 459481, 465985, 466779, 470058, 471969, 491288, 492433, 507787, 512552, 513000, 515356, 515464, 525373, 525758, 527178, 535252, 536099, 539114, 540889, 541465, 547521, 550032, 551872, 556850, 557463, 559430, 564643, 572765, 574243, 578771, 579539, 579624, 582574, 584065, 585077, 585889, 587216, 590418, 595867, 598061, 598129, 600822, 600986, 601174, 602092, 602186, 602314, 602338, 602343, 605094, 609164, 614830, 615910, 618949, 621472, 625737, 650748, 661365, 677416, 680706, 717410, 781857, 784657, 790193, 800677, 812564);

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

[
  "эротик show"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'эротик show';

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

[
  "эротик show"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'эротик show';