Query Metrics
7
Database Queries
7
Different statements
197.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.47 ms (85.84%) |
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 12128 383379 391010 391530 413117 417547 418334 423320 423973 426071 428051 429728 439492 439660 442587 443117 443816 449424 450803 459258 462005 464939 480064 482330 482608 491637 493455 494735 496936 498152 499199 507124 518081 528607 546926 558333 562132 570399 570994 581501 587483 595711 608800 614520 619091 619247 622746 623375 624227 631762 632031 635973 642290 642521 650532 666719 666978 675094 675145 675891 675960 676303 676372 678878 687359 688403 697758 711964 714927 725510 728096 729000 733065 733111 734623 735332 741053 741613 744360 750576 755447 758268 759731 764909 768626 773890 775103 775652 777257 780158 780406 782503 788212 793216 793246 793845 795097 795374 796090 800392 800598 801087 801612 804144 806777 813067 814606 815928 818397 818984 819838 824861 825154 826079 826278 826593 826889 827040 827058 ] |
||||||||||||||||||||||||||||||
|
17.13 ms (8.68%) |
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 480064 759731 714927 780406 813067 450803 439660 507124 818984 827058 725510 391010 825154 734623 827040 417547 442587 482608 459258 558333 678878 688403 750576 741053 744360 608800 391530 493455 733065 729000 587483 499199 12128 826593 819838 666978 562132 622746 775652 780158 793246 795374 800598 768626 418334 426071 824861 711964 775103 733111 793216 687359 439492 383379 818397 804144 795097 800392 631762 755447 570399 449424 496936 619247 528607 714349 650532 782503 801612 423320 595711 423973 494735 413117 428051 429728 814606 826278 815928 498152 518081 581501 570994 675145 676372 666719 675094 675960 676303 697758 546926 619091 642521 632031 623375 642290 793845 806777 777257 796090 773890 788212 801087 735332 741613 758268 764909 728096 614520 624227 635973 443117 462005 482330 443816 464939 675891 491637 826079 826889 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.68%) |
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 12128 383379 391010 391530 413117 417547 418334 423320 423973 426071 428051 429728 439492 439660 442587 443117 443816 449424 450803 459258 462005 464939 480064 482330 482608 491637 493455 494735 496936 498152 499199 507124 518081 528607 546926 558333 562132 570399 570994 581501 587483 595711 608800 614520 619091 619247 622746 623375 624227 631762 632031 635973 642290 642521 650532 666719 666978 675094 675145 675891 675960 676303 676372 678878 687359 688403 697758 711964 714927 725510 728096 729000 733065 733111 734623 735332 741053 741613 744360 750576 755447 758268 759731 764909 768626 773890 775103 775652 777257 780158 780406 782503 788212 793216 793246 793845 795097 795374 796090 800392 800598 801087 801612 804144 806777 813067 814606 815928 818397 818984 819838 824861 825154 826079 826278 826593 826889 827040 827058 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife ass licking"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен жоп лиза"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.76%) |
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.