Query Metrics
7
Database Queries
7
Different statements
143.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.78 ms (83.37%) |
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 365912 383842 384289 387550 390693 390881 392238 396110 397352 401122 404690 404831 406799 407433 408586 415148 416969 418623 418840 420499 422609 422716 426395 429479 435413 447139 449112 455877 457259 457516 459149 464161 469778 475102 477076 477514 477745 478078 486275 491487 492294 500815 510554 512152 523442 528275 530958 533090 536271 551962 552682 553996 556418 561730 565159 565935 566981 572709 574292 577100 584252 585898 592357 593878 595447 596039 597747 597865 601524 605329 605332 605405 615040 641828 656944 661034 665931 668305 671077 671579 671644 672112 672159 674688 675204 681515 688032 699731 703142 712174 720372 720375 729691 731245 734770 736943 739969 744630 749215 752584 756095 756841 761090 762285 763798 767198 770261 776662 780662 780950 791000 799692 800282 800553 818551 819537 820890 821716 822205 823341 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (9.66%) |
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 596039 752584 799692 731245 734770 699731 780662 397352 477076 401122 822205 820890 821716 510554 565159 553996 566981 671077 672112 597865 595447 605329 605332 592357 800553 756095 756841 744630 767198 763798 712174 464161 422609 429479 415148 491487 577100 593878 455877 477514 492294 390693 416969 435413 556418 552682 478078 406799 457259 422716 823341 818551 477745 447139 749215 762285 761090 641828 392238 390881 407433 387550 561730 475102 486275 523442 739969 418840 551962 512152 530958 533090 656944 681515 720375 665931 720372 565935 585898 791000 776662 800282 736943 383842 404831 459149 536271 572709 584252 674688 671644 672159 675204 703142 661034 668305 688032 605405 729691 770261 780950 408586 420499 365912 457516 396110 404690 418623 500815 574292 671579 597747 615040 601524 469778 528275 384289 426395 819537 449112 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.96%) |
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 365912 383842 384289 387550 390693 390881 392238 396110 397352 401122 404690 404831 406799 407433 408586 415148 416969 418623 418840 420499 422609 422716 426395 429479 435413 447139 449112 455877 457259 457516 459149 464161 469778 475102 477076 477514 477745 478078 486275 491487 492294 500815 510554 512152 523442 528275 530958 533090 536271 551962 552682 553996 556418 561730 565159 565935 566981 572709 574292 577100 584252 585898 592357 593878 595447 596039 597747 597865 601524 605329 605332 605405 615040 641828 656944 661034 665931 668305 671077 671579 671644 672112 672159 674688 675204 681515 688032 699731 703142 712174 720372 720375 729691 731245 734770 736943 739969 744630 749215 752584 756095 756841 761090 762285 763798 767198 770261 776662 780662 780950 791000 799692 800282 800553 818551 819537 820890 821716 822205 823341 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy anal teens"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая анал teens"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая анал teens"
]
|
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.