Query Metrics
7
Database Queries
7
Different statements
390.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.13 ms (53.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
157.82 ms (40.42%) |
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 190958 389729 390794 396316 418958 421821 422194 426535 431481 431511 434260 434455 435720 435745 437310 441728 442469 443184 443428 446204 446729 446901 448731 449361 449897 451127 454053 454341 457203 461727 462453 462491 464337 466267 471632 474129 475465 477327 477955 478333 482251 488549 489101 492138 502809 502812 506127 510217 511016 512451 513897 516230 516476 517003 518753 519094 519548 519825 522355 523760 525150 527669 527872 530870 531219 532898 538022 546119 546687 547834 549224 550221 556817 557551 557924 561588 562829 562938 562951 563099 563196 563917 563932 569972 571684 572543 573742 575185 580160 580166 581714 581825 586671 586919 587922 588092 590950 604835 609827 610587 611245 611561 614339 618982 626353 631961 635178 647935 650843 670947 699707 701206 770663 789692 796276 803461 807944 808603 814873 818929 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (4.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 492138 556817 571684 575185 581825 546687 547834 590950 586671 588092 807944 770663 631961 789692 443428 446729 390794 442469 814873 464337 489101 513897 525150 461727 557924 580166 572543 635178 587922 609827 586919 482251 478333 477327 527669 573742 650843 562829 434455 523760 506127 569972 471632 517003 670947 510217 557551 549224 796276 531219 396316 434260 818929 457203 454341 475465 502812 522355 611245 462453 421821 519548 527872 431481 435745 454053 519825 561588 647935 562938 610587 808603 618982 422194 443184 448731 563932 190958 516476 530870 474129 546119 563196 550221 563099 701206 563917 611561 803461 477955 441728 466267 462491 488549 435720 451127 446204 449361 532898 519094 562951 580160 626353 604835 614339 699707 389729 426535 446901 418958 449897 538022 518753 502809 516230 512451 431511 437310 581714 511016 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.67%) |
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 190958 389729 390794 396316 418958 421821 422194 426535 431481 431511 434260 434455 435720 435745 437310 441728 442469 443184 443428 446204 446729 446901 448731 449361 449897 451127 454053 454341 457203 461727 462453 462491 464337 466267 471632 474129 475465 477327 477955 478333 482251 488549 489101 492138 502809 502812 506127 510217 511016 512451 513897 516230 516476 517003 518753 519094 519548 519825 522355 523760 525150 527669 527872 530870 531219 532898 538022 546119 546687 547834 549224 550221 556817 557551 557924 561588 562829 562938 562951 563099 563196 563917 563932 569972 571684 572543 573742 575185 580160 580166 581714 581825 586671 586919 587922 588092 590950 604835 609827 610587 611245 611561 614339 618982 626353 631961 635178 647935 650843 670947 699707 701206 770663 789692 796276 803461 807944 808603 814873 818929 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom спящ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mom sleeping"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom спящ"
]
|
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.