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

[
  "rough anal skinny"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rough anal skinny' 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
  604061
  606801
  439844
  666548
  601641
  609682
  640801
  439800
  573261
  647872
  489372
  536789
  542590
  558820
  590633
  592645
  520739
  606798
  622402
  439049
  535505
  501313
  540518
  582323
  541197
  586596
  811497
  425878
  523205
  545341
  530681
  536586
  666881
  600290
  523996
  527975
  645276
  537654
  583670
  593863
  604289
  627725
  473539
  503419
  530696
  676087
  600206
  439845
  632978
  634153
  597819
  526199
  544840
  599966
  543659
  628371
  533948
  628336
  716220
  810109
  630221
  524508
  539203
  555789
  628383
  570736
  677783
  419627
  590444
  565501
  472845
  545418
  556741
  707391
  628333
  630531
  554119
  510371
  616994
  496086
  581968
  526203
  593992
  646826
]

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 (604061, 606801, 439844, 666548, 601641, 609682, 640801, 439800, 573261, 647872, 489372, 536789, 542590, 558820, 590633, 592645, 520739, 606798, 622402, 439049, 535505, 501313, 540518, 582323, 541197, 586596, 811497, 425878, 523205, 545341, 530681, 536586, 666881, 600290, 523996, 527975, 645276, 537654, 583670, 593863, 604289, 627725, 473539, 503419, 530696, 676087, 600206, 439845, 632978, 634153, 597819, 526199, 544840, 599966, 543659, 628371, 533948, 628336, 716220, 810109, 630221, 524508, 539203, 555789, 628383, 570736, 677783, 419627, 590444, 565501, 472845, 545418, 556741, 707391, 628333, 630531, 554119, 510371, 616994, 496086, 581968, 526203, 593992, 646826);

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
  419627
  425878
  439049
  439800
  439844
  439845
  472845
  473539
  489372
  496086
  501313
  503419
  510371
  520739
  523205
  523996
  524508
  526199
  526203
  527975
  530681
  530696
  533948
  535505
  536586
  536789
  537654
  539203
  540518
  541197
  542590
  543659
  544840
  545341
  545418
  554119
  555789
  556741
  558820
  565501
  570736
  573261
  581968
  582323
  583670
  586596
  590444
  590633
  592645
  593863
  593992
  597819
  599966
  600206
  600290
  601641
  604061
  604289
  606798
  606801
  609682
  616994
  622402
  627725
  628333
  628336
  628371
  628383
  630221
  630531
  632978
  634153
  640801
  645276
  646826
  647872
  666548
  666881
  676087
  677783
  707391
  716220
  810109
  811497
]

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 (419627, 425878, 439049, 439800, 439844, 439845, 472845, 473539, 489372, 496086, 501313, 503419, 510371, 520739, 523205, 523996, 524508, 526199, 526203, 527975, 530681, 530696, 533948, 535505, 536586, 536789, 537654, 539203, 540518, 541197, 542590, 543659, 544840, 545341, 545418, 554119, 555789, 556741, 558820, 565501, 570736, 573261, 581968, 582323, 583670, 586596, 590444, 590633, 592645, 593863, 593992, 597819, 599966, 600206, 600290, 601641, 604061, 604289, 606798, 606801, 609682, 616994, 622402, 627725, 628333, 628336, 628371, 628383, 630221, 630531, 632978, 634153, 640801, 645276, 646826, 647872, 666548, 666881, 676087, 677783, 707391, 716220, 810109, 811497);

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
  419627
  425878
  439049
  439800
  439844
  439845
  472845
  473539
  489372
  496086
  501313
  503419
  510371
  520739
  523205
  523996
  524508
  526199
  526203
  527975
  530681
  530696
  533948
  535505
  536586
  536789
  537654
  539203
  540518
  541197
  542590
  543659
  544840
  545341
  545418
  554119
  555789
  556741
  558820
  565501
  570736
  573261
  581968
  582323
  583670
  586596
  590444
  590633
  592645
  593863
  593992
  597819
  599966
  600206
  600290
  601641
  604061
  604289
  606798
  606801
  609682
  616994
  622402
  627725
  628333
  628336
  628371
  628383
  630221
  630531
  632978
  634153
  640801
  645276
  646826
  647872
  666548
  666881
  676087
  677783
  707391
  716220
  810109
  811497
]

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 (419627, 425878, 439049, 439800, 439844, 439845, 472845, 473539, 489372, 496086, 501313, 503419, 510371, 520739, 523205, 523996, 524508, 526199, 526203, 527975, 530681, 530696, 533948, 535505, 536586, 536789, 537654, 539203, 540518, 541197, 542590, 543659, 544840, 545341, 545418, 554119, 555789, 556741, 558820, 565501, 570736, 573261, 581968, 582323, 583670, 586596, 590444, 590633, 592645, 593863, 593992, 597819, 599966, 600206, 600290, 601641, 604061, 604289, 606798, 606801, 609682, 616994, 622402, 627725, 628333, 628336, 628371, 628383, 630221, 630531, 632978, 634153, 640801, 645276, 646826, 647872, 666548, 666881, 676087, 677783, 707391, 716220, 810109, 811497);

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

[
  "rough анал худые"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'rough анал худые';

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

[
  "rough анал худые"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rough анал худые';