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

[
  "teen blowjob swallow"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen blowjob swallow' 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
  641975
  533370
  545341
  542583
  647936
  696582
  683264
  705302
  647830
  674975
  600415
  632707
  633770
  600337
  633792
  531247
  630764
  600363
  540398
  666902
  592034
  633718
  633742
  636294
  633451
  637729
  628382
  647895
  634801
  634115
  630526
  562763
  615717
  639716
  534027
  537648
  677783
  647972
  632978
  632690
  646427
  666904
  634790
  537184
  525682
  634780
  505794
  647905
  535338
  695123
  644916
  630533
  539203
  695181
  707391
  666894
  628383
  630537
  545389
  545410
  666880
  444356
  599966
  666895
  666850
  648257
  628333
  630280
  647860
  559178
  633435
  545611
  628371
  533915
  617420
  533746
  553992
]

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 (641975, 533370, 545341, 542583, 647936, 696582, 683264, 705302, 647830, 674975, 600415, 632707, 633770, 600337, 633792, 531247, 630764, 600363, 540398, 666902, 592034, 633718, 633742, 636294, 633451, 637729, 628382, 647895, 634801, 634115, 630526, 562763, 615717, 639716, 534027, 537648, 677783, 647972, 632978, 632690, 646427, 666904, 634790, 537184, 525682, 634780, 505794, 647905, 535338, 695123, 644916, 630533, 539203, 695181, 707391, 666894, 628383, 630537, 545389, 545410, 666880, 444356, 599966, 666895, 666850, 648257, 628333, 630280, 647860, 559178, 633435, 545611, 628371, 533915, 617420, 533746, 553992);

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
  444356
  525682
  531247
  533370
  533746
  533915
  534027
  535338
  537184
  537648
  539203
  540398
  542583
  545341
  545389
  545410
  545611
  553992
  559178
  562763
  592034
  599966
  600337
  600363
  600415
  615717
  617420
  628333
  628371
  628382
  628383
  630280
  630526
  630533
  630537
  630764
  632690
  632707
  632978
  633435
  633451
  633718
  633742
  633770
  633792
  634115
  634780
  634790
  634801
  636294
  637729
  639716
  641975
  644916
  646427
  647830
  647860
  647895
  647905
  647936
  647972
  648257
  666850
  666880
  666894
  666895
  666902
  666904
  674975
  677783
  683264
  695123
  695181
  696582
  705302
  707391
]

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 (444356, 525682, 531247, 533370, 533746, 533915, 534027, 535338, 537184, 537648, 539203, 540398, 542583, 545341, 545389, 545410, 545611, 553992, 559178, 562763, 592034, 599966, 600337, 600363, 600415, 615717, 617420, 628333, 628371, 628382, 628383, 630280, 630526, 630533, 630537, 630764, 632690, 632707, 632978, 633435, 633451, 633718, 633742, 633770, 633792, 634115, 634780, 634790, 634801, 636294, 637729, 639716, 641975, 644916, 646427, 647830, 647860, 647895, 647905, 647936, 647972, 648257, 666850, 666880, 666894, 666895, 666902, 666904, 674975, 677783, 683264, 695123, 695181, 696582, 705302, 707391);

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
  444356
  525682
  531247
  533370
  533746
  533915
  534027
  535338
  537184
  537648
  539203
  540398
  542583
  545341
  545389
  545410
  545611
  553992
  559178
  562763
  592034
  599966
  600337
  600363
  600415
  615717
  617420
  628333
  628371
  628382
  628383
  630280
  630526
  630533
  630537
  630764
  632690
  632707
  632978
  633435
  633451
  633718
  633742
  633770
  633792
  634115
  634780
  634790
  634801
  636294
  637729
  639716
  641975
  644916
  646427
  647830
  647860
  647895
  647905
  647936
  647972
  648257
  666850
  666880
  666894
  666895
  666902
  666904
  674975
  677783
  683264
  695123
  695181
  696582
  705302
  707391
]

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 (444356, 525682, 531247, 533370, 533746, 533915, 534027, 535338, 537184, 537648, 539203, 540398, 542583, 545341, 545389, 545410, 545611, 553992, 559178, 562763, 592034, 599966, 600337, 600363, 600415, 615717, 617420, 628333, 628371, 628382, 628383, 630280, 630526, 630533, 630537, 630764, 632690, 632707, 632978, 633435, 633451, 633718, 633742, 633770, 633792, 634115, 634780, 634790, 634801, 636294, 637729, 639716, 641975, 644916, 646427, 647830, 647860, 647895, 647905, 647936, 647972, 648257, 666850, 666880, 666894, 666895, 666902, 666904, 674975, 677783, 683264, 695123, 695181, 696582, 705302, 707391);

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

[
  "teen минет оральн секс глота"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen минет оральн секс глота';

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

[
  "teen минет оральн секс глота"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen минет оральн секс глота';