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

[
  "thai amateur"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'thai amateur' 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
  501597
  460030
  794954
  736507
  772507
  493852
  810176
  568618
  568621
  680618
  712276
  546865
  588577
  555532
  668467
  538547
  729751
  738936
  698109
  603929
  631214
  813109
  734146
  152234
  590066
  568614
  568629
  670425
  709961
  690682
  708263
  596336
  591748
  592879
  444216
  580053
  559782
  587307
  615983
  501564
  388915
  568631
  668459
  556371
  789067
  744711
  626432
  602575
  626876
  600502
  589732
  631019
  560136
  522263
  648937
  596730
  794951
  455967
  455981
  514199
  547089
  568617
  568638
  721557
  455978
  477399
  600581
  571812
  557361
  600579
  455975
  500594
  647162
  432990
  701206
  420680
  663539
  527756
  550882
  500600
  460327
  496887
  455245
]

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 (501597, 460030, 794954, 736507, 772507, 493852, 810176, 568618, 568621, 680618, 712276, 546865, 588577, 555532, 668467, 538547, 729751, 738936, 698109, 603929, 631214, 813109, 734146, 152234, 590066, 568614, 568629, 670425, 709961, 690682, 708263, 596336, 591748, 592879, 444216, 580053, 559782, 587307, 615983, 501564, 388915, 568631, 668459, 556371, 789067, 744711, 626432, 602575, 626876, 600502, 589732, 631019, 560136, 522263, 648937, 596730, 794951, 455967, 455981, 514199, 547089, 568617, 568638, 721557, 455978, 477399, 600581, 571812, 557361, 600579, 455975, 500594, 647162, 432990, 701206, 420680, 663539, 527756, 550882, 500600, 460327, 496887, 455245);

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
  152234
  388915
  420680
  432990
  444216
  455245
  455967
  455975
  455978
  455981
  460030
  460327
  477399
  493852
  496887
  500594
  500600
  501564
  501597
  514199
  522263
  527756
  538547
  546865
  547089
  550882
  555532
  556371
  557361
  559782
  560136
  568614
  568617
  568618
  568621
  568629
  568631
  568638
  571812
  580053
  587307
  588577
  589732
  590066
  591748
  592879
  596336
  596730
  600502
  600579
  600581
  602575
  603929
  615983
  626432
  626876
  631019
  631214
  647162
  648937
  663539
  668459
  668467
  670425
  680618
  690682
  698109
  701206
  708263
  709961
  712276
  721557
  729751
  734146
  736507
  738936
  744711
  772507
  789067
  794951
  794954
  810176
  813109
]

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 (152234, 388915, 420680, 432990, 444216, 455245, 455967, 455975, 455978, 455981, 460030, 460327, 477399, 493852, 496887, 500594, 500600, 501564, 501597, 514199, 522263, 527756, 538547, 546865, 547089, 550882, 555532, 556371, 557361, 559782, 560136, 568614, 568617, 568618, 568621, 568629, 568631, 568638, 571812, 580053, 587307, 588577, 589732, 590066, 591748, 592879, 596336, 596730, 600502, 600579, 600581, 602575, 603929, 615983, 626432, 626876, 631019, 631214, 647162, 648937, 663539, 668459, 668467, 670425, 680618, 690682, 698109, 701206, 708263, 709961, 712276, 721557, 729751, 734146, 736507, 738936, 744711, 772507, 789067, 794951, 794954, 810176, 813109);

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
  152234
  388915
  420680
  432990
  444216
  455245
  455967
  455975
  455978
  455981
  460030
  460327
  477399
  493852
  496887
  500594
  500600
  501564
  501597
  514199
  522263
  527756
  538547
  546865
  547089
  550882
  555532
  556371
  557361
  559782
  560136
  568614
  568617
  568618
  568621
  568629
  568631
  568638
  571812
  580053
  587307
  588577
  589732
  590066
  591748
  592879
  596336
  596730
  600502
  600579
  600581
  602575
  603929
  615983
  626432
  626876
  631019
  631214
  647162
  648937
  663539
  668459
  668467
  670425
  680618
  690682
  698109
  701206
  708263
  709961
  712276
  721557
  729751
  734146
  736507
  738936
  744711
  772507
  789067
  794951
  794954
  810176
  813109
]

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 (152234, 388915, 420680, 432990, 444216, 455245, 455967, 455975, 455978, 455981, 460030, 460327, 477399, 493852, 496887, 500594, 500600, 501564, 501597, 514199, 522263, 527756, 538547, 546865, 547089, 550882, 555532, 556371, 557361, 559782, 560136, 568614, 568617, 568618, 568621, 568629, 568631, 568638, 571812, 580053, 587307, 588577, 589732, 590066, 591748, 592879, 596336, 596730, 600502, 600579, 600581, 602575, 603929, 615983, 626432, 626876, 631019, 631214, 647162, 648937, 663539, 668459, 668467, 670425, 680618, 690682, 698109, 701206, 708263, 709961, 712276, 721557, 729751, 734146, 736507, 738936, 744711, 772507, 789067, 794951, 794954, 810176, 813109);

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` = 'тайк азиатк любительск';