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

[
  "crying teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'crying teen' 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
  809894
  423464
  427437
  430355
  471996
  482081
  432790
  436437
  428716
  448846
  453598
  512966
  521871
  525391
  489544
  484087
  622932
  542218
  597501
  598510
  426220
  492459
  558566
  684211
  602371
  624375
  642693
  448562
  455096
  459651
  461454
  457130
  522832
  500978
  528262
  408460
  429255
  415963
  452228
  522434
  501598
  670239
  474621
  450579
  423650
  447615
  447412
  505614
  575713
  414357
  453324
  530582
  460879
  688390
  598524
  481910
  583994
  588801
  595891
  609292
  473772
  654552
  604289
  406075
  549860
  516682
  582631
  619965
  518521
  496367
  634230
  649185
  565186
]

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 (809894, 423464, 427437, 430355, 471996, 482081, 432790, 436437, 428716, 448846, 453598, 512966, 521871, 525391, 489544, 484087, 622932, 542218, 597501, 598510, 426220, 492459, 558566, 684211, 602371, 624375, 642693, 448562, 455096, 459651, 461454, 457130, 522832, 500978, 528262, 408460, 429255, 415963, 452228, 522434, 501598, 670239, 474621, 450579, 423650, 447615, 447412, 505614, 575713, 414357, 453324, 530582, 460879, 688390, 598524, 481910, 583994, 588801, 595891, 609292, 473772, 654552, 604289, 406075, 549860, 516682, 582631, 619965, 518521, 496367, 634230, 649185, 565186);

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
  406075
  408460
  414357
  415963
  423464
  423650
  426220
  427437
  428716
  429255
  430355
  432790
  436437
  447412
  447615
  448562
  448846
  450579
  452228
  453324
  453598
  455096
  457130
  459651
  460879
  461454
  471996
  473772
  474621
  481910
  482081
  484087
  489544
  492459
  496367
  500978
  501598
  505614
  512966
  516682
  518521
  521871
  522434
  522832
  525391
  528262
  530582
  542218
  549860
  558566
  565186
  575713
  582631
  583994
  588801
  595891
  597501
  598510
  598524
  602371
  604289
  609292
  619965
  622932
  624375
  634230
  642693
  649185
  654552
  670239
  684211
  688390
  809894
]

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 (406075, 408460, 414357, 415963, 423464, 423650, 426220, 427437, 428716, 429255, 430355, 432790, 436437, 447412, 447615, 448562, 448846, 450579, 452228, 453324, 453598, 455096, 457130, 459651, 460879, 461454, 471996, 473772, 474621, 481910, 482081, 484087, 489544, 492459, 496367, 500978, 501598, 505614, 512966, 516682, 518521, 521871, 522434, 522832, 525391, 528262, 530582, 542218, 549860, 558566, 565186, 575713, 582631, 583994, 588801, 595891, 597501, 598510, 598524, 602371, 604289, 609292, 619965, 622932, 624375, 634230, 642693, 649185, 654552, 670239, 684211, 688390, 809894);

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
  406075
  408460
  414357
  415963
  423464
  423650
  426220
  427437
  428716
  429255
  430355
  432790
  436437
  447412
  447615
  448562
  448846
  450579
  452228
  453324
  453598
  455096
  457130
  459651
  460879
  461454
  471996
  473772
  474621
  481910
  482081
  484087
  489544
  492459
  496367
  500978
  501598
  505614
  512966
  516682
  518521
  521871
  522434
  522832
  525391
  528262
  530582
  542218
  549860
  558566
  565186
  575713
  582631
  583994
  588801
  595891
  597501
  598510
  598524
  602371
  604289
  609292
  619965
  622932
  624375
  634230
  642693
  649185
  654552
  670239
  684211
  688390
  809894
]

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 (406075, 408460, 414357, 415963, 423464, 423650, 426220, 427437, 428716, 429255, 430355, 432790, 436437, 447412, 447615, 448562, 448846, 450579, 452228, 453324, 453598, 455096, 457130, 459651, 460879, 461454, 471996, 473772, 474621, 481910, 482081, 484087, 489544, 492459, 496367, 500978, 501598, 505614, 512966, 516682, 518521, 521871, 522434, 522832, 525391, 528262, 530582, 542218, 549860, 558566, 565186, 575713, 582631, 583994, 588801, 595891, 597501, 598510, 598524, 602371, 604289, 609292, 619965, 622932, 624375, 634230, 642693, 649185, 654552, 670239, 684211, 688390, 809894);

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

[
  "крича вперв teen"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'крича вперв teen';

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

[
  "крича вперв teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'крича вперв teen';

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 ?

[
  "crying teen"
  "crying teen"
  "crying teen"
  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 ('crying teen') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('crying teen')
              AND `query` <> 'crying teen'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;