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

[
  "young-teen-casting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'young-teen-casting' 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
  649556
  645993
  680170
  623205
  631597
  457500
  545418
  648257
  675008
  624270
  628333
  597575
  620851
  632632
  532644
  409995
  527915
  485481
  517743
  452018
  448445
  530030
  534842
  532738
  534229
  536590
  537660
  530060
  530017
  561970
  702677
  597231
  524198
  517229
  585716
  465606
  530912
  532645
  556797
  454984
  419627
  424480
  418416
  509802
  450775
  533563
  539203
  536584
  537210
  537212
  518473
  531123
  532661
  532745
  604247
  582229
  487703
  533746
  532672
  540330
  536695
  573393
  646448
  642774
  532666
  533915
  530369
  599988
  510757
  516686
  522382
  533557
  521575
]

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 (649556, 645993, 680170, 623205, 631597, 457500, 545418, 648257, 675008, 624270, 628333, 597575, 620851, 632632, 532644, 409995, 527915, 485481, 517743, 452018, 448445, 530030, 534842, 532738, 534229, 536590, 537660, 530060, 530017, 561970, 702677, 597231, 524198, 517229, 585716, 465606, 530912, 532645, 556797, 454984, 419627, 424480, 418416, 509802, 450775, 533563, 539203, 536584, 537210, 537212, 518473, 531123, 532661, 532745, 604247, 582229, 487703, 533746, 532672, 540330, 536695, 573393, 646448, 642774, 532666, 533915, 530369, 599988, 510757, 516686, 522382, 533557, 521575);

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
  409995
  418416
  419627
  424480
  448445
  450775
  452018
  454984
  457500
  465606
  485481
  487703
  509802
  510757
  516686
  517229
  517743
  518473
  521575
  522382
  524198
  527915
  530017
  530030
  530060
  530369
  530912
  531123
  532644
  532645
  532661
  532666
  532672
  532738
  532745
  533557
  533563
  533746
  533915
  534229
  534842
  536584
  536590
  536695
  537210
  537212
  537660
  539203
  540330
  545418
  556797
  561970
  573393
  582229
  585716
  597231
  597575
  599988
  604247
  620851
  623205
  624270
  628333
  631597
  632632
  642774
  645993
  646448
  648257
  649556
  675008
  680170
  702677
]

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 (409995, 418416, 419627, 424480, 448445, 450775, 452018, 454984, 457500, 465606, 485481, 487703, 509802, 510757, 516686, 517229, 517743, 518473, 521575, 522382, 524198, 527915, 530017, 530030, 530060, 530369, 530912, 531123, 532644, 532645, 532661, 532666, 532672, 532738, 532745, 533557, 533563, 533746, 533915, 534229, 534842, 536584, 536590, 536695, 537210, 537212, 537660, 539203, 540330, 545418, 556797, 561970, 573393, 582229, 585716, 597231, 597575, 599988, 604247, 620851, 623205, 624270, 628333, 631597, 632632, 642774, 645993, 646448, 648257, 649556, 675008, 680170, 702677);

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
  409995
  418416
  419627
  424480
  448445
  450775
  452018
  454984
  457500
  465606
  485481
  487703
  509802
  510757
  516686
  517229
  517743
  518473
  521575
  522382
  524198
  527915
  530017
  530030
  530060
  530369
  530912
  531123
  532644
  532645
  532661
  532666
  532672
  532738
  532745
  533557
  533563
  533746
  533915
  534229
  534842
  536584
  536590
  536695
  537210
  537212
  537660
  539203
  540330
  545418
  556797
  561970
  573393
  582229
  585716
  597231
  597575
  599988
  604247
  620851
  623205
  624270
  628333
  631597
  632632
  642774
  645993
  646448
  648257
  649556
  675008
  680170
  702677
]

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 (409995, 418416, 419627, 424480, 448445, 450775, 452018, 454984, 457500, 465606, 485481, 487703, 509802, 510757, 516686, 517229, 517743, 518473, 521575, 522382, 524198, 527915, 530017, 530030, 530060, 530369, 530912, 531123, 532644, 532645, 532661, 532666, 532672, 532738, 532745, 533557, 533563, 533746, 533915, 534229, 534842, 536584, 536590, 536695, 537210, 537212, 537660, 539203, 540330, 545418, 556797, 561970, 573393, 582229, 585716, 597231, 597575, 599988, 604247, 620851, 623205, 624270, 628333, 631597, 632632, 642774, 645993, 646448, 648257, 649556, 675008, 680170, 702677);

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

[
  "young teen кастинг"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'young teen кастинг';

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

[
  "young teen кастинг"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'young teen кастинг';