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

[
  "very mature"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very mature' 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
  464781
  416346
  433614
  511530
  520794
  549638
  663992
  523032
  177261
  399162
  584053
  477556
  518950
  522997
  515413
  475890
  564062
  573145
  562168
  547805
  550337
  674269
  559332
  611324
  593003
  587961
  601754
  743836
  736225
  796877
  390218
  483370
  514004
  471612
  495198
  589634
  406289
  518946
  559430
  565346
  714380
  591253
  610668
  590721
  748227
  378046
  460535
  438013
  513954
  508786
  525884
  523882
  526039
  457888
  517571
  496636
  487348
  544474
  648539
  550307
  590720
  590130
  697000
  439733
  467975
  516632
  427543
  516727
  517928
  439620
  521136
  469552
  630771
  407168
  553269
  614745
  533426
  698124
  606799
  511009
  585007
]

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 (464781, 416346, 433614, 511530, 520794, 549638, 663992, 523032, 177261, 399162, 584053, 477556, 518950, 522997, 515413, 475890, 564062, 573145, 562168, 547805, 550337, 674269, 559332, 611324, 593003, 587961, 601754, 743836, 736225, 796877, 390218, 483370, 514004, 471612, 495198, 589634, 406289, 518946, 559430, 565346, 714380, 591253, 610668, 590721, 748227, 378046, 460535, 438013, 513954, 508786, 525884, 523882, 526039, 457888, 517571, 496636, 487348, 544474, 648539, 550307, 590720, 590130, 697000, 439733, 467975, 516632, 427543, 516727, 517928, 439620, 521136, 469552, 630771, 407168, 553269, 614745, 533426, 698124, 606799, 511009, 585007);

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
  177261
  378046
  390218
  399162
  406289
  407168
  416346
  427543
  433614
  438013
  439620
  439733
  457888
  460535
  464781
  467975
  469552
  471612
  475890
  477556
  483370
  487348
  495198
  496636
  508786
  511009
  511530
  513954
  514004
  515413
  516632
  516727
  517571
  517928
  518946
  518950
  520794
  521136
  522997
  523032
  523882
  525884
  526039
  533426
  544474
  547805
  549638
  550307
  550337
  553269
  559332
  559430
  562168
  564062
  565346
  573145
  584053
  585007
  587961
  589634
  590130
  590720
  590721
  591253
  593003
  601754
  606799
  610668
  611324
  614745
  630771
  648539
  663992
  674269
  697000
  698124
  714380
  736225
  743836
  748227
  796877
]

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 (177261, 378046, 390218, 399162, 406289, 407168, 416346, 427543, 433614, 438013, 439620, 439733, 457888, 460535, 464781, 467975, 469552, 471612, 475890, 477556, 483370, 487348, 495198, 496636, 508786, 511009, 511530, 513954, 514004, 515413, 516632, 516727, 517571, 517928, 518946, 518950, 520794, 521136, 522997, 523032, 523882, 525884, 526039, 533426, 544474, 547805, 549638, 550307, 550337, 553269, 559332, 559430, 562168, 564062, 565346, 573145, 584053, 585007, 587961, 589634, 590130, 590720, 590721, 591253, 593003, 601754, 606799, 610668, 611324, 614745, 630771, 648539, 663992, 674269, 697000, 698124, 714380, 736225, 743836, 748227, 796877);

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
  177261
  378046
  390218
  399162
  406289
  407168
  416346
  427543
  433614
  438013
  439620
  439733
  457888
  460535
  464781
  467975
  469552
  471612
  475890
  477556
  483370
  487348
  495198
  496636
  508786
  511009
  511530
  513954
  514004
  515413
  516632
  516727
  517571
  517928
  518946
  518950
  520794
  521136
  522997
  523032
  523882
  525884
  526039
  533426
  544474
  547805
  549638
  550307
  550337
  553269
  559332
  559430
  562168
  564062
  565346
  573145
  584053
  585007
  587961
  589634
  590130
  590720
  590721
  591253
  593003
  601754
  606799
  610668
  611324
  614745
  630771
  648539
  663992
  674269
  697000
  698124
  714380
  736225
  743836
  748227
  796877
]

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 (177261, 378046, 390218, 399162, 406289, 407168, 416346, 427543, 433614, 438013, 439620, 439733, 457888, 460535, 464781, 467975, 469552, 471612, 475890, 477556, 483370, 487348, 495198, 496636, 508786, 511009, 511530, 513954, 514004, 515413, 516632, 516727, 517571, 517928, 518946, 518950, 520794, 521136, 522997, 523032, 523882, 525884, 526039, 533426, 544474, 547805, 549638, 550307, 550337, 553269, 559332, 559430, 562168, 564062, 565346, 573145, 584053, 585007, 587961, 589634, 590130, 590720, 590721, 591253, 593003, 601754, 606799, 610668, 611324, 614745, 630771, 648539, 663992, 674269, 697000, 698124, 714380, 736225, 743836, 748227, 796877);

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

[
  "very mature"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'very mature';

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

[
  "very mature"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very mature';