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

[
  "довела парня"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'довела парня' 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
  575459
  563396
  596658
  612668
  600149
  525226
  555953
  494815
  569581
  570604
  425028
  613316
  613970
  595500
  601906
  485315
  563087
  653455
  562995
  565351
  571027
  572885
  576095
  565185
  574244
  589721
  604003
  627074
  519345
  525525
  509100
  520445
  511837
  542903
  561092
  618371
  398877
  499878
  514311
  528766
  627700
  537198
  565679
  556531
  652869
  549214
  551388
  576240
  598500
  606217
  598844
  408675
  480521
  472474
  539336
  561328
  546757
  579038
  653557
  659272
  621946
  603159
  465394
  427550
  488904
  496569
  516214
  509802
  602916
  430553
  516308
  524848
  514070
  565186
]

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 (575459, 563396, 596658, 612668, 600149, 525226, 555953, 494815, 569581, 570604, 425028, 613316, 613970, 595500, 601906, 485315, 563087, 653455, 562995, 565351, 571027, 572885, 576095, 565185, 574244, 589721, 604003, 627074, 519345, 525525, 509100, 520445, 511837, 542903, 561092, 618371, 398877, 499878, 514311, 528766, 627700, 537198, 565679, 556531, 652869, 549214, 551388, 576240, 598500, 606217, 598844, 408675, 480521, 472474, 539336, 561328, 546757, 579038, 653557, 659272, 621946, 603159, 465394, 427550, 488904, 496569, 516214, 509802, 602916, 430553, 516308, 524848, 514070, 565186);

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
  398877
  408675
  425028
  427550
  430553
  465394
  472474
  480521
  485315
  488904
  494815
  496569
  499878
  509100
  509802
  511837
  514070
  514311
  516214
  516308
  519345
  520445
  524848
  525226
  525525
  528766
  537198
  539336
  542903
  546757
  549214
  551388
  555953
  556531
  561092
  561328
  562995
  563087
  563396
  565185
  565186
  565351
  565679
  569581
  570604
  571027
  572885
  574244
  575459
  576095
  576240
  579038
  589721
  595500
  596658
  598500
  598844
  600149
  601906
  602916
  603159
  604003
  606217
  612668
  613316
  613970
  618371
  621946
  627074
  627700
  652869
  653455
  653557
  659272
]

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 (398877, 408675, 425028, 427550, 430553, 465394, 472474, 480521, 485315, 488904, 494815, 496569, 499878, 509100, 509802, 511837, 514070, 514311, 516214, 516308, 519345, 520445, 524848, 525226, 525525, 528766, 537198, 539336, 542903, 546757, 549214, 551388, 555953, 556531, 561092, 561328, 562995, 563087, 563396, 565185, 565186, 565351, 565679, 569581, 570604, 571027, 572885, 574244, 575459, 576095, 576240, 579038, 589721, 595500, 596658, 598500, 598844, 600149, 601906, 602916, 603159, 604003, 606217, 612668, 613316, 613970, 618371, 621946, 627074, 627700, 652869, 653455, 653557, 659272);

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
  398877
  408675
  425028
  427550
  430553
  465394
  472474
  480521
  485315
  488904
  494815
  496569
  499878
  509100
  509802
  511837
  514070
  514311
  516214
  516308
  519345
  520445
  524848
  525226
  525525
  528766
  537198
  539336
  542903
  546757
  549214
  551388
  555953
  556531
  561092
  561328
  562995
  563087
  563396
  565185
  565186
  565351
  565679
  569581
  570604
  571027
  572885
  574244
  575459
  576095
  576240
  579038
  589721
  595500
  596658
  598500
  598844
  600149
  601906
  602916
  603159
  604003
  606217
  612668
  613316
  613970
  618371
  621946
  627074
  627700
  652869
  653455
  653557
  659272
]

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 (398877, 408675, 425028, 427550, 430553, 465394, 472474, 480521, 485315, 488904, 494815, 496569, 499878, 509100, 509802, 511837, 514070, 514311, 516214, 516308, 519345, 520445, 524848, 525226, 525525, 528766, 537198, 539336, 542903, 546757, 549214, 551388, 555953, 556531, 561092, 561328, 562995, 563087, 563396, 565185, 565186, 565351, 565679, 569581, 570604, 571027, 572885, 574244, 575459, 576095, 576240, 579038, 589721, 595500, 596658, 598500, 598844, 600149, 601906, 602916, 603159, 604003, 606217, 612668, 613316, 613970, 618371, 621946, 627074, 627700, 652869, 653455, 653557, 659272);

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

[
  "довел парен"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'довел парен';

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

[
  "довел парен"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'довел парен';