Query Metrics
7
Database Queries
7
Different statements
151.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.34 ms (80.77%) |
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 389966 390571 395666 406168 416032 419531 420129 425509 428884 433640 441067 443784 444238 452304 452373 454227 454253 455438 458281 463803 466995 467705 473203 473391 474786 474874 483372 483377 483380 490517 494508 500914 503486 504174 505736 508257 509262 509439 509664 513808 516478 517428 517705 517735 517736 518596 519516 520755 523046 523590 523837 529400 532893 538530 541418 541851 542710 544024 550721 550827 554374 556577 557327 558172 561457 561505 562342 565720 566076 569303 571102 576006 582438 582444 584019 584172 586713 588693 592184 592756 592973 592985 593363 593540 594560 595097 598078 598832 602260 603254 604631 605255 607640 607716 618622 618668 618999 622315 628696 632083 634723 634746 639119 660457 662876 663485 667344 681498 726710 726713 731034 731124 741504 741724 742404 752506 760169 760739 760859 796804 ] |
||||||||||||||||||||||||||||||
|
19.12 ms (12.62%) |
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 452373 454253 467705 490517 500914 494508 503486 505736 517705 520755 508257 509262 517736 529400 517735 532893 557327 576006 584172 542710 550721 550827 561457 562342 566076 582438 584019 660457 662876 663485 667344 681498 554374 592756 592973 592985 593540 598078 622315 605255 607640 618668 618999 639119 594560 598832 603254 628696 634723 592184 595097 607716 731034 742404 760169 760739 796804 741504 726713 760859 726710 741724 752506 602260 604631 632083 428884 466995 455438 458281 406168 419531 474786 416032 483372 483377 523837 473391 731124 473203 389966 444238 443784 425509 519516 569303 571102 541851 556577 593363 618622 588693 634746 390571 474874 483380 441067 538530 541418 509664 518596 509439 516478 504174 586713 433640 395666 420129 454227 463803 452304 517428 523046 523590 513808 558172 561505 565720 582444 544024 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.95%) |
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 389966 390571 395666 406168 416032 419531 420129 425509 428884 433640 441067 443784 444238 452304 452373 454227 454253 455438 458281 463803 466995 467705 473203 473391 474786 474874 483372 483377 483380 490517 494508 500914 503486 504174 505736 508257 509262 509439 509664 513808 516478 517428 517705 517735 517736 518596 519516 520755 523046 523590 523837 529400 532893 538530 541418 541851 542710 544024 550721 550827 554374 556577 557327 558172 561457 561505 562342 565720 566076 569303 571102 576006 582438 582444 584019 584172 586713 588693 592184 592756 592973 592985 593363 593540 594560 595097 598078 598832 602260 603254 604631 605255 607640 607716 618622 618668 618999 622315 628696 632083 634723 634746 639119 660457 662876 663485 667344 681498 726710 726713 731034 731124 741504 741724 742404 752506 760169 760739 760859 796804 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ÐÅ ð┐ð¥ð╗ð¢ÐïðÁ ð▓ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац полная в"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.