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

[
  "amateur threesome anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur threesome anal' 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
  827327
  541588
  398756
  609922
  643316
  596839
  522878
  503167
  791074
  593992
  472783
  543429
  640136
  727132
  520132
  669574
  616608
  485147
  593829
  453032
  597841
  464594
  100685
  549239
  559233
  544663
  454924
  506046
  484680
  482674
  512583
  466268
  780016
  482139
  575661
  556436
  668975
  773974
  510108
  776153
  457963
  451609
  470522
  714281
  565281
  528420
  603159
  577084
  558186
  584644
  567416
  768739
  807449
  630806
  800781
  785727
  417058
  462769
  578392
  553935
  785628
  520759
  616956
  462305
  571334
  443389
  625648
  499353
  451042
  529485
  434192
  521126
  524235
]

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 (827327, 541588, 398756, 609922, 643316, 596839, 522878, 503167, 791074, 593992, 472783, 543429, 640136, 727132, 520132, 669574, 616608, 485147, 593829, 453032, 597841, 464594, 100685, 549239, 559233, 544663, 454924, 506046, 484680, 482674, 512583, 466268, 780016, 482139, 575661, 556436, 668975, 773974, 510108, 776153, 457963, 451609, 470522, 714281, 565281, 528420, 603159, 577084, 558186, 584644, 567416, 768739, 807449, 630806, 800781, 785727, 417058, 462769, 578392, 553935, 785628, 520759, 616956, 462305, 571334, 443389, 625648, 499353, 451042, 529485, 434192, 521126, 524235);

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
  100685
  398756
  417058
  434192
  443389
  451042
  451609
  453032
  454924
  457963
  462305
  462769
  464594
  466268
  470522
  472783
  482139
  482674
  484680
  485147
  499353
  503167
  506046
  510108
  512583
  520132
  520759
  521126
  522878
  524235
  528420
  529485
  541588
  543429
  544663
  549239
  553935
  556436
  558186
  559233
  565281
  567416
  571334
  575661
  577084
  578392
  584644
  593829
  593992
  596839
  597841
  603159
  609922
  616608
  616956
  625648
  630806
  640136
  643316
  668975
  669574
  714281
  727132
  768739
  773974
  776153
  780016
  785628
  785727
  791074
  800781
  807449
  827327
]

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 (100685, 398756, 417058, 434192, 443389, 451042, 451609, 453032, 454924, 457963, 462305, 462769, 464594, 466268, 470522, 472783, 482139, 482674, 484680, 485147, 499353, 503167, 506046, 510108, 512583, 520132, 520759, 521126, 522878, 524235, 528420, 529485, 541588, 543429, 544663, 549239, 553935, 556436, 558186, 559233, 565281, 567416, 571334, 575661, 577084, 578392, 584644, 593829, 593992, 596839, 597841, 603159, 609922, 616608, 616956, 625648, 630806, 640136, 643316, 668975, 669574, 714281, 727132, 768739, 773974, 776153, 780016, 785628, 785727, 791074, 800781, 807449, 827327);

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
  100685
  398756
  417058
  434192
  443389
  451042
  451609
  453032
  454924
  457963
  462305
  462769
  464594
  466268
  470522
  472783
  482139
  482674
  484680
  485147
  499353
  503167
  506046
  510108
  512583
  520132
  520759
  521126
  522878
  524235
  528420
  529485
  541588
  543429
  544663
  549239
  553935
  556436
  558186
  559233
  565281
  567416
  571334
  575661
  577084
  578392
  584644
  593829
  593992
  596839
  597841
  603159
  609922
  616608
  616956
  625648
  630806
  640136
  643316
  668975
  669574
  714281
  727132
  768739
  773974
  776153
  780016
  785628
  785727
  791074
  800781
  807449
  827327
]

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 (100685, 398756, 417058, 434192, 443389, 451042, 451609, 453032, 454924, 457963, 462305, 462769, 464594, 466268, 470522, 472783, 482139, 482674, 484680, 485147, 499353, 503167, 506046, 510108, 512583, 520132, 520759, 521126, 522878, 524235, 528420, 529485, 541588, 543429, 544663, 549239, 553935, 556436, 558186, 559233, 565281, 567416, 571334, 575661, 577084, 578392, 584644, 593829, 593992, 596839, 597841, 603159, 609922, 616608, 616956, 625648, 630806, 640136, 643316, 668975, 669574, 714281, 727132, 768739, 773974, 776153, 780016, 785628, 785727, 791074, 800781, 807449, 827327);

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` = 'любительск секс втро анал';