Query Metrics
7
Database Queries
7
Different statements
175.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.63 ms (87.48%) |
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 383672 390108 390286 412855 415863 424192 439796 440708 450933 451222 451316 454384 469959 483735 487291 529595 531827 531852 531855 531874 537155 537269 537321 540426 542874 545449 545462 545551 548197 548926 566282 575171 575956 584031 587484 595166 595194 595581 596223 596632 613780 616349 619666 621960 625779 627194 636751 641997 642076 643249 644335 647530 650719 654988 660383 663317 666855 672323 705571 710528 712496 722383 722394 727976 731790 735931 739798 740580 742672 744050 745295 748492 752654 752689 756749 756785 757473 757872 758622 759335 760195 760548 760563 760659 769149 769343 770379 772257 777751 777768 779280 780309 780387 780393 781259 781262 782998 783016 786015 786864 786888 787466 791028 791880 793072 793149 796692 796700 796716 798297 799683 803551 806454 806828 807110 808971 808991 809015 824668 827296 ] |
||||||||||||||||||||||||||||||
|
11.68 ms (6.65%) |
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 786888 793149 798297 803551 786864 748492 752654 758622 745295 769343 740580 742672 756749 727976 757473 779280 780387 782998 796700 487291 824668 787466 808971 781262 412855 483735 809015 537155 531827 531852 531874 545462 548926 710528 712496 663317 619666 644335 760548 796716 641997 439796 390286 827296 660383 548197 595166 786015 793072 808991 769149 770379 806454 542874 575956 584031 650719 654988 647530 672323 722394 596223 636751 780393 781259 791028 807110 796692 760195 783016 757872 731790 756785 739798 759335 760563 735931 722383 780309 806828 440708 469959 451316 540426 613780 616349 566282 643249 744050 415863 537321 596632 450933 454384 451222 529595 537269 545449 575171 545551 666855 642076 621960 627194 777751 777768 772257 752689 625779 705571 791880 799683 383672 531855 390108 595194 595581 587484 760659 424192 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.80%) |
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 383672 390108 390286 412855 415863 424192 439796 440708 450933 451222 451316 454384 469959 483735 487291 529595 531827 531852 531855 531874 537155 537269 537321 540426 542874 545449 545462 545551 548197 548926 566282 575171 575956 584031 587484 595166 595194 595581 596223 596632 613780 616349 619666 621960 625779 627194 636751 641997 642076 643249 644335 647530 650719 654988 660383 663317 666855 672323 705571 710528 712496 722383 722394 727976 731790 735931 739798 740580 742672 744050 745295 748492 752654 752689 756749 756785 757473 757872 758622 759335 760195 760548 760563 760659 769149 769343 770379 772257 777751 777768 779280 780309 780387 780393 781259 781262 782998 783016 786015 786864 786888 787466 791028 791880 793072 793149 796692 796700 796716 798297 799683 803551 806454 806828 807110 808971 808991 809015 824668 827296 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo riding solo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд riding соло"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд riding соло"
]
|
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.