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 milf masturbate"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur milf masturbate' 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
  605108
  487548
  518822
  443317
  423814
  471041
  526544
  469150
  559172
  568752
  802905
  725527
  739759
  810009
  429705
  423802
  422197
  528144
  479364
  551872
  509430
  505736
  560287
  632083
  717236
  438333
  529376
  519503
  541118
  567509
  583990
  602578
  609774
  746774
  605589
  421579
  424001
  463976
  496063
  486126
  515736
  522689
  520134
  449710
  420008
  486888
  529176
  543364
  625436
  452300
  495562
  529776
  577582
  681539
  597873
  439445
  520203
  560385
  644150
  697000
  522314
  453394
  520201
  420654
  536903
  584120
  434322
  517088
  521504
  422171
  577823
  516741
  604298
]

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 (605108, 487548, 518822, 443317, 423814, 471041, 526544, 469150, 559172, 568752, 802905, 725527, 739759, 810009, 429705, 423802, 422197, 528144, 479364, 551872, 509430, 505736, 560287, 632083, 717236, 438333, 529376, 519503, 541118, 567509, 583990, 602578, 609774, 746774, 605589, 421579, 424001, 463976, 496063, 486126, 515736, 522689, 520134, 449710, 420008, 486888, 529176, 543364, 625436, 452300, 495562, 529776, 577582, 681539, 597873, 439445, 520203, 560385, 644150, 697000, 522314, 453394, 520201, 420654, 536903, 584120, 434322, 517088, 521504, 422171, 577823, 516741, 604298);

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
  420008
  420654
  421579
  422171
  422197
  423802
  423814
  424001
  429705
  434322
  438333
  439445
  443317
  449710
  452300
  453394
  463976
  469150
  471041
  479364
  486126
  486888
  487548
  495562
  496063
  505736
  509430
  515736
  516741
  517088
  518822
  519503
  520134
  520201
  520203
  521504
  522314
  522689
  526544
  528144
  529176
  529376
  529776
  536903
  541118
  543364
  551872
  559172
  560287
  560385
  567509
  568752
  577582
  577823
  583990
  584120
  597873
  602578
  604298
  605108
  605589
  609774
  625436
  632083
  644150
  681539
  697000
  717236
  725527
  739759
  746774
  802905
  810009
]

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 (420008, 420654, 421579, 422171, 422197, 423802, 423814, 424001, 429705, 434322, 438333, 439445, 443317, 449710, 452300, 453394, 463976, 469150, 471041, 479364, 486126, 486888, 487548, 495562, 496063, 505736, 509430, 515736, 516741, 517088, 518822, 519503, 520134, 520201, 520203, 521504, 522314, 522689, 526544, 528144, 529176, 529376, 529776, 536903, 541118, 543364, 551872, 559172, 560287, 560385, 567509, 568752, 577582, 577823, 583990, 584120, 597873, 602578, 604298, 605108, 605589, 609774, 625436, 632083, 644150, 681539, 697000, 717236, 725527, 739759, 746774, 802905, 810009);

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
  420008
  420654
  421579
  422171
  422197
  423802
  423814
  424001
  429705
  434322
  438333
  439445
  443317
  449710
  452300
  453394
  463976
  469150
  471041
  479364
  486126
  486888
  487548
  495562
  496063
  505736
  509430
  515736
  516741
  517088
  518822
  519503
  520134
  520201
  520203
  521504
  522314
  522689
  526544
  528144
  529176
  529376
  529776
  536903
  541118
  543364
  551872
  559172
  560287
  560385
  567509
  568752
  577582
  577823
  583990
  584120
  597873
  602578
  604298
  605108
  605589
  609774
  625436
  632083
  644150
  681539
  697000
  717236
  725527
  739759
  746774
  802905
  810009
]

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 (420008, 420654, 421579, 422171, 422197, 423802, 423814, 424001, 429705, 434322, 438333, 439445, 443317, 449710, 452300, 453394, 463976, 469150, 471041, 479364, 486126, 486888, 487548, 495562, 496063, 505736, 509430, 515736, 516741, 517088, 518822, 519503, 520134, 520201, 520203, 521504, 522314, 522689, 526544, 528144, 529176, 529376, 529776, 536903, 541118, 543364, 551872, 559172, 560287, 560385, 567509, 568752, 577582, 577823, 583990, 584120, 597873, 602578, 604298, 605108, 605589, 609774, 625436, 632083, 644150, 681539, 697000, 717236, 725527, 739759, 746774, 802905, 810009);

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

[
  "любительск milf masturbate"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск milf masturbate';

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

[
  "любительск milf masturbate"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск milf masturbate';