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

[
  "romantic homemade"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'romantic homemade' 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
  484118
  511441
  469819
  515966
  802818
  432266
  438356
  490331
  521622
  499604
  521364
  550482
  595731
  459061
  558582
  790841
  459995
  518356
  490009
  584812
  541294
  561913
  615318
  800884
  412110
  461654
  534163
  466759
  509835
  804054
  452767
  462414
  487334
  489105
  507293
  513396
  565586
  624838
  628711
  416905
  442146
  520501
  525924
  549679
  456550
  479592
  425337
  526579
  499667
  441237
  520921
  511939
  521377
  584480
  470205
  439526
  484119
  482921
  509543
  624142
  460807
  585711
  458702
  587751
  599048
  473537
  529168
  455846
  527387
  416422
  492333
  458905
  498056
  506966
  483208
  562397
  547525
  607797
  569065
  483607
]

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 (484118, 511441, 469819, 515966, 802818, 432266, 438356, 490331, 521622, 499604, 521364, 550482, 595731, 459061, 558582, 790841, 459995, 518356, 490009, 584812, 541294, 561913, 615318, 800884, 412110, 461654, 534163, 466759, 509835, 804054, 452767, 462414, 487334, 489105, 507293, 513396, 565586, 624838, 628711, 416905, 442146, 520501, 525924, 549679, 456550, 479592, 425337, 526579, 499667, 441237, 520921, 511939, 521377, 584480, 470205, 439526, 484119, 482921, 509543, 624142, 460807, 585711, 458702, 587751, 599048, 473537, 529168, 455846, 527387, 416422, 492333, 458905, 498056, 506966, 483208, 562397, 547525, 607797, 569065, 483607);

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
  412110
  416422
  416905
  425337
  432266
  438356
  439526
  441237
  442146
  452767
  455846
  456550
  458702
  458905
  459061
  459995
  460807
  461654
  462414
  466759
  469819
  470205
  473537
  479592
  482921
  483208
  483607
  484118
  484119
  487334
  489105
  490009
  490331
  492333
  498056
  499604
  499667
  506966
  507293
  509543
  509835
  511441
  511939
  513396
  515966
  518356
  520501
  520921
  521364
  521377
  521622
  525924
  526579
  527387
  529168
  534163
  541294
  547525
  549679
  550482
  558582
  561913
  562397
  565586
  569065
  584480
  584812
  585711
  587751
  595731
  599048
  607797
  615318
  624142
  624838
  628711
  790841
  800884
  802818
  804054
]

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 (412110, 416422, 416905, 425337, 432266, 438356, 439526, 441237, 442146, 452767, 455846, 456550, 458702, 458905, 459061, 459995, 460807, 461654, 462414, 466759, 469819, 470205, 473537, 479592, 482921, 483208, 483607, 484118, 484119, 487334, 489105, 490009, 490331, 492333, 498056, 499604, 499667, 506966, 507293, 509543, 509835, 511441, 511939, 513396, 515966, 518356, 520501, 520921, 521364, 521377, 521622, 525924, 526579, 527387, 529168, 534163, 541294, 547525, 549679, 550482, 558582, 561913, 562397, 565586, 569065, 584480, 584812, 585711, 587751, 595731, 599048, 607797, 615318, 624142, 624838, 628711, 790841, 800884, 802818, 804054);

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
  412110
  416422
  416905
  425337
  432266
  438356
  439526
  441237
  442146
  452767
  455846
  456550
  458702
  458905
  459061
  459995
  460807
  461654
  462414
  466759
  469819
  470205
  473537
  479592
  482921
  483208
  483607
  484118
  484119
  487334
  489105
  490009
  490331
  492333
  498056
  499604
  499667
  506966
  507293
  509543
  509835
  511441
  511939
  513396
  515966
  518356
  520501
  520921
  521364
  521377
  521622
  525924
  526579
  527387
  529168
  534163
  541294
  547525
  549679
  550482
  558582
  561913
  562397
  565586
  569065
  584480
  584812
  585711
  587751
  595731
  599048
  607797
  615318
  624142
  624838
  628711
  790841
  800884
  802818
  804054
]

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 (412110, 416422, 416905, 425337, 432266, 438356, 439526, 441237, 442146, 452767, 455846, 456550, 458702, 458905, 459061, 459995, 460807, 461654, 462414, 466759, 469819, 470205, 473537, 479592, 482921, 483208, 483607, 484118, 484119, 487334, 489105, 490009, 490331, 492333, 498056, 499604, 499667, 506966, 507293, 509543, 509835, 511441, 511939, 513396, 515966, 518356, 520501, 520921, 521364, 521377, 521622, 525924, 526579, 527387, 529168, 534163, 541294, 547525, 549679, 550482, 558582, 561913, 562397, 565586, 569065, 584480, 584812, 585711, 587751, 595731, 599048, 607797, 615318, 624142, 624838, 628711, 790841, 800884, 802818, 804054);

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

[
  "romantic домашн любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'romantic домашн любительск';

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

[
  "romantic домашн любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'romantic домашн любительск';