Query Metrics
7
Database Queries
7
Different statements
195.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.41 ms (87.19%) |
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 38068 39285 81603 95742 114756 133698 150461 176394 285831 300296 316911 365989 382353 386385 387325 387786 388189 388857 393496 395562 395929 396656 398870 399358 402585 403054 404234 404554 407378 410754 413703 414635 415200 415464 416094 416707 417024 427770 429046 431348 431541 432723 437843 443300 444446 448557 455390 461713 464687 467208 468599 472110 472773 475143 481515 489127 492112 515225 515372 533948 538580 548604 548825 558307 561649 565045 573172 583641 584734 602633 608432 611282 611948 613294 616075 624368 627738 633471 641745 645538 647983 662777 667082 668389 675253 676759 681389 684248 690468 690528 692100 698468 699009 701465 705305 708454 709539 718071 721385 721390 721755 722493 734501 753929 777800 778276 779316 779356 779848 780461 785389 786198 786374 788337 789201 797634 798653 801171 801378 801424 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (7.23%) |
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 398870 133698 285831 444446 468599 415200 437843 584734 95742 393496 316911 387325 388189 396656 416707 407378 429046 443300 432723 410754 448557 467208 461713 489127 464687 558307 565045 561649 647983 602633 797634 404234 414635 365989 472773 114756 382353 395562 431541 475143 395929 399358 403054 404554 413703 417024 427770 416094 431348 455390 472110 515225 492112 533948 515372 81603 386385 150461 176394 300296 38068 39285 388857 387786 402585 415464 481515 538580 583641 548604 573172 548825 667082 676759 684248 699009 701465 709539 721390 722493 662777 668389 681389 692100 698468 705305 708454 721385 721755 645538 675253 690468 690528 718071 616075 624368 633471 641745 608432 611282 611948 627738 613294 777800 778276 779356 779848 780461 785389 786198 786374 789201 801378 801424 779316 788337 798653 801171 734501 753929 ] |
||||||||||||||||||||||||||||||
|
4.20 ms (2.15%) |
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 38068 39285 81603 95742 114756 133698 150461 176394 285831 300296 316911 365989 382353 386385 387325 387786 388189 388857 393496 395562 395929 396656 398870 399358 402585 403054 404234 404554 407378 410754 413703 414635 415200 415464 416094 416707 417024 427770 429046 431348 431541 432723 437843 443300 444446 448557 455390 461713 464687 467208 468599 472110 472773 475143 481515 489127 492112 515225 515372 533948 538580 548604 548825 558307 561649 565045 573172 583641 584734 602633 608432 611282 611948 613294 616075 624368 627738 633471 641745 645538 647983 662777 667082 668389 675253 676759 681389 684248 690468 690528 692100 698468 699009 701465 705305 708454 709539 718071 721385 721390 721755 722493 734501 753929 777800 778276 779316 779356 779848 780461 785389 786198 786374 788337 789201 797634 798653 801171 801378 801424 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
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.