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

[
  "best handjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'best handjob' 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
  400872
  422445
  525754
  562541
  418068
  545538
  567051
  574047
  579377
  557213
  569994
  525277
  601231
  634484
  500226
  489461
  443909
  517337
  619885
  397918
  456852
  600010
  799175
  442857
  438851
  539288
  526718
  545444
  494196
  572711
  453046
  506358
  645918
  590514
  464794
  495361
  492528
  695181
  446431
  666895
  696213
  521431
  552997
  523892
  482338
  565650
  615823
  629849
  497203
  695123
  630546
  676428
  695127
  578596
  522681
  490005
  524587
  491034
  615907
  599144
  528811
  628073
  532419
  666850
  544992
  604061
  619516
  556045
  502468
  602928
  568062
  582258
  573212
  536400
]

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 (400872, 422445, 525754, 562541, 418068, 545538, 567051, 574047, 579377, 557213, 569994, 525277, 601231, 634484, 500226, 489461, 443909, 517337, 619885, 397918, 456852, 600010, 799175, 442857, 438851, 539288, 526718, 545444, 494196, 572711, 453046, 506358, 645918, 590514, 464794, 495361, 492528, 695181, 446431, 666895, 696213, 521431, 552997, 523892, 482338, 565650, 615823, 629849, 497203, 695123, 630546, 676428, 695127, 578596, 522681, 490005, 524587, 491034, 615907, 599144, 528811, 628073, 532419, 666850, 544992, 604061, 619516, 556045, 502468, 602928, 568062, 582258, 573212, 536400);

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
  397918
  400872
  418068
  422445
  438851
  442857
  443909
  446431
  453046
  456852
  464794
  482338
  489461
  490005
  491034
  492528
  494196
  495361
  497203
  500226
  502468
  506358
  517337
  521431
  522681
  523892
  524587
  525277
  525754
  526718
  528811
  532419
  536400
  539288
  544992
  545444
  545538
  552997
  556045
  557213
  562541
  565650
  567051
  568062
  569994
  572711
  573212
  574047
  578596
  579377
  582258
  590514
  599144
  600010
  601231
  602928
  604061
  615823
  615907
  619516
  619885
  628073
  629849
  630546
  634484
  645918
  666850
  666895
  676428
  695123
  695127
  695181
  696213
  799175
]

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 (397918, 400872, 418068, 422445, 438851, 442857, 443909, 446431, 453046, 456852, 464794, 482338, 489461, 490005, 491034, 492528, 494196, 495361, 497203, 500226, 502468, 506358, 517337, 521431, 522681, 523892, 524587, 525277, 525754, 526718, 528811, 532419, 536400, 539288, 544992, 545444, 545538, 552997, 556045, 557213, 562541, 565650, 567051, 568062, 569994, 572711, 573212, 574047, 578596, 579377, 582258, 590514, 599144, 600010, 601231, 602928, 604061, 615823, 615907, 619516, 619885, 628073, 629849, 630546, 634484, 645918, 666850, 666895, 676428, 695123, 695127, 695181, 696213, 799175);

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
  397918
  400872
  418068
  422445
  438851
  442857
  443909
  446431
  453046
  456852
  464794
  482338
  489461
  490005
  491034
  492528
  494196
  495361
  497203
  500226
  502468
  506358
  517337
  521431
  522681
  523892
  524587
  525277
  525754
  526718
  528811
  532419
  536400
  539288
  544992
  545444
  545538
  552997
  556045
  557213
  562541
  565650
  567051
  568062
  569994
  572711
  573212
  574047
  578596
  579377
  582258
  590514
  599144
  600010
  601231
  602928
  604061
  615823
  615907
  619516
  619885
  628073
  629849
  630546
  634484
  645918
  666850
  666895
  676428
  695123
  695127
  695181
  696213
  799175
]

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 (397918, 400872, 418068, 422445, 438851, 442857, 443909, 446431, 453046, 456852, 464794, 482338, 489461, 490005, 491034, 492528, 494196, 495361, 497203, 500226, 502468, 506358, 517337, 521431, 522681, 523892, 524587, 525277, 525754, 526718, 528811, 532419, 536400, 539288, 544992, 545444, 545538, 552997, 556045, 557213, 562541, 565650, 567051, 568062, 569994, 572711, 573212, 574047, 578596, 579377, 582258, 590514, 599144, 600010, 601231, 602928, 604061, 615823, 615907, 619516, 619885, 628073, 629849, 630546, 634484, 645918, 666850, 666895, 676428, 695123, 695127, 695181, 696213, 799175);

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

[
  "best дрочк член"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'best дрочк член';

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

[
  "best дрочк член"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'best дрочк член';