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

[
  "deepthroat vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'deepthroat vintage' 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
  681137
  580255
  566696
  546614
  694058
  597117
  542480
  668943
  579296
  541378
  606778
  598099
  645883
  560387
  541764
  571241
  709748
  577365
  541625
  577364
  592456
  652223
  622373
  541872
  670113
  614258
  702061
  622978
  652541
  628324
  576673
  577360
  541408
  619082
  620157
  628327
  541656
  541773
  703519
  606782
  541884
  703833
  556785
  624367
  544281
  607707
  563223
  542194
  544627
  576720
  541886
  541877
  541635
  577356
  541885
  671726
  541673
  541833
  542188
  541774
  542954
  541667
  541614
  542196
  541664
  541683
  541752
  542961
  543496
  541588
  542195
  541924
  542192
  541639
  567416
  609196
  542187
  541831
  559378
  652539
  541646
]

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 (681137, 580255, 566696, 546614, 694058, 597117, 542480, 668943, 579296, 541378, 606778, 598099, 645883, 560387, 541764, 571241, 709748, 577365, 541625, 577364, 592456, 652223, 622373, 541872, 670113, 614258, 702061, 622978, 652541, 628324, 576673, 577360, 541408, 619082, 620157, 628327, 541656, 541773, 703519, 606782, 541884, 703833, 556785, 624367, 544281, 607707, 563223, 542194, 544627, 576720, 541886, 541877, 541635, 577356, 541885, 671726, 541673, 541833, 542188, 541774, 542954, 541667, 541614, 542196, 541664, 541683, 541752, 542961, 543496, 541588, 542195, 541924, 542192, 541639, 567416, 609196, 542187, 541831, 559378, 652539, 541646);

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
  541378
  541408
  541588
  541614
  541625
  541635
  541639
  541646
  541656
  541664
  541667
  541673
  541683
  541752
  541764
  541773
  541774
  541831
  541833
  541872
  541877
  541884
  541885
  541886
  541924
  542187
  542188
  542192
  542194
  542195
  542196
  542480
  542954
  542961
  543496
  544281
  544627
  546614
  556785
  559378
  560387
  563223
  566696
  567416
  571241
  576673
  576720
  577356
  577360
  577364
  577365
  579296
  580255
  592456
  597117
  598099
  606778
  606782
  607707
  609196
  614258
  619082
  620157
  622373
  622978
  624367
  628324
  628327
  645883
  652223
  652539
  652541
  668943
  670113
  671726
  681137
  694058
  702061
  703519
  703833
  709748
]

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 (541378, 541408, 541588, 541614, 541625, 541635, 541639, 541646, 541656, 541664, 541667, 541673, 541683, 541752, 541764, 541773, 541774, 541831, 541833, 541872, 541877, 541884, 541885, 541886, 541924, 542187, 542188, 542192, 542194, 542195, 542196, 542480, 542954, 542961, 543496, 544281, 544627, 546614, 556785, 559378, 560387, 563223, 566696, 567416, 571241, 576673, 576720, 577356, 577360, 577364, 577365, 579296, 580255, 592456, 597117, 598099, 606778, 606782, 607707, 609196, 614258, 619082, 620157, 622373, 622978, 624367, 628324, 628327, 645883, 652223, 652539, 652541, 668943, 670113, 671726, 681137, 694058, 702061, 703519, 703833, 709748);

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
  541378
  541408
  541588
  541614
  541625
  541635
  541639
  541646
  541656
  541664
  541667
  541673
  541683
  541752
  541764
  541773
  541774
  541831
  541833
  541872
  541877
  541884
  541885
  541886
  541924
  542187
  542188
  542192
  542194
  542195
  542196
  542480
  542954
  542961
  543496
  544281
  544627
  546614
  556785
  559378
  560387
  563223
  566696
  567416
  571241
  576673
  576720
  577356
  577360
  577364
  577365
  579296
  580255
  592456
  597117
  598099
  606778
  606782
  607707
  609196
  614258
  619082
  620157
  622373
  622978
  624367
  628324
  628327
  645883
  652223
  652539
  652541
  668943
  670113
  671726
  681137
  694058
  702061
  703519
  703833
  709748
]

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 (541378, 541408, 541588, 541614, 541625, 541635, 541639, 541646, 541656, 541664, 541667, 541673, 541683, 541752, 541764, 541773, 541774, 541831, 541833, 541872, 541877, 541884, 541885, 541886, 541924, 542187, 542188, 542192, 542194, 542195, 542196, 542480, 542954, 542961, 543496, 544281, 544627, 546614, 556785, 559378, 560387, 563223, 566696, 567416, 571241, 576673, 576720, 577356, 577360, 577364, 577365, 579296, 580255, 592456, 597117, 598099, 606778, 606782, 607707, 609196, 614258, 619082, 620157, 622373, 622978, 624367, 628324, 628327, 645883, 652223, 652539, 652541, 668943, 670113, 671726, 681137, 694058, 702061, 703519, 703833, 709748);

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

[
  "глубокийминет минет оральн секс vintage"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'глубокийминет минет оральн секс vintage';

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

[
  "глубокийминет минет оральн секс vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'глубокийминет минет оральн секс vintage';