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
  567419
  554465
  562596
  563134
  669778
  672954
  681301
  667261
  663420
  668943
  549226
  549234
  565677
  580318
  583696
  593059
  610002
  614412
  615907
  599227
  594920
  624853
  618513
  612316
  484375
  154410
  465635
  483145
  486530
  489399
  500458
  524883
  525484
  524900
  527947
  531076
  494282
  500480
  505688
  514902
  567424
  562890
  543924
  663856
  667646
  667219
  593529
  599172
  624793
  593347
  624468
  602668
  606349
  491022
  454277
  522619
  522596
  526212
  527676
  477200
  573335
  554770
  564292
  566153
  678782
  554973
  640687
  471439
  518858
  498019
  504386
  517067
  480749
  480290
  522616
]

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 (567419, 554465, 562596, 563134, 669778, 672954, 681301, 667261, 663420, 668943, 549226, 549234, 565677, 580318, 583696, 593059, 610002, 614412, 615907, 599227, 594920, 624853, 618513, 612316, 484375, 154410, 465635, 483145, 486530, 489399, 500458, 524883, 525484, 524900, 527947, 531076, 494282, 500480, 505688, 514902, 567424, 562890, 543924, 663856, 667646, 667219, 593529, 599172, 624793, 593347, 624468, 602668, 606349, 491022, 454277, 522619, 522596, 526212, 527676, 477200, 573335, 554770, 564292, 566153, 678782, 554973, 640687, 471439, 518858, 498019, 504386, 517067, 480749, 480290, 522616);

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
  154410
  454277
  465635
  471439
  477200
  480290
  480749
  483145
  484375
  486530
  489399
  491022
  494282
  498019
  500458
  500480
  504386
  505688
  514902
  517067
  518858
  522596
  522616
  522619
  524883
  524900
  525484
  526212
  527676
  527947
  531076
  543924
  549226
  549234
  554465
  554770
  554973
  562596
  562890
  563134
  564292
  565677
  566153
  567419
  567424
  573335
  580318
  583696
  593059
  593347
  593529
  594920
  599172
  599227
  602668
  606349
  610002
  612316
  614412
  615907
  618513
  624468
  624793
  624853
  640687
  663420
  663856
  667219
  667261
  667646
  668943
  669778
  672954
  678782
  681301
]

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 (154410, 454277, 465635, 471439, 477200, 480290, 480749, 483145, 484375, 486530, 489399, 491022, 494282, 498019, 500458, 500480, 504386, 505688, 514902, 517067, 518858, 522596, 522616, 522619, 524883, 524900, 525484, 526212, 527676, 527947, 531076, 543924, 549226, 549234, 554465, 554770, 554973, 562596, 562890, 563134, 564292, 565677, 566153, 567419, 567424, 573335, 580318, 583696, 593059, 593347, 593529, 594920, 599172, 599227, 602668, 606349, 610002, 612316, 614412, 615907, 618513, 624468, 624793, 624853, 640687, 663420, 663856, 667219, 667261, 667646, 668943, 669778, 672954, 678782, 681301);

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
  154410
  454277
  465635
  471439
  477200
  480290
  480749
  483145
  484375
  486530
  489399
  491022
  494282
  498019
  500458
  500480
  504386
  505688
  514902
  517067
  518858
  522596
  522616
  522619
  524883
  524900
  525484
  526212
  527676
  527947
  531076
  543924
  549226
  549234
  554465
  554770
  554973
  562596
  562890
  563134
  564292
  565677
  566153
  567419
  567424
  573335
  580318
  583696
  593059
  593347
  593529
  594920
  599172
  599227
  602668
  606349
  610002
  612316
  614412
  615907
  618513
  624468
  624793
  624853
  640687
  663420
  663856
  667219
  667261
  667646
  668943
  669778
  672954
  678782
  681301
]

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 (154410, 454277, 465635, 471439, 477200, 480290, 480749, 483145, 484375, 486530, 489399, 491022, 494282, 498019, 500458, 500480, 504386, 505688, 514902, 517067, 518858, 522596, 522616, 522619, 524883, 524900, 525484, 526212, 527676, 527947, 531076, 543924, 549226, 549234, 554465, 554770, 554973, 562596, 562890, 563134, 564292, 565677, 566153, 567419, 567424, 573335, 580318, 583696, 593059, 593347, 593529, 594920, 599172, 599227, 602668, 606349, 610002, 612316, 614412, 615907, 618513, 624468, 624793, 624853, 640687, 663420, 663856, 667219, 667261, 667646, 668943, 669778, 672954, 678782, 681301);

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` = 'сосет бабушк';