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

[
  "русский куколд милфа"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русский куколд милфа' 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
  624849
  590546
  780445
  513408
  542744
  542792
  478528
  599213
  478530
  506691
  546720
  472396
  796506
  759484
  492167
  625567
  779069
  727330
  465930
  560474
  785876
  803076
  467488
  696308
  514693
  488520
  519955
  596841
  586448
  716841
  627380
  552794
  511162
  551572
  569987
  542872
  557997
  456737
  606018
  425312
  599272
  542745
  472388
  472393
  522423
  501997
  628426
  671395
  626024
  529457
  512560
  620754
  516823
  554414
  484628
  518781
  513398
  520127
  542748
  752965
  446314
  472128
  524613
  598204
  527030
  473293
  439583
  517117
  516090
  583723
  528081
]

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 (624849, 590546, 780445, 513408, 542744, 542792, 478528, 599213, 478530, 506691, 546720, 472396, 796506, 759484, 492167, 625567, 779069, 727330, 465930, 560474, 785876, 803076, 467488, 696308, 514693, 488520, 519955, 596841, 586448, 716841, 627380, 552794, 511162, 551572, 569987, 542872, 557997, 456737, 606018, 425312, 599272, 542745, 472388, 472393, 522423, 501997, 628426, 671395, 626024, 529457, 512560, 620754, 516823, 554414, 484628, 518781, 513398, 520127, 542748, 752965, 446314, 472128, 524613, 598204, 527030, 473293, 439583, 517117, 516090, 583723, 528081);

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
  425312
  439583
  446314
  456737
  465930
  467488
  472128
  472388
  472393
  472396
  473293
  478528
  478530
  484628
  488520
  492167
  501997
  506691
  511162
  512560
  513398
  513408
  514693
  516090
  516823
  517117
  518781
  519955
  520127
  522423
  524613
  527030
  528081
  529457
  542744
  542745
  542748
  542792
  542872
  546720
  551572
  552794
  554414
  557997
  560474
  569987
  583723
  586448
  590546
  596841
  598204
  599213
  599272
  606018
  620754
  624849
  625567
  626024
  627380
  628426
  671395
  696308
  716841
  727330
  752965
  759484
  779069
  780445
  785876
  796506
  803076
]

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 (425312, 439583, 446314, 456737, 465930, 467488, 472128, 472388, 472393, 472396, 473293, 478528, 478530, 484628, 488520, 492167, 501997, 506691, 511162, 512560, 513398, 513408, 514693, 516090, 516823, 517117, 518781, 519955, 520127, 522423, 524613, 527030, 528081, 529457, 542744, 542745, 542748, 542792, 542872, 546720, 551572, 552794, 554414, 557997, 560474, 569987, 583723, 586448, 590546, 596841, 598204, 599213, 599272, 606018, 620754, 624849, 625567, 626024, 627380, 628426, 671395, 696308, 716841, 727330, 752965, 759484, 779069, 780445, 785876, 796506, 803076);

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
  425312
  439583
  446314
  456737
  465930
  467488
  472128
  472388
  472393
  472396
  473293
  478528
  478530
  484628
  488520
  492167
  501997
  506691
  511162
  512560
  513398
  513408
  514693
  516090
  516823
  517117
  518781
  519955
  520127
  522423
  524613
  527030
  528081
  529457
  542744
  542745
  542748
  542792
  542872
  546720
  551572
  552794
  554414
  557997
  560474
  569987
  583723
  586448
  590546
  596841
  598204
  599213
  599272
  606018
  620754
  624849
  625567
  626024
  627380
  628426
  671395
  696308
  716841
  727330
  752965
  759484
  779069
  780445
  785876
  796506
  803076
]

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 (425312, 439583, 446314, 456737, 465930, 467488, 472128, 472388, 472393, 472396, 473293, 478528, 478530, 484628, 488520, 492167, 501997, 506691, 511162, 512560, 513398, 513408, 514693, 516090, 516823, 517117, 518781, 519955, 520127, 522423, 524613, 527030, 528081, 529457, 542744, 542745, 542748, 542792, 542872, 546720, 551572, 552794, 554414, 557997, 560474, 569987, 583723, 586448, 590546, 596841, 598204, 599213, 599272, 606018, 620754, 624849, 625567, 626024, 627380, 628426, 671395, 696308, 716841, 727330, 752965, 759484, 779069, 780445, 785876, 796506, 803076);

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` = 'русск куколд милф';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "русский куколд милфа"
  "русский куколд милфа"
  "русский куколд милфа"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('русский куколд милфа') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('русский куколд милфа')
              AND `query` <> 'русский куколд милфа'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;