Query Metrics
7
Database Queries
7
Different statements
203.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.08 ms (87.32%) |
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 188269 233733 310758 385314 389973 391926 409877 424414 424426 424462 426434 428752 429416 432852 432939 441864 443787 443894 443953 445736 446533 448793 450802 450965 453096 459804 459997 462019 462911 464302 466499 467885 468479 469396 471035 477068 477555 483745 486537 493754 494755 495507 496066 500941 502108 509218 511375 522882 526082 529331 530142 535855 538937 541321 541357 545325 547860 555225 555243 555252 555274 555279 555400 555413 562791 563533 565308 570394 576607 576641 576644 582029 585110 593608 596134 597018 606425 610961 613004 620156 620159 629898 656920 657489 660383 661915 664166 669276 670109 671466 681223 699744 706935 721166 728215 729082 737870 740721 752703 756642 766677 783777 791550 800396 803543 813115 815111 815117 815250 815279 815375 815511 815806 816062 816952 816959 817526 817794 819410 824689 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (7.36%) |
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 657489 681223 593608 706935 529331 541357 448793 426434 459997 453096 565308 443953 188269 477555 483745 471035 424462 496066 450965 469396 570394 816952 815111 815279 816062 815250 817526 819410 824689 815375 815511 816959 530142 522882 576641 671466 721166 670109 656920 555274 596134 597018 620159 813115 800396 740721 803543 766677 729082 756642 728215 699744 783777 509218 424426 443787 477068 660383 389973 428752 585110 468479 446533 462911 500941 538937 486537 541321 555413 562791 555400 563533 582029 669276 661915 791550 391926 495507 511375 459804 385314 310758 409877 432852 441864 432939 815806 815117 817794 450802 464302 466499 445736 493754 502108 535855 494755 526082 547860 555243 576644 545325 555225 555279 576607 664166 555252 610961 613004 620156 606425 737870 752703 629898 233733 467885 424414 443894 429416 462019 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.61%) |
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 188269 233733 310758 385314 389973 391926 409877 424414 424426 424462 426434 428752 429416 432852 432939 441864 443787 443894 443953 445736 446533 448793 450802 450965 453096 459804 459997 462019 462911 464302 466499 467885 468479 469396 471035 477068 477555 483745 486537 493754 494755 495507 496066 500941 502108 509218 511375 522882 526082 529331 530142 535855 538937 541321 541357 545325 547860 555225 555243 555252 555274 555279 555400 555413 562791 563533 565308 570394 576607 576641 576644 582029 585110 593608 596134 597018 606425 610961 613004 620156 620159 629898 656920 657489 660383 661915 664166 669276 670109 671466 681223 699744 706935 721166 728215 729082 737870 740721 752703 756642 766677 783777 791550 800396 803543 813115 815111 815117 815250 815279 815375 815511 815806 816062 816952 816959 817526 817794 819410 824689 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal milf hairy"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал milf волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал milf волосатая"
]
|
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.