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

[
  "son jerking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'son jerking' 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
  464329
  439587
  439695
  511369
  504968
  428881
  417990
  446269
  524626
  687437
  482251
  477337
  433070
  518046
  516480
  521997
  505973
  425347
  532682
  422211
  426994
  453721
  397530
  465824
  458928
  471109
  506833
  716927
  566928
  443832
  428137
  414946
  421825
  516478
  529157
  516886
  492096
  421155
  463215
  429561
  515717
  489941
  450319
  512369
  544420
  549821
  563438
  568344
  582372
  400191
  473248
  474777
  439633
  523907
  519936
  504927
  434608
  507884
  539759
  550633
  549829
  620265
  432807
  421827
  516481
  507047
  563450
  630475
  401064
  422208
  512539
  563218
  439565
  613275
  621655
  485265
  599703
  519023
]

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 (464329, 439587, 439695, 511369, 504968, 428881, 417990, 446269, 524626, 687437, 482251, 477337, 433070, 518046, 516480, 521997, 505973, 425347, 532682, 422211, 426994, 453721, 397530, 465824, 458928, 471109, 506833, 716927, 566928, 443832, 428137, 414946, 421825, 516478, 529157, 516886, 492096, 421155, 463215, 429561, 515717, 489941, 450319, 512369, 544420, 549821, 563438, 568344, 582372, 400191, 473248, 474777, 439633, 523907, 519936, 504927, 434608, 507884, 539759, 550633, 549829, 620265, 432807, 421827, 516481, 507047, 563450, 630475, 401064, 422208, 512539, 563218, 439565, 613275, 621655, 485265, 599703, 519023);

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
  397530
  400191
  401064
  414946
  417990
  421155
  421825
  421827
  422208
  422211
  425347
  426994
  428137
  428881
  429561
  432807
  433070
  434608
  439565
  439587
  439633
  439695
  443832
  446269
  450319
  453721
  458928
  463215
  464329
  465824
  471109
  473248
  474777
  477337
  482251
  485265
  489941
  492096
  504927
  504968
  505973
  506833
  507047
  507884
  511369
  512369
  512539
  515717
  516478
  516480
  516481
  516886
  518046
  519023
  519936
  521997
  523907
  524626
  529157
  532682
  539759
  544420
  549821
  549829
  550633
  563218
  563438
  563450
  566928
  568344
  582372
  599703
  613275
  620265
  621655
  630475
  687437
  716927
]

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 (397530, 400191, 401064, 414946, 417990, 421155, 421825, 421827, 422208, 422211, 425347, 426994, 428137, 428881, 429561, 432807, 433070, 434608, 439565, 439587, 439633, 439695, 443832, 446269, 450319, 453721, 458928, 463215, 464329, 465824, 471109, 473248, 474777, 477337, 482251, 485265, 489941, 492096, 504927, 504968, 505973, 506833, 507047, 507884, 511369, 512369, 512539, 515717, 516478, 516480, 516481, 516886, 518046, 519023, 519936, 521997, 523907, 524626, 529157, 532682, 539759, 544420, 549821, 549829, 550633, 563218, 563438, 563450, 566928, 568344, 582372, 599703, 613275, 620265, 621655, 630475, 687437, 716927);

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
  397530
  400191
  401064
  414946
  417990
  421155
  421825
  421827
  422208
  422211
  425347
  426994
  428137
  428881
  429561
  432807
  433070
  434608
  439565
  439587
  439633
  439695
  443832
  446269
  450319
  453721
  458928
  463215
  464329
  465824
  471109
  473248
  474777
  477337
  482251
  485265
  489941
  492096
  504927
  504968
  505973
  506833
  507047
  507884
  511369
  512369
  512539
  515717
  516478
  516480
  516481
  516886
  518046
  519023
  519936
  521997
  523907
  524626
  529157
  532682
  539759
  544420
  549821
  549829
  550633
  563218
  563438
  563450
  566928
  568344
  582372
  599703
  613275
  620265
  621655
  630475
  687437
  716927
]

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 (397530, 400191, 401064, 414946, 417990, 421155, 421825, 421827, 422208, 422211, 425347, 426994, 428137, 428881, 429561, 432807, 433070, 434608, 439565, 439587, 439633, 439695, 443832, 446269, 450319, 453721, 458928, 463215, 464329, 465824, 471109, 473248, 474777, 477337, 482251, 485265, 489941, 492096, 504927, 504968, 505973, 506833, 507047, 507884, 511369, 512369, 512539, 515717, 516478, 516480, 516481, 516886, 518046, 519023, 519936, 521997, 523907, 524626, 529157, 532682, 539759, 544420, 549821, 549829, 550633, 563218, 563438, 563450, 566928, 568344, 582372, 599703, 613275, 620265, 621655, 630475, 687437, 716927);

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

[
  "son дрочк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'son дрочк';

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

[
  "son дрочк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'son дрочк';