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

[
  "filled pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'filled pussy' 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
  432154
  464660
  472751
  456573
  455039
  462849
  469678
  431372
  491363
  502775
  503122
  528293
  568053
  558338
  625556
  815313
  815748
  527868
  487346
  566217
  578410
  630115
  586534
  626527
  586792
  588321
  615774
  809477
  452679
  482168
  468611
  524750
  486147
  492599
  526813
  496784
  518216
  524751
  502795
  512159
  517417
  575841
  404693
  451861
  463392
  447614
  519179
  512528
  495795
  473900
  569179
  681025
  559560
  606704
  778359
  493164
  529100
  529243
  514897
  523558
  511184
  508487
  623306
  613489
  420218
  562487
  626881
  611310
  479020
  425998
  546741
  629950
  561704
  603102
  493163
  468065
  504912
]

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 (432154, 464660, 472751, 456573, 455039, 462849, 469678, 431372, 491363, 502775, 503122, 528293, 568053, 558338, 625556, 815313, 815748, 527868, 487346, 566217, 578410, 630115, 586534, 626527, 586792, 588321, 615774, 809477, 452679, 482168, 468611, 524750, 486147, 492599, 526813, 496784, 518216, 524751, 502795, 512159, 517417, 575841, 404693, 451861, 463392, 447614, 519179, 512528, 495795, 473900, 569179, 681025, 559560, 606704, 778359, 493164, 529100, 529243, 514897, 523558, 511184, 508487, 623306, 613489, 420218, 562487, 626881, 611310, 479020, 425998, 546741, 629950, 561704, 603102, 493163, 468065, 504912);

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
  404693
  420218
  425998
  431372
  432154
  447614
  451861
  452679
  455039
  456573
  462849
  463392
  464660
  468065
  468611
  469678
  472751
  473900
  479020
  482168
  486147
  487346
  491363
  492599
  493163
  493164
  495795
  496784
  502775
  502795
  503122
  504912
  508487
  511184
  512159
  512528
  514897
  517417
  518216
  519179
  523558
  524750
  524751
  526813
  527868
  528293
  529100
  529243
  546741
  558338
  559560
  561704
  562487
  566217
  568053
  569179
  575841
  578410
  586534
  586792
  588321
  603102
  606704
  611310
  613489
  615774
  623306
  625556
  626527
  626881
  629950
  630115
  681025
  778359
  809477
  815313
  815748
]

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 (404693, 420218, 425998, 431372, 432154, 447614, 451861, 452679, 455039, 456573, 462849, 463392, 464660, 468065, 468611, 469678, 472751, 473900, 479020, 482168, 486147, 487346, 491363, 492599, 493163, 493164, 495795, 496784, 502775, 502795, 503122, 504912, 508487, 511184, 512159, 512528, 514897, 517417, 518216, 519179, 523558, 524750, 524751, 526813, 527868, 528293, 529100, 529243, 546741, 558338, 559560, 561704, 562487, 566217, 568053, 569179, 575841, 578410, 586534, 586792, 588321, 603102, 606704, 611310, 613489, 615774, 623306, 625556, 626527, 626881, 629950, 630115, 681025, 778359, 809477, 815313, 815748);

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
  404693
  420218
  425998
  431372
  432154
  447614
  451861
  452679
  455039
  456573
  462849
  463392
  464660
  468065
  468611
  469678
  472751
  473900
  479020
  482168
  486147
  487346
  491363
  492599
  493163
  493164
  495795
  496784
  502775
  502795
  503122
  504912
  508487
  511184
  512159
  512528
  514897
  517417
  518216
  519179
  523558
  524750
  524751
  526813
  527868
  528293
  529100
  529243
  546741
  558338
  559560
  561704
  562487
  566217
  568053
  569179
  575841
  578410
  586534
  586792
  588321
  603102
  606704
  611310
  613489
  615774
  623306
  625556
  626527
  626881
  629950
  630115
  681025
  778359
  809477
  815313
  815748
]

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 (404693, 420218, 425998, 431372, 432154, 447614, 451861, 452679, 455039, 456573, 462849, 463392, 464660, 468065, 468611, 469678, 472751, 473900, 479020, 482168, 486147, 487346, 491363, 492599, 493163, 493164, 495795, 496784, 502775, 502795, 503122, 504912, 508487, 511184, 512159, 512528, 514897, 517417, 518216, 519179, 523558, 524750, 524751, 526813, 527868, 528293, 529100, 529243, 546741, 558338, 559560, 561704, 562487, 566217, 568053, 569179, 575841, 578410, 586534, 586792, 588321, 603102, 606704, 611310, 613489, 615774, 623306, 625556, 626527, 626881, 629950, 630115, 681025, 778359, 809477, 815313, 815748);

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

[
  "filled pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'filled pussy';

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

[
  "filled pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'filled pussy';