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

[
  "public toilet room"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'public toilet room' 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
  456546
  504132
  451654
  488336
  546778
  690932
  656862
  609419
  457129
  469648
  475556
  422438
  461006
  591847
  437934
  432728
  533328
  526154
  489046
  555533
  443068
  541080
  488335
  411698
  782301
  548023
  585425
  453187
  547969
  661268
  480095
  393274
  514615
  508386
  620121
  534823
  465859
  393122
  526548
  383687
  391792
  484222
  404608
  780266
  490293
  513375
  820627
  398281
  513828
  661317
  496192
  668451
  149573
  820652
  672765
  472375
  591272
  458716
  459157
  542764
  541029
  422095
  435882
  569561
  392157
  443403
  569241
  619362
  383366
  485187
  556865
  453028
  548422
  621973
  482917
  562941
  615680
  427327
  508746
  514902
  460443
  492779
]

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 (456546, 504132, 451654, 488336, 546778, 690932, 656862, 609419, 457129, 469648, 475556, 422438, 461006, 591847, 437934, 432728, 533328, 526154, 489046, 555533, 443068, 541080, 488335, 411698, 782301, 548023, 585425, 453187, 547969, 661268, 480095, 393274, 514615, 508386, 620121, 534823, 465859, 393122, 526548, 383687, 391792, 484222, 404608, 780266, 490293, 513375, 820627, 398281, 513828, 661317, 496192, 668451, 149573, 820652, 672765, 472375, 591272, 458716, 459157, 542764, 541029, 422095, 435882, 569561, 392157, 443403, 569241, 619362, 383366, 485187, 556865, 453028, 548422, 621973, 482917, 562941, 615680, 427327, 508746, 514902, 460443, 492779);

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
  149573
  383366
  383687
  391792
  392157
  393122
  393274
  398281
  404608
  411698
  422095
  422438
  427327
  432728
  435882
  437934
  443068
  443403
  451654
  453028
  453187
  456546
  457129
  458716
  459157
  460443
  461006
  465859
  469648
  472375
  475556
  480095
  482917
  484222
  485187
  488335
  488336
  489046
  490293
  492779
  496192
  504132
  508386
  508746
  513375
  513828
  514615
  514902
  526154
  526548
  533328
  534823
  541029
  541080
  542764
  546778
  547969
  548023
  548422
  555533
  556865
  562941
  569241
  569561
  585425
  591272
  591847
  609419
  615680
  619362
  620121
  621973
  656862
  661268
  661317
  668451
  672765
  690932
  780266
  782301
  820627
  820652
]

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 (149573, 383366, 383687, 391792, 392157, 393122, 393274, 398281, 404608, 411698, 422095, 422438, 427327, 432728, 435882, 437934, 443068, 443403, 451654, 453028, 453187, 456546, 457129, 458716, 459157, 460443, 461006, 465859, 469648, 472375, 475556, 480095, 482917, 484222, 485187, 488335, 488336, 489046, 490293, 492779, 496192, 504132, 508386, 508746, 513375, 513828, 514615, 514902, 526154, 526548, 533328, 534823, 541029, 541080, 542764, 546778, 547969, 548023, 548422, 555533, 556865, 562941, 569241, 569561, 585425, 591272, 591847, 609419, 615680, 619362, 620121, 621973, 656862, 661268, 661317, 668451, 672765, 690932, 780266, 782301, 820627, 820652);

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
  149573
  383366
  383687
  391792
  392157
  393122
  393274
  398281
  404608
  411698
  422095
  422438
  427327
  432728
  435882
  437934
  443068
  443403
  451654
  453028
  453187
  456546
  457129
  458716
  459157
  460443
  461006
  465859
  469648
  472375
  475556
  480095
  482917
  484222
  485187
  488335
  488336
  489046
  490293
  492779
  496192
  504132
  508386
  508746
  513375
  513828
  514615
  514902
  526154
  526548
  533328
  534823
  541029
  541080
  542764
  546778
  547969
  548023
  548422
  555533
  556865
  562941
  569241
  569561
  585425
  591272
  591847
  609419
  615680
  619362
  620121
  621973
  656862
  661268
  661317
  668451
  672765
  690932
  780266
  782301
  820627
  820652
]

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 (149573, 383366, 383687, 391792, 392157, 393122, 393274, 398281, 404608, 411698, 422095, 422438, 427327, 432728, 435882, 437934, 443068, 443403, 451654, 453028, 453187, 456546, 457129, 458716, 459157, 460443, 461006, 465859, 469648, 472375, 475556, 480095, 482917, 484222, 485187, 488335, 488336, 489046, 490293, 492779, 496192, 504132, 508386, 508746, 513375, 513828, 514615, 514902, 526154, 526548, 533328, 534823, 541029, 541080, 542764, 546778, 547969, 548023, 548422, 555533, 556865, 562941, 569241, 569561, 585425, 591272, 591847, 609419, 615680, 619362, 620121, 621973, 656862, 661268, 661317, 668451, 672765, 690932, 780266, 782301, 820627, 820652);

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

[
  "на улиц туалет room"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'на улиц туалет room';

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

[
  "на улиц туалет room"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'на улиц туалет room';