Query Metrics
7
Database Queries
7
Different statements
271.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
246.36 ms (90.79%) |
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 233355 233443 383249 383880 386771 388772 388891 388962 389980 390805 390904 391326 391545 393052 395310 398098 398446 398912 400026 401764 402219 402222 403166 418871 421544 428574 428586 441430 441479 441613 443868 447819 452864 458920 488697 495364 500308 503448 521294 540844 543162 546057 552329 561012 575606 575665 576496 583082 590806 593560 595435 597798 598135 598493 598754 600146 603052 624170 632118 632593 633316 636049 639552 647275 650230 651876 652955 654346 656579 656593 658837 662148 662181 669001 670048 671665 671670 671952 673488 692094 696160 696227 698434 702162 712583 717235 717890 719376 720362 721322 722649 724129 725144 726164 741529 743087 744689 745503 746802 746972 747519 752595 754180 755634 767315 769802 770287 776289 777056 785582 787505 792179 793440 795684 797389 800554 805654 805668 805722 828848 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (5.61%) |
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 797389 391545 400026 458920 233355 390904 395310 447819 503448 702162 662181 669001 598493 633316 441430 495364 393052 576496 698434 692094 721322 632118 793440 805722 743087 745503 744689 770287 746972 390805 398912 233443 402222 828848 386771 391326 632593 389980 552329 575665 673488 383880 388891 401764 403166 441613 421544 443868 428586 651876 696227 595435 593560 800554 725144 767315 452864 383249 388772 402219 418871 500308 488697 521294 388962 398098 398446 428574 441479 540844 561012 543162 546057 583082 650230 656579 670048 671665 671952 712583 720362 652955 658837 662148 696160 717890 719376 647275 654346 656593 671670 717235 722649 575606 597798 603052 636049 600146 590806 598135 598754 624170 639552 776289 777056 785582 792179 795684 805654 746802 747519 752595 754180 755634 769802 787505 805668 724129 726164 741529 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.03%) |
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 233355 233443 383249 383880 386771 388772 388891 388962 389980 390805 390904 391326 391545 393052 395310 398098 398446 398912 400026 401764 402219 402222 403166 418871 421544 428574 428586 441430 441479 441613 443868 447819 452864 458920 488697 495364 500308 503448 521294 540844 543162 546057 552329 561012 575606 575665 576496 583082 590806 593560 595435 597798 598135 598493 598754 600146 603052 624170 632118 632593 633316 636049 639552 647275 650230 651876 652955 654346 656579 656593 658837 662148 662181 669001 670048 671665 671670 671952 673488 692094 696160 696227 698434 702162 712583 717235 717890 719376 720362 721322 722649 724129 725144 726164 741529 743087 744689 745503 746802 746972 747519 752595 754180 755634 767315 769802 770287 776289 777056 785582 787505 792179 793440 795684 797389 800554 805654 805668 805722 828848 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал teen анал"
]
|
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.