Query Metrics
7
Database Queries
7
Different statements
170.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.25 ms (83.51%) |
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 65760 118164 386786 394620 401523 410676 416752 424088 426600 439012 440076 441092 441108 441129 446771 449144 450434 456220 459200 471687 475591 487270 487280 488753 492049 494385 495726 498017 498412 501098 506516 506839 507314 508909 508938 512083 512087 512357 514867 517690 517724 519316 519697 519698 519765 521338 528922 529793 530627 531854 532826 536461 538990 546147 547496 548454 550798 550816 552568 554820 554857 555000 555415 555797 557720 563943 568264 568529 573206 579394 579457 579517 581781 583698 583711 585544 602832 604967 608356 619286 627498 628096 630078 630793 632254 639023 651987 658784 662061 663306 664183 665972 666529 666962 669007 669012 669022 672850 680143 685843 706541 713163 717548 725121 728443 742303 748974 749700 752597 757977 765822 788735 791772 796887 800593 806928 811765 812332 824876 824879 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (9.97%) |
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 426600 439012 450434 519316 532826 508938 514867 528922 557720 579394 583698 563943 555000 555797 579517 669007 550816 568264 619286 628096 630078 627498 456220 517690 824876 824879 546147 585544 118164 440076 441108 441129 487280 488753 449144 471687 475591 495726 512083 531854 536461 538990 529793 554857 583711 554820 555415 548454 568529 579457 658784 666529 669022 672850 680143 713163 717548 651987 662061 663306 664183 666962 706541 665972 685843 550798 639023 602832 604967 632254 608356 788735 796887 800593 812332 725121 752597 806928 811765 749700 757977 742303 748974 765822 728443 630793 791772 401523 424088 446771 459200 65760 394620 441092 512087 512357 521338 487270 494385 492049 410676 552568 386786 416752 498017 498412 506516 507314 530627 501098 506839 508909 517724 519765 519697 519698 547496 573206 581781 669012 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.97%) |
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 65760 118164 386786 394620 401523 410676 416752 424088 426600 439012 440076 441092 441108 441129 446771 449144 450434 456220 459200 471687 475591 487270 487280 488753 492049 494385 495726 498017 498412 501098 506516 506839 507314 508909 508938 512083 512087 512357 514867 517690 517724 519316 519697 519698 519765 521338 528922 529793 530627 531854 532826 536461 538990 546147 547496 548454 550798 550816 552568 554820 554857 555000 555415 555797 557720 563943 568264 568529 573206 579394 579457 579517 581781 583698 583711 585544 602832 604967 608356 619286 627498 628096 630078 630793 632254 639023 651987 658784 662061 663306 664183 665972 666529 666962 669007 669012 669022 672850 680143 685843 706541 713163 717548 725121 728443 742303 748974 749700 752597 757977 765822 788735 791772 796887 800593 806928 811765 812332 824876 824879 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фистит"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
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.