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

[
  "asian milf минет"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'asian milf минет' 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
  152234
  412964
  499791
  801890
  614993
  534239
  541593
  649559
  717278
  668459
  586672
  563535
  430828
  396817
  714578
  803268
  489167
  642063
  519497
  631019
  772970
  815137
  503043
  813110
  804677
  455975
  483394
  709117
  506731
  752596
  483014
  583851
  301259
  785525
  494059
  603929
  631214
  418051
  425993
  668467
  566498
  785711
  729751
  665781
  594760
  568061
  388915
  505756
  563656
  757362
  517278
  384368
  542189
  497656
  600577
  609121
  600502
  455981
  560136
  596730
  455967
  455184
  455978
  444838
  677712
  538653
  583247
  647162
  701206
  541849
  455245
  663539
  503479
  541863
  623261
  460327
  502511
  592277
  484299
  502533
]

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 (152234, 412964, 499791, 801890, 614993, 534239, 541593, 649559, 717278, 668459, 586672, 563535, 430828, 396817, 714578, 803268, 489167, 642063, 519497, 631019, 772970, 815137, 503043, 813110, 804677, 455975, 483394, 709117, 506731, 752596, 483014, 583851, 301259, 785525, 494059, 603929, 631214, 418051, 425993, 668467, 566498, 785711, 729751, 665781, 594760, 568061, 388915, 505756, 563656, 757362, 517278, 384368, 542189, 497656, 600577, 609121, 600502, 455981, 560136, 596730, 455967, 455184, 455978, 444838, 677712, 538653, 583247, 647162, 701206, 541849, 455245, 663539, 503479, 541863, 623261, 460327, 502511, 592277, 484299, 502533);

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
  152234
  301259
  384368
  388915
  396817
  412964
  418051
  425993
  430828
  444838
  455184
  455245
  455967
  455975
  455978
  455981
  460327
  483014
  483394
  484299
  489167
  494059
  497656
  499791
  502511
  502533
  503043
  503479
  505756
  506731
  517278
  519497
  534239
  538653
  541593
  541849
  541863
  542189
  560136
  563535
  563656
  566498
  568061
  583247
  583851
  586672
  592277
  594760
  596730
  600502
  600577
  603929
  609121
  614993
  623261
  631019
  631214
  642063
  647162
  649559
  663539
  665781
  668459
  668467
  677712
  701206
  709117
  714578
  717278
  729751
  752596
  757362
  772970
  785525
  785711
  801890
  803268
  804677
  813110
  815137
]

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 (152234, 301259, 384368, 388915, 396817, 412964, 418051, 425993, 430828, 444838, 455184, 455245, 455967, 455975, 455978, 455981, 460327, 483014, 483394, 484299, 489167, 494059, 497656, 499791, 502511, 502533, 503043, 503479, 505756, 506731, 517278, 519497, 534239, 538653, 541593, 541849, 541863, 542189, 560136, 563535, 563656, 566498, 568061, 583247, 583851, 586672, 592277, 594760, 596730, 600502, 600577, 603929, 609121, 614993, 623261, 631019, 631214, 642063, 647162, 649559, 663539, 665781, 668459, 668467, 677712, 701206, 709117, 714578, 717278, 729751, 752596, 757362, 772970, 785525, 785711, 801890, 803268, 804677, 813110, 815137);

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
  152234
  301259
  384368
  388915
  396817
  412964
  418051
  425993
  430828
  444838
  455184
  455245
  455967
  455975
  455978
  455981
  460327
  483014
  483394
  484299
  489167
  494059
  497656
  499791
  502511
  502533
  503043
  503479
  505756
  506731
  517278
  519497
  534239
  538653
  541593
  541849
  541863
  542189
  560136
  563535
  563656
  566498
  568061
  583247
  583851
  586672
  592277
  594760
  596730
  600502
  600577
  603929
  609121
  614993
  623261
  631019
  631214
  642063
  647162
  649559
  663539
  665781
  668459
  668467
  677712
  701206
  709117
  714578
  717278
  729751
  752596
  757362
  772970
  785525
  785711
  801890
  803268
  804677
  813110
  815137
]

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 (152234, 301259, 384368, 388915, 396817, 412964, 418051, 425993, 430828, 444838, 455184, 455245, 455967, 455975, 455978, 455981, 460327, 483014, 483394, 484299, 489167, 494059, 497656, 499791, 502511, 502533, 503043, 503479, 505756, 506731, 517278, 519497, 534239, 538653, 541593, 541849, 541863, 542189, 560136, 563535, 563656, 566498, 568061, 583247, 583851, 586672, 592277, 594760, 596730, 600502, 600577, 603929, 609121, 614993, 623261, 631019, 631214, 642063, 647162, 649559, 663539, 665781, 668459, 668467, 677712, 701206, 709117, 714578, 717278, 729751, 752596, 757362, 772970, 785525, 785711, 801890, 803268, 804677, 813110, 815137);

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

[
  "азиатк milf минет оральн секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'азиатк milf минет оральн секс';

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

[
  "азиатк milf минет оральн секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'азиатк milf минет оральн секс';