Query Metrics
7
Database Queries
7
Different statements
155.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.01 ms (83.48%) |
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 76836 102626 413687 418035 419109 419112 423329 446686 455598 463842 468025 468073 469794 474806 475139 478833 482242 498795 499697 500874 500875 500945 507713 513562 514017 520216 521652 522935 524257 526758 528361 531155 531377 533013 533062 534330 534994 536783 541099 545355 546423 546804 564078 564686 565547 568554 577608 580288 583982 589623 597216 597845 599940 599988 600332 609536 619167 619574 629774 632059 635270 637191 642044 643001 645861 647942 657197 657236 662090 672412 675000 675010 676022 676638 677784 682932 687630 688698 699639 710895 711631 713115 714083 714088 714097 715818 720013 721083 726131 727483 728902 728926 730140 738679 738684 738817 740806 741606 746940 748623 748637 748640 750582 756627 756890 756975 761535 764814 767390 777509 780333 789646 792665 808780 814014 814033 815742 815899 816033 816524 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (10.76%) |
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 676022 676638 568554 423329 583982 531155 645861 675000 642044 528361 536783 675010 677784 632059 545355 463842 533013 534994 546804 597216 599988 599940 687630 715818 672412 499697 531377 76836 419109 714088 647942 764814 688698 756975 526758 814014 619574 748637 726131 815742 814033 522935 730140 713115 500874 711631 446686 780333 564078 699639 629774 643001 748640 419112 507713 748623 413687 498795 662090 815899 609536 738684 714083 816033 534330 756890 482242 468025 756627 469794 513562 577608 475139 728902 816524 750582 767390 789646 657236 589623 500875 521652 600332 637191 720013 468073 728926 597845 619167 102626 746940 740806 478833 533062 541099 738817 418035 714097 635270 808780 761535 777509 580288 455598 474806 514017 564686 520216 792665 565547 500945 524257 682932 657197 546423 738679 727483 710895 721083 741606 ] |
||||||||||||||||||||||||||||||
|
2.39 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 76836 102626 413687 418035 419109 419112 423329 446686 455598 463842 468025 468073 469794 474806 475139 478833 482242 498795 499697 500874 500875 500945 507713 513562 514017 520216 521652 522935 524257 526758 528361 531155 531377 533013 533062 534330 534994 536783 541099 545355 546423 546804 564078 564686 565547 568554 577608 580288 583982 589623 597216 597845 599940 599988 600332 609536 619167 619574 629774 632059 635270 637191 642044 643001 645861 647942 657197 657236 662090 672412 675000 675010 676022 676638 677784 682932 687630 688698 699639 710895 711631 713115 714083 714088 714097 715818 720013 721083 726131 727483 728902 728926 730140 738679 738684 738817 740806 741606 746940 748623 748637 748640 750582 756627 756890 756975 761535 764814 767390 777509 780333 789646 792665 808780 814014 814033 815742 815899 816033 816524 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt big dick"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
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.