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

[
  "cum covered"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum covered' 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
  449415
  459765
  486549
  492930
  529939
  537363
  503850
  557706
  571617
  576370
  686596
  589258
  775351
  786115
  733480
  728497
  641925
  808229
  809001
  813501
  481386
  497232
  485800
  503002
  494822
  423500
  452545
  512739
  528563
  526755
  546051
  543353
  561360
  561614
  580160
  584555
  695117
  589174
  791943
  730270
  601690
  644047
  708741
  455663
  444279
  446560
  527965
  500446
  488474
  519878
  529558
  418394
  477831
  498391
  528412
  559905
  569256
  599567
  417497
  447828
  418607
  424387
  434670
  452593
  518291
  542533
  667975
  456706
  519027
  601312
  452286
  427950
  416426
  486868
  461375
  607537
  550829
  675012
  689013
  605840
  613394
]

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 (449415, 459765, 486549, 492930, 529939, 537363, 503850, 557706, 571617, 576370, 686596, 589258, 775351, 786115, 733480, 728497, 641925, 808229, 809001, 813501, 481386, 497232, 485800, 503002, 494822, 423500, 452545, 512739, 528563, 526755, 546051, 543353, 561360, 561614, 580160, 584555, 695117, 589174, 791943, 730270, 601690, 644047, 708741, 455663, 444279, 446560, 527965, 500446, 488474, 519878, 529558, 418394, 477831, 498391, 528412, 559905, 569256, 599567, 417497, 447828, 418607, 424387, 434670, 452593, 518291, 542533, 667975, 456706, 519027, 601312, 452286, 427950, 416426, 486868, 461375, 607537, 550829, 675012, 689013, 605840, 613394);

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
  416426
  417497
  418394
  418607
  423500
  424387
  427950
  434670
  444279
  446560
  447828
  449415
  452286
  452545
  452593
  455663
  456706
  459765
  461375
  477831
  481386
  485800
  486549
  486868
  488474
  492930
  494822
  497232
  498391
  500446
  503002
  503850
  512739
  518291
  519027
  519878
  526755
  527965
  528412
  528563
  529558
  529939
  537363
  542533
  543353
  546051
  550829
  557706
  559905
  561360
  561614
  569256
  571617
  576370
  580160
  584555
  589174
  589258
  599567
  601312
  601690
  605840
  607537
  613394
  641925
  644047
  667975
  675012
  686596
  689013
  695117
  708741
  728497
  730270
  733480
  775351
  786115
  791943
  808229
  809001
  813501
]

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 (416426, 417497, 418394, 418607, 423500, 424387, 427950, 434670, 444279, 446560, 447828, 449415, 452286, 452545, 452593, 455663, 456706, 459765, 461375, 477831, 481386, 485800, 486549, 486868, 488474, 492930, 494822, 497232, 498391, 500446, 503002, 503850, 512739, 518291, 519027, 519878, 526755, 527965, 528412, 528563, 529558, 529939, 537363, 542533, 543353, 546051, 550829, 557706, 559905, 561360, 561614, 569256, 571617, 576370, 580160, 584555, 589174, 589258, 599567, 601312, 601690, 605840, 607537, 613394, 641925, 644047, 667975, 675012, 686596, 689013, 695117, 708741, 728497, 730270, 733480, 775351, 786115, 791943, 808229, 809001, 813501);

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
  416426
  417497
  418394
  418607
  423500
  424387
  427950
  434670
  444279
  446560
  447828
  449415
  452286
  452545
  452593
  455663
  456706
  459765
  461375
  477831
  481386
  485800
  486549
  486868
  488474
  492930
  494822
  497232
  498391
  500446
  503002
  503850
  512739
  518291
  519027
  519878
  526755
  527965
  528412
  528563
  529558
  529939
  537363
  542533
  543353
  546051
  550829
  557706
  559905
  561360
  561614
  569256
  571617
  576370
  580160
  584555
  589174
  589258
  599567
  601312
  601690
  605840
  607537
  613394
  641925
  644047
  667975
  675012
  686596
  689013
  695117
  708741
  728497
  730270
  733480
  775351
  786115
  791943
  808229
  809001
  813501
]

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 (416426, 417497, 418394, 418607, 423500, 424387, 427950, 434670, 444279, 446560, 447828, 449415, 452286, 452545, 452593, 455663, 456706, 459765, 461375, 477831, 481386, 485800, 486549, 486868, 488474, 492930, 494822, 497232, 498391, 500446, 503002, 503850, 512739, 518291, 519027, 519878, 526755, 527965, 528412, 528563, 529558, 529939, 537363, 542533, 543353, 546051, 550829, 557706, 559905, 561360, 561614, 569256, 571617, 576370, 580160, 584555, 589174, 589258, 599567, 601312, 601690, 605840, 607537, 613394, 641925, 644047, 667975, 675012, 686596, 689013, 695117, 708741, 728497, 730270, 733480, 775351, 786115, 791943, 808229, 809001, 813501);

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

[
  "cum covered"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cum covered';

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

[
  "cum covered"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum covered';