Query Metrics
7
Database Queries
7
Different statements
205.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.40 ms (85.72%) |
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 357595 385706 390566 395698 395758 395959 396251 401116 402067 413824 447745 472223 510689 554531 564416 568557 597226 598679 604425 604968 607215 614244 618916 620770 622374 624273 626735 632060 633518 641120 643396 644291 645951 646270 649130 649190 655827 660689 674713 676473 677015 677311 679380 683454 683470 685687 688105 688220 689693 692191 697230 697263 698557 703193 705546 705572 705913 706899 708103 708476 708763 715323 716528 717708 717713 718947 718991 719102 721369 721704 722199 723932 733876 735524 737161 737910 740489 740505 743341 743345 747996 748685 750410 751722 754017 758199 761290 762984 766269 774512 775941 787931 788443 788686 788805 789457 789733 790246 790249 800568 801305 803244 803261 804175 805242 807554 807918 811128 814257 815778 815999 817317 817482 818444 819608 819613 821102 821503 826672 827328 ] |
||||||||||||||||||||||||||||||
|
19.83 ms (9.64%) |
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 402067 447745 390566 357595 396251 413824 395959 401116 510689 385706 395698 817482 821503 826672 814257 815778 815999 818444 819608 819613 827328 817317 821102 472223 564416 568557 554531 645951 646270 677015 688105 688220 689693 705572 708103 715323 716528 719102 660689 674713 676473 679380 683454 685687 692191 697230 698557 718947 649130 649190 655827 677311 683470 697263 703193 705546 705913 708476 718991 722199 604968 644291 598679 604425 614244 618916 622374 643396 597226 620770 624273 626735 632060 641120 775941 788443 788686 790249 800568 804175 805242 807554 774512 787931 788805 789457 789733 801305 803261 737910 743341 743345 750410 762984 766269 790246 740489 723932 740505 748685 735524 737161 747996 751722 754017 733876 758199 761290 607215 633518 706899 708763 717708 717713 721369 721704 803244 807918 811128 395758 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.48%) |
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 357595 385706 390566 395698 395758 395959 396251 401116 402067 413824 447745 472223 510689 554531 564416 568557 597226 598679 604425 604968 607215 614244 618916 620770 622374 624273 626735 632060 633518 641120 643396 644291 645951 646270 649130 649190 655827 660689 674713 676473 677015 677311 679380 683454 683470 685687 688105 688220 689693 692191 697230 697263 698557 703193 705546 705572 705913 706899 708103 708476 708763 715323 716528 717708 717713 718947 718991 719102 721369 721704 722199 723932 733876 735524 737161 737910 740489 740505 743341 743345 747996 748685 750410 751722 754017 758199 761290 762984 766269 774512 775941 787931 788443 788686 788805 789457 789733 790246 790249 800568 801305 803244 803261 804175 805242 807554 807918 811128 814257 815778 815999 817317 817482 818444 819608 819613 821102 821503 826672 827328 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal old man"
]
|
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.