Query Metrics
7
Database Queries
7
Different statements
168.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.23 ms (84.38%) |
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 8867 31563 182154 202846 234600 265692 340635 352189 360860 381818 381942 381967 382325 382490 384249 386017 388729 389739 391961 409078 420163 444168 464927 466768 466956 471113 475274 479106 510819 529346 529351 531373 533715 535324 535363 537097 537147 537852 544791 545143 554492 554528 554546 555137 555153 583914 585365 587789 587958 590145 592495 593044 597130 597730 599489 603358 603359 603399 605232 605535 607331 629799 636426 645928 657788 660054 664594 665042 697473 705078 705452 710268 714316 714484 714698 720482 720525 720527 722322 735810 736410 742341 744182 744188 744219 744226 744229 744803 744806 746677 748299 751012 751678 753600 754923 755355 755369 758337 759793 760211 770107 770131 770197 770252 772549 781875 795990 796841 799111 799633 799646 802571 804484 805359 805363 810096 817590 819241 819625 825859 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (9.07%) |
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 384249 360860 597730 819241 554492 664594 605232 386017 753600 555153 603359 795990 665042 735810 388729 510819 234600 657788 810096 710268 744182 796841 744803 587958 381818 537097 31563 8867 382490 529346 629799 531373 799633 805359 805363 533715 714316 770107 660054 825859 744226 746677 381942 381967 382325 475274 744229 597130 202846 755355 389739 645928 697473 755369 772549 537852 722322 714484 603399 636426 593044 340635 420163 444168 736410 464927 182154 544791 799646 770197 720525 744188 603358 590145 744219 537147 817590 409078 352189 592495 466956 714698 599489 742341 751678 759793 554528 479106 555137 471113 554546 607331 585365 587789 751012 583914 529351 819625 535363 545143 720527 605535 802571 748299 770131 770252 758337 799111 754923 804484 391961 466768 535324 720482 705078 705452 744806 760211 781875 265692 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings mature solo"
]
|
||||||||||||||||||||||||||||||
|
2.55 ms (1.51%) |
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 8867 31563 182154 202846 234600 265692 340635 352189 360860 381818 381942 381967 382325 382490 384249 386017 388729 389739 391961 409078 420163 444168 464927 466768 466956 471113 475274 479106 510819 529346 529351 531373 533715 535324 535363 537097 537147 537852 544791 545143 554492 554528 554546 555137 555153 583914 585365 587789 587958 590145 592495 593044 597130 597730 599489 603358 603359 603399 605232 605535 607331 629799 636426 645928 657788 660054 664594 665042 697473 705078 705452 710268 714316 714484 714698 720482 720525 720527 722322 735810 736410 742341 744182 744188 744219 744226 744229 744803 744806 746677 748299 751012 751678 753600 754923 755355 755369 758337 759793 760211 770107 770131 770197 770252 772549 781875 795990 796841 799111 799633 799646 802571 804484 805359 805363 810096 817590 819241 819625 825859 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел mature соло"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел mature соло"
]
|
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.