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

[
  "big dick blond"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big dick blond' 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
  558868
  654183
  723461
  651123
  598216
  464018
  569095
  531154
  483515
  510059
  519081
  815801
  576285
  599507
  628431
  385258
  33309
  477598
  647023
  640435
  457891
  527565
  436118
  465500
  489602
  501649
  414110
  491321
  814839
  819530
  549142
  713014
  566783
  605562
  468323
  550299
  742449
  456634
  491403
  448097
  480652
  454061
  474787
  441168
  462170
  522891
  486349
  519721
  497219
  593702
  413225
  535049
  446266
  549027
  467592
  508438
  654923
  550406
  617076
  793608
  486111
  466240
  589591
  583608
  479126
  426368
  409209
  400845
  522913
  470283
  667695
  571464
  522874
  574777
  391386
  629296
  517301
  575778
  606202
  601853
  659419
  647344
  639741
]

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 (558868, 654183, 723461, 651123, 598216, 464018, 569095, 531154, 483515, 510059, 519081, 815801, 576285, 599507, 628431, 385258, 33309, 477598, 647023, 640435, 457891, 527565, 436118, 465500, 489602, 501649, 414110, 491321, 814839, 819530, 549142, 713014, 566783, 605562, 468323, 550299, 742449, 456634, 491403, 448097, 480652, 454061, 474787, 441168, 462170, 522891, 486349, 519721, 497219, 593702, 413225, 535049, 446266, 549027, 467592, 508438, 654923, 550406, 617076, 793608, 486111, 466240, 589591, 583608, 479126, 426368, 409209, 400845, 522913, 470283, 667695, 571464, 522874, 574777, 391386, 629296, 517301, 575778, 606202, 601853, 659419, 647344, 639741);

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
  33309
  385258
  391386
  400845
  409209
  413225
  414110
  426368
  436118
  441168
  446266
  448097
  454061
  456634
  457891
  462170
  464018
  465500
  466240
  467592
  468323
  470283
  474787
  477598
  479126
  480652
  483515
  486111
  486349
  489602
  491321
  491403
  497219
  501649
  508438
  510059
  517301
  519081
  519721
  522874
  522891
  522913
  527565
  531154
  535049
  549027
  549142
  550299
  550406
  558868
  566783
  569095
  571464
  574777
  575778
  576285
  583608
  589591
  593702
  598216
  599507
  601853
  605562
  606202
  617076
  628431
  629296
  639741
  640435
  647023
  647344
  651123
  654183
  654923
  659419
  667695
  713014
  723461
  742449
  793608
  814839
  815801
  819530
]

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 (33309, 385258, 391386, 400845, 409209, 413225, 414110, 426368, 436118, 441168, 446266, 448097, 454061, 456634, 457891, 462170, 464018, 465500, 466240, 467592, 468323, 470283, 474787, 477598, 479126, 480652, 483515, 486111, 486349, 489602, 491321, 491403, 497219, 501649, 508438, 510059, 517301, 519081, 519721, 522874, 522891, 522913, 527565, 531154, 535049, 549027, 549142, 550299, 550406, 558868, 566783, 569095, 571464, 574777, 575778, 576285, 583608, 589591, 593702, 598216, 599507, 601853, 605562, 606202, 617076, 628431, 629296, 639741, 640435, 647023, 647344, 651123, 654183, 654923, 659419, 667695, 713014, 723461, 742449, 793608, 814839, 815801, 819530);

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
  33309
  385258
  391386
  400845
  409209
  413225
  414110
  426368
  436118
  441168
  446266
  448097
  454061
  456634
  457891
  462170
  464018
  465500
  466240
  467592
  468323
  470283
  474787
  477598
  479126
  480652
  483515
  486111
  486349
  489602
  491321
  491403
  497219
  501649
  508438
  510059
  517301
  519081
  519721
  522874
  522891
  522913
  527565
  531154
  535049
  549027
  549142
  550299
  550406
  558868
  566783
  569095
  571464
  574777
  575778
  576285
  583608
  589591
  593702
  598216
  599507
  601853
  605562
  606202
  617076
  628431
  629296
  639741
  640435
  647023
  647344
  651123
  654183
  654923
  659419
  667695
  713014
  723461
  742449
  793608
  814839
  815801
  819530
]

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 (33309, 385258, 391386, 400845, 409209, 413225, 414110, 426368, 436118, 441168, 446266, 448097, 454061, 456634, 457891, 462170, 464018, 465500, 466240, 467592, 468323, 470283, 474787, 477598, 479126, 480652, 483515, 486111, 486349, 489602, 491321, 491403, 497219, 501649, 508438, 510059, 517301, 519081, 519721, 522874, 522891, 522913, 527565, 531154, 535049, 549027, 549142, 550299, 550406, 558868, 566783, 569095, 571464, 574777, 575778, 576285, 583608, 589591, 593702, 598216, 599507, 601853, 605562, 606202, 617076, 628431, 629296, 639741, 640435, 647023, 647344, 651123, 654183, 654923, 659419, 667695, 713014, 723461, 742449, 793608, 814839, 815801, 819530);

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

[
  "большой большие член blond"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большой большие член blond';

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

[
  "большой большие член blond"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большой большие член blond';