Query Metrics
7
Database Queries
7
Different statements
173.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.94 ms (82.99%) |
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 2291 107495 318463 352045 382489 383823 384030 386414 389062 395685 397605 397865 401202 401398 401773 405112 412403 415928 416215 422243 425490 425992 426917 427359 428054 429430 429839 443142 443776 445112 446545 450563 450816 453021 453091 453635 454446 454973 455757 459372 459899 460923 464545 466069 466941 467835 467914 468953 474104 475900 476282 476356 476495 477715 478011 478933 479038 484564 485741 485980 487356 489396 491157 491461 494592 499051 502025 502061 504024 505640 506824 508163 509639 513975 518828 518829 522563 526642 526967 528772 547920 548036 549248 553235 556436 559038 559279 559645 562962 564794 574678 589780 624466 663367 690092 726698 728975 731752 731754 733110 733473 740611 744988 745922 771482 774403 781812 781962 800023 801064 805265 808057 810715 820368 826169 826380 826381 826384 826889 827419 ] |
||||||||||||||||||||||||||||||
|
18.54 ms (10.69%) |
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 505640 487356 426917 518828 467835 827419 386414 820368 781962 733473 416215 454446 548036 384030 443142 513975 781812 808057 744988 2291 726698 459899 826380 826381 826889 826169 740611 547920 491461 428054 559645 624466 800023 745922 733110 728975 805265 415928 589780 556436 810715 489396 425992 460923 422243 445112 412403 526642 506824 401773 502061 499051 494592 559279 476356 491157 459372 502025 468953 476282 518829 826384 731754 478933 401202 484564 446545 771482 476495 427359 453021 731752 107495 401398 562962 553235 522563 485980 425490 453635 504024 526967 574678 450563 774403 528772 564794 352045 450816 454973 475900 395685 405112 466069 397605 455757 453091 397865 464545 479038 383823 467914 429430 474104 477715 485741 429839 443776 509639 549248 382489 508163 559038 318463 690092 663367 801064 389062 478011 466941 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.79%) |
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 2291 107495 318463 352045 382489 383823 384030 386414 389062 395685 397605 397865 401202 401398 401773 405112 412403 415928 416215 422243 425490 425992 426917 427359 428054 429430 429839 443142 443776 445112 446545 450563 450816 453021 453091 453635 454446 454973 455757 459372 459899 460923 464545 466069 466941 467835 467914 468953 474104 475900 476282 476356 476495 477715 478011 478933 479038 484564 485741 485980 487356 489396 491157 491461 494592 499051 502025 502061 504024 505640 506824 508163 509639 513975 518828 518829 522563 526642 526967 528772 547920 548036 549248 553235 556436 559038 559279 559645 562962 564794 574678 589780 624466 663367 690092 726698 728975 731752 731754 733110 733473 740611 744988 745922 771482 774403 781812 781962 800023 801064 805265 808057 810715 820368 826169 826380 826381 826384 826889 827419 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни толстушке"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс полная"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс полная"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.