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

[
  "vagina closeup"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'vagina closeup' 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
  446181
  436937
  486929
  526550
  573270
  567071
  583866
  516950
  485301
  485750
  567072
  733274
  796862
  453933
  460463
  452942
  509437
  610958
  524639
  528407
  547805
  715282
  605277
  479128
  434365
  499551
  489319
  444921
  533390
  593695
  431731
  383599
  450939
  583609
  576394
  581210
  624168
  604225
  424197
  426096
  434335
  534674
  528474
  479598
  456653
  473679
  457062
  520049
  524991
  490132
  624166
  467893
  82710
  566955
  575169
  415050
  536371
  630919
  437610
  444570
  453135
  456329
  501717
  508140
  524684
  524944
  596240
  593656
  491286
  448632
  445026
  424530
  623150
  564985
]

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 (446181, 436937, 486929, 526550, 573270, 567071, 583866, 516950, 485301, 485750, 567072, 733274, 796862, 453933, 460463, 452942, 509437, 610958, 524639, 528407, 547805, 715282, 605277, 479128, 434365, 499551, 489319, 444921, 533390, 593695, 431731, 383599, 450939, 583609, 576394, 581210, 624168, 604225, 424197, 426096, 434335, 534674, 528474, 479598, 456653, 473679, 457062, 520049, 524991, 490132, 624166, 467893, 82710, 566955, 575169, 415050, 536371, 630919, 437610, 444570, 453135, 456329, 501717, 508140, 524684, 524944, 596240, 593656, 491286, 448632, 445026, 424530, 623150, 564985);

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
  82710
  383599
  415050
  424197
  424530
  426096
  431731
  434335
  434365
  436937
  437610
  444570
  444921
  445026
  446181
  448632
  450939
  452942
  453135
  453933
  456329
  456653
  457062
  460463
  467893
  473679
  479128
  479598
  485301
  485750
  486929
  489319
  490132
  491286
  499551
  501717
  508140
  509437
  516950
  520049
  524639
  524684
  524944
  524991
  526550
  528407
  528474
  533390
  534674
  536371
  547805
  564985
  566955
  567071
  567072
  573270
  575169
  576394
  581210
  583609
  583866
  593656
  593695
  596240
  604225
  605277
  610958
  623150
  624166
  624168
  630919
  715282
  733274
  796862
]

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 (82710, 383599, 415050, 424197, 424530, 426096, 431731, 434335, 434365, 436937, 437610, 444570, 444921, 445026, 446181, 448632, 450939, 452942, 453135, 453933, 456329, 456653, 457062, 460463, 467893, 473679, 479128, 479598, 485301, 485750, 486929, 489319, 490132, 491286, 499551, 501717, 508140, 509437, 516950, 520049, 524639, 524684, 524944, 524991, 526550, 528407, 528474, 533390, 534674, 536371, 547805, 564985, 566955, 567071, 567072, 573270, 575169, 576394, 581210, 583609, 583866, 593656, 593695, 596240, 604225, 605277, 610958, 623150, 624166, 624168, 630919, 715282, 733274, 796862);

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
  82710
  383599
  415050
  424197
  424530
  426096
  431731
  434335
  434365
  436937
  437610
  444570
  444921
  445026
  446181
  448632
  450939
  452942
  453135
  453933
  456329
  456653
  457062
  460463
  467893
  473679
  479128
  479598
  485301
  485750
  486929
  489319
  490132
  491286
  499551
  501717
  508140
  509437
  516950
  520049
  524639
  524684
  524944
  524991
  526550
  528407
  528474
  533390
  534674
  536371
  547805
  564985
  566955
  567071
  567072
  573270
  575169
  576394
  581210
  583609
  583866
  593656
  593695
  596240
  604225
  605277
  610958
  623150
  624166
  624168
  630919
  715282
  733274
  796862
]

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 (82710, 383599, 415050, 424197, 424530, 426096, 431731, 434335, 434365, 436937, 437610, 444570, 444921, 445026, 446181, 448632, 450939, 452942, 453135, 453933, 456329, 456653, 457062, 460463, 467893, 473679, 479128, 479598, 485301, 485750, 486929, 489319, 490132, 491286, 499551, 501717, 508140, 509437, 516950, 520049, 524639, 524684, 524944, 524991, 526550, 528407, 528474, 533390, 534674, 536371, 547805, 564985, 566955, 567071, 567072, 573270, 575169, 576394, 581210, 583609, 583866, 593656, 593695, 596240, 604225, 605277, 610958, 623150, 624166, 624168, 630919, 715282, 733274, 796862);

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

[
  "вагин closeup"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'вагин closeup';

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

[
  "вагин closeup"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'вагин closeup';