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

[
  "sex with friends"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex with friends' 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
  474632
  525211
  529434
  432771
  457469
  463074
  577392
  467619
  483408
  462310
  519169
  500156
  561351
  456688
  474681
  565095
  583654
  465449
  420726
  460731
  531073
  518917
  620265
  603147
  506820
  520422
  445668
  520701
  510908
  615714
  434000
  432149
  454527
  411201
  446080
  427530
  454308
  485155
  733204
  543425
  676911
  481688
  435479
  472567
  524527
  463511
  504213
  505460
  543334
  418597
  526833
  484144
  501209
  682531
  454521
  519632
  640136
  474633
  546669
  474639
  456618
  517567
  480719
  577323
  468965
  604960
  581433
  550667
  536665
  607372
  620295
  484463
  572711
  518593
  583723
  567088
  682530
  615703
  567148
  534994
  464566
  562108
  483788
]

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 (474632, 525211, 529434, 432771, 457469, 463074, 577392, 467619, 483408, 462310, 519169, 500156, 561351, 456688, 474681, 565095, 583654, 465449, 420726, 460731, 531073, 518917, 620265, 603147, 506820, 520422, 445668, 520701, 510908, 615714, 434000, 432149, 454527, 411201, 446080, 427530, 454308, 485155, 733204, 543425, 676911, 481688, 435479, 472567, 524527, 463511, 504213, 505460, 543334, 418597, 526833, 484144, 501209, 682531, 454521, 519632, 640136, 474633, 546669, 474639, 456618, 517567, 480719, 577323, 468965, 604960, 581433, 550667, 536665, 607372, 620295, 484463, 572711, 518593, 583723, 567088, 682530, 615703, 567148, 534994, 464566, 562108, 483788);

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
  411201
  418597
  420726
  427530
  432149
  432771
  434000
  435479
  445668
  446080
  454308
  454521
  454527
  456618
  456688
  457469
  460731
  462310
  463074
  463511
  464566
  465449
  467619
  468965
  472567
  474632
  474633
  474639
  474681
  480719
  481688
  483408
  483788
  484144
  484463
  485155
  500156
  501209
  504213
  505460
  506820
  510908
  517567
  518593
  518917
  519169
  519632
  520422
  520701
  524527
  525211
  526833
  529434
  531073
  534994
  536665
  543334
  543425
  546669
  550667
  561351
  562108
  565095
  567088
  567148
  572711
  577323
  577392
  581433
  583654
  583723
  603147
  604960
  607372
  615703
  615714
  620265
  620295
  640136
  676911
  682530
  682531
  733204
]

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 (411201, 418597, 420726, 427530, 432149, 432771, 434000, 435479, 445668, 446080, 454308, 454521, 454527, 456618, 456688, 457469, 460731, 462310, 463074, 463511, 464566, 465449, 467619, 468965, 472567, 474632, 474633, 474639, 474681, 480719, 481688, 483408, 483788, 484144, 484463, 485155, 500156, 501209, 504213, 505460, 506820, 510908, 517567, 518593, 518917, 519169, 519632, 520422, 520701, 524527, 525211, 526833, 529434, 531073, 534994, 536665, 543334, 543425, 546669, 550667, 561351, 562108, 565095, 567088, 567148, 572711, 577323, 577392, 581433, 583654, 583723, 603147, 604960, 607372, 615703, 615714, 620265, 620295, 640136, 676911, 682530, 682531, 733204);

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
  411201
  418597
  420726
  427530
  432149
  432771
  434000
  435479
  445668
  446080
  454308
  454521
  454527
  456618
  456688
  457469
  460731
  462310
  463074
  463511
  464566
  465449
  467619
  468965
  472567
  474632
  474633
  474639
  474681
  480719
  481688
  483408
  483788
  484144
  484463
  485155
  500156
  501209
  504213
  505460
  506820
  510908
  517567
  518593
  518917
  519169
  519632
  520422
  520701
  524527
  525211
  526833
  529434
  531073
  534994
  536665
  543334
  543425
  546669
  550667
  561351
  562108
  565095
  567088
  567148
  572711
  577323
  577392
  581433
  583654
  583723
  603147
  604960
  607372
  615703
  615714
  620265
  620295
  640136
  676911
  682530
  682531
  733204
]

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 (411201, 418597, 420726, 427530, 432149, 432771, 434000, 435479, 445668, 446080, 454308, 454521, 454527, 456618, 456688, 457469, 460731, 462310, 463074, 463511, 464566, 465449, 467619, 468965, 472567, 474632, 474633, 474639, 474681, 480719, 481688, 483408, 483788, 484144, 484463, 485155, 500156, 501209, 504213, 505460, 506820, 510908, 517567, 518593, 518917, 519169, 519632, 520422, 520701, 524527, 525211, 526833, 529434, 531073, 534994, 536665, 543334, 543425, 546669, 550667, 561351, 562108, 565095, 567088, 567148, 572711, 577323, 577392, 581433, 583654, 583723, 603147, 604960, 607372, 615703, 615714, 620265, 620295, 640136, 676911, 682530, 682531, 733204);

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

[
  "секс friends"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс friends';

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

[
  "секс friends"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс friends';