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

[
  "milf solo hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf solo hot' 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
  524796
  483523
  497920
  536393
  604865
  791738
  386671
  450287
  447600
  476321
  478991
  531594
  513816
  528407
  519531
  534169
  485472
  558160
  547807
  552706
  582833
  563108
  578718
  704218
  591277
  597722
  624905
  626066
  604803
  602338
  605266
  801636
  469167
  429905
  518201
  493258
  497829
  519354
  507766
  554529
  566761
  426399
  525729
  508891
  477506
  479936
  554235
  553208
  554930
  558132
  599529
  596857
  590102
  601806
  605742
  752661
  458007
  526531
  526536
  541839
  541418
  580223
  745312
  602063
  527442
  532531
  495566
  581873
  604153
  554526
  696499
  593292
  553832
  505891
  545300
  548056
  537789
]

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 (524796, 483523, 497920, 536393, 604865, 791738, 386671, 450287, 447600, 476321, 478991, 531594, 513816, 528407, 519531, 534169, 485472, 558160, 547807, 552706, 582833, 563108, 578718, 704218, 591277, 597722, 624905, 626066, 604803, 602338, 605266, 801636, 469167, 429905, 518201, 493258, 497829, 519354, 507766, 554529, 566761, 426399, 525729, 508891, 477506, 479936, 554235, 553208, 554930, 558132, 599529, 596857, 590102, 601806, 605742, 752661, 458007, 526531, 526536, 541839, 541418, 580223, 745312, 602063, 527442, 532531, 495566, 581873, 604153, 554526, 696499, 593292, 553832, 505891, 545300, 548056, 537789);

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
  386671
  426399
  429905
  447600
  450287
  458007
  469167
  476321
  477506
  478991
  479936
  483523
  485472
  493258
  495566
  497829
  497920
  505891
  507766
  508891
  513816
  518201
  519354
  519531
  524796
  525729
  526531
  526536
  527442
  528407
  531594
  532531
  534169
  536393
  537789
  541418
  541839
  545300
  547807
  548056
  552706
  553208
  553832
  554235
  554526
  554529
  554930
  558132
  558160
  563108
  566761
  578718
  580223
  581873
  582833
  590102
  591277
  593292
  596857
  597722
  599529
  601806
  602063
  602338
  604153
  604803
  604865
  605266
  605742
  624905
  626066
  696499
  704218
  745312
  752661
  791738
  801636
]

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 (386671, 426399, 429905, 447600, 450287, 458007, 469167, 476321, 477506, 478991, 479936, 483523, 485472, 493258, 495566, 497829, 497920, 505891, 507766, 508891, 513816, 518201, 519354, 519531, 524796, 525729, 526531, 526536, 527442, 528407, 531594, 532531, 534169, 536393, 537789, 541418, 541839, 545300, 547807, 548056, 552706, 553208, 553832, 554235, 554526, 554529, 554930, 558132, 558160, 563108, 566761, 578718, 580223, 581873, 582833, 590102, 591277, 593292, 596857, 597722, 599529, 601806, 602063, 602338, 604153, 604803, 604865, 605266, 605742, 624905, 626066, 696499, 704218, 745312, 752661, 791738, 801636);

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
  386671
  426399
  429905
  447600
  450287
  458007
  469167
  476321
  477506
  478991
  479936
  483523
  485472
  493258
  495566
  497829
  497920
  505891
  507766
  508891
  513816
  518201
  519354
  519531
  524796
  525729
  526531
  526536
  527442
  528407
  531594
  532531
  534169
  536393
  537789
  541418
  541839
  545300
  547807
  548056
  552706
  553208
  553832
  554235
  554526
  554529
  554930
  558132
  558160
  563108
  566761
  578718
  580223
  581873
  582833
  590102
  591277
  593292
  596857
  597722
  599529
  601806
  602063
  602338
  604153
  604803
  604865
  605266
  605742
  624905
  626066
  696499
  704218
  745312
  752661
  791738
  801636
]

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 (386671, 426399, 429905, 447600, 450287, 458007, 469167, 476321, 477506, 478991, 479936, 483523, 485472, 493258, 495566, 497829, 497920, 505891, 507766, 508891, 513816, 518201, 519354, 519531, 524796, 525729, 526531, 526536, 527442, 528407, 531594, 532531, 534169, 536393, 537789, 541418, 541839, 545300, 547807, 548056, 552706, 553208, 553832, 554235, 554526, 554529, 554930, 558132, 558160, 563108, 566761, 578718, 580223, 581873, 582833, 590102, 591277, 593292, 596857, 597722, 599529, 601806, 602063, 602338, 604153, 604803, 604865, 605266, 605742, 624905, 626066, 696499, 704218, 745312, 752661, 791738, 801636);

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

[
  "milf соло hot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf соло hot';

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

[
  "milf соло hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf соло hot';