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

[
  "kissing hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kissing hard' 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
  392605
  447496
  482925
  502736
  504261
  511773
  522499
  525210
  498671
  511599
  407809
  435659
  816553
  814736
  474835
  454886
  532903
  550648
  570052
  557951
  564668
  569886
  570165
  544418
  705099
  682839
  601088
  588899
  604083
  595375
  618612
  624990
  722918
  447235
  450797
  450800
  481820
  521370
  513326
  523309
  509931
  443420
  518328
  512919
  574407
  651561
  567162
  518264
  489432
  486587
  507742
  396975
  512980
  508468
  557540
  570535
  578139
  569533
  575815
  614431
  633744
  634765
  790218
  702061
  393724
  516659
  505107
  506259
  529100
  506827
  533802
  527676
  536689
  560195
  763136
  517577
  540800
  491784
  537199
  572077
  485147
  560227
  428202
  500971
  559712
  427981
  561480
  486835
]

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 (392605, 447496, 482925, 502736, 504261, 511773, 522499, 525210, 498671, 511599, 407809, 435659, 816553, 814736, 474835, 454886, 532903, 550648, 570052, 557951, 564668, 569886, 570165, 544418, 705099, 682839, 601088, 588899, 604083, 595375, 618612, 624990, 722918, 447235, 450797, 450800, 481820, 521370, 513326, 523309, 509931, 443420, 518328, 512919, 574407, 651561, 567162, 518264, 489432, 486587, 507742, 396975, 512980, 508468, 557540, 570535, 578139, 569533, 575815, 614431, 633744, 634765, 790218, 702061, 393724, 516659, 505107, 506259, 529100, 506827, 533802, 527676, 536689, 560195, 763136, 517577, 540800, 491784, 537199, 572077, 485147, 560227, 428202, 500971, 559712, 427981, 561480, 486835);

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
  392605
  393724
  396975
  407809
  427981
  428202
  435659
  443420
  447235
  447496
  450797
  450800
  454886
  474835
  481820
  482925
  485147
  486587
  486835
  489432
  491784
  498671
  500971
  502736
  504261
  505107
  506259
  506827
  507742
  508468
  509931
  511599
  511773
  512919
  512980
  513326
  516659
  517577
  518264
  518328
  521370
  522499
  523309
  525210
  527676
  529100
  532903
  533802
  536689
  537199
  540800
  544418
  550648
  557540
  557951
  559712
  560195
  560227
  561480
  564668
  567162
  569533
  569886
  570052
  570165
  570535
  572077
  574407
  575815
  578139
  588899
  595375
  601088
  604083
  614431
  618612
  624990
  633744
  634765
  651561
  682839
  702061
  705099
  722918
  763136
  790218
  814736
  816553
]

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 (392605, 393724, 396975, 407809, 427981, 428202, 435659, 443420, 447235, 447496, 450797, 450800, 454886, 474835, 481820, 482925, 485147, 486587, 486835, 489432, 491784, 498671, 500971, 502736, 504261, 505107, 506259, 506827, 507742, 508468, 509931, 511599, 511773, 512919, 512980, 513326, 516659, 517577, 518264, 518328, 521370, 522499, 523309, 525210, 527676, 529100, 532903, 533802, 536689, 537199, 540800, 544418, 550648, 557540, 557951, 559712, 560195, 560227, 561480, 564668, 567162, 569533, 569886, 570052, 570165, 570535, 572077, 574407, 575815, 578139, 588899, 595375, 601088, 604083, 614431, 618612, 624990, 633744, 634765, 651561, 682839, 702061, 705099, 722918, 763136, 790218, 814736, 816553);

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
  392605
  393724
  396975
  407809
  427981
  428202
  435659
  443420
  447235
  447496
  450797
  450800
  454886
  474835
  481820
  482925
  485147
  486587
  486835
  489432
  491784
  498671
  500971
  502736
  504261
  505107
  506259
  506827
  507742
  508468
  509931
  511599
  511773
  512919
  512980
  513326
  516659
  517577
  518264
  518328
  521370
  522499
  523309
  525210
  527676
  529100
  532903
  533802
  536689
  537199
  540800
  544418
  550648
  557540
  557951
  559712
  560195
  560227
  561480
  564668
  567162
  569533
  569886
  570052
  570165
  570535
  572077
  574407
  575815
  578139
  588899
  595375
  601088
  604083
  614431
  618612
  624990
  633744
  634765
  651561
  682839
  702061
  705099
  722918
  763136
  790218
  814736
  816553
]

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 (392605, 393724, 396975, 407809, 427981, 428202, 435659, 443420, 447235, 447496, 450797, 450800, 454886, 474835, 481820, 482925, 485147, 486587, 486835, 489432, 491784, 498671, 500971, 502736, 504261, 505107, 506259, 506827, 507742, 508468, 509931, 511599, 511773, 512919, 512980, 513326, 516659, 517577, 518264, 518328, 521370, 522499, 523309, 525210, 527676, 529100, 532903, 533802, 536689, 537199, 540800, 544418, 550648, 557540, 557951, 559712, 560195, 560227, 561480, 564668, 567162, 569533, 569886, 570052, 570165, 570535, 572077, 574407, 575815, 578139, 588899, 595375, 601088, 604083, 614431, 618612, 624990, 633744, 634765, 651561, 682839, 702061, 705099, 722918, 763136, 790218, 814736, 816553);

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

[
  "kissing hard"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'kissing hard';

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

[
  "kissing hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kissing hard';