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

[
  "amateur hidden camera"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur hidden camera' 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
  433904
  618234
  432743
  758329
  414135
  472695
  455596
  417839
  448282
  519319
  410770
  483227
  559110
  608363
  753993
  430713
  620318
  789767
  744711
  522517
  568283
  432728
  702525
  432699
  417493
  418574
  432707
  418572
  525881
  497611
  579856
  599772
  727027
  521493
  504696
  425821
  520319
  516283
  534159
  789141
  529898
  529905
  559087
  464196
  519610
  488207
  567756
  570952
  455471
  492939
  522975
  446690
  528445
  484256
  455804
  520342
  432631
  490152
  506440
  525349
  456892
  455300
  458149
  457523
  507034
  473333
  462210
  481461
  459472
  459485
  517065
  453704
  458883
  806435
  454536
  516387
  528144
  455601
  496119
  628273
  452251
]

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 (433904, 618234, 432743, 758329, 414135, 472695, 455596, 417839, 448282, 519319, 410770, 483227, 559110, 608363, 753993, 430713, 620318, 789767, 744711, 522517, 568283, 432728, 702525, 432699, 417493, 418574, 432707, 418572, 525881, 497611, 579856, 599772, 727027, 521493, 504696, 425821, 520319, 516283, 534159, 789141, 529898, 529905, 559087, 464196, 519610, 488207, 567756, 570952, 455471, 492939, 522975, 446690, 528445, 484256, 455804, 520342, 432631, 490152, 506440, 525349, 456892, 455300, 458149, 457523, 507034, 473333, 462210, 481461, 459472, 459485, 517065, 453704, 458883, 806435, 454536, 516387, 528144, 455601, 496119, 628273, 452251);

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
  410770
  414135
  417493
  417839
  418572
  418574
  425821
  430713
  432631
  432699
  432707
  432728
  432743
  433904
  446690
  448282
  452251
  453704
  454536
  455300
  455471
  455596
  455601
  455804
  456892
  457523
  458149
  458883
  459472
  459485
  462210
  464196
  472695
  473333
  481461
  483227
  484256
  488207
  490152
  492939
  496119
  497611
  504696
  506440
  507034
  516283
  516387
  517065
  519319
  519610
  520319
  520342
  521493
  522517
  522975
  525349
  525881
  528144
  528445
  529898
  529905
  534159
  559087
  559110
  567756
  568283
  570952
  579856
  599772
  608363
  618234
  620318
  628273
  702525
  727027
  744711
  753993
  758329
  789141
  789767
  806435
]

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 (410770, 414135, 417493, 417839, 418572, 418574, 425821, 430713, 432631, 432699, 432707, 432728, 432743, 433904, 446690, 448282, 452251, 453704, 454536, 455300, 455471, 455596, 455601, 455804, 456892, 457523, 458149, 458883, 459472, 459485, 462210, 464196, 472695, 473333, 481461, 483227, 484256, 488207, 490152, 492939, 496119, 497611, 504696, 506440, 507034, 516283, 516387, 517065, 519319, 519610, 520319, 520342, 521493, 522517, 522975, 525349, 525881, 528144, 528445, 529898, 529905, 534159, 559087, 559110, 567756, 568283, 570952, 579856, 599772, 608363, 618234, 620318, 628273, 702525, 727027, 744711, 753993, 758329, 789141, 789767, 806435);

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
  410770
  414135
  417493
  417839
  418572
  418574
  425821
  430713
  432631
  432699
  432707
  432728
  432743
  433904
  446690
  448282
  452251
  453704
  454536
  455300
  455471
  455596
  455601
  455804
  456892
  457523
  458149
  458883
  459472
  459485
  462210
  464196
  472695
  473333
  481461
  483227
  484256
  488207
  490152
  492939
  496119
  497611
  504696
  506440
  507034
  516283
  516387
  517065
  519319
  519610
  520319
  520342
  521493
  522517
  522975
  525349
  525881
  528144
  528445
  529898
  529905
  534159
  559087
  559110
  567756
  568283
  570952
  579856
  599772
  608363
  618234
  620318
  628273
  702525
  727027
  744711
  753993
  758329
  789141
  789767
  806435
]

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 (410770, 414135, 417493, 417839, 418572, 418574, 425821, 430713, 432631, 432699, 432707, 432728, 432743, 433904, 446690, 448282, 452251, 453704, 454536, 455300, 455471, 455596, 455601, 455804, 456892, 457523, 458149, 458883, 459472, 459485, 462210, 464196, 472695, 473333, 481461, 483227, 484256, 488207, 490152, 492939, 496119, 497611, 504696, 506440, 507034, 516283, 516387, 517065, 519319, 519610, 520319, 520342, 521493, 522517, 522975, 525349, 525881, 528144, 528445, 529898, 529905, 534159, 559087, 559110, 567756, 568283, 570952, 579856, 599772, 608363, 618234, 620318, 628273, 702525, 727027, 744711, 753993, 758329, 789141, 789767, 806435);

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

[
  "любительск скрыт camera"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск скрыт camera';

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

[
  "любительск скрыт camera"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск скрыт camera';