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 old mature"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny old mature' 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
  421287
  434192
  424746
  432751
  445416
  492106
  532129
  533426
  510286
  540437
  497404
  518960
  499791
  559050
  548549
  550615
  560197
  542188
  562879
  559183
  582624
  609953
  585721
  588244
  631968
  587901
  597963
  601856
  604161
  609140
  603364
  735778
  416959
  428022
  403939
  424780
  487717
  495022
  520445
  565783
  624226
  487703
  492607
  541643
  576717
  559392
  543772
  559178
  561907
  607374
  587220
  520803
  541650
  484017
  490204
  528435
  559233
  499882
  567416
  598865
  599988
  602945
  438896
  430018
  521159
  545480
  560230
  580215
  665328
  613487
  590878
  541611
  527967
]

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 (421287, 434192, 424746, 432751, 445416, 492106, 532129, 533426, 510286, 540437, 497404, 518960, 499791, 559050, 548549, 550615, 560197, 542188, 562879, 559183, 582624, 609953, 585721, 588244, 631968, 587901, 597963, 601856, 604161, 609140, 603364, 735778, 416959, 428022, 403939, 424780, 487717, 495022, 520445, 565783, 624226, 487703, 492607, 541643, 576717, 559392, 543772, 559178, 561907, 607374, 587220, 520803, 541650, 484017, 490204, 528435, 559233, 499882, 567416, 598865, 599988, 602945, 438896, 430018, 521159, 545480, 560230, 580215, 665328, 613487, 590878, 541611, 527967);

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
  403939
  416959
  421287
  424746
  424780
  428022
  430018
  432751
  434192
  438896
  445416
  484017
  487703
  487717
  490204
  492106
  492607
  495022
  497404
  499791
  499882
  510286
  518960
  520445
  520803
  521159
  527967
  528435
  532129
  533426
  540437
  541611
  541643
  541650
  542188
  543772
  545480
  548549
  550615
  559050
  559178
  559183
  559233
  559392
  560197
  560230
  561907
  562879
  565783
  567416
  576717
  580215
  582624
  585721
  587220
  587901
  588244
  590878
  597963
  598865
  599988
  601856
  602945
  603364
  604161
  607374
  609140
  609953
  613487
  624226
  631968
  665328
  735778
]

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 (403939, 416959, 421287, 424746, 424780, 428022, 430018, 432751, 434192, 438896, 445416, 484017, 487703, 487717, 490204, 492106, 492607, 495022, 497404, 499791, 499882, 510286, 518960, 520445, 520803, 521159, 527967, 528435, 532129, 533426, 540437, 541611, 541643, 541650, 542188, 543772, 545480, 548549, 550615, 559050, 559178, 559183, 559233, 559392, 560197, 560230, 561907, 562879, 565783, 567416, 576717, 580215, 582624, 585721, 587220, 587901, 588244, 590878, 597963, 598865, 599988, 601856, 602945, 603364, 604161, 607374, 609140, 609953, 613487, 624226, 631968, 665328, 735778);

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
  403939
  416959
  421287
  424746
  424780
  428022
  430018
  432751
  434192
  438896
  445416
  484017
  487703
  487717
  490204
  492106
  492607
  495022
  497404
  499791
  499882
  510286
  518960
  520445
  520803
  521159
  527967
  528435
  532129
  533426
  540437
  541611
  541643
  541650
  542188
  543772
  545480
  548549
  550615
  559050
  559178
  559183
  559233
  559392
  560197
  560230
  561907
  562879
  565783
  567416
  576717
  580215
  582624
  585721
  587220
  587901
  588244
  590878
  597963
  598865
  599988
  601856
  602945
  603364
  604161
  607374
  609140
  609953
  613487
  624226
  631968
  665328
  735778
]

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 (403939, 416959, 421287, 424746, 424780, 428022, 430018, 432751, 434192, 438896, 445416, 484017, 487703, 487717, 490204, 492106, 492607, 495022, 497404, 499791, 499882, 510286, 518960, 520445, 520803, 521159, 527967, 528435, 532129, 533426, 540437, 541611, 541643, 541650, 542188, 543772, 545480, 548549, 550615, 559050, 559178, 559183, 559233, 559392, 560197, 560230, 561907, 562879, 565783, 567416, 576717, 580215, 582624, 585721, 587220, 587901, 588244, 590878, 597963, 598865, 599988, 601856, 602945, 603364, 604161, 607374, 609140, 609953, 613487, 624226, 631968, 665328, 735778);

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

[
  "худые old mature"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'худые old mature';

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

[
  "худые old mature"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'худые old mature';