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

[
  "gangbang girl 30"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gangbang girl 30' 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
  484457
  532738
  536590
  668525
  704523
  630524
  603235
  823695
  674415
  474680
  580264
  477097
  550207
  562068
  542864
  566789
  702163
  545773
  634769
  628082
  647898
  565245
  597272
  631196
  490201
  543858
  623196
  608431
  615717
  820762
  680176
  485541
  577331
  545363
  579113
  553272
  633449
  536584
  545488
  675006
  680186
  666868
  680207
  634187
  597963
  608756
  556797
  545389
  545409
  707391
  695127
  625423
  545410
  627812
  540437
  406381
  730798
  598806
  545418
  541643
  628333
  540330
  624270
  637074
  517743
  562814
  562825
  615696
  533534
  585716
  618326
  530369
  521575
]

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 (484457, 532738, 536590, 668525, 704523, 630524, 603235, 823695, 674415, 474680, 580264, 477097, 550207, 562068, 542864, 566789, 702163, 545773, 634769, 628082, 647898, 565245, 597272, 631196, 490201, 543858, 623196, 608431, 615717, 820762, 680176, 485541, 577331, 545363, 579113, 553272, 633449, 536584, 545488, 675006, 680186, 666868, 680207, 634187, 597963, 608756, 556797, 545389, 545409, 707391, 695127, 625423, 545410, 627812, 540437, 406381, 730798, 598806, 545418, 541643, 628333, 540330, 624270, 637074, 517743, 562814, 562825, 615696, 533534, 585716, 618326, 530369, 521575);

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
  406381
  474680
  477097
  484457
  485541
  490201
  517743
  521575
  530369
  532738
  533534
  536584
  536590
  540330
  540437
  541643
  542864
  543858
  545363
  545389
  545409
  545410
  545418
  545488
  545773
  550207
  553272
  556797
  562068
  562814
  562825
  565245
  566789
  577331
  579113
  580264
  585716
  597272
  597963
  598806
  603235
  608431
  608756
  615696
  615717
  618326
  623196
  624270
  625423
  627812
  628082
  628333
  630524
  631196
  633449
  634187
  634769
  637074
  647898
  666868
  668525
  674415
  675006
  680176
  680186
  680207
  695127
  702163
  704523
  707391
  730798
  820762
  823695
]

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 (406381, 474680, 477097, 484457, 485541, 490201, 517743, 521575, 530369, 532738, 533534, 536584, 536590, 540330, 540437, 541643, 542864, 543858, 545363, 545389, 545409, 545410, 545418, 545488, 545773, 550207, 553272, 556797, 562068, 562814, 562825, 565245, 566789, 577331, 579113, 580264, 585716, 597272, 597963, 598806, 603235, 608431, 608756, 615696, 615717, 618326, 623196, 624270, 625423, 627812, 628082, 628333, 630524, 631196, 633449, 634187, 634769, 637074, 647898, 666868, 668525, 674415, 675006, 680176, 680186, 680207, 695127, 702163, 704523, 707391, 730798, 820762, 823695);

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
  406381
  474680
  477097
  484457
  485541
  490201
  517743
  521575
  530369
  532738
  533534
  536584
  536590
  540330
  540437
  541643
  542864
  543858
  545363
  545389
  545409
  545410
  545418
  545488
  545773
  550207
  553272
  556797
  562068
  562814
  562825
  565245
  566789
  577331
  579113
  580264
  585716
  597272
  597963
  598806
  603235
  608431
  608756
  615696
  615717
  618326
  623196
  624270
  625423
  627812
  628082
  628333
  630524
  631196
  633449
  634187
  634769
  637074
  647898
  666868
  668525
  674415
  675006
  680176
  680186
  680207
  695127
  702163
  704523
  707391
  730798
  820762
  823695
]

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 (406381, 474680, 477097, 484457, 485541, 490201, 517743, 521575, 530369, 532738, 533534, 536584, 536590, 540330, 540437, 541643, 542864, 543858, 545363, 545389, 545409, 545410, 545418, 545488, 545773, 550207, 553272, 556797, 562068, 562814, 562825, 565245, 566789, 577331, 579113, 580264, 585716, 597272, 597963, 598806, 603235, 608431, 608756, 615696, 615717, 618326, 623196, 624270, 625423, 627812, 628082, 628333, 630524, 631196, 633449, 634187, 634769, 637074, 647898, 666868, 668525, 674415, 675006, 680176, 680186, 680207, 695127, 702163, 704523, 707391, 730798, 820762, 823695);

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

[
  "gangbang девушк 30"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'gangbang девушк 30';

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

[
  "gangbang девушк 30"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gangbang девушк 30';