Query Metrics
7
Database Queries
7
Different statements
165.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.09 ms (83.84%) |
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 391893 391895 391929 401674 409727 426710 426711 443658 451555 454527 455126 456432 456448 462289 462560 463176 464531 465388 466291 470003 470500 470504 470539 470586 470588 470622 470625 470631 470634 470643 470654 470926 473788 473939 473952 474632 475115 475232 475945 476495 477373 477943 477966 483377 484402 484416 484681 485493 488825 492041 492048 493088 495195 495738 502222 504268 510426 512558 512560 513608 517125 517556 520135 520473 523192 523305 524147 526568 527030 530310 533648 533658 533736 533772 534070 535599 542739 542744 542757 542765 542770 542789 544177 545027 545187 547948 547952 551553 560319 560454 566367 567955 568666 576165 585276 590472 590505 590631 590693 616716 648657 653527 670721 678374 694639 720878 725314 730497 731325 741476 743644 753505 755723 757638 758388 792515 799672 809765 811795 814320 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (10.46%) |
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 451555 534070 391895 547948 542739 475232 456432 476495 462289 470634 391929 720878 492048 533648 477373 520135 590631 510426 753505 527030 743644 533772 542770 391893 512558 551553 799672 811795 495195 542765 470625 530310 590472 535599 560319 576165 616716 590693 524147 523192 545027 566367 648657 463176 730497 792515 470504 814320 462560 426711 475115 426710 401674 523305 456448 465388 470654 504268 470622 694639 741476 493088 477943 545187 757638 512560 809765 755723 470643 678374 758388 731325 542744 590505 466291 473788 517556 520473 502222 477966 484416 533736 464531 725314 485493 495738 443658 470500 470631 488825 513608 483377 547952 474632 470588 475945 470003 409727 568666 670721 484402 484681 560454 455126 473939 473952 470926 567955 585276 526568 542757 454527 470586 544177 533658 470539 492041 517125 542789 653527 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.52%) |
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 391893 391895 391929 401674 409727 426710 426711 443658 451555 454527 455126 456432 456448 462289 462560 463176 464531 465388 466291 470003 470500 470504 470539 470586 470588 470622 470625 470631 470634 470643 470654 470926 473788 473939 473952 474632 475115 475232 475945 476495 477373 477943 477966 483377 484402 484416 484681 485493 488825 492041 492048 493088 495195 495738 502222 504268 510426 512558 512560 513608 517125 517556 520135 520473 523192 523305 524147 526568 527030 530310 533648 533658 533736 533772 534070 535599 542739 542744 542757 542765 542770 542789 544177 545027 545187 547948 547952 551553 560319 560454 566367 567955 568666 576165 585276 590472 590505 590631 590693 616716 648657 653527 670721 678374 694639 720878 725314 730497 731325 741476 743644 753505 755723 757638 758388 792515 799672 809765 811795 814320 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife threesome"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.87%) |
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.