Query Metrics
7
Database Queries
7
Different statements
196.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.87 ms (83.37%) |
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 61051 383924 392004 401204 408885 415878 419613 420140 429366 439052 441041 443250 445413 448795 449406 451121 452876 455914 456190 457480 465132 467097 467563 467588 468148 468219 468946 468949 469735 470453 473366 475426 477506 478437 488820 493443 495467 496337 503738 504085 505139 505386 511274 511893 511953 512933 513220 514868 520913 521682 526504 528657 529739 531862 537861 544831 546129 547468 547470 547474 547482 550337 561015 567063 573188 573204 574763 584999 589166 590129 590803 604228 605026 607569 614350 623300 626082 629602 634100 636948 642022 655010 662072 662886 665083 669018 669038 672925 679270 695870 709693 719461 724459 728571 735563 749255 752613 752706 757466 761632 770544 772579 776031 778172 780684 782050 782839 787511 792715 792749 795391 796315 796678 796681 796695 802906 803544 803576 807142 812553 ] |
||||||||||||||||||||||||||||||
|
21.73 ms (11.06%) |
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 672925 655010 662072 662886 665083 546129 604228 629602 634100 607569 636948 776031 780684 778172 782839 795391 796695 807142 772579 787511 812553 728571 761632 757466 770544 749255 752613 792715 792749 796678 796681 802906 503738 537861 531862 719461 477506 642022 383924 782050 796315 803576 724459 735563 803544 401204 443250 420140 441041 415878 419613 584999 455914 467563 475426 465132 468946 473366 478437 457480 493443 511274 511953 512933 526504 514868 468219 469735 574763 547470 679270 614350 590803 623300 590129 445413 456190 392004 452876 448795 470453 495467 529739 520913 521682 488820 504085 408885 439052 429366 468148 449406 451121 468949 528657 496337 505139 505386 511893 513220 547482 573204 573188 544831 547468 547474 550337 567063 669038 669018 695870 561015 589166 605026 752706 626082 709693 61051 467097 467588 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (1.92%) |
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 61051 383924 392004 401204 408885 415878 419613 420140 429366 439052 441041 443250 445413 448795 449406 451121 452876 455914 456190 457480 465132 467097 467563 467588 468148 468219 468946 468949 469735 470453 473366 475426 477506 478437 488820 493443 495467 496337 503738 504085 505139 505386 511274 511893 511953 512933 513220 514868 520913 521682 526504 528657 529739 531862 537861 544831 546129 547468 547470 547474 547482 550337 561015 567063 573188 573204 574763 584999 589166 590129 590803 604228 605026 607569 614350 623300 626082 629602 634100 636948 642022 655010 662072 662886 665083 669018 669038 672925 679270 695870 709693 719461 724459 728571 735563 749255 752613 752706 757466 761632 770544 772579 776031 778172 780684 782050 782839 787511 792715 792749 795391 796315 796678 796681 796695 802906 803544 803576 807142 812553 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo wife"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд жен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.73%) |
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.