Query Metrics
7
Database Queries
7
Different statements
171.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.50 ms (87.73%) |
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 269287 411516 466753 471039 472291 485910 517430 530038 530403 530664 531009 531739 533635 533675 535549 537134 538289 540556 541184 541459 541488 543955 546307 548895 548974 554698 555772 559422 563310 570932 586545 588583 598347 599661 605230 605912 610697 617713 618550 629367 629836 639642 644172 648659 649707 651651 655548 656296 660459 661966 662881 682886 697994 721003 722251 723030 723192 723232 735069 738081 739142 740895 741226 743676 747047 749376 749378 749393 750347 751002 751046 751177 751183 751797 752252 752259 752353 753593 755500 755566 757252 757264 757463 759143 760383 760566 761251 765567 770020 776849 777811 778219 779837 780332 780390 780527 780933 781392 782149 792067 799686 802320 804342 809086 814410 816705 816845 817338 818576 821790 824110 824188 825371 825410 825835 826031 827350 827354 827438 827456 ] |
||||||||||||||||||||||||||||||
|
11.37 ms (6.63%) |
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 765567 697994 782149 269287 817338 824110 825835 821790 827354 827438 818576 824188 816705 816845 825371 825410 827456 827350 826031 485910 466753 530403 533635 530664 533675 517430 531009 531739 535549 537134 471039 548974 554698 541184 541488 546307 541459 543955 548895 555772 648659 649707 655548 656296 682886 722251 723030 662881 559422 570932 586545 629367 598347 605230 605912 644172 610697 599661 779837 780933 776849 804342 740895 749376 752353 755500 755566 757264 757463 799686 802320 751046 760383 770020 738081 747047 751002 759143 741226 749378 750347 751177 751797 752252 752259 757252 761251 735069 739142 743676 749393 751183 753593 760566 617713 629836 723232 777811 778219 780390 780527 781392 411516 814410 540556 530038 538289 472291 563310 651651 661966 721003 723192 660459 618550 588583 639642 792067 809086 780332 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.78%) |
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 269287 411516 466753 471039 472291 485910 517430 530038 530403 530664 531009 531739 533635 533675 535549 537134 538289 540556 541184 541459 541488 543955 546307 548895 548974 554698 555772 559422 563310 570932 586545 588583 598347 599661 605230 605912 610697 617713 618550 629367 629836 639642 644172 648659 649707 651651 655548 656296 660459 661966 662881 682886 697994 721003 722251 723030 723192 723232 735069 738081 739142 740895 741226 743676 747047 749376 749378 749393 750347 751002 751046 751177 751183 751797 752252 752259 752353 753593 755500 755566 757252 757264 757463 759143 760383 760566 761251 765567 770020 776849 777811 778219 779837 780332 780390 780527 780933 781392 782149 792067 799686 802320 804342 809086 814410 816705 816845 817338 818576 821790 824110 824188 825371 825410 825835 826031 827350 827354 827438 827456 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur ass solo"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.