Query Metrics
7
Database Queries
7
Different statements
198.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.47 ms (88.28%) |
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 16870 39167 124361 382163 390459 394162 395427 396302 396849 397838 397867 398690 399223 400151 403099 403401 406061 407159 413472 417290 419471 421598 422618 425532 428082 429611 434854 434912 435070 438415 438665 440776 441664 442802 445203 445667 446107 446210 446817 447830 448039 448198 449238 449438 449696 450607 452366 453984 454589 456276 457914 458163 458959 459876 460845 461709 461845 462555 463244 465911 471460 474175 479222 479894 481025 481120 481773 484312 485111 487610 489841 490264 493888 501316 501937 512775 518186 518337 521402 521857 567508 568015 585114 588138 597218 605560 625496 635345 640254 651681 665217 680619 709346 712201 722308 729041 730780 730998 733615 743795 746188 758200 761278 761951 765062 775873 777675 778821 781032 786719 787147 787449 796001 797887 799894 801445 803303 804123 ] |
||||||||||||||||||||||||||||||
|
13.85 ms (6.97%) |
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 458163 474175 481773 501316 501937 521857 493888 518337 521402 512775 400151 39167 16870 390459 396302 397838 398690 403099 406061 425532 407159 448039 458959 481120 567508 568015 665217 722308 651681 680619 712201 597218 635345 640254 588138 625496 775873 777675 778821 781032 786719 799894 803303 780348 797887 804123 761278 787449 796001 729041 730998 761951 730780 758200 765062 768323 733615 743795 746188 605560 709346 787147 801445 403401 434912 396849 459876 417290 438665 460845 456276 518186 124361 394162 395427 382163 397867 399223 434854 441664 442802 421598 422618 428082 413472 445203 419471 429611 435070 438415 440776 585114 446107 446817 448198 449238 449696 453984 454589 457914 461709 462555 463244 471460 479894 487610 489841 490264 445667 446210 461845 465911 479222 481025 484312 485111 447830 449438 450607 452366 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.12%) |
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 16870 39167 124361 382163 390459 394162 395427 396302 396849 397838 397867 398690 399223 400151 403099 403401 406061 407159 413472 417290 419471 421598 422618 425532 428082 429611 434854 434912 435070 438415 438665 440776 441664 442802 445203 445667 446107 446210 446817 447830 448039 448198 449238 449438 449696 450607 452366 453984 454589 456276 457914 458163 458959 459876 460845 461709 461845 462555 463244 465911 471460 474175 479222 479894 481025 481120 481773 484312 485111 487610 489841 490264 493888 501316 501937 512775 518186 518337 521402 521857 567508 568015 585114 588138 597218 605560 625496 635345 640254 651681 665217 680619 709346 712201 722308 729041 730780 730998 733615 743795 746188 758200 761278 761951 765062 775873 777675 778821 781032 786719 787147 787449 796001 797887 799894 801445 803303 804123 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum boy"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum парен"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum парен"
]
|
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.