Query Metrics
7
Database Queries
7
Different statements
152.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.26 ms (85.96%) |
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 193462 386854 388773 391116 392565 397144 397939 401391 401575 401875 413463 423497 426728 426998 428062 443188 457230 464369 465063 467789 467863 470690 475879 483451 495260 499359 509571 547551 602068 602684 605585 629739 630836 650595 694197 702489 711266 716581 724021 725412 725474 725539 726802 727543 730627 733284 733505 733994 740665 741143 743870 744464 746433 746646 750379 750794 752135 754063 754065 755202 755509 757278 759939 762799 764109 764245 764379 765562 766257 766265 766344 766459 766692 767519 776922 778080 778530 782762 782773 789268 789451 789662 790340 790840 791316 794047 794462 794639 794756 795004 795229 795815 795950 795951 795974 796075 796119 796258 796608 798864 799674 800349 801183 801253 802475 803620 803702 803725 803909 804950 806710 806712 807738 809813 809867 810075 811536 812468 817241 817249 ] |
||||||||||||||||||||||||||||||
|
12.47 ms (8.17%) |
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 602684 629739 778530 782762 789662 794462 795815 802475 776922 782773 789268 794639 796075 796258 798864 803620 803725 724021 725412 725474 733994 740665 741143 746433 755509 766459 790340 790840 791316 795004 795229 795950 796608 799674 803909 806710 807738 730627 750794 757278 765562 766692 754063 725539 726802 733284 733505 744464 746646 752135 755202 762799 764109 764379 767519 727543 743870 750379 754065 764245 766257 766344 602068 605585 702489 711266 778080 789451 794756 795951 795974 800349 801183 803702 804950 806712 809813 809867 810075 811536 812468 392565 467863 465063 467789 470690 509571 495260 388773 483451 386854 397939 401875 426728 426998 464369 457230 499359 423497 817249 547551 650595 694197 630836 801253 759939 794047 796119 766265 716581 475879 193462 391116 397144 401391 401575 413463 428062 443188 817241 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.55%) |
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 193462 386854 388773 391116 392565 397144 397939 401391 401575 401875 413463 423497 426728 426998 428062 443188 457230 464369 465063 467789 467863 470690 475879 483451 495260 499359 509571 547551 602068 602684 605585 629739 630836 650595 694197 702489 711266 716581 724021 725412 725474 725539 726802 727543 730627 733284 733505 733994 740665 741143 743870 744464 746433 746646 750379 750794 752135 754063 754065 755202 755509 757278 759939 762799 764109 764245 764379 765562 766257 766265 766344 766459 766692 767519 776922 778080 778530 782762 782773 789268 789451 789662 790340 790840 791316 794047 794462 794639 794756 795004 795229 795815 795950 795951 795974 796075 796119 796258 796608 798864 799674 800349 801183 801253 802475 803620 803702 803725 803909 804950 806710 806712 807738 809813 809867 810075 811536 812468 817241 817249 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf webcam"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf вебкамер"
]
|
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.