Query Metrics
7
Database Queries
7
Different statements
209.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.41 ms (85.06%) |
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 33459 96690 326134 386935 388474 388726 405056 405718 405848 414374 416166 418450 421564 425353 428119 430701 432586 443112 451262 451637 452189 452282 453531 454801 455085 455088 464171 467611 473501 476195 477084 483752 485152 491273 495126 496074 503051 510109 511393 521367 522140 523883 531134 531248 531393 532641 533015 533443 533477 534301 534313 534961 535049 536178 536438 536550 536620 536628 537117 539159 542566 550200 567343 581013 583505 585143 589211 590879 592377 595101 597753 599851 599994 600012 600200 600280 600340 600962 601887 602617 602968 604352 604497 604558 604580 612726 616338 617429 619401 629045 632970 634793 637085 639789 642714 644271 646841 649583 649974 650470 651135 653937 660148 666585 666912 675002 681313 683529 697308 706658 714003 714522 716323 718979 737722 814798 815351 815410 815598 820767 ] |
||||||||||||||||||||||||||||||
|
21.31 ms (10.16%) |
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 651135 681313 675002 600012 617429 619401 592377 639789 601887 604352 634793 604580 714003 425353 388474 428119 432586 455085 455088 430701 485152 496074 567343 476195 602968 600340 531393 706658 697308 604497 737722 414374 416166 646841 467611 589211 443112 629045 33459 421564 452282 521367 523883 535049 536628 542566 612726 600200 599994 451262 503051 491273 510109 326134 96690 388726 386935 405056 405848 405718 418450 815410 585143 814798 815598 815351 820767 454801 464171 451637 452189 453531 477084 495126 522140 533477 534313 536178 537117 539159 531134 531248 533015 536438 536620 534301 536550 511393 532641 533443 534961 473501 483752 581013 583505 550200 649974 650470 683529 714522 649583 660148 666585 666912 716323 653937 718979 600962 616338 642714 644271 600280 602617 604558 637085 590879 595101 632970 597753 599851 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.37%) |
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 33459 96690 326134 386935 388474 388726 405056 405718 405848 414374 416166 418450 421564 425353 428119 430701 432586 443112 451262 451637 452189 452282 453531 454801 455085 455088 464171 467611 473501 476195 477084 483752 485152 491273 495126 496074 503051 510109 511393 521367 522140 523883 531134 531248 531393 532641 533015 533443 533477 534301 534313 534961 535049 536178 536438 536550 536620 536628 537117 539159 542566 550200 567343 581013 583505 585143 589211 590879 592377 595101 597753 599851 599994 600012 600200 600280 600340 600962 601887 602617 602968 604352 604497 604558 604580 612726 616338 617429 619401 629045 632970 634793 637085 639789 642714 644271 646841 649583 649974 650470 651135 653937 660148 666585 666912 675002 681313 683529 697308 706658 714003 714522 716323 718979 737722 814798 815351 815410 815598 820767 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf interracial anal"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf межрасов анал"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf межрасов анал"
]
|
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.