Query Metrics
7
Database Queries
7
Different statements
298.69 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.85 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.30 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"комнате"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.93 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 797434 801594 803218 810064 730645 732508 740208 749994 754864 762152 768732 768982 728249 736502 745849 758506 764623 767680 773178 728898 743129 748693 753429 758136 759346 730356 748911 749373 767475 620570 632938 634948 635167 786494 788383 791746 804037 804816 285023 24243 126450 248084 388417 527586 382958 68967 384268 123070 193890 202872 214560 177522 391607 88614 38857 389648 396816 398948 402585 406428 814593 458836 520190 530562 537630 506568 477285 545034 546101 546649 565792 581275 546296 556282 572705 542246 551543 646533 648693 652468 668810 671350 684876 689923 699346 665324 671567 675356 676130 684874 688398 712647 714563 718143 720088 700775 716066 575269 629667 614538 617496 624590 627880 602915 607859 780423 783843 786276 791327 791985 795897 796567 796864 799215 799311 800135 802387 810201 811399 812489 ] |
||||||||||||||||||||||||||||||
| 4 | 3.76 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 24243 38857 68967 88614 123070 126450 177522 193890 202872 214560 248084 285023 382958 384268 388417 389648 391607 396816 398948 402585 406428 458836 477285 506568 520190 527586 530562 537630 542246 545034 546101 546296 546649 551543 556282 565792 572705 575269 581275 602915 607859 614538 617496 620570 624590 627880 629667 632938 634948 635167 646533 648693 652468 665324 668810 671350 671567 675356 676130 684874 684876 688398 689923 699346 700775 712647 714563 716066 718143 720088 728249 728898 730356 730645 732508 736502 740208 743129 745849 748693 748911 749373 749994 753429 754864 758136 758506 759346 762152 764623 767475 767680 768732 768982 773178 780423 783843 786276 786494 788383 791327 791746 791985 795897 796567 796864 797434 799215 799311 800135 801594 802387 803218 804037 804816 810064 810201 811399 812489 814593 ] |
||||||||||||||||||||||||||||||
| 5 | 273.45 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 24243 38857 68967 88614 123070 126450 177522 193890 202872 214560 248084 285023 382958 384268 388417 389648 391607 396816 398948 402585 406428 458836 477285 506568 520190 527586 530562 537630 542246 545034 546101 546296 546649 551543 556282 565792 572705 575269 581275 602915 607859 614538 617496 620570 624590 627880 629667 632938 634948 635167 646533 648693 652468 665324 668810 671350 671567 675356 676130 684874 684876 688398 689923 699346 700775 712647 714563 716066 718143 720088 728249 728898 730356 730645 732508 736502 740208 743129 745849 748693 748911 749373 749994 753429 754864 758136 758506 759346 762152 764623 767475 767680 768732 768982 773178 780423 783843 786276 786494 788383 791327 791746 791985 795897 796567 796864 797434 799215 799311 800135 801594 802387 803218 804037 804816 810064 810201 811399 812489 814593 ] |
||||||||||||||||||||||||||||||
| 6 | 1.94 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"комнат"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.46 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"комнат"
]
|
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.