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

[
  "redhead glasses"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'redhead glasses' 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
  520600
  523568
  500996
  515193
  516775
  476227
  493835
  551922
  570719
  663348
  691409
  549234
  559678
  590289
  589747
  615575
  612472
  811090
  770329
  475874
  467542
  415546
  430816
  466018
  491747
  387039
  438001
  485463
  489712
  524900
  579677
  544937
  552616
  558286
  581665
  677125
  668668
  554358
  628314
  638576
  593604
  604040
  619423
  445836
  408283
  486887
  520701
  528010
  523056
  386218
  482516
  556728
  557181
  668394
  710524
  610096
  603642
  474941
  471365
  483342
  458327
  526103
  465524
  551069
  591033
  603286
  606482
  538485
  516760
  533613
  457064
  578823
  605496
  617198
  430404
  527447
  489950
  622778
  434601
  508150
]

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 (520600, 523568, 500996, 515193, 516775, 476227, 493835, 551922, 570719, 663348, 691409, 549234, 559678, 590289, 589747, 615575, 612472, 811090, 770329, 475874, 467542, 415546, 430816, 466018, 491747, 387039, 438001, 485463, 489712, 524900, 579677, 544937, 552616, 558286, 581665, 677125, 668668, 554358, 628314, 638576, 593604, 604040, 619423, 445836, 408283, 486887, 520701, 528010, 523056, 386218, 482516, 556728, 557181, 668394, 710524, 610096, 603642, 474941, 471365, 483342, 458327, 526103, 465524, 551069, 591033, 603286, 606482, 538485, 516760, 533613, 457064, 578823, 605496, 617198, 430404, 527447, 489950, 622778, 434601, 508150);

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
  386218
  387039
  408283
  415546
  430404
  430816
  434601
  438001
  445836
  457064
  458327
  465524
  466018
  467542
  471365
  474941
  475874
  476227
  482516
  483342
  485463
  486887
  489712
  489950
  491747
  493835
  500996
  508150
  515193
  516760
  516775
  520600
  520701
  523056
  523568
  524900
  526103
  527447
  528010
  533613
  538485
  544937
  549234
  551069
  551922
  552616
  554358
  556728
  557181
  558286
  559678
  570719
  578823
  579677
  581665
  589747
  590289
  591033
  593604
  603286
  603642
  604040
  605496
  606482
  610096
  612472
  615575
  617198
  619423
  622778
  628314
  638576
  663348
  668394
  668668
  677125
  691409
  710524
  770329
  811090
]

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 (386218, 387039, 408283, 415546, 430404, 430816, 434601, 438001, 445836, 457064, 458327, 465524, 466018, 467542, 471365, 474941, 475874, 476227, 482516, 483342, 485463, 486887, 489712, 489950, 491747, 493835, 500996, 508150, 515193, 516760, 516775, 520600, 520701, 523056, 523568, 524900, 526103, 527447, 528010, 533613, 538485, 544937, 549234, 551069, 551922, 552616, 554358, 556728, 557181, 558286, 559678, 570719, 578823, 579677, 581665, 589747, 590289, 591033, 593604, 603286, 603642, 604040, 605496, 606482, 610096, 612472, 615575, 617198, 619423, 622778, 628314, 638576, 663348, 668394, 668668, 677125, 691409, 710524, 770329, 811090);

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
  386218
  387039
  408283
  415546
  430404
  430816
  434601
  438001
  445836
  457064
  458327
  465524
  466018
  467542
  471365
  474941
  475874
  476227
  482516
  483342
  485463
  486887
  489712
  489950
  491747
  493835
  500996
  508150
  515193
  516760
  516775
  520600
  520701
  523056
  523568
  524900
  526103
  527447
  528010
  533613
  538485
  544937
  549234
  551069
  551922
  552616
  554358
  556728
  557181
  558286
  559678
  570719
  578823
  579677
  581665
  589747
  590289
  591033
  593604
  603286
  603642
  604040
  605496
  606482
  610096
  612472
  615575
  617198
  619423
  622778
  628314
  638576
  663348
  668394
  668668
  677125
  691409
  710524
  770329
  811090
]

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 (386218, 387039, 408283, 415546, 430404, 430816, 434601, 438001, 445836, 457064, 458327, 465524, 466018, 467542, 471365, 474941, 475874, 476227, 482516, 483342, 485463, 486887, 489712, 489950, 491747, 493835, 500996, 508150, 515193, 516760, 516775, 520600, 520701, 523056, 523568, 524900, 526103, 527447, 528010, 533613, 538485, 544937, 549234, 551069, 551922, 552616, 554358, 556728, 557181, 558286, 559678, 570719, 578823, 579677, 581665, 589747, 590289, 591033, 593604, 603286, 603642, 604040, 605496, 606482, 610096, 612472, 615575, 617198, 619423, 622778, 628314, 638576, 663348, 668394, 668668, 677125, 691409, 710524, 770329, 811090);

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` = 'рыжая очкастая';