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

[
  "hairy ebony"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy ebony' 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
  635949
  790034
  789494
  792616
  396665
  435728
  401463
  395895
  30636
  426220
  426295
  815330
  472831
  464922
  495418
  513660
  576722
  647637
  624224
  414133
  588285
  406935
  425834
  822673
  520728
  523358
  531405
  531440
  650385
  689634
  647885
  571458
  592437
  585377
  423650
  452058
  541606
  533802
  486179
  589524
  807023
  416364
  430709
  417482
  731371
  449115
  487746
  520729
  545305
  560219
  565168
  639824
  601669
  420291
  600979
  471380
  541594
  528304
  429999
  437868
  477210
  430404
  466499
  601133
  391715
  462911
  536853
  458010
  467960
  512806
  434601
  460208
  566710
  486018
  574371
  603376
]

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 (635949, 790034, 789494, 792616, 396665, 435728, 401463, 395895, 30636, 426220, 426295, 815330, 472831, 464922, 495418, 513660, 576722, 647637, 624224, 414133, 588285, 406935, 425834, 822673, 520728, 523358, 531405, 531440, 650385, 689634, 647885, 571458, 592437, 585377, 423650, 452058, 541606, 533802, 486179, 589524, 807023, 416364, 430709, 417482, 731371, 449115, 487746, 520729, 545305, 560219, 565168, 639824, 601669, 420291, 600979, 471380, 541594, 528304, 429999, 437868, 477210, 430404, 466499, 601133, 391715, 462911, 536853, 458010, 467960, 512806, 434601, 460208, 566710, 486018, 574371, 603376);

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
  30636
  391715
  395895
  396665
  401463
  406935
  414133
  416364
  417482
  420291
  423650
  425834
  426220
  426295
  429999
  430404
  430709
  434601
  435728
  437868
  449115
  452058
  458010
  460208
  462911
  464922
  466499
  467960
  471380
  472831
  477210
  486018
  486179
  487746
  495418
  512806
  513660
  520728
  520729
  523358
  528304
  531405
  531440
  533802
  536853
  541594
  541606
  545305
  560219
  565168
  566710
  571458
  574371
  576722
  585377
  588285
  589524
  592437
  600979
  601133
  601669
  603376
  624224
  635949
  639824
  647637
  647885
  650385
  689634
  731371
  789494
  790034
  792616
  807023
  815330
  822673
]

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 (30636, 391715, 395895, 396665, 401463, 406935, 414133, 416364, 417482, 420291, 423650, 425834, 426220, 426295, 429999, 430404, 430709, 434601, 435728, 437868, 449115, 452058, 458010, 460208, 462911, 464922, 466499, 467960, 471380, 472831, 477210, 486018, 486179, 487746, 495418, 512806, 513660, 520728, 520729, 523358, 528304, 531405, 531440, 533802, 536853, 541594, 541606, 545305, 560219, 565168, 566710, 571458, 574371, 576722, 585377, 588285, 589524, 592437, 600979, 601133, 601669, 603376, 624224, 635949, 639824, 647637, 647885, 650385, 689634, 731371, 789494, 790034, 792616, 807023, 815330, 822673);

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
  30636
  391715
  395895
  396665
  401463
  406935
  414133
  416364
  417482
  420291
  423650
  425834
  426220
  426295
  429999
  430404
  430709
  434601
  435728
  437868
  449115
  452058
  458010
  460208
  462911
  464922
  466499
  467960
  471380
  472831
  477210
  486018
  486179
  487746
  495418
  512806
  513660
  520728
  520729
  523358
  528304
  531405
  531440
  533802
  536853
  541594
  541606
  545305
  560219
  565168
  566710
  571458
  574371
  576722
  585377
  588285
  589524
  592437
  600979
  601133
  601669
  603376
  624224
  635949
  639824
  647637
  647885
  650385
  689634
  731371
  789494
  790034
  792616
  807023
  815330
  822673
]

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 (30636, 391715, 395895, 396665, 401463, 406935, 414133, 416364, 417482, 420291, 423650, 425834, 426220, 426295, 429999, 430404, 430709, 434601, 435728, 437868, 449115, 452058, 458010, 460208, 462911, 464922, 466499, 467960, 471380, 472831, 477210, 486018, 486179, 487746, 495418, 512806, 513660, 520728, 520729, 523358, 528304, 531405, 531440, 533802, 536853, 541594, 541606, 545305, 560219, 565168, 566710, 571458, 574371, 576722, 585377, 588285, 589524, 592437, 600979, 601133, 601669, 603376, 624224, 635949, 639824, 647637, 647885, 650385, 689634, 731371, 789494, 790034, 792616, 807023, 815330, 822673);

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

[
  "волосатая чернокожая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'волосатая чернокожая';

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

[
  "волосатая чернокожая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'волосатая чернокожая';