Query Metrics
7
Database Queries
7
Different statements
177.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.77 ms (86.43%) |
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 398744 411805 414173 416881 417278 418739 418795 425641 429242 429265 442090 443415 443950 456444 457411 460276 462228 462347 464872 466786 468516 474982 477876 483769 491696 493676 497843 502010 504282 506166 508256 512311 513921 518510 519828 523059 528188 532284 535622 538103 539398 541692 548017 552813 553433 557600 558343 558379 562025 562618 564442 574185 575274 579686 590401 596484 598020 601210 604993 606352 606926 607885 614444 615640 622488 626256 642275 690455 693174 702224 718639 729198 730052 734789 740627 743350 755589 756256 763950 763964 765927 767643 771291 771660 771824 773681 774234 777866 778646 779002 779338 781272 781584 782382 782497 785468 786080 786244 789496 790849 791196 796086 796897 797018 798127 800777 802480 802801 804323 807365 809996 810417 812703 813116 813298 813617 818823 819440 820190 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (7.71%) |
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 590401 596484 604993 614444 615640 606352 606926 607885 622488 778646 782382 782497 791196 796897 802801 813116 779338 786080 789496 796086 797018 802480 740627 743350 755589 763950 772131 781272 781584 785468 786244 790849 798127 800777 807365 810417 729198 734789 773681 774234 756256 771291 771660 771824 763964 765927 767643 642275 702224 779002 804323 812703 813298 443950 462347 468516 464872 457411 462228 491696 693174 690455 777866 809996 730052 718639 398744 819440 502010 552813 564442 474982 477876 418795 411805 506166 512311 562618 579686 548017 601210 626256 598020 425641 443415 442090 416881 418739 414173 417278 429242 429265 813617 818823 820190 466786 493676 456444 460276 483769 497843 518510 528188 532284 508256 519828 523059 538103 504282 513921 535622 539398 562025 574185 575274 541692 553433 557600 558343 558379 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.63%) |
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 398744 411805 414173 416881 417278 418739 418795 425641 429242 429265 442090 443415 443950 456444 457411 460276 462228 462347 464872 466786 468516 474982 477876 483769 491696 493676 497843 502010 504282 506166 508256 512311 513921 518510 519828 523059 528188 532284 535622 538103 539398 541692 548017 552813 553433 557600 558343 558379 562025 562618 564442 574185 575274 579686 590401 596484 598020 601210 604993 606352 606926 607885 614444 615640 622488 626256 642275 690455 693174 702224 718639 729198 730052 734789 740627 743350 755589 756256 763950 763964 765927 767643 771291 771660 771824 773681 774234 777866 778646 779002 779338 781272 781584 782382 782497 785468 786080 786244 789496 790849 791196 796086 796897 797018 798127 800777 802480 802801 804323 807365 809996 810417 812703 813116 813298 813617 818823 819440 820190 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov fucking"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов fucking"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов fucking"
]
|
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.