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

[
  "too too"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'too too' 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
  506622
  528306
  528661
  522387
  526502
  540612
  517422
  548984
  550764
  562802
  562853
  575889
  571007
  547764
  575715
  588454
  592046
  631110
  600114
  610958
  405050
  434859
  413964
  471319
  473798
  452297
  448781
  451311
  520129
  486580
  499636
  515249
  528262
  445327
  449717
  489239
  519261
  522434
  537241
  555391
  565038
  728452
  624832
  421797
  516632
  508569
  479004
  498404
  507195
  540071
  542218
  674047
  650992
  452327
  515605
  507666
  514772
  503659
  528682
  683083
  461141
  399717
  525113
  659035
  571137
  623615
  520950
  572771
  465248
  529200
  557537
  520355
  519933
  565783
]

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 (506622, 528306, 528661, 522387, 526502, 540612, 517422, 548984, 550764, 562802, 562853, 575889, 571007, 547764, 575715, 588454, 592046, 631110, 600114, 610958, 405050, 434859, 413964, 471319, 473798, 452297, 448781, 451311, 520129, 486580, 499636, 515249, 528262, 445327, 449717, 489239, 519261, 522434, 537241, 555391, 565038, 728452, 624832, 421797, 516632, 508569, 479004, 498404, 507195, 540071, 542218, 674047, 650992, 452327, 515605, 507666, 514772, 503659, 528682, 683083, 461141, 399717, 525113, 659035, 571137, 623615, 520950, 572771, 465248, 529200, 557537, 520355, 519933, 565783);

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
  399717
  405050
  413964
  421797
  434859
  445327
  448781
  449717
  451311
  452297
  452327
  461141
  465248
  471319
  473798
  479004
  486580
  489239
  498404
  499636
  503659
  506622
  507195
  507666
  508569
  514772
  515249
  515605
  516632
  517422
  519261
  519933
  520129
  520355
  520950
  522387
  522434
  525113
  526502
  528262
  528306
  528661
  528682
  529200
  537241
  540071
  540612
  542218
  547764
  548984
  550764
  555391
  557537
  562802
  562853
  565038
  565783
  571007
  571137
  572771
  575715
  575889
  588454
  592046
  600114
  610958
  623615
  624832
  631110
  650992
  659035
  674047
  683083
  728452
]

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 (399717, 405050, 413964, 421797, 434859, 445327, 448781, 449717, 451311, 452297, 452327, 461141, 465248, 471319, 473798, 479004, 486580, 489239, 498404, 499636, 503659, 506622, 507195, 507666, 508569, 514772, 515249, 515605, 516632, 517422, 519261, 519933, 520129, 520355, 520950, 522387, 522434, 525113, 526502, 528262, 528306, 528661, 528682, 529200, 537241, 540071, 540612, 542218, 547764, 548984, 550764, 555391, 557537, 562802, 562853, 565038, 565783, 571007, 571137, 572771, 575715, 575889, 588454, 592046, 600114, 610958, 623615, 624832, 631110, 650992, 659035, 674047, 683083, 728452);

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
  399717
  405050
  413964
  421797
  434859
  445327
  448781
  449717
  451311
  452297
  452327
  461141
  465248
  471319
  473798
  479004
  486580
  489239
  498404
  499636
  503659
  506622
  507195
  507666
  508569
  514772
  515249
  515605
  516632
  517422
  519261
  519933
  520129
  520355
  520950
  522387
  522434
  525113
  526502
  528262
  528306
  528661
  528682
  529200
  537241
  540071
  540612
  542218
  547764
  548984
  550764
  555391
  557537
  562802
  562853
  565038
  565783
  571007
  571137
  572771
  575715
  575889
  588454
  592046
  600114
  610958
  623615
  624832
  631110
  650992
  659035
  674047
  683083
  728452
]

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 (399717, 405050, 413964, 421797, 434859, 445327, 448781, 449717, 451311, 452297, 452327, 461141, 465248, 471319, 473798, 479004, 486580, 489239, 498404, 499636, 503659, 506622, 507195, 507666, 508569, 514772, 515249, 515605, 516632, 517422, 519261, 519933, 520129, 520355, 520950, 522387, 522434, 525113, 526502, 528262, 528306, 528661, 528682, 529200, 537241, 540071, 540612, 542218, 547764, 548984, 550764, 555391, 557537, 562802, 562853, 565038, 565783, 571007, 571137, 572771, 575715, 575889, 588454, 592046, 600114, 610958, 623615, 624832, 631110, 650992, 659035, 674047, 683083, 728452);

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

[
  "too too"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'too too';

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

[
  "too too"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'too too';