Query Metrics
7
Database Queries
7
Different statements
472.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
449.59 ms (95.07%) |
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 7791 20907 39126 82252 105023 129857 151014 214602 220774 233274 242127 365735 382165 382297 383508 385908 386782 388098 388228 388796 393424 396215 398309 417234 426893 449259 451309 457934 463072 464619 471715 479576 494886 521537 528657 533229 536065 545551 551242 556172 559219 570595 578530 579921 580608 580769 587155 590105 602177 605408 605684 609965 617964 622701 635415 640149 640336 645194 650007 650348 651333 660863 663834 665490 666848 667314 672891 677343 680386 683584 684458 684488 692805 701302 702446 703062 713705 715754 722850 724120 724605 726423 726728 729142 730144 732802 734403 744277 748489 750628 751044 756628 757318 757363 764807 767960 768716 773131 774883 779765 780268 782852 784612 784970 789129 790461 791394 800579 802471 804335 804882 805189 805808 807235 814974 820765 827033 828000 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (2.85%) |
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 827033 677343 715754 580608 587155 805189 800579 802471 805808 724605 764807 724120 744277 730144 713705 220774 105023 7791 233274 463072 521537 665490 385908 383508 242127 39126 388098 426893 551242 570595 672891 663834 666848 667314 692805 722850 579921 605408 609965 617964 622701 784612 784970 773131 726728 780268 791394 382297 396215 388228 494886 732802 580769 756628 388796 814974 645194 464619 365735 20907 559219 683584 703062 457934 528657 151014 820765 660863 701302 702446 129857 393424 417234 828000 449259 479576 451309 533229 536065 471715 556172 573937 545551 578530 651333 680386 684488 650348 650007 684458 602177 605684 590105 640149 640336 774883 779765 782852 786867 807235 804335 729142 734403 750628 757363 751044 767960 768716 748489 757318 726423 635415 789129 790461 804882 386782 82252 214602 382165 398309 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (0.72%) |
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 7791 20907 39126 82252 105023 129857 151014 214602 220774 233274 242127 365735 382165 382297 383508 385908 386782 388098 388228 388796 393424 396215 398309 417234 426893 449259 451309 457934 463072 464619 471715 479576 494886 521537 528657 533229 536065 545551 551242 556172 559219 570595 578530 579921 580608 580769 587155 590105 602177 605408 605684 609965 617964 622701 635415 640149 640336 645194 650007 650348 651333 660863 663834 665490 666848 667314 672891 677343 680386 683584 684458 684488 692805 701302 702446 703062 713705 715754 722850 724120 724605 726423 726728 729142 730144 732802 734403 744277 748489 750628 751044 756628 757318 757363 764807 767960 768716 773131 774883 779765 780268 782852 784612 784970 789129 790461 791394 800579 802471 804335 804882 805189 805808 807235 814974 820765 827033 828000 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding sex pussy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding секс pussy"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding секс pussy"
]
|
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.