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 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01ÆÃ\x14²&qOìÖC)<$º\x07"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0192C714FD26714F8D9943293C24A707 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
  486539
  518255
  523931
  501178
  402001
  429604
  445971
  450847
  447009
  480370
  511359
  572023
  542907
  662444
  554529
  607027
  598144
  598486
  431913
  404957
  426409
  467605
  440987
  485918
  473948
  509997
  541738
  564992
  601491
  595588
  618007
  629882
  602739
  428398
  499867
  516087
  502648
  526531
  536648
  572711
  558380
  567837
  623116
  603981
  458224
  419988
  560189
  565795
  568062
  568720
  577909
  546347
  561082
  556036
  619216
  620048
  591351
  598984
  448816
  459524
  449925
  492169
  496853
  518438
  523492
  535062
  524323
  544472
  647656
  577491
  606014
  612455
  605406
  478651
  504718
  520232
  527933
  625001
  609958
  623405
  521843
]

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 (486539, 518255, 523931, 501178, 402001, 429604, 445971, 450847, 447009, 480370, 511359, 572023, 542907, 662444, 554529, 607027, 598144, 598486, 431913, 404957, 426409, 467605, 440987, 485918, 473948, 509997, 541738, 564992, 601491, 595588, 618007, 629882, 602739, 428398, 499867, 516087, 502648, 526531, 536648, 572711, 558380, 567837, 623116, 603981, 458224, 419988, 560189, 565795, 568062, 568720, 577909, 546347, 561082, 556036, 619216, 620048, 591351, 598984, 448816, 459524, 449925, 492169, 496853, 518438, 523492, 535062, 524323, 544472, 647656, 577491, 606014, 612455, 605406, 478651, 504718, 520232, 527933, 625001, 609958, 623405, 521843);

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
  402001
  404957
  419988
  426409
  428398
  429604
  431913
  440987
  445971
  447009
  448816
  449925
  450847
  458224
  459524
  467605
  473948
  478651
  480370
  485918
  486539
  492169
  496853
  499867
  501178
  502648
  504718
  509997
  511359
  516087
  518255
  518438
  520232
  521843
  523492
  523931
  524323
  526531
  527933
  535062
  536648
  541738
  542907
  544472
  546347
  554529
  556036
  558380
  560189
  561082
  564992
  565795
  567837
  568062
  568720
  572023
  572711
  577491
  577909
  591351
  595588
  598144
  598486
  598984
  601491
  602739
  603981
  605406
  606014
  607027
  609958
  612455
  618007
  619216
  620048
  623116
  623405
  625001
  629882
  647656
  662444
]

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 (402001, 404957, 419988, 426409, 428398, 429604, 431913, 440987, 445971, 447009, 448816, 449925, 450847, 458224, 459524, 467605, 473948, 478651, 480370, 485918, 486539, 492169, 496853, 499867, 501178, 502648, 504718, 509997, 511359, 516087, 518255, 518438, 520232, 521843, 523492, 523931, 524323, 526531, 527933, 535062, 536648, 541738, 542907, 544472, 546347, 554529, 556036, 558380, 560189, 561082, 564992, 565795, 567837, 568062, 568720, 572023, 572711, 577491, 577909, 591351, 595588, 598144, 598486, 598984, 601491, 602739, 603981, 605406, 606014, 607027, 609958, 612455, 618007, 619216, 620048, 623116, 623405, 625001, 629882, 647656, 662444);

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
  402001
  404957
  419988
  426409
  428398
  429604
  431913
  440987
  445971
  447009
  448816
  449925
  450847
  458224
  459524
  467605
  473948
  478651
  480370
  485918
  486539
  492169
  496853
  499867
  501178
  502648
  504718
  509997
  511359
  516087
  518255
  518438
  520232
  521843
  523492
  523931
  524323
  526531
  527933
  535062
  536648
  541738
  542907
  544472
  546347
  554529
  556036
  558380
  560189
  561082
  564992
  565795
  567837
  568062
  568720
  572023
  572711
  577491
  577909
  591351
  595588
  598144
  598486
  598984
  601491
  602739
  603981
  605406
  606014
  607027
  609958
  612455
  618007
  619216
  620048
  623116
  623405
  625001
  629882
  647656
  662444
]

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 (402001, 404957, 419988, 426409, 428398, 429604, 431913, 440987, 445971, 447009, 448816, 449925, 450847, 458224, 459524, 467605, 473948, 478651, 480370, 485918, 486539, 492169, 496853, 499867, 501178, 502648, 504718, 509997, 511359, 516087, 518255, 518438, 520232, 521843, 523492, 523931, 524323, 526531, 527933, 535062, 536648, 541738, 542907, 544472, 546347, 554529, 556036, 558380, 560189, 561082, 564992, 565795, 567837, 568062, 568720, 572023, 572711, 577491, 577909, 591351, 595588, 598144, 598486, 598984, 601491, 602739, 603981, 605406, 606014, 607027, 609958, 612455, 618007, 619216, 620048, 623116, 623405, 625001, 629882, 647656, 662444);

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` = 'бод';