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

[
  "rus boys sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rus boys sex' 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
  395955
  563204
  619235
  443680
  409346
  384878
  233369
  232940
  558247
  418338
  411726
  581424
  558020
  462329
  411694
  443786
  797825
  443685
  443748
  692450
  443130
  575177
  443772
  484718
  510533
  550351
  391941
  782253
  443789
  479027
  483360
  484657
  496028
  391262
  454268
  466164
  620264
  518842
  516562
  485916
  526738
  423940
  484381
  479049
  559060
  443741
  460736
  560430
  550229
  467626
  474650
  462702
  484459
  484669
  470987
  484609
  443767
  510750
  484392
  514681
  552343
  484655
  454277
  484730
  484660
  470481
  484643
  465828
  466014
  476251
  484402
  466069
  484656
  485735
  646838
  484713
  484708
  460739
  602569
  546114
]

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 (395955, 563204, 619235, 443680, 409346, 384878, 233369, 232940, 558247, 418338, 411726, 581424, 558020, 462329, 411694, 443786, 797825, 443685, 443748, 692450, 443130, 575177, 443772, 484718, 510533, 550351, 391941, 782253, 443789, 479027, 483360, 484657, 496028, 391262, 454268, 466164, 620264, 518842, 516562, 485916, 526738, 423940, 484381, 479049, 559060, 443741, 460736, 560430, 550229, 467626, 474650, 462702, 484459, 484669, 470987, 484609, 443767, 510750, 484392, 514681, 552343, 484655, 454277, 484730, 484660, 470481, 484643, 465828, 466014, 476251, 484402, 466069, 484656, 485735, 646838, 484713, 484708, 460739, 602569, 546114);

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
  232940
  233369
  384878
  391262
  391941
  395955
  409346
  411694
  411726
  418338
  423940
  443130
  443680
  443685
  443741
  443748
  443767
  443772
  443786
  443789
  454268
  454277
  460736
  460739
  462329
  462702
  465828
  466014
  466069
  466164
  467626
  470481
  470987
  474650
  476251
  479027
  479049
  483360
  484381
  484392
  484402
  484459
  484609
  484643
  484655
  484656
  484657
  484660
  484669
  484708
  484713
  484718
  484730
  485735
  485916
  496028
  510533
  510750
  514681
  516562
  518842
  526738
  546114
  550229
  550351
  552343
  558020
  558247
  559060
  560430
  563204
  575177
  581424
  602569
  619235
  620264
  646838
  692450
  782253
  797825
]

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 (232940, 233369, 384878, 391262, 391941, 395955, 409346, 411694, 411726, 418338, 423940, 443130, 443680, 443685, 443741, 443748, 443767, 443772, 443786, 443789, 454268, 454277, 460736, 460739, 462329, 462702, 465828, 466014, 466069, 466164, 467626, 470481, 470987, 474650, 476251, 479027, 479049, 483360, 484381, 484392, 484402, 484459, 484609, 484643, 484655, 484656, 484657, 484660, 484669, 484708, 484713, 484718, 484730, 485735, 485916, 496028, 510533, 510750, 514681, 516562, 518842, 526738, 546114, 550229, 550351, 552343, 558020, 558247, 559060, 560430, 563204, 575177, 581424, 602569, 619235, 620264, 646838, 692450, 782253, 797825);

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
  232940
  233369
  384878
  391262
  391941
  395955
  409346
  411694
  411726
  418338
  423940
  443130
  443680
  443685
  443741
  443748
  443767
  443772
  443786
  443789
  454268
  454277
  460736
  460739
  462329
  462702
  465828
  466014
  466069
  466164
  467626
  470481
  470987
  474650
  476251
  479027
  479049
  483360
  484381
  484392
  484402
  484459
  484609
  484643
  484655
  484656
  484657
  484660
  484669
  484708
  484713
  484718
  484730
  485735
  485916
  496028
  510533
  510750
  514681
  516562
  518842
  526738
  546114
  550229
  550351
  552343
  558020
  558247
  559060
  560430
  563204
  575177
  581424
  602569
  619235
  620264
  646838
  692450
  782253
  797825
]

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 (232940, 233369, 384878, 391262, 391941, 395955, 409346, 411694, 411726, 418338, 423940, 443130, 443680, 443685, 443741, 443748, 443767, 443772, 443786, 443789, 454268, 454277, 460736, 460739, 462329, 462702, 465828, 466014, 466069, 466164, 467626, 470481, 470987, 474650, 476251, 479027, 479049, 483360, 484381, 484392, 484402, 484459, 484609, 484643, 484655, 484656, 484657, 484660, 484669, 484708, 484713, 484718, 484730, 485735, 485916, 496028, 510533, 510750, 514681, 516562, 518842, 526738, 546114, 550229, 550351, 552343, 558020, 558247, 559060, 560430, 563204, 575177, 581424, 602569, 619235, 620264, 646838, 692450, 782253, 797825);

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

[
  "русск boys секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск boys секс';

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

[
  "русск boys секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск boys секс';