Query Metrics
7
Database Queries
7
Different statements
150.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.26 ms (79.25%) |
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 391945 392007 392015 396707 401482 410346 411804 413388 413819 414125 415004 417384 423663 424347 425469 427585 439492 441364 445530 445661 447253 452797 461606 464195 464256 464811 468281 471312 478043 479018 480413 485057 496074 498239 511592 511830 512933 514243 514912 525236 526260 528502 530000 530020 530371 530503 530689 531124 531186 532755 532966 533043 533373 533563 533643 533877 535057 536446 536532 537114 537676 541440 541839 545368 547556 550124 550199 554840 561040 566771 575300 577402 577519 581188 585971 589436 596208 598090 599963 600017 600270 600276 600312 600317 600340 604781 604890 606587 616094 628414 631162 632671 634546 639710 639816 641997 646841 646930 650307 650322 669025 669038 669074 670368 680313 695870 699516 699573 707322 708449 712557 745479 758779 780968 788136 805429 812911 812989 815752 ] |
||||||||||||||||||||||||||||||
|
20.01 ms (13.30%) |
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 396707 464256 581188 680313 427585 600317 531186 531124 600312 536446 533563 815752 461606 512933 699516 670368 708449 585971 641997 812989 392015 471312 464811 411804 554840 669038 669074 695870 561040 589436 606587 598090 758779 425469 391945 465885 441364 498239 631162 632671 485057 634546 541839 464195 535057 530371 596208 639816 532966 423663 417384 514912 533877 526260 575300 712557 650307 600276 600017 639710 805429 745479 410346 413819 788136 445530 468281 533643 547556 707322 599963 604890 628414 478043 401482 514243 511592 530020 533373 537114 545368 646930 646841 532755 413388 445661 452797 480413 530689 536532 537676 533043 550199 566771 577402 541440 650322 577519 600270 604781 392007 415004 479018 414125 447253 496074 525236 528502 699573 780968 812911 616094 669025 530503 530000 550124 600340 511830 424347 439492 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.95%) |
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 391945 392007 392015 396707 401482 410346 411804 413388 413819 414125 415004 417384 423663 424347 425469 427585 439492 441364 445530 445661 447253 452797 461606 464195 464256 464811 468281 471312 478043 479018 480413 485057 496074 498239 511592 511830 512933 514243 514912 525236 526260 528502 530000 530020 530371 530503 530689 531124 531186 532755 532966 533043 533373 533563 533643 533877 535057 536446 536532 537114 537676 541440 541839 545368 547556 550124 550199 554840 561040 566771 575300 577402 577519 581188 585971 589436 596208 598090 599963 600017 600270 600276 600312 600317 600340 604781 604890 606587 616094 628414 631162 632671 634546 639710 639816 641997 646841 646930 650307 650322 669025 669038 669074 670368 680313 695870 699516 699573 707322 708449 712557 745479 758779 780968 788136 805429 812911 812989 815752 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal deep"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал deep"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал deep"
]
|
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.