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

[
  "surprise fuck wife"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'surprise fuck wife' 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
  493434
  505961
  742046
  459564
  562500
  579842
  579867
  588186
  592301
  796090
  482305
  493337
  718747
  554294
  517599
  610587
  453451
  398201
  450518
  459541
  505846
  459177
  520189
  563549
  528583
  549534
  614680
  547949
  450228
  521320
  668451
  505917
  681209
  456208
  521205
  579858
  579863
  474743
  497184
  508558
  574874
  428166
  557052
  468888
  637402
  453732
  465256
  591487
  593778
  623376
  130054
  467325
  481166
  416255
  567363
  491654
  572697
  605663
  540807
  561131
  596497
  579876
  532029
  773565
  577641
  593808
  586009
  518504
  557544
  583371
  583913
  621655
  593574
  613177
  429084
]

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 (493434, 505961, 742046, 459564, 562500, 579842, 579867, 588186, 592301, 796090, 482305, 493337, 718747, 554294, 517599, 610587, 453451, 398201, 450518, 459541, 505846, 459177, 520189, 563549, 528583, 549534, 614680, 547949, 450228, 521320, 668451, 505917, 681209, 456208, 521205, 579858, 579863, 474743, 497184, 508558, 574874, 428166, 557052, 468888, 637402, 453732, 465256, 591487, 593778, 623376, 130054, 467325, 481166, 416255, 567363, 491654, 572697, 605663, 540807, 561131, 596497, 579876, 532029, 773565, 577641, 593808, 586009, 518504, 557544, 583371, 583913, 621655, 593574, 613177, 429084);

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
  130054
  398201
  416255
  428166
  429084
  450228
  450518
  453451
  453732
  456208
  459177
  459541
  459564
  465256
  467325
  468888
  474743
  481166
  482305
  491654
  493337
  493434
  497184
  505846
  505917
  505961
  508558
  517599
  518504
  520189
  521205
  521320
  528583
  532029
  540807
  547949
  549534
  554294
  557052
  557544
  561131
  562500
  563549
  567363
  572697
  574874
  577641
  579842
  579858
  579863
  579867
  579876
  583371
  583913
  586009
  588186
  591487
  592301
  593574
  593778
  593808
  596497
  605663
  610587
  613177
  614680
  621655
  623376
  637402
  668451
  681209
  718747
  742046
  773565
  796090
]

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 (130054, 398201, 416255, 428166, 429084, 450228, 450518, 453451, 453732, 456208, 459177, 459541, 459564, 465256, 467325, 468888, 474743, 481166, 482305, 491654, 493337, 493434, 497184, 505846, 505917, 505961, 508558, 517599, 518504, 520189, 521205, 521320, 528583, 532029, 540807, 547949, 549534, 554294, 557052, 557544, 561131, 562500, 563549, 567363, 572697, 574874, 577641, 579842, 579858, 579863, 579867, 579876, 583371, 583913, 586009, 588186, 591487, 592301, 593574, 593778, 593808, 596497, 605663, 610587, 613177, 614680, 621655, 623376, 637402, 668451, 681209, 718747, 742046, 773565, 796090);

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
  130054
  398201
  416255
  428166
  429084
  450228
  450518
  453451
  453732
  456208
  459177
  459541
  459564
  465256
  467325
  468888
  474743
  481166
  482305
  491654
  493337
  493434
  497184
  505846
  505917
  505961
  508558
  517599
  518504
  520189
  521205
  521320
  528583
  532029
  540807
  547949
  549534
  554294
  557052
  557544
  561131
  562500
  563549
  567363
  572697
  574874
  577641
  579842
  579858
  579863
  579867
  579876
  583371
  583913
  586009
  588186
  591487
  592301
  593574
  593778
  593808
  596497
  605663
  610587
  613177
  614680
  621655
  623376
  637402
  668451
  681209
  718747
  742046
  773565
  796090
]

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 (130054, 398201, 416255, 428166, 429084, 450228, 450518, 453451, 453732, 456208, 459177, 459541, 459564, 465256, 467325, 468888, 474743, 481166, 482305, 491654, 493337, 493434, 497184, 505846, 505917, 505961, 508558, 517599, 518504, 520189, 521205, 521320, 528583, 532029, 540807, 547949, 549534, 554294, 557052, 557544, 561131, 562500, 563549, 567363, 572697, 574874, 577641, 579842, 579858, 579863, 579867, 579876, 583371, 583913, 586009, 588186, 591487, 592301, 593574, 593778, 593808, 596497, 605663, 610587, 613177, 614680, 621655, 623376, 637402, 668451, 681209, 718747, 742046, 773565, 796090);

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

[
  "surprise секс жен"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'surprise секс жен';

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

[
  "surprise секс жен"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'surprise секс жен';