Query Metrics
7
Database Queries
7
Different statements
164.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.56 ms (77.58%) |
1 |
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 378035 384541 386271 386756 391086 391541 395423 396588 398049 399250 399367 399705 405182 409010 410780 417903 417904 419765 419868 420231 425320 436250 449592 449679 451265 460799 463864 464146 464147 465168 465575 468063 468714 468873 474240 477074 481148 481151 481663 481668 482793 485161 485249 496380 497743 500431 507219 508910 513126 519819 524501 530488 532807 533370 533476 534216 536741 538416 540305 543884 545615 555847 555873 562391 565161 565506 565507 566035 572641 573926 575355 587598 589060 597863 598944 599862 599863 599955 600206 600363 600415 604025 604391 604581 612804 619505 622452 622996 631972 639008 643338 653823 654833 655113 656088 656785 657430 658077 658094 659161 659502 659567 659638 659759 660531 672712 674927 674945 681189 698048 718931 719857 720301 725622 732638 741288 788570 800331 804756 828115 ] |
||||||||||||||||||||||||||||||
|
26.43 ms (16.07%) |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 468873 481151 485249 533476 562391 545615 565161 573926 674927 587598 631972 600206 425320 386271 395423 378035 398049 399705 417904 436250 449679 540305 464147 565507 575355 674945 604025 604391 604581 804756 725622 622452 409010 399250 477074 481668 391086 399367 420231 465575 496380 507219 828115 732638 657430 659161 659638 659502 659759 654833 656785 698048 532807 589060 513126 533370 599863 599955 599862 655113 463864 524501 543884 566035 672712 600415 600363 718931 386756 658077 658094 660531 653823 659567 622996 619505 384541 643338 536741 656088 565506 396588 410780 419765 482793 465168 481148 485161 451265 468063 449592 481663 534216 538416 519819 530488 460799 474240 572641 681189 720301 719857 555847 555873 598944 597863 639008 741288 800331 612804 788570 417903 405182 391541 468714 419868 464146 500431 497743 508910 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.54%) |
1 |
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 378035 384541 386271 386756 391086 391541 395423 396588 398049 399250 399367 399705 405182 409010 410780 417903 417904 419765 419868 420231 425320 436250 449592 449679 451265 460799 463864 464146 464147 465168 465575 468063 468714 468873 474240 477074 481148 481151 481663 481668 482793 485161 485249 496380 497743 500431 507219 508910 513126 519819 524501 530488 532807 533370 533476 534216 536741 538416 540305 543884 545615 555847 555873 562391 565161 565506 565507 566035 572641 573926 575355 587598 589060 597863 598944 599862 599863 599955 600206 600363 600415 604025 604391 604581 612804 619505 622452 622996 631972 639008 643338 653823 654833 655113 656088 656785 657430 658077 658094 659161 659502 659567 659638 659759 660531 672712 674927 674945 681189 698048 718931 719857 720301 725622 732638 741288 788570 800331 804756 828115 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small bbc"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая bbc"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая bbc"
]
|
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.