Query Metrics
7
Database Queries
7
Different statements
153.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.63 ms (84.62%) |
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 20715 239599 385794 393729 393777 395984 400984 402087 419590 444935 467173 470707 491814 495148 515160 519639 520730 529206 540776 543822 544270 544350 547345 547642 550612 552900 557207 557274 566984 567153 567155 569668 569692 572575 572578 575514 576380 597195 618422 619430 622178 626755 627813 628516 652600 661905 663395 665443 666810 667244 669577 678763 678972 680036 683505 684203 685632 688370 694536 695921 696508 698958 699009 699025 701384 702461 709703 709881 710549 711894 712913 712923 715300 715415 716482 717368 721502 736172 736917 739098 741453 743158 743369 746112 747926 748544 753570 759584 759597 760466 760482 769905 772388 774079 774160 788438 788963 794643 800700 802406 804637 805591 810600 813318 815888 817309 818410 818821 819550 819563 819595 819993 820087 820427 821625 822137 823024 824012 825804 827964 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (8.12%) |
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 557207 567155 569692 627813 395984 515160 385794 400984 402087 819563 825804 815888 819993 822137 827964 566984 544350 680036 699009 716482 661905 678763 715300 715415 684203 709703 628516 813318 794643 804637 800700 736917 774160 743369 759597 769905 774079 709881 710549 788438 393729 597195 467173 470707 495148 567153 393777 818410 540776 819550 823024 824012 817309 818821 819595 820087 820427 821625 519639 491814 543822 550612 572578 547642 544270 652600 665443 666810 688370 696508 701384 717368 667244 678972 685632 694536 695921 698958 711894 712913 721502 683505 712923 547345 552900 572575 619430 622178 626755 788963 743158 805591 810600 736172 753570 760466 772388 739098 746112 747926 759584 741453 748544 760482 618422 702461 802406 20715 239599 663395 419590 669577 699025 569668 529206 444935 520730 575514 576380 557274 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.60%) |
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 20715 239599 385794 393729 393777 395984 400984 402087 419590 444935 467173 470707 491814 495148 515160 519639 520730 529206 540776 543822 544270 544350 547345 547642 550612 552900 557207 557274 566984 567153 567155 569668 569692 572575 572578 575514 576380 597195 618422 619430 622178 626755 627813 628516 652600 661905 663395 665443 666810 667244 669577 678763 678972 680036 683505 684203 685632 688370 694536 695921 696508 698958 699009 699025 701384 702461 709703 709881 710549 711894 712913 712923 715300 715415 716482 717368 721502 736172 736917 739098 741453 743158 743369 746112 747926 748544 753570 759584 759597 760466 760482 769905 772388 774079 774160 788438 788963 794643 800700 802406 804637 805591 810600 813318 815888 817309 818410 818821 819550 819563 819595 819993 820087 820427 821625 822137 823024 824012 825804 827964 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young fuck"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young секс"
]
|
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.