Query Metrics
7
Database Queries
7
Different statements
162.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.91 ms (84.75%) |
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 395973 421520 422339 422402 422561 422572 422649 423039 423263 428481 428726 430256 437537 443372 444452 445835 446781 447127 447277 447407 454284 456215 460302 462379 463775 463777 463808 463915 464916 465645 465951 474487 479492 479728 480941 481780 491474 491666 492187 492245 495066 496613 496711 496758 506297 507939 508526 512828 512857 513230 513272 513656 513696 518936 519687 521454 522565 525439 527632 528437 528446 529092 531174 531472 532843 532965 533018 533570 533576 533747 536385 536931 537915 538544 538608 538837 540316 543456 544368 546200 549106 550091 554256 555884 555899 556307 559856 565800 571957 597244 599367 602232 605659 605790 614428 623178 623922 626389 626538 634791 639048 647875 647891 651180 651666 651913 656577 662198 665918 665926 666536 666541 678942 679770 718675 720882 733862 788788 788794 817033 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (8.85%) |
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 528437 528446 536931 538544 491474 491666 496758 512828 513230 513272 522565 527632 421520 532843 531174 533747 651666 546200 463808 395973 422561 423039 428481 437537 443372 422649 422402 422572 428726 430256 444452 817033 460302 463775 463915 446781 447277 447407 465951 479728 445835 447127 454284 456215 463777 465645 474487 479492 480941 481780 492187 495066 496613 496711 518936 525439 533018 537915 506297 507939 512857 521454 536385 538837 540316 531472 533576 508526 513656 513696 519687 529092 532965 533570 538608 462379 464916 492245 549106 555884 571957 543456 544368 554256 565800 666541 720882 647891 651180 651913 665926 678942 679770 647875 656577 662198 665918 666536 550091 555899 556307 559856 599367 626538 639048 605790 623178 623922 597244 602232 605659 788788 788794 733862 614428 626389 634791 718675 422339 423263 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.90%) |
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 395973 421520 422339 422402 422561 422572 422649 423039 423263 428481 428726 430256 437537 443372 444452 445835 446781 447127 447277 447407 454284 456215 460302 462379 463775 463777 463808 463915 464916 465645 465951 474487 479492 479728 480941 481780 491474 491666 492187 492245 495066 496613 496711 496758 506297 507939 508526 512828 512857 513230 513272 513656 513696 518936 519687 521454 522565 525439 527632 528437 528446 529092 531174 531472 532843 532965 533018 533570 533576 533747 536385 536931 537915 538544 538608 538837 540316 543456 544368 546200 549106 550091 554256 555884 555899 556307 559856 565800 571957 597244 599367 602232 605659 605790 614428 623178 623922 626389 626538 634791 639048 647875 647891 651180 651666 651913 656577 662198 665918 665926 666536 666541 678942 679770 718675 720882 733862 788788 788794 817033 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen domination"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen domination"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen domination"
]
|
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.