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

[
  "mature ebony"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature ebony' 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
  537241
  537098
  497899
  532172
  534823
  496312
  531405
  551916
  581711
  545819
  647885
  602968
  642061
  588283
  808579
  474550
  452058
  477210
  533966
  691509
  433165
  443112
  448813
  512533
  533802
  537939
  526381
  486179
  541634
  541656
  580277
  560669
  602946
  808526
  102235
  578395
  614515
  481910
  487746
  531537
  536370
  533064
  554182
  563535
  699397
  639824
  634484
  418363
  425531
  603198
  771620
  408437
  674983
  637460
  636033
  471380
  541594
  807389
  429999
  437868
  635243
  639744
  643020
  430404
  430700
  800685
  460208
  466499
  458010
  462911
  503269
  434601
  412541
  467960
  503274
  513357
  636304
  472299
  516885
  545763
  574384
]

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 (537241, 537098, 497899, 532172, 534823, 496312, 531405, 551916, 581711, 545819, 647885, 602968, 642061, 588283, 808579, 474550, 452058, 477210, 533966, 691509, 433165, 443112, 448813, 512533, 533802, 537939, 526381, 486179, 541634, 541656, 580277, 560669, 602946, 808526, 102235, 578395, 614515, 481910, 487746, 531537, 536370, 533064, 554182, 563535, 699397, 639824, 634484, 418363, 425531, 603198, 771620, 408437, 674983, 637460, 636033, 471380, 541594, 807389, 429999, 437868, 635243, 639744, 643020, 430404, 430700, 800685, 460208, 466499, 458010, 462911, 503269, 434601, 412541, 467960, 503274, 513357, 636304, 472299, 516885, 545763, 574384);

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
  102235
  408437
  412541
  418363
  425531
  429999
  430404
  430700
  433165
  434601
  437868
  443112
  448813
  452058
  458010
  460208
  462911
  466499
  467960
  471380
  472299
  474550
  477210
  481910
  486179
  487746
  496312
  497899
  503269
  503274
  512533
  513357
  516885
  526381
  531405
  531537
  532172
  533064
  533802
  533966
  534823
  536370
  537098
  537241
  537939
  541594
  541634
  541656
  545763
  545819
  551916
  554182
  560669
  563535
  574384
  578395
  580277
  581711
  588283
  602946
  602968
  603198
  614515
  634484
  635243
  636033
  636304
  637460
  639744
  639824
  642061
  643020
  647885
  674983
  691509
  699397
  771620
  800685
  807389
  808526
  808579
]

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 (102235, 408437, 412541, 418363, 425531, 429999, 430404, 430700, 433165, 434601, 437868, 443112, 448813, 452058, 458010, 460208, 462911, 466499, 467960, 471380, 472299, 474550, 477210, 481910, 486179, 487746, 496312, 497899, 503269, 503274, 512533, 513357, 516885, 526381, 531405, 531537, 532172, 533064, 533802, 533966, 534823, 536370, 537098, 537241, 537939, 541594, 541634, 541656, 545763, 545819, 551916, 554182, 560669, 563535, 574384, 578395, 580277, 581711, 588283, 602946, 602968, 603198, 614515, 634484, 635243, 636033, 636304, 637460, 639744, 639824, 642061, 643020, 647885, 674983, 691509, 699397, 771620, 800685, 807389, 808526, 808579);

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
  102235
  408437
  412541
  418363
  425531
  429999
  430404
  430700
  433165
  434601
  437868
  443112
  448813
  452058
  458010
  460208
  462911
  466499
  467960
  471380
  472299
  474550
  477210
  481910
  486179
  487746
  496312
  497899
  503269
  503274
  512533
  513357
  516885
  526381
  531405
  531537
  532172
  533064
  533802
  533966
  534823
  536370
  537098
  537241
  537939
  541594
  541634
  541656
  545763
  545819
  551916
  554182
  560669
  563535
  574384
  578395
  580277
  581711
  588283
  602946
  602968
  603198
  614515
  634484
  635243
  636033
  636304
  637460
  639744
  639824
  642061
  643020
  647885
  674983
  691509
  699397
  771620
  800685
  807389
  808526
  808579
]

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 (102235, 408437, 412541, 418363, 425531, 429999, 430404, 430700, 433165, 434601, 437868, 443112, 448813, 452058, 458010, 460208, 462911, 466499, 467960, 471380, 472299, 474550, 477210, 481910, 486179, 487746, 496312, 497899, 503269, 503274, 512533, 513357, 516885, 526381, 531405, 531537, 532172, 533064, 533802, 533966, 534823, 536370, 537098, 537241, 537939, 541594, 541634, 541656, 545763, 545819, 551916, 554182, 560669, 563535, 574384, 578395, 580277, 581711, 588283, 602946, 602968, 603198, 614515, 634484, 635243, 636033, 636304, 637460, 639744, 639824, 642061, 643020, 647885, 674983, 691509, 699397, 771620, 800685, 807389, 808526, 808579);

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

[
  "mature чернокожая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature чернокожая';

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

[
  "mature чернокожая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature чернокожая';