Query Metrics
7
Database Queries
7
Different statements
187.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.71 ms (85.31%) |
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 7308 20031 144252 330414 386894 387245 387709 395887 402239 403755 403986 404209 419102 423497 447083 454313 455190 456738 457024 457994 459505 462334 462887 464548 470674 522815 526379 543784 570500 571908 572155 573069 573600 589899 595747 596594 601905 602665 608630 613945 620645 621462 623398 623672 627141 647848 649956 653593 653618 669233 671129 672335 672800 673081 673142 676489 676608 678811 682329 690693 693617 696568 699114 709782 710188 712298 714814 714844 714855 719062 719299 722218 725132 728283 731797 735951 738737 743232 744340 744746 749482 752183 755399 757544 759595 759622 761466 765411 766717 767861 777580 779039 779737 782506 785733 787297 789094 789278 791528 792430 792571 794416 794844 795503 798325 799620 799756 800629 800914 801407 801948 802491 802506 802539 808249 808724 810681 814970 818591 828306 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (8.44%) |
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 802539 470674 828306 818591 570500 673081 673142 810681 755399 779039 386894 457994 752183 731797 722218 387709 623672 571908 596594 7308 447083 522815 457024 573069 696568 653593 767861 402239 794844 682329 749482 801948 20031 462887 653618 671129 777580 757544 787297 403755 419102 462334 459505 573600 710188 676489 791528 792571 808249 792430 725132 759622 735951 744340 627141 714855 404209 144252 543784 712298 714814 789278 602665 719299 669233 454313 455190 678811 690693 647848 620645 595747 808724 623398 423497 814970 649956 693617 709782 672800 676608 608630 613945 779737 789094 799620 799756 802491 802506 782506 785733 800629 801407 759595 744746 728283 765411 738737 743232 766717 719062 795503 800914 387245 403986 526379 456738 464548 395887 330414 572155 699114 714844 672335 601905 621462 589899 794416 798325 761466 ] |
||||||||||||||||||||||||||||||
|
4.41 ms (2.36%) |
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 7308 20031 144252 330414 386894 387245 387709 395887 402239 403755 403986 404209 419102 423497 447083 454313 455190 456738 457024 457994 459505 462334 462887 464548 470674 522815 526379 543784 570500 571908 572155 573069 573600 589899 595747 596594 601905 602665 608630 613945 620645 621462 623398 623672 627141 647848 649956 653593 653618 669233 671129 672335 672800 673081 673142 676489 676608 678811 682329 690693 693617 696568 699114 709782 710188 712298 714814 714844 714855 719062 719299 722218 725132 728283 731797 735951 738737 743232 744340 744746 749482 752183 755399 757544 759595 759622 761466 765411 766717 767861 777580 779039 779737 782506 785733 787297 789094 789278 791528 792430 792571 794416 794844 795503 798325 799620 799756 800629 800914 801407 801948 802491 802506 802539 808249 808724 810681 814970 818591 828306 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy минет оральн секс"
]
|
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.