Query Metrics
7
Database Queries
7
Different statements
174.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.43 ms (86.83%) |
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 21506 31708 33098 33917 181612 192968 383565 385913 386405 388291 388407 389135 401137 403614 404503 405859 407777 407779 415580 415636 418270 418757 418774 419729 420619 422246 427034 429368 430342 430484 432791 433354 433382 442379 443203 447528 447965 449245 450310 451549 452112 454591 456622 457723 458213 459347 459518 459727 461019 462329 462939 463775 463835 465068 465180 467755 468473 469069 469452 469591 469906 472107 472360 476471 476951 478573 479995 484720 485040 485942 486651 491512 491785 492446 492933 493547 494196 497199 500391 500665 503159 506255 507132 507274 509215 509434 509705 510423 523980 524219 524907 526992 527904 536391 540157 555569 556571 559099 562287 565103 565954 565973 569447 571763 573773 578054 580930 586592 594868 596133 597031 601337 666472 694945 717173 718384 743634 758227 785026 793042 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (7.79%) |
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 454591 507132 743634 388407 569447 565954 386405 31708 433382 601337 418774 524219 469906 718384 479995 500665 578054 451549 472360 510423 509705 181612 485040 459347 407779 442379 556571 427034 433354 21506 476471 492446 509434 462329 793042 430484 476951 491785 443203 469591 666472 758227 432791 536391 383565 33917 388291 420619 447965 457723 565103 524907 573773 456622 462939 465068 523980 694945 492933 559099 429368 540157 586592 485942 418757 385913 192968 459518 494196 415636 463835 459727 389135 401137 486651 507274 418270 449245 461019 467755 491512 500391 565973 497199 430342 419729 562287 555569 465180 447528 468473 503159 509215 484720 478573 403614 452112 405859 785026 596133 717173 33098 506255 469069 571763 594868 415580 597031 526992 527904 580930 404503 450310 469452 463775 458213 472107 422246 407777 493547 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.57%) |
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 21506 31708 33098 33917 181612 192968 383565 385913 386405 388291 388407 389135 401137 403614 404503 405859 407777 407779 415580 415636 418270 418757 418774 419729 420619 422246 427034 429368 430342 430484 432791 433354 433382 442379 443203 447528 447965 449245 450310 451549 452112 454591 456622 457723 458213 459347 459518 459727 461019 462329 462939 463775 463835 465068 465180 467755 468473 469069 469452 469591 469906 472107 472360 476471 476951 478573 479995 484720 485040 485942 486651 491512 491785 492446 492933 493547 494196 497199 500391 500665 503159 506255 507132 507274 509215 509434 509705 510423 523980 524219 524907 526992 527904 536391 540157 555569 556571 559099 562287 565103 565954 565973 569447 571763 573773 578054 580930 586592 594868 596133 597031 601337 666472 694945 717173 718384 743634 758227 785026 793042 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"no tits blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.