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

[
  "secretary hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'secretary hot' 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
  600743
  618610
  585519
  391359
  383262
  396278
  456148
  484984
  505254
  679708
  739176
  447679
  456518
  467293
  807378
  815063
  469475
  516034
  513243
  552270
  591270
  589116
  600864
  804104
  432393
  494786
  490410
  524217
  410775
  826508
  461281
  559863
  388449
  550841
  811628
  445345
  815116
  456978
  750190
  583868
  800982
  824345
  588324
  758512
  481750
  625342
  634532
  484748
  522878
  438062
  796495
  448508
  438650
  461906
  435792
  465303
  457862
  456931
  560248
  775793
  525306
  468269
  421471
  455307
  429272
  477631
  437591
  478087
  515604
  546594
  411863
  527442
  561814
  528181
  611892
  591354
  625440
]

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 (600743, 618610, 585519, 391359, 383262, 396278, 456148, 484984, 505254, 679708, 739176, 447679, 456518, 467293, 807378, 815063, 469475, 516034, 513243, 552270, 591270, 589116, 600864, 804104, 432393, 494786, 490410, 524217, 410775, 826508, 461281, 559863, 388449, 550841, 811628, 445345, 815116, 456978, 750190, 583868, 800982, 824345, 588324, 758512, 481750, 625342, 634532, 484748, 522878, 438062, 796495, 448508, 438650, 461906, 435792, 465303, 457862, 456931, 560248, 775793, 525306, 468269, 421471, 455307, 429272, 477631, 437591, 478087, 515604, 546594, 411863, 527442, 561814, 528181, 611892, 591354, 625440);

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
  383262
  388449
  391359
  396278
  410775
  411863
  421471
  429272
  432393
  435792
  437591
  438062
  438650
  445345
  447679
  448508
  455307
  456148
  456518
  456931
  456978
  457862
  461281
  461906
  465303
  467293
  468269
  469475
  477631
  478087
  481750
  484748
  484984
  490410
  494786
  505254
  513243
  515604
  516034
  522878
  524217
  525306
  527442
  528181
  546594
  550841
  552270
  559863
  560248
  561814
  583868
  585519
  588324
  589116
  591270
  591354
  600743
  600864
  611892
  618610
  625342
  625440
  634532
  679708
  739176
  750190
  758512
  775793
  796495
  800982
  804104
  807378
  811628
  815063
  815116
  824345
  826508
]

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 (383262, 388449, 391359, 396278, 410775, 411863, 421471, 429272, 432393, 435792, 437591, 438062, 438650, 445345, 447679, 448508, 455307, 456148, 456518, 456931, 456978, 457862, 461281, 461906, 465303, 467293, 468269, 469475, 477631, 478087, 481750, 484748, 484984, 490410, 494786, 505254, 513243, 515604, 516034, 522878, 524217, 525306, 527442, 528181, 546594, 550841, 552270, 559863, 560248, 561814, 583868, 585519, 588324, 589116, 591270, 591354, 600743, 600864, 611892, 618610, 625342, 625440, 634532, 679708, 739176, 750190, 758512, 775793, 796495, 800982, 804104, 807378, 811628, 815063, 815116, 824345, 826508);

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
  383262
  388449
  391359
  396278
  410775
  411863
  421471
  429272
  432393
  435792
  437591
  438062
  438650
  445345
  447679
  448508
  455307
  456148
  456518
  456931
  456978
  457862
  461281
  461906
  465303
  467293
  468269
  469475
  477631
  478087
  481750
  484748
  484984
  490410
  494786
  505254
  513243
  515604
  516034
  522878
  524217
  525306
  527442
  528181
  546594
  550841
  552270
  559863
  560248
  561814
  583868
  585519
  588324
  589116
  591270
  591354
  600743
  600864
  611892
  618610
  625342
  625440
  634532
  679708
  739176
  750190
  758512
  775793
  796495
  800982
  804104
  807378
  811628
  815063
  815116
  824345
  826508
]

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 (383262, 388449, 391359, 396278, 410775, 411863, 421471, 429272, 432393, 435792, 437591, 438062, 438650, 445345, 447679, 448508, 455307, 456148, 456518, 456931, 456978, 457862, 461281, 461906, 465303, 467293, 468269, 469475, 477631, 478087, 481750, 484748, 484984, 490410, 494786, 505254, 513243, 515604, 516034, 522878, 524217, 525306, 527442, 528181, 546594, 550841, 552270, 559863, 560248, 561814, 583868, 585519, 588324, 589116, 591270, 591354, 600743, 600864, 611892, 618610, 625342, 625440, 634532, 679708, 739176, 750190, 758512, 775793, 796495, 800982, 804104, 807378, 811628, 815063, 815116, 824345, 826508);

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

[
  "секретарш hot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секретарш hot';

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

[
  "секретарш hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секретарш hot';