Query Metrics
7
Database Queries
7
Different statements
191.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.62 ms (86.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 382313 388789 392775 396551 399520 400195 401059 401221 401282 404720 407552 409144 412309 415097 416360 417010 421793 425481 425603 426810 428653 430144 431494 432790 433703 434168 434182 434201 437325 437333 437803 441874 442457 443859 445501 447023 447750 448635 448970 449489 449678 450921 452441 452628 454250 454372 454862 454916 456585 457688 460279 464109 466721 468060 470731 472582 473913 476943 478796 480434 484918 485782 492610 494697 496181 500957 501547 504036 506130 507804 507889 508159 509332 510233 513123 516354 516792 516811 518308 519740 519833 519938 523420 526591 526611 526830 526944 527843 528112 528113 528817 532011 548570 549770 550102 555885 557185 559680 561314 562184 563917 563930 565061 569556 572943 579040 585912 592812 600686 603896 604503 620300 693023 698289 703144 704560 706290 713262 748237 799060 ] |
||||||||||||||||||||||||||||||
|
16.91 ms (8.82%) |
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 470731 508159 496181 526944 528817 441874 437333 466721 506130 519938 572943 603896 392775 437325 454250 472582 484918 516792 507804 401059 400195 388789 448635 409144 454916 407552 454372 549770 550102 434182 421793 417010 456585 412309 548570 704560 706290 401221 426810 431494 507889 396551 415097 445501 485782 518308 698289 703144 559680 563930 748237 713262 799060 457688 425603 432790 416360 478796 492610 501547 494697 509332 434201 437803 443859 510233 555885 561314 562184 604503 620300 523420 504036 442457 464109 569556 563917 592812 600686 450921 460279 473913 448970 516811 526591 526611 516354 527843 430144 428653 434168 452441 513123 519833 532011 579040 693023 585912 425481 468060 399520 452628 454862 480434 449489 449678 447023 528113 526830 500957 476943 401282 519740 528112 382313 404720 447750 433703 557185 565061 ] |
||||||||||||||||||||||||||||||
|
3.01 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 382313 388789 392775 396551 399520 400195 401059 401221 401282 404720 407552 409144 412309 415097 416360 417010 421793 425481 425603 426810 428653 430144 431494 432790 433703 434168 434182 434201 437325 437333 437803 441874 442457 443859 445501 447023 447750 448635 448970 449489 449678 450921 452441 452628 454250 454372 454862 454916 456585 457688 460279 464109 466721 468060 470731 472582 473913 476943 478796 480434 484918 485782 492610 494697 496181 500957 501547 504036 506130 507804 507889 508159 509332 510233 513123 516354 516792 516811 518308 519740 519833 519938 523420 526591 526611 526830 526944 527843 528112 528113 528817 532011 548570 549770 550102 555885 557185 559680 561314 562184 563917 563930 565061 569556 572943 579040 585912 592812 600686 603896 604503 620300 693023 698289 703144 704560 706290 713262 748237 799060 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck daughter"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс daughter"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс daughter"
]
|
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.