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

[
  "anal skinny asian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal skinny asian' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"""
    \x01òj* ]p\x07Å\n
    aºôWtº
    """
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01956A2AFF5D70078F0A61A7935774A7 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
  542798
  551103
  597246
  643415
  749693
  535039
  580235
  722776
  597244
  547241
  554339
  463798
  463867
  491248
  580255
  640732
  422694
  529129
  530670
  591341
  536340
  534987
  422648
  583491
  468666
  556421
  423267
  586619
  528314
  823818
  583936
  472567
  422996
  559942
  702164
  628379
  628388
  597239
  552010
  448821
  492215
  545604
  546654
  595329
  565277
  554425
  545610
  680189
  720056
  559183
  497422
  446505
  537199
  565259
  582540
  807521
  422837
  479277
  541848
  541774
  545600
  637049
  536214
  542189
  537206
  648937
  628117
  603951
  427174
  553280
  513215
  395824
  540330
]

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 (542798, 551103, 597246, 643415, 749693, 535039, 580235, 722776, 597244, 547241, 554339, 463798, 463867, 491248, 580255, 640732, 422694, 529129, 530670, 591341, 536340, 534987, 422648, 583491, 468666, 556421, 423267, 586619, 528314, 823818, 583936, 472567, 422996, 559942, 702164, 628379, 628388, 597239, 552010, 448821, 492215, 545604, 546654, 595329, 565277, 554425, 545610, 680189, 720056, 559183, 497422, 446505, 537199, 565259, 582540, 807521, 422837, 479277, 541848, 541774, 545600, 637049, 536214, 542189, 537206, 648937, 628117, 603951, 427174, 553280, 513215, 395824, 540330);

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
  395824
  422648
  422694
  422837
  422996
  423267
  427174
  446505
  448821
  463798
  463867
  468666
  472567
  479277
  491248
  492215
  497422
  513215
  528314
  529129
  530670
  534987
  535039
  536214
  536340
  537199
  537206
  540330
  541774
  541848
  542189
  542798
  545600
  545604
  545610
  546654
  547241
  551103
  552010
  553280
  554339
  554425
  556421
  559183
  559942
  565259
  565277
  580235
  580255
  582540
  583491
  583936
  586619
  591341
  595329
  597239
  597244
  597246
  603951
  628117
  628379
  628388
  637049
  640732
  643415
  648937
  680189
  702164
  720056
  722776
  749693
  807521
  823818
]

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 (395824, 422648, 422694, 422837, 422996, 423267, 427174, 446505, 448821, 463798, 463867, 468666, 472567, 479277, 491248, 492215, 497422, 513215, 528314, 529129, 530670, 534987, 535039, 536214, 536340, 537199, 537206, 540330, 541774, 541848, 542189, 542798, 545600, 545604, 545610, 546654, 547241, 551103, 552010, 553280, 554339, 554425, 556421, 559183, 559942, 565259, 565277, 580235, 580255, 582540, 583491, 583936, 586619, 591341, 595329, 597239, 597244, 597246, 603951, 628117, 628379, 628388, 637049, 640732, 643415, 648937, 680189, 702164, 720056, 722776, 749693, 807521, 823818);

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
  395824
  422648
  422694
  422837
  422996
  423267
  427174
  446505
  448821
  463798
  463867
  468666
  472567
  479277
  491248
  492215
  497422
  513215
  528314
  529129
  530670
  534987
  535039
  536214
  536340
  537199
  537206
  540330
  541774
  541848
  542189
  542798
  545600
  545604
  545610
  546654
  547241
  551103
  552010
  553280
  554339
  554425
  556421
  559183
  559942
  565259
  565277
  580235
  580255
  582540
  583491
  583936
  586619
  591341
  595329
  597239
  597244
  597246
  603951
  628117
  628379
  628388
  637049
  640732
  643415
  648937
  680189
  702164
  720056
  722776
  749693
  807521
  823818
]

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 (395824, 422648, 422694, 422837, 422996, 423267, 427174, 446505, 448821, 463798, 463867, 468666, 472567, 479277, 491248, 492215, 497422, 513215, 528314, 529129, 530670, 534987, 535039, 536214, 536340, 537199, 537206, 540330, 541774, 541848, 542189, 542798, 545600, 545604, 545610, 546654, 547241, 551103, 552010, 553280, 554339, 554425, 556421, 559183, 559942, 565259, 565277, 580235, 580255, 582540, 583491, 583936, 586619, 591341, 595329, 597239, 597244, 597246, 603951, 628117, 628379, 628388, 637049, 640732, 643415, 648937, 680189, 702164, 720056, 722776, 749693, 807521, 823818);

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` = 'анал худые азиатк';