Query Metrics
7
Database Queries
7
Different statements
199.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.16 ms (85.35%) |
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 96636 383356 390571 395686 397306 418492 418724 421220 424523 429668 431452 431975 434286 443312 447454 447759 447790 447843 449060 451175 451267 451559 452036 454284 459805 460016 461725 462379 463809 466685 474487 474688 475483 475933 476117 477555 477557 478033 478475 479728 480941 482788 484821 489093 489820 490267 491266 491273 491286 493194 494513 496722 497901 501228 506287 506705 507291 511020 511899 512215 512830 514088 514836 516771 517847 519107 522072 522851 523197 525020 526168 527409 529854 530005 530385 531131 533831 535028 536335 537915 538837 539278 540338 541887 542591 543888 544867 556307 560664 562374 565800 571957 573409 578299 583505 592313 600225 620160 620244 621853 628312 634791 637746 639048 641642 645016 647875 656577 665918 665926 666536 666541 678942 680183 700284 716707 718745 720882 793438 817033 ] |
||||||||||||||||||||||||||||||
|
18.90 ms (9.48%) |
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 475483 645016 491273 511899 529854 460016 538837 565800 434286 506287 506705 560664 573409 390571 491286 431975 451267 539278 478475 527409 493194 96636 600225 475933 479728 531131 720882 678942 641642 700284 447843 522851 525020 817033 583505 665926 665918 620160 452036 476117 466685 463809 543888 716707 793438 447790 592313 620244 447759 462379 647875 656577 477557 451559 512830 680183 397306 459805 497901 530385 494513 512215 542591 496722 454284 537915 541887 666541 666536 556307 639048 634791 429668 474688 490267 578299 621853 418724 526168 533831 418492 522072 530005 507291 540338 517847 562374 474487 480941 571957 637746 447454 421220 482788 544867 628312 478033 477555 501228 511020 491266 523197 451175 449060 516771 424523 443312 489093 431452 489820 514088 536335 535028 519107 484821 383356 395686 461725 514836 718745 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.49%) |
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 96636 383356 390571 395686 397306 418492 418724 421220 424523 429668 431452 431975 434286 443312 447454 447759 447790 447843 449060 451175 451267 451559 452036 454284 459805 460016 461725 462379 463809 466685 474487 474688 475483 475933 476117 477555 477557 478033 478475 479728 480941 482788 484821 489093 489820 490267 491266 491273 491286 493194 494513 496722 497901 501228 506287 506705 507291 511020 511899 512215 512830 514088 514836 516771 517847 519107 522072 522851 523197 525020 526168 527409 529854 530005 530385 531131 533831 535028 536335 537915 538837 539278 540338 541887 542591 543888 544867 556307 560664 562374 565800 571957 573409 578299 583505 592313 600225 620160 620244 621853 628312 634791 637746 639048 641642 645016 647875 656577 665918 665926 666536 666541 678942 680183 700284 716707 718745 720882 793438 817033 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex slave anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс доминирован анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.85%) |
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.