Query Metrics
7
Database Queries
7
Different statements
188.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.15 ms (82.19%) |
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 387251 387905 405961 410254 417067 418538 419550 420635 420695 421250 421871 421907 422044 422463 424411 439819 441004 442673 443660 443779 443784 443823 443926 447045 448521 449170 453494 453841 454277 455411 456455 456614 462305 463074 464327 464368 466355 467555 470487 470657 470941 474289 474633 474639 475439 475846 476797 478096 480059 482132 482142 482506 484628 484629 484656 484665 484681 484727 484738 484748 484750 495149 500363 502147 503658 506056 508180 509033 510398 512355 513604 513607 515358 516329 520753 522556 524018 531884 534968 537970 538360 544528 544665 544668 549799 550667 551130 553190 558788 562758 565351 573800 578411 581433 583482 583500 590230 590469 591416 598859 603635 603653 603675 609531 612422 628654 639044 639060 640136 648539 653052 671863 671893 707889 710265 724305 728143 733239 750725 751565 ] |
||||||||||||||||||||||||||||||
|
22.22 ms (11.77%) |
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 448521 422463 418538 463074 495149 478096 653052 648539 424411 470657 470941 512355 484738 484727 581433 420695 453494 456614 454277 516329 549799 609531 603635 603675 603653 612422 467555 466355 484629 387251 591416 475846 509033 443823 447045 453841 583482 590230 480059 455411 502147 544668 419550 565351 544528 482506 421907 510398 464368 421871 420635 441004 707889 558788 417067 520753 598859 387905 443660 534968 443779 462305 456455 443784 484628 531884 639044 421250 538360 551130 583500 671893 640136 474639 484748 484750 513607 750725 733239 578411 544665 573800 590469 524018 537970 482132 500363 443926 405961 442673 503658 550667 422044 476797 470487 506056 475439 515358 724305 474633 484665 484656 410254 639060 751565 464327 508180 628654 482142 484681 728143 553190 439819 474289 449170 671863 710265 522556 562758 513604 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (2.22%) |
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 387251 387905 405961 410254 417067 418538 419550 420635 420695 421250 421871 421907 422044 422463 424411 439819 441004 442673 443660 443779 443784 443823 443926 447045 448521 449170 453494 453841 454277 455411 456455 456614 462305 463074 464327 464368 466355 467555 470487 470657 470941 474289 474633 474639 475439 475846 476797 478096 480059 482132 482142 482506 484628 484629 484656 484665 484681 484727 484738 484748 484750 495149 500363 502147 503658 506056 508180 509033 510398 512355 513604 513607 515358 516329 520753 522556 524018 531884 534968 537970 538360 544528 544665 544668 549799 550667 551130 553190 558788 562758 565351 573800 578411 581433 583482 583500 590230 590469 591416 598859 603635 603653 603675 609531 612422 628654 639044 639060 640136 648539 653052 671863 671893 707889 710265 724305 728143 733239 750725 751565 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swinger wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"свингер жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.85%) |
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.