Query Metrics
7
Database Queries
7
Different statements
358.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.48 ms (58.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк девушк"
]
|
||||||||||||||||||||||||||||||
|
122.32 ms (34.11%) |
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 69611 69704 79826 81510 81603 336987 387759 387835 393677 398369 410328 418084 418375 420405 420548 431652 432316 449800 459771 469059 474384 489327 490599 504488 508973 519570 527530 530101 532567 534742 540158 540250 542887 547533 558757 558763 570858 571336 571765 578824 585916 585968 588317 590493 602568 609233 629537 629558 629649 629662 629870 629929 629932 634100 634883 647143 650478 658819 659350 662002 662195 667235 674307 680612 685233 689483 694127 700689 704840 709707 710754 710817 710929 714399 716657 717149 717181 720036 723438 726293 727298 727413 731054 733356 734524 734696 738114 738898 739987 740246 741318 743422 747853 750224 753172 757803 760562 760624 767440 768334 773691 776984 777627 778221 778270 779084 785313 785568 786101 786160 790398 793853 794569 794587 801987 805212 807849 812157 812443 813211 ] |
||||||||||||||||||||||||||||||
|
19.03 ms (5.31%) |
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 659350 558757 578824 588317 418084 393677 432316 530101 527530 469059 542887 658819 571336 585916 585968 634100 785568 743422 629929 629932 805212 420548 431652 474384 418375 489327 79826 81603 602568 629649 490599 410328 387759 387835 420405 459771 449800 534742 570858 558763 547533 710817 714399 716657 720036 723438 647143 662195 680612 689483 694127 709707 650478 662002 667235 674307 685233 704840 710754 710929 629662 634883 629537 776984 777627 807849 812443 779084 790398 793853 794569 727413 733356 753172 760562 785313 786101 786160 794587 801987 813211 731054 734524 738898 757803 740246 750224 773691 726293 747853 768334 727298 734696 738114 739987 741318 760624 767440 609233 629558 700689 717149 717181 778221 778270 812157 81510 69704 540158 69611 519570 540250 571765 629870 508973 532567 504488 398369 590493 336987 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.77%) |
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 69611 69704 79826 81510 81603 336987 387759 387835 393677 398369 410328 418084 418375 420405 420548 431652 432316 449800 459771 469059 474384 489327 490599 504488 508973 519570 527530 530101 532567 534742 540158 540250 542887 547533 558757 558763 570858 571336 571765 578824 585916 585968 588317 590493 602568 609233 629537 629558 629649 629662 629870 629929 629932 634100 634883 647143 650478 658819 659350 662002 662195 667235 674307 680612 685233 689483 694127 700689 704840 709707 710754 710817 710929 714399 716657 717149 717181 720036 723438 726293 727298 727413 731054 733356 734524 734696 738114 738898 739987 740246 741318 743422 747853 750224 753172 757803 760562 760624 767440 768334 773691 776984 777627 778221 778270 779084 785313 785568 786101 786160 790398 793853 794569 794587 801987 805212 807849 812157 812443 813211 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation girl"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.