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

[
  "sweet girl dildo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sweet girl dildo' 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
  450076
  784596
  594606
  722401
  634561
  664579
  803035
  808160
  604286
  438178
  677854
  598504
  607685
  784731
  747439
  429566
  673833
  687318
  797068
  813187
  802908
  525608
  447318
  666446
  616013
  660253
  547789
  522272
  534801
  155291
  181926
  584009
  708551
  585826
  525904
  631697
  776398
  723008
  613832
  556045
  431655
  423025
  427437
  430474
  774708
  510581
  509439
  538963
  565264
  634155
  451064
  526440
  565306
  640732
  456933
  530494
  519563
  446172
  580629
  579224
  532152
  650174
  641986
  666490
  625404
  587977
  521089
  561624
  446030
  601358
  443299
  461454
  518597
  518599
  552508
  599044
]

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 (450076, 784596, 594606, 722401, 634561, 664579, 803035, 808160, 604286, 438178, 677854, 598504, 607685, 784731, 747439, 429566, 673833, 687318, 797068, 813187, 802908, 525608, 447318, 666446, 616013, 660253, 547789, 522272, 534801, 155291, 181926, 584009, 708551, 585826, 525904, 631697, 776398, 723008, 613832, 556045, 431655, 423025, 427437, 430474, 774708, 510581, 509439, 538963, 565264, 634155, 451064, 526440, 565306, 640732, 456933, 530494, 519563, 446172, 580629, 579224, 532152, 650174, 641986, 666490, 625404, 587977, 521089, 561624, 446030, 601358, 443299, 461454, 518597, 518599, 552508, 599044);

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
  155291
  181926
  423025
  427437
  429566
  430474
  431655
  438178
  443299
  446030
  446172
  447318
  450076
  451064
  456933
  461454
  509439
  510581
  518597
  518599
  519563
  521089
  522272
  525608
  525904
  526440
  530494
  532152
  534801
  538963
  547789
  552508
  556045
  561624
  565264
  565306
  579224
  580629
  584009
  585826
  587977
  594606
  598504
  599044
  601358
  604286
  607685
  613832
  616013
  625404
  631697
  634155
  634561
  640732
  641986
  650174
  660253
  664579
  666446
  666490
  673833
  677854
  687318
  708551
  722401
  723008
  747439
  774708
  776398
  784596
  784731
  797068
  802908
  803035
  808160
  813187
]

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 (155291, 181926, 423025, 427437, 429566, 430474, 431655, 438178, 443299, 446030, 446172, 447318, 450076, 451064, 456933, 461454, 509439, 510581, 518597, 518599, 519563, 521089, 522272, 525608, 525904, 526440, 530494, 532152, 534801, 538963, 547789, 552508, 556045, 561624, 565264, 565306, 579224, 580629, 584009, 585826, 587977, 594606, 598504, 599044, 601358, 604286, 607685, 613832, 616013, 625404, 631697, 634155, 634561, 640732, 641986, 650174, 660253, 664579, 666446, 666490, 673833, 677854, 687318, 708551, 722401, 723008, 747439, 774708, 776398, 784596, 784731, 797068, 802908, 803035, 808160, 813187);

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
  155291
  181926
  423025
  427437
  429566
  430474
  431655
  438178
  443299
  446030
  446172
  447318
  450076
  451064
  456933
  461454
  509439
  510581
  518597
  518599
  519563
  521089
  522272
  525608
  525904
  526440
  530494
  532152
  534801
  538963
  547789
  552508
  556045
  561624
  565264
  565306
  579224
  580629
  584009
  585826
  587977
  594606
  598504
  599044
  601358
  604286
  607685
  613832
  616013
  625404
  631697
  634155
  634561
  640732
  641986
  650174
  660253
  664579
  666446
  666490
  673833
  677854
  687318
  708551
  722401
  723008
  747439
  774708
  776398
  784596
  784731
  797068
  802908
  803035
  808160
  813187
]

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 (155291, 181926, 423025, 427437, 429566, 430474, 431655, 438178, 443299, 446030, 446172, 447318, 450076, 451064, 456933, 461454, 509439, 510581, 518597, 518599, 519563, 521089, 522272, 525608, 525904, 526440, 530494, 532152, 534801, 538963, 547789, 552508, 556045, 561624, 565264, 565306, 579224, 580629, 584009, 585826, 587977, 594606, 598504, 599044, 601358, 604286, 607685, 613832, 616013, 625404, 631697, 634155, 634561, 640732, 641986, 650174, 660253, 664579, 666446, 666490, 673833, 677854, 687318, 708551, 722401, 723008, 747439, 774708, 776398, 784596, 784731, 797068, 802908, 803035, 808160, 813187);

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` = 'милая девушк дилд';