Query Metrics
7
Database Queries
7
Different statements
460.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.83 ms (49.93%) |
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 86472 383098 383370 384539 389044 391694 392978 394053 397406 398444 411675 422475 423490 423871 424045 424156 427143 428968 429837 438321 440855 441798 441952 448053 448412 453007 454016 457593 459520 460432 460856 465567 465930 467833 476066 476402 477042 477132 477376 477460 477968 478524 479225 480091 480728 482554 482585 482892 483310 483907 495156 495980 497386 499603 500634 503179 503397 503535 503809 504026 505196 505748 506206 507188 510841 511042 512580 516664 521599 521765 522617 524268 525392 526787 527196 530401 531533 534480 543288 545467 547026 551551 558471 558827 561008 567349 570967 571312 572236 577134 578253 581023 583532 587741 588234 591224 605165 617743 622521 640592 653437 664237 682686 687150 688009 689504 705451 707974 725089 725998 726606 733340 744454 763561 784775 796734 797204 805354 806866 817747 ] |
||||||||||||||||||||||||||||||
|
209.55 ms (45.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave wife"
]
|
||||||||||||||||||||||||||||||
|
13.09 ms (2.84%) |
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 587741 725998 477132 511042 506206 411675 453007 477460 483907 516664 521765 503397 653437 687150 561008 591224 477376 477968 465930 497386 383370 383098 392978 398444 427143 422475 817747 448053 477042 480091 482554 482892 448412 510841 500634 522617 530401 534480 499603 503179 524268 531533 465567 478524 482585 543288 545467 571312 581023 551551 567349 570967 578253 705451 664237 707974 689504 583532 588234 640592 605165 622521 805354 806866 784775 797204 733340 726606 744454 763561 617743 394053 424156 441798 454016 476066 480728 457593 460856 424045 467833 391694 423871 429837 438321 460432 503809 504026 483310 505196 526787 527196 495980 512580 505748 441952 521599 495156 507188 479225 558827 572236 547026 558471 577134 682686 688009 725089 459520 476402 503535 525392 796734 384539 86472 389044 397406 423490 428968 440855 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (0.58%) |
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 86472 383098 383370 384539 389044 391694 392978 394053 397406 398444 411675 422475 423490 423871 424045 424156 427143 428968 429837 438321 440855 441798 441952 448053 448412 453007 454016 457593 459520 460432 460856 465567 465930 467833 476066 476402 477042 477132 477376 477460 477968 478524 479225 480091 480728 482554 482585 482892 483310 483907 495156 495980 497386 499603 500634 503179 503397 503535 503809 504026 505196 505748 506206 507188 510841 511042 512580 516664 521599 521765 522617 524268 525392 526787 527196 530401 531533 534480 543288 545467 547026 551551 558471 558827 561008 567349 570967 571312 572236 577134 578253 581023 583532 587741 588234 591224 605165 617743 622521 640592 653437 664237 682686 687150 688009 689504 705451 707974 725089 725998 726606 733340 744454 763561 784775 796734 797204 805354 806866 817747 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован жен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.34%) |
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.