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

[
  "old cum in"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'old cum in' 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
  469604
  441022
  416998
  470100
  524872
  492455
  527142
  502277
  430601
  428531
  814903
  474830
  524850
  532738
  512539
  523021
  535346
  477020
  581401
  582480
  655471
  668525
  683508
  647830
  647952
  592034
  621463
  630524
  634153
  590930
  628396
  637729
  628397
  633732
  414315
  470074
  504098
  524198
  515896
  523171
  524878
  530690
  536676
  524860
  532747
  537184
  516885
  562068
  564407
  696213
  663537
  573800
  622398
  604051
  609906
  488308
  502279
  539203
  537210
  537212
  524853
  483627
  545409
  561704
  707391
  695127
  559712
  580669
  603878
  494037
  516904
  530762
  550436
  545418
  559178
  567148
  624846
  624847
  628333
  492256
  438896
  560511
]

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 (469604, 441022, 416998, 470100, 524872, 492455, 527142, 502277, 430601, 428531, 814903, 474830, 524850, 532738, 512539, 523021, 535346, 477020, 581401, 582480, 655471, 668525, 683508, 647830, 647952, 592034, 621463, 630524, 634153, 590930, 628396, 637729, 628397, 633732, 414315, 470074, 504098, 524198, 515896, 523171, 524878, 530690, 536676, 524860, 532747, 537184, 516885, 562068, 564407, 696213, 663537, 573800, 622398, 604051, 609906, 488308, 502279, 539203, 537210, 537212, 524853, 483627, 545409, 561704, 707391, 695127, 559712, 580669, 603878, 494037, 516904, 530762, 550436, 545418, 559178, 567148, 624846, 624847, 628333, 492256, 438896, 560511);

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
  414315
  416998
  428531
  430601
  438896
  441022
  469604
  470074
  470100
  474830
  477020
  483627
  488308
  492256
  492455
  494037
  502277
  502279
  504098
  512539
  515896
  516885
  516904
  523021
  523171
  524198
  524850
  524853
  524860
  524872
  524878
  527142
  530690
  530762
  532738
  532747
  535346
  536676
  537184
  537210
  537212
  539203
  545409
  545418
  550436
  559178
  559712
  560511
  561704
  562068
  564407
  567148
  573800
  580669
  581401
  582480
  590930
  592034
  603878
  604051
  609906
  621463
  622398
  624846
  624847
  628333
  628396
  628397
  630524
  633732
  634153
  637729
  647830
  647952
  655471
  663537
  668525
  683508
  695127
  696213
  707391
  814903
]

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 (414315, 416998, 428531, 430601, 438896, 441022, 469604, 470074, 470100, 474830, 477020, 483627, 488308, 492256, 492455, 494037, 502277, 502279, 504098, 512539, 515896, 516885, 516904, 523021, 523171, 524198, 524850, 524853, 524860, 524872, 524878, 527142, 530690, 530762, 532738, 532747, 535346, 536676, 537184, 537210, 537212, 539203, 545409, 545418, 550436, 559178, 559712, 560511, 561704, 562068, 564407, 567148, 573800, 580669, 581401, 582480, 590930, 592034, 603878, 604051, 609906, 621463, 622398, 624846, 624847, 628333, 628396, 628397, 630524, 633732, 634153, 637729, 647830, 647952, 655471, 663537, 668525, 683508, 695127, 696213, 707391, 814903);

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
  414315
  416998
  428531
  430601
  438896
  441022
  469604
  470074
  470100
  474830
  477020
  483627
  488308
  492256
  492455
  494037
  502277
  502279
  504098
  512539
  515896
  516885
  516904
  523021
  523171
  524198
  524850
  524853
  524860
  524872
  524878
  527142
  530690
  530762
  532738
  532747
  535346
  536676
  537184
  537210
  537212
  539203
  545409
  545418
  550436
  559178
  559712
  560511
  561704
  562068
  564407
  567148
  573800
  580669
  581401
  582480
  590930
  592034
  603878
  604051
  609906
  621463
  622398
  624846
  624847
  628333
  628396
  628397
  630524
  633732
  634153
  637729
  647830
  647952
  655471
  663537
  668525
  683508
  695127
  696213
  707391
  814903
]

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 (414315, 416998, 428531, 430601, 438896, 441022, 469604, 470074, 470100, 474830, 477020, 483627, 488308, 492256, 492455, 494037, 502277, 502279, 504098, 512539, 515896, 516885, 516904, 523021, 523171, 524198, 524850, 524853, 524860, 524872, 524878, 527142, 530690, 530762, 532738, 532747, 535346, 536676, 537184, 537210, 537212, 539203, 545409, 545418, 550436, 559178, 559712, 560511, 561704, 562068, 564407, 567148, 573800, 580669, 581401, 582480, 590930, 592034, 603878, 604051, 609906, 621463, 622398, 624846, 624847, 628333, 628396, 628397, 630524, 633732, 634153, 637729, 647830, 647952, 655471, 663537, 668525, 683508, 695127, 696213, 707391, 814903);

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

[
  "old cum"
]

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

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

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

[
  "old cum"
]

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

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