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

[
  "solo asian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'solo asian' 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
  438052
  431038
  825860
  827063
  547241
  428944
  468153
  567127
  558175
  680706
  615371
  643145
  749693
  819181
  824449
  579499
  555547
  672212
  642164
  804703
  783740
  574243
  752700
  384960
  507774
  649435
  665964
  601767
  637318
  740110
  751036
  173238
  452781
  534791
  645526
  645604
  792273
  473055
  617486
  500743
  599829
  772507
  428903
  480233
  524369
  538547
  499885
  500679
  546085
  547768
  606493
  439252
  464690
  534023
  495167
  467715
  572967
  559782
  542884
  690682
  556371
  590981
  587307
  599789
  615983
  740268
  471092
  546783
  761289
  480788
  516873
  544964
  615447
  508891
  494206
  585889
  607879
  502533
]

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 (438052, 431038, 825860, 827063, 547241, 428944, 468153, 567127, 558175, 680706, 615371, 643145, 749693, 819181, 824449, 579499, 555547, 672212, 642164, 804703, 783740, 574243, 752700, 384960, 507774, 649435, 665964, 601767, 637318, 740110, 751036, 173238, 452781, 534791, 645526, 645604, 792273, 473055, 617486, 500743, 599829, 772507, 428903, 480233, 524369, 538547, 499885, 500679, 546085, 547768, 606493, 439252, 464690, 534023, 495167, 467715, 572967, 559782, 542884, 690682, 556371, 590981, 587307, 599789, 615983, 740268, 471092, 546783, 761289, 480788, 516873, 544964, 615447, 508891, 494206, 585889, 607879, 502533);

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
  173238
  384960
  428903
  428944
  431038
  438052
  439252
  452781
  464690
  467715
  468153
  471092
  473055
  480233
  480788
  494206
  495167
  499885
  500679
  500743
  502533
  507774
  508891
  516873
  524369
  534023
  534791
  538547
  542884
  544964
  546085
  546783
  547241
  547768
  555547
  556371
  558175
  559782
  567127
  572967
  574243
  579499
  585889
  587307
  590981
  599789
  599829
  601767
  606493
  607879
  615371
  615447
  615983
  617486
  637318
  642164
  643145
  645526
  645604
  649435
  665964
  672212
  680706
  690682
  740110
  740268
  749693
  751036
  752700
  761289
  772507
  783740
  792273
  804703
  819181
  824449
  825860
  827063
]

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 (173238, 384960, 428903, 428944, 431038, 438052, 439252, 452781, 464690, 467715, 468153, 471092, 473055, 480233, 480788, 494206, 495167, 499885, 500679, 500743, 502533, 507774, 508891, 516873, 524369, 534023, 534791, 538547, 542884, 544964, 546085, 546783, 547241, 547768, 555547, 556371, 558175, 559782, 567127, 572967, 574243, 579499, 585889, 587307, 590981, 599789, 599829, 601767, 606493, 607879, 615371, 615447, 615983, 617486, 637318, 642164, 643145, 645526, 645604, 649435, 665964, 672212, 680706, 690682, 740110, 740268, 749693, 751036, 752700, 761289, 772507, 783740, 792273, 804703, 819181, 824449, 825860, 827063);

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
  173238
  384960
  428903
  428944
  431038
  438052
  439252
  452781
  464690
  467715
  468153
  471092
  473055
  480233
  480788
  494206
  495167
  499885
  500679
  500743
  502533
  507774
  508891
  516873
  524369
  534023
  534791
  538547
  542884
  544964
  546085
  546783
  547241
  547768
  555547
  556371
  558175
  559782
  567127
  572967
  574243
  579499
  585889
  587307
  590981
  599789
  599829
  601767
  606493
  607879
  615371
  615447
  615983
  617486
  637318
  642164
  643145
  645526
  645604
  649435
  665964
  672212
  680706
  690682
  740110
  740268
  749693
  751036
  752700
  761289
  772507
  783740
  792273
  804703
  819181
  824449
  825860
  827063
]

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 (173238, 384960, 428903, 428944, 431038, 438052, 439252, 452781, 464690, 467715, 468153, 471092, 473055, 480233, 480788, 494206, 495167, 499885, 500679, 500743, 502533, 507774, 508891, 516873, 524369, 534023, 534791, 538547, 542884, 544964, 546085, 546783, 547241, 547768, 555547, 556371, 558175, 559782, 567127, 572967, 574243, 579499, 585889, 587307, 590981, 599789, 599829, 601767, 606493, 607879, 615371, 615447, 615983, 617486, 637318, 642164, 643145, 645526, 645604, 649435, 665964, 672212, 680706, 690682, 740110, 740268, 749693, 751036, 752700, 761289, 772507, 783740, 792273, 804703, 819181, 824449, 825860, 827063);

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` = 'соло азиатк';