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

[
  "cream"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cream' LIMIT 1;

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

[
  b"\x01’Ìï©opj«\x02ê¥q\x18o&"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0192CCEFA96F706AAB02EAA571186F26 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
  712534
  652644
  675703
  550884
  594503
  610039
  598871
  618066
  808625
  788576
  731279
  759892
  760859
  400943
  436689
  447800
  462656
  431960
  425773
  445424
  507131
  483172
  486418
  491329
  527168
  525796
  419871
  452568
  485997
  532783
  533741
  489023
  548733
  555989
  569201
  569229
  544867
  666523
  629748
  724229
  447741
  512285
  522832
  485134
  523150
  644962
  455986
  537905
  528499
  552643
  571809
  591997
  640614
  465345
  457841
  391943
  411681
  518467
  518212
  414357
  648825
  588877
  472524
  561970
  625770
  444795
  440971
  567667
  591959
  599249
  642016
  469649
  523780
  558472
]

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 (712534, 652644, 675703, 550884, 594503, 610039, 598871, 618066, 808625, 788576, 731279, 759892, 760859, 400943, 436689, 447800, 462656, 431960, 425773, 445424, 507131, 483172, 486418, 491329, 527168, 525796, 419871, 452568, 485997, 532783, 533741, 489023, 548733, 555989, 569201, 569229, 544867, 666523, 629748, 724229, 447741, 512285, 522832, 485134, 523150, 644962, 455986, 537905, 528499, 552643, 571809, 591997, 640614, 465345, 457841, 391943, 411681, 518467, 518212, 414357, 648825, 588877, 472524, 561970, 625770, 444795, 440971, 567667, 591959, 599249, 642016, 469649, 523780, 558472);

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
  391943
  400943
  411681
  414357
  419871
  425773
  431960
  436689
  440971
  444795
  445424
  447741
  447800
  452568
  455986
  457841
  462656
  465345
  469649
  472524
  483172
  485134
  485997
  486418
  489023
  491329
  507131
  512285
  518212
  518467
  522832
  523150
  523780
  525796
  527168
  528499
  532783
  533741
  537905
  544867
  548733
  550884
  552643
  555989
  558472
  561970
  567667
  569201
  569229
  571809
  588877
  591959
  591997
  594503
  598871
  599249
  610039
  618066
  625770
  629748
  640614
  642016
  644962
  648825
  652644
  666523
  675703
  712534
  724229
  731279
  759892
  760859
  788576
  808625
]

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 (391943, 400943, 411681, 414357, 419871, 425773, 431960, 436689, 440971, 444795, 445424, 447741, 447800, 452568, 455986, 457841, 462656, 465345, 469649, 472524, 483172, 485134, 485997, 486418, 489023, 491329, 507131, 512285, 518212, 518467, 522832, 523150, 523780, 525796, 527168, 528499, 532783, 533741, 537905, 544867, 548733, 550884, 552643, 555989, 558472, 561970, 567667, 569201, 569229, 571809, 588877, 591959, 591997, 594503, 598871, 599249, 610039, 618066, 625770, 629748, 640614, 642016, 644962, 648825, 652644, 666523, 675703, 712534, 724229, 731279, 759892, 760859, 788576, 808625);

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
  391943
  400943
  411681
  414357
  419871
  425773
  431960
  436689
  440971
  444795
  445424
  447741
  447800
  452568
  455986
  457841
  462656
  465345
  469649
  472524
  483172
  485134
  485997
  486418
  489023
  491329
  507131
  512285
  518212
  518467
  522832
  523150
  523780
  525796
  527168
  528499
  532783
  533741
  537905
  544867
  548733
  550884
  552643
  555989
  558472
  561970
  567667
  569201
  569229
  571809
  588877
  591959
  591997
  594503
  598871
  599249
  610039
  618066
  625770
  629748
  640614
  642016
  644962
  648825
  652644
  666523
  675703
  712534
  724229
  731279
  759892
  760859
  788576
  808625
]

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 (391943, 400943, 411681, 414357, 419871, 425773, 431960, 436689, 440971, 444795, 445424, 447741, 447800, 452568, 455986, 457841, 462656, 465345, 469649, 472524, 483172, 485134, 485997, 486418, 489023, 491329, 507131, 512285, 518212, 518467, 522832, 523150, 523780, 525796, 527168, 528499, 532783, 533741, 537905, 544867, 548733, 550884, 552643, 555989, 558472, 561970, 567667, 569201, 569229, 571809, 588877, 591959, 591997, 594503, 598871, 599249, 610039, 618066, 625770, 629748, 640614, 642016, 644962, 648825, 652644, 666523, 675703, 712534, 724229, 731279, 759892, 760859, 788576, 808625);

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

[
  "cream"
]

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

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

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

[
  "cream"
]

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

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