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

[
  "skinny brunette milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny brunette milf' 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
  597204
  607049
  607707
  636295
  613177
  437831
  524897
  527669
  498030
  519087
  541215
  439819
  428126
  430827
  463768
  534372
  557985
  541848
  542568
  571213
  573800
  580270
  596901
  606217
  600218
  631179
  431749
  482088
  421907
  421839
  455912
  493122
  494778
  514294
  487703
  421287
  445416
  492106
  554386
  575194
  550100
  541774
  545605
  553272
  554790
  544686
  559183
  593150
  628336
  587651
  588244
  600349
  603743
  596168
  600257
  603364
  466963
  420635
  441004
  538803
  495022
  509100
  560511
  613487
  532755
  532672
  542195
  541924
  587220
  630531
  622778
  528435
  542199
  543419
  567416
  598865
  606697
  438896
  430018
  599940
  560230
  590878
]

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 (597204, 607049, 607707, 636295, 613177, 437831, 524897, 527669, 498030, 519087, 541215, 439819, 428126, 430827, 463768, 534372, 557985, 541848, 542568, 571213, 573800, 580270, 596901, 606217, 600218, 631179, 431749, 482088, 421907, 421839, 455912, 493122, 494778, 514294, 487703, 421287, 445416, 492106, 554386, 575194, 550100, 541774, 545605, 553272, 554790, 544686, 559183, 593150, 628336, 587651, 588244, 600349, 603743, 596168, 600257, 603364, 466963, 420635, 441004, 538803, 495022, 509100, 560511, 613487, 532755, 532672, 542195, 541924, 587220, 630531, 622778, 528435, 542199, 543419, 567416, 598865, 606697, 438896, 430018, 599940, 560230, 590878);

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
  420635
  421287
  421839
  421907
  428126
  430018
  430827
  431749
  437831
  438896
  439819
  441004
  445416
  455912
  463768
  466963
  482088
  487703
  492106
  493122
  494778
  495022
  498030
  509100
  514294
  519087
  524897
  527669
  528435
  532672
  532755
  534372
  538803
  541215
  541774
  541848
  541924
  542195
  542199
  542568
  543419
  544686
  545605
  550100
  553272
  554386
  554790
  557985
  559183
  560230
  560511
  567416
  571213
  573800
  575194
  580270
  587220
  587651
  588244
  590878
  593150
  596168
  596901
  597204
  598865
  599940
  600218
  600257
  600349
  603364
  603743
  606217
  606697
  607049
  607707
  613177
  613487
  622778
  628336
  630531
  631179
  636295
]

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 (420635, 421287, 421839, 421907, 428126, 430018, 430827, 431749, 437831, 438896, 439819, 441004, 445416, 455912, 463768, 466963, 482088, 487703, 492106, 493122, 494778, 495022, 498030, 509100, 514294, 519087, 524897, 527669, 528435, 532672, 532755, 534372, 538803, 541215, 541774, 541848, 541924, 542195, 542199, 542568, 543419, 544686, 545605, 550100, 553272, 554386, 554790, 557985, 559183, 560230, 560511, 567416, 571213, 573800, 575194, 580270, 587220, 587651, 588244, 590878, 593150, 596168, 596901, 597204, 598865, 599940, 600218, 600257, 600349, 603364, 603743, 606217, 606697, 607049, 607707, 613177, 613487, 622778, 628336, 630531, 631179, 636295);

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
  420635
  421287
  421839
  421907
  428126
  430018
  430827
  431749
  437831
  438896
  439819
  441004
  445416
  455912
  463768
  466963
  482088
  487703
  492106
  493122
  494778
  495022
  498030
  509100
  514294
  519087
  524897
  527669
  528435
  532672
  532755
  534372
  538803
  541215
  541774
  541848
  541924
  542195
  542199
  542568
  543419
  544686
  545605
  550100
  553272
  554386
  554790
  557985
  559183
  560230
  560511
  567416
  571213
  573800
  575194
  580270
  587220
  587651
  588244
  590878
  593150
  596168
  596901
  597204
  598865
  599940
  600218
  600257
  600349
  603364
  603743
  606217
  606697
  607049
  607707
  613177
  613487
  622778
  628336
  630531
  631179
  636295
]

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 (420635, 421287, 421839, 421907, 428126, 430018, 430827, 431749, 437831, 438896, 439819, 441004, 445416, 455912, 463768, 466963, 482088, 487703, 492106, 493122, 494778, 495022, 498030, 509100, 514294, 519087, 524897, 527669, 528435, 532672, 532755, 534372, 538803, 541215, 541774, 541848, 541924, 542195, 542199, 542568, 543419, 544686, 545605, 550100, 553272, 554386, 554790, 557985, 559183, 560230, 560511, 567416, 571213, 573800, 575194, 580270, 587220, 587651, 588244, 590878, 593150, 596168, 596901, 597204, 598865, 599940, 600218, 600257, 600349, 603364, 603743, 606217, 606697, 607049, 607707, 613177, 613487, 622778, 628336, 630531, 631179, 636295);

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

[
  "худые черноволосая milf"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'худые черноволосая milf';

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

[
  "худые черноволосая milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'худые черноволосая milf';