Query Metrics
7
Database Queries
7
Different statements
419.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
397.76 ms (94.92%) |
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 547674 549326 549477 549499 549645 550509 551093 551149 552653 552854 553487 553646 554093 554178 554704 554829 555561 556100 557474 557774 557824 558196 560984 560993 562047 562988 563107 564271 564354 567616 568342 570690 571004 572224 572361 573369 573462 574131 574362 576692 577145 578742 579451 579855 580210 580501 581020 581742 581987 582316 583206 583246 583575 584107 588034 588208 588825 589907 589950 590177 590986 591091 591564 591724 591947 594221 594363 594578 595035 597546 599817 600929 601134 601313 602461 602737 604221 604896 605179 612219 617783 618141 619573 620820 622294 625558 638924 650295 650726 650908 651692 652057 655464 655524 659352 660441 662220 664494 664987 665323 666081 666940 668768 668780 669255 672842 673416 673704 674388 674918 677371 677969 678260 680718 683300 685940 686573 687950 688009 689120 ] |
||||||||||||||||||||||||||||||
|
11.43 ms (2.73%) |
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 578742 579451 579855 580501 581020 583575 549326 549477 549499 550509 554178 554829 557474 564271 568342 573369 574131 576692 583246 551149 553487 553646 556100 557774 563107 564354 567616 572361 573462 574362 580210 581742 582316 583206 650295 650908 652057 655464 662220 666940 674388 674918 677969 678260 651692 655524 659352 660441 664494 673416 673704 677371 680718 685940 687950 689120 650726 664987 665323 666081 668768 668780 669255 672842 683300 686573 688009 547674 549645 551093 552653 552854 554093 554704 555561 557824 558196 560984 560993 562047 562988 570690 571004 572224 577145 581987 584107 588034 588208 589907 589950 590177 590986 594221 604896 612219 617783 622294 638924 588825 591564 594578 595035 597546 599817 601313 602461 602737 604221 618141 619573 625558 591091 591724 591947 594363 600929 601134 605179 620820 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (0.61%) |
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 547674 549326 549477 549499 549645 550509 551093 551149 552653 552854 553487 553646 554093 554178 554704 554829 555561 556100 557474 557774 557824 558196 560984 560993 562047 562988 563107 564271 564354 567616 568342 570690 571004 572224 572361 573369 573462 574131 574362 576692 577145 578742 579451 579855 580210 580501 581020 581742 581987 582316 583206 583246 583575 584107 588034 588208 588825 589907 589950 590177 590986 591091 591564 591724 591947 594221 594363 594578 595035 597546 599817 600929 601134 601313 602461 602737 604221 604896 605179 612219 617783 618141 619573 620820 622294 625558 638924 650295 650726 650908 651692 652057 655464 655524 659352 660441 662220 664494 664987 665323 666081 666940 668768 668780 669255 672842 673416 673704 674388 674918 677371 677969 678260 680718 683300 685940 686573 687950 688009 689120 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"щетин"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"щетина"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.35%) |
1 |
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.