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

[
  "fisting teen beauty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fisting teen beauty' 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
  537663
  544840
  676022
  647972
  676638
  647307
  649514
  665768
  642706
  640813
  586587
  634769
  464887
  519592
  514113
  495273
  522138
  492064
  452014
  539203
  537236
  540559
  531123
  532643
  532745
  541853
  545488
  565276
  678522
  650316
  675000
  677784
  630533
  637049
  617427
  628383
  634780
  448816
  480800
  503310
  516684
  532666
  533915
  599988
  516686
  576088
  648257
  674994
  675008
  613515
  621259
  632632
  630280
  469198
  483550
  529078
  525287
  533557
  523924
  665328
  467907
  491665
  491232
  628389
  614029
  617420
  427174
  521544
  596431
  527915
  417674
  603131
  427263
  593125
  617165
]

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 (537663, 544840, 676022, 647972, 676638, 647307, 649514, 665768, 642706, 640813, 586587, 634769, 464887, 519592, 514113, 495273, 522138, 492064, 452014, 539203, 537236, 540559, 531123, 532643, 532745, 541853, 545488, 565276, 678522, 650316, 675000, 677784, 630533, 637049, 617427, 628383, 634780, 448816, 480800, 503310, 516684, 532666, 533915, 599988, 516686, 576088, 648257, 674994, 675008, 613515, 621259, 632632, 630280, 469198, 483550, 529078, 525287, 533557, 523924, 665328, 467907, 491665, 491232, 628389, 614029, 617420, 427174, 521544, 596431, 527915, 417674, 603131, 427263, 593125, 617165);

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
  417674
  427174
  427263
  448816
  452014
  464887
  467907
  469198
  480800
  483550
  491232
  491665
  492064
  495273
  503310
  514113
  516684
  516686
  519592
  521544
  522138
  523924
  525287
  527915
  529078
  531123
  532643
  532666
  532745
  533557
  533915
  537236
  537663
  539203
  540559
  541853
  544840
  545488
  565276
  576088
  586587
  593125
  596431
  599988
  603131
  613515
  614029
  617165
  617420
  617427
  621259
  628383
  628389
  630280
  630533
  632632
  634769
  634780
  637049
  640813
  642706
  647307
  647972
  648257
  649514
  650316
  665328
  665768
  674994
  675000
  675008
  676022
  676638
  677784
  678522
]

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 (417674, 427174, 427263, 448816, 452014, 464887, 467907, 469198, 480800, 483550, 491232, 491665, 492064, 495273, 503310, 514113, 516684, 516686, 519592, 521544, 522138, 523924, 525287, 527915, 529078, 531123, 532643, 532666, 532745, 533557, 533915, 537236, 537663, 539203, 540559, 541853, 544840, 545488, 565276, 576088, 586587, 593125, 596431, 599988, 603131, 613515, 614029, 617165, 617420, 617427, 621259, 628383, 628389, 630280, 630533, 632632, 634769, 634780, 637049, 640813, 642706, 647307, 647972, 648257, 649514, 650316, 665328, 665768, 674994, 675000, 675008, 676022, 676638, 677784, 678522);

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
  417674
  427174
  427263
  448816
  452014
  464887
  467907
  469198
  480800
  483550
  491232
  491665
  492064
  495273
  503310
  514113
  516684
  516686
  519592
  521544
  522138
  523924
  525287
  527915
  529078
  531123
  532643
  532666
  532745
  533557
  533915
  537236
  537663
  539203
  540559
  541853
  544840
  545488
  565276
  576088
  586587
  593125
  596431
  599988
  603131
  613515
  614029
  617165
  617420
  617427
  621259
  628383
  628389
  630280
  630533
  632632
  634769
  634780
  637049
  640813
  642706
  647307
  647972
  648257
  649514
  650316
  665328
  665768
  674994
  675000
  675008
  676022
  676638
  677784
  678522
]

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 (417674, 427174, 427263, 448816, 452014, 464887, 467907, 469198, 480800, 483550, 491232, 491665, 492064, 495273, 503310, 514113, 516684, 516686, 519592, 521544, 522138, 523924, 525287, 527915, 529078, 531123, 532643, 532666, 532745, 533557, 533915, 537236, 537663, 539203, 540559, 541853, 544840, 545488, 565276, 576088, 586587, 593125, 596431, 599988, 603131, 613515, 614029, 617165, 617420, 617427, 621259, 628383, 628389, 630280, 630533, 632632, 634769, 634780, 637049, 640813, 642706, 647307, 647972, 648257, 649514, 650316, 665328, 665768, 674994, 675000, 675008, 676022, 676638, 677784, 678522);

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

[
  "фистинг teen beauty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'фистинг teen beauty';

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

[
  "фистинг teen beauty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'фистинг teen beauty';