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

[
  "watching homemade"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'watching homemade' 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
  460516
  451652
  511159
  504015
  558958
  543364
  661300
  554060
  620341
  441619
  423881
  464528
  524100
  523454
  525179
  489542
  518171
  497793
  454395
  511176
  528412
  528865
  463518
  547931
  549726
  720271
  690300
  620252
  590886
  803293
  463514
  478517
  437756
  456942
  477809
  435642
  524162
  441019
  517612
  527966
  449717
  548848
  560385
  680819
  528258
  496977
  467656
  514264
  442883
  503975
  485002
  508569
  514315
  434369
  608279
  483660
  517117
  521617
  541961
  577711
  624064
  432172
  542971
  422028
  525828
  565852
  500477
  550667
  662435
  594590
  628273
  490091
  619003
  663372
  523499
]

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 (460516, 451652, 511159, 504015, 558958, 543364, 661300, 554060, 620341, 441619, 423881, 464528, 524100, 523454, 525179, 489542, 518171, 497793, 454395, 511176, 528412, 528865, 463518, 547931, 549726, 720271, 690300, 620252, 590886, 803293, 463514, 478517, 437756, 456942, 477809, 435642, 524162, 441019, 517612, 527966, 449717, 548848, 560385, 680819, 528258, 496977, 467656, 514264, 442883, 503975, 485002, 508569, 514315, 434369, 608279, 483660, 517117, 521617, 541961, 577711, 624064, 432172, 542971, 422028, 525828, 565852, 500477, 550667, 662435, 594590, 628273, 490091, 619003, 663372, 523499);

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
  422028
  423881
  432172
  434369
  435642
  437756
  441019
  441619
  442883
  449717
  451652
  454395
  456942
  460516
  463514
  463518
  464528
  467656
  477809
  478517
  483660
  485002
  489542
  490091
  496977
  497793
  500477
  503975
  504015
  508569
  511159
  511176
  514264
  514315
  517117
  517612
  518171
  521617
  523454
  523499
  524100
  524162
  525179
  525828
  527966
  528258
  528412
  528865
  541961
  542971
  543364
  547931
  548848
  549726
  550667
  554060
  558958
  560385
  565852
  577711
  590886
  594590
  608279
  619003
  620252
  620341
  624064
  628273
  661300
  662435
  663372
  680819
  690300
  720271
  803293
]

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 (422028, 423881, 432172, 434369, 435642, 437756, 441019, 441619, 442883, 449717, 451652, 454395, 456942, 460516, 463514, 463518, 464528, 467656, 477809, 478517, 483660, 485002, 489542, 490091, 496977, 497793, 500477, 503975, 504015, 508569, 511159, 511176, 514264, 514315, 517117, 517612, 518171, 521617, 523454, 523499, 524100, 524162, 525179, 525828, 527966, 528258, 528412, 528865, 541961, 542971, 543364, 547931, 548848, 549726, 550667, 554060, 558958, 560385, 565852, 577711, 590886, 594590, 608279, 619003, 620252, 620341, 624064, 628273, 661300, 662435, 663372, 680819, 690300, 720271, 803293);

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
  422028
  423881
  432172
  434369
  435642
  437756
  441019
  441619
  442883
  449717
  451652
  454395
  456942
  460516
  463514
  463518
  464528
  467656
  477809
  478517
  483660
  485002
  489542
  490091
  496977
  497793
  500477
  503975
  504015
  508569
  511159
  511176
  514264
  514315
  517117
  517612
  518171
  521617
  523454
  523499
  524100
  524162
  525179
  525828
  527966
  528258
  528412
  528865
  541961
  542971
  543364
  547931
  548848
  549726
  550667
  554060
  558958
  560385
  565852
  577711
  590886
  594590
  608279
  619003
  620252
  620341
  624064
  628273
  661300
  662435
  663372
  680819
  690300
  720271
  803293
]

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 (422028, 423881, 432172, 434369, 435642, 437756, 441019, 441619, 442883, 449717, 451652, 454395, 456942, 460516, 463514, 463518, 464528, 467656, 477809, 478517, 483660, 485002, 489542, 490091, 496977, 497793, 500477, 503975, 504015, 508569, 511159, 511176, 514264, 514315, 517117, 517612, 518171, 521617, 523454, 523499, 524100, 524162, 525179, 525828, 527966, 528258, 528412, 528865, 541961, 542971, 543364, 547931, 548848, 549726, 550667, 554060, 558958, 560385, 565852, 577711, 590886, 594590, 608279, 619003, 620252, 620341, 624064, 628273, 661300, 662435, 663372, 680819, 690300, 720271, 803293);

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

[
  "watching домашн любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'watching домашн любительск';

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

[
  "watching домашн любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'watching домашн любительск';