Query Metrics
7
Database Queries
7
Different statements
148.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.89 ms (80.70%) |
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 395698 399088 399170 400682 401105 404950 406339 423620 427437 429629 432552 435022 436577 439125 443555 445334 445411 446099 447719 457893 458681 459111 460697 463921 468145 473529 478462 479756 482538 483814 490174 491275 494143 494526 496164 497371 499902 501534 506073 507685 508149 508754 518446 518519 521899 523357 523420 523991 524070 529092 530488 532940 533018 533522 534032 540273 550294 556334 560608 562853 565160 565958 568123 568643 571210 574870 576114 576388 580631 581518 582708 583592 585417 593766 597269 597907 601536 616025 627810 628116 629934 632123 632638 632969 634512 637141 639254 641623 648924 649576 651620 657128 670250 679190 680120 680161 681505 683963 696995 718675 722264 731303 747136 749128 749456 750527 758226 759344 771918 772708 773664 780597 784054 791604 792137 806192 806325 814460 820774 823427 ] |
||||||||||||||||||||||||||||||
|
19.31 ms (13.00%) |
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 639254 791604 806325 731303 747136 400682 439125 501534 496164 508754 499902 580631 460697 534032 497371 632123 806192 749456 556334 571210 628116 395698 820774 823427 722264 680161 683963 585417 780597 772708 773664 406339 792137 457893 445411 447719 483814 523357 696995 583592 632969 427437 518519 657128 593766 478462 506073 524070 749128 632638 423620 432552 533522 581518 560608 670250 651620 565958 574870 750527 468145 521899 494143 523420 680120 637141 679190 399088 445334 533018 530488 576388 565160 576114 648924 649576 568123 641623 758226 629934 459111 463921 399170 443555 429629 458681 508149 518446 523991 627810 634512 473529 550294 479756 404950 784054 446099 532940 597269 562853 582708 681505 435022 507685 491275 401105 616025 601536 436577 814460 482538 540273 494526 529092 490174 568643 597907 759344 771918 718675 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.59%) |
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 395698 399088 399170 400682 401105 404950 406339 423620 427437 429629 432552 435022 436577 439125 443555 445334 445411 446099 447719 457893 458681 459111 460697 463921 468145 473529 478462 479756 482538 483814 490174 491275 494143 494526 496164 497371 499902 501534 506073 507685 508149 508754 518446 518519 521899 523357 523420 523991 524070 529092 530488 532940 533018 533522 534032 540273 550294 556334 560608 562853 565160 565958 568123 568643 571210 574870 576114 576388 580631 581518 582708 583592 585417 593766 597269 597907 601536 616025 627810 628116 629934 632123 632638 632969 634512 637141 639254 641623 648924 649576 651620 657128 670250 679190 680120 680161 681505 683963 696995 718675 722264 731303 747136 749128 749456 750527 758226 759344 771918 772708 773664 780597 784054 791604 792137 806192 806325 814460 820774 823427 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl first anal"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк first анал"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк first анал"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.