Query Metrics
7
Database Queries
7
Different statements
190.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.76 ms (85.26%) |
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 400817 400819 426444 434015 447522 447554 459489 465908 480428 485565 486189 494463 505266 527859 541676 544509 548796 551256 551417 552395 552977 553469 560611 560623 560630 560963 561004 561657 561677 561722 561834 561841 561891 561929 562223 562265 564423 565951 565956 567773 568122 571062 572999 573676 574101 574502 574550 574567 574578 574819 574896 574905 575076 575156 575492 575744 576088 576105 576279 577130 577321 577401 578501 578503 579026 579580 581078 581934 582532 588257 590081 590352 591367 591938 592329 592381 595359 595412 596161 596459 596638 597005 597114 597815 597964 598444 598734 598753 598782 598788 598958 599553 601877 602762 605437 607549 619506 622399 645994 651895 651957 661283 667052 677042 679040 679383 696164 707480 714444 714448 718647 718669 721393 722625 722781 722825 722883 723609 800272 804306 ] |
||||||||||||||||||||||||||||||
|
18.49 ms (9.69%) |
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 562265 578501 596638 598958 465908 577321 561891 568122 581078 597964 595412 577130 599553 602762 598782 722825 696164 572999 577401 582532 718669 722883 560630 574896 597815 804306 459489 400819 573676 651957 677042 645994 651895 661283 679040 679383 598788 598734 597114 714444 560623 574101 564423 574567 579026 667052 561004 565956 590081 591938 597005 480428 434015 561929 562223 567773 576088 548796 574819 575076 578503 552977 574550 574578 598444 598753 426444 447554 485565 581934 579580 551417 596459 723609 544509 553469 561722 561834 575492 575744 576105 551256 552395 561841 565951 571062 574905 575156 560963 561657 561677 707480 718647 560611 574502 576279 591367 622399 592329 605437 607549 590352 596161 601877 619506 588257 592381 800272 714448 721393 722625 722781 400817 447522 527859 494463 541676 486189 505266 595359 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.30%) |
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 400817 400819 426444 434015 447522 447554 459489 465908 480428 485565 486189 494463 505266 527859 541676 544509 548796 551256 551417 552395 552977 553469 560611 560623 560630 560963 561004 561657 561677 561722 561834 561841 561891 561929 562223 562265 564423 565951 565956 567773 568122 571062 572999 573676 574101 574502 574550 574567 574578 574819 574896 574905 575076 575156 575492 575744 576088 576105 576279 577130 577321 577401 578501 578503 579026 579580 581078 581934 582532 588257 590081 590352 591367 591938 592329 592381 595359 595412 596161 596459 596638 597005 597114 597815 597964 598444 598734 598753 598782 598788 598958 599553 601877 602762 605437 607549 619506 622399 645994 651895 651957 661283 667052 677042 679040 679383 696164 707480 714444 714448 718647 718669 721393 722625 722781 722825 722883 723609 800272 804306 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал butt"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian anal butt"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал butt"
]
|
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.