Query Metrics
7
Database Queries
7
Different statements
150.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.86 ms (86.30%) |
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 392987 500311 532184 532195 535364 539397 539548 540156 542298 546067 546070 546143 546264 547391 550779 555261 556068 565228 565517 573449 575043 578206 578794 587947 592969 600479 622296 628032 629579 632820 637178 645381 650787 651676 660357 660769 665948 677069 677894 680607 695079 702381 704401 706154 707401 707419 707511 708651 712137 714159 714227 714252 715440 716268 720666 722105 725427 725449 726126 726150 726281 726764 730060 730413 730951 734312 735478 736681 739684 740274 741094 742352 742505 743789 746854 748380 752110 754850 755043 760173 761526 763449 767513 767536 768508 768676 768894 771347 780912 782595 788673 791266 794427 794645 794731 796501 797290 800172 801703 803301 812244 813032 817810 818754 819347 819745 820317 824515 824902 824947 826091 826491 826507 826770 826959 827087 827418 827525 828572 ] |
||||||||||||||||||||||||||||||
|
9.78 ms (6.50%) |
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 812244 813032 587947 726150 819347 820317 817810 826959 824947 578794 748380 722105 628032 500311 542298 818754 824515 824902 539548 540156 532184 535364 539397 573449 546067 546070 565228 547391 550779 556068 645381 660357 660769 677069 680607 707401 707419 707511 651676 708651 714159 714227 650787 665948 712137 714252 555261 578206 592969 600479 622296 637178 791266 796501 734312 794427 801703 726126 746854 725449 741094 742505 629579 632820 700231 702381 704401 706154 715440 794731 797290 575043 695079 677894 800172 725427 392987 826770 726281 546143 546264 742352 755043 768676 826491 827087 827418 827525 826507 819745 826091 828572 532195 565517 716268 720666 788673 782595 726764 730060 730413 760173 767513 767536 794645 803301 730951 736681 754850 768508 740274 763449 735478 739684 743789 752110 771347 761526 768894 780912 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск жен"
]
|
||||||||||||||||||||||||||||||
|
2.35 ms (1.56%) |
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 392987 500311 532184 532195 535364 539397 539548 540156 542298 546067 546070 546143 546264 547391 550779 555261 556068 565228 565517 573449 575043 578206 578794 587947 592969 600479 622296 628032 629579 632820 637178 645381 650787 651676 660357 660769 665948 677069 677894 680607 695079 702381 704401 706154 707401 707419 707511 708651 712137 714159 714227 714252 715440 716268 720666 722105 725427 725449 726126 726150 726281 726764 730060 730413 730951 734312 735478 736681 739684 740274 741094 742352 742505 743789 746854 748380 752110 754850 755043 760173 761526 763449 767513 767536 768508 768676 768894 771347 780912 782595 788673 791266 794427 794645 794731 796501 797290 800172 801703 803301 812244 813032 817810 818754 819347 819745 820317 824515 824902 824947 826091 826491 826507 826770 826959 827087 827418 827525 828572 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade wife"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.18%) |
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.