Query Metrics
7
Database Queries
7
Different statements
250.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.53 ms (89.90%) |
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 391917 391925 391926 419835 420330 427115 429881 429899 429902 434327 434332 434344 434352 434367 434374 436942 443804 446302 452363 452950 454885 456908 459476 461954 463973 464017 465431 465846 466992 466995 467885 467889 470007 472421 472665 474310 476884 485295 490402 491436 493411 506458 510280 510425 511375 513010 513258 513619 519363 523595 536049 536062 536094 544930 546059 551836 553441 555982 558316 559430 564475 565308 568214 576157 577949 579585 581173 581741 583612 588911 589907 590425 591997 592988 596796 598692 599494 618799 619230 623821 629047 649306 659182 661915 664595 670272 695096 700965 706889 714346 714443 714466 719461 739779 743634 743641 752840 752950 760167 782093 789230 793037 793095 794063 800707 800753 800754 800767 801639 802340 803441 804235 807842 807902 808319 810409 810524 810527 812052 825514 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (5.57%) |
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 420330 511375 825514 465846 583612 700965 544930 551836 598692 793095 800767 812052 752950 760167 793037 800707 803441 443804 474310 470007 661915 743634 472421 591997 391917 581173 466995 459476 513619 510280 456908 536094 564475 577949 581741 706889 695096 588911 599494 619230 800753 802340 810527 800754 808319 752840 714466 782093 804235 391925 513010 452950 490402 476884 427115 429902 391926 467889 429881 464017 446302 629047 434367 579585 466992 454885 485295 523595 536049 536062 553441 555982 546059 568214 649306 664595 714346 670272 714443 719461 589907 623821 618799 596796 794063 801639 807842 810409 810524 807902 739779 743641 434332 467885 419835 434327 434344 436942 506458 513258 519363 590425 429899 452363 491436 789230 659182 558316 559430 565308 434374 465431 472665 510425 592988 576157 461954 463973 493411 434352 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (1.43%) |
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 391917 391925 391926 419835 420330 427115 429881 429899 429902 434327 434332 434344 434352 434367 434374 436942 443804 446302 452363 452950 454885 456908 459476 461954 463973 464017 465431 465846 466992 466995 467885 467889 470007 472421 472665 474310 476884 485295 490402 491436 493411 506458 510280 510425 511375 513010 513258 513619 519363 523595 536049 536062 536094 544930 546059 551836 553441 555982 558316 559430 564475 565308 568214 576157 577949 579585 581173 581741 583612 588911 589907 590425 591997 592988 596796 598692 599494 618799 619230 623821 629047 649306 659182 661915 664595 670272 695096 700965 706889 714346 714443 714466 719461 739779 743634 743641 752840 752950 760167 782093 789230 793037 793095 794063 800707 800753 800754 800767 801639 802340 803441 804235 807842 807902 808319 810409 810524 810527 812052 825514 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая русск соло"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy russian solo"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая русск соло"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.62%) |
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.