Query Metrics
7
Database Queries
7
Different statements
134.47 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.91 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.97 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slut public"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.17 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 449697 486696 630528 599275 483473 475677 511649 610607 453508 447935 478043 415896 772087 578300 511492 433188 433493 461730 447918 452376 519095 532989 493893 681137 619802 643415 433279 439858 455180 477555 476103 478044 486408 537017 515717 551477 572544 401880 672403 514576 571841 484866 632054 559154 571199 465605 556054 575716 535432 736284 737504 570033 501212 482808 470074 616585 562298 524555 492128 543607 749501 472125 513761 521723 522812 490520 572160 571889 514401 517574 540268 570218 438069 559283 676612 570367 572482 530637 573212 537287 570541 570584 725339 490517 550599 555969 554338 666776 513664 642064 ] |
||||||||||||||||||||||||||||||
| 4 | 3.77 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 401880 415896 433188 433279 433493 438069 439858 447918 447935 449697 452376 453508 455180 461730 465605 470074 472125 475677 476103 477555 478043 478044 482808 483473 484866 486408 486696 490517 490520 492128 493893 501212 511492 511649 513664 513761 514401 514576 515717 517574 519095 521723 522812 524555 530637 532989 535432 537017 537287 540268 543607 550599 551477 554338 555969 556054 559154 559283 562298 570033 570218 570367 570541 570584 571199 571841 571889 572160 572482 572544 573212 575716 578300 599275 610607 616585 619802 630528 632054 642064 643415 666776 672403 676612 681137 725339 736284 737504 749501 772087 ] |
||||||||||||||||||||||||||||||
| 5 | 107.31 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 401880 415896 433188 433279 433493 438069 439858 447918 447935 449697 452376 453508 455180 461730 465605 470074 472125 475677 476103 477555 478043 478044 482808 483473 484866 486408 486696 490517 490520 492128 493893 501212 511492 511649 513664 513761 514401 514576 515717 517574 519095 521723 522812 524555 530637 532989 535432 537017 537287 540268 543607 550599 551477 554338 555969 556054 559154 559283 562298 570033 570218 570367 570541 570584 571199 571841 571889 572160 572482 572544 573212 575716 578300 599275 610607 616585 619802 630528 632054 642064 643415 666776 672403 676612 681137 725339 736284 737504 749501 772087 ] |
||||||||||||||||||||||||||||||
| 6 | 1.74 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"slut на улиц"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.59 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"slut на улиц"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.