Query Metrics
7
Database Queries
7
Different statements
157.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.72 ms (81.73%) |
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 389612 394258 395166 402887 403434 415815 418293 419057 422150 423155 423481 424247 424269 424520 426011 427081 427985 429792 432887 434470 434523 437974 437997 438044 438056 438334 441821 442551 443459 443949 443958 443961 445320 446592 450145 450171 452719 455536 455626 455835 456487 456703 456832 459113 462996 463805 466587 467675 474271 475469 475910 478207 478212 479879 480263 480629 480644 483578 486881 487698 494178 496472 498670 499712 501703 507000 507519 509097 509250 516606 521355 521568 524205 526398 526881 528756 528814 531935 534568 535572 538062 541582 546532 555128 555930 557810 565695 567081 577243 577632 583142 585569 590917 591935 592921 600094 604238 608645 626405 659022 666672 673862 694139 708148 712540 717189 725451 740828 742930 753211 775235 777482 780936 789490 791505 796072 797551 809978 813084 813249 ] |
||||||||||||||||||||||||||||||
|
19.00 ms (12.06%) |
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 708148 777482 780936 480629 394258 434470 452719 415815 424520 426011 427081 438044 438056 443949 443958 478212 432887 424247 509250 486881 498670 526398 528756 496472 507519 419057 809978 577243 526881 753211 466587 455835 528814 789490 521355 389612 403434 422150 443459 442551 427985 467675 475469 455626 455536 456832 483578 538062 501703 507000 535572 474271 480644 577632 567081 541582 659022 673862 694139 712540 585569 608645 591935 590917 813084 775235 725451 791505 796072 797551 813249 742930 740828 423155 424269 402887 429792 438334 441821 395166 456703 462996 463805 480263 437974 478207 521568 494178 509097 516606 524205 626405 546532 600094 487698 434523 423481 445320 475910 450145 456487 499712 534568 531935 555128 583142 666672 717189 555930 557810 565695 592921 604238 443961 437997 418293 446592 450171 459113 479879 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.81%) |
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 389612 394258 395166 402887 403434 415815 418293 419057 422150 423155 423481 424247 424269 424520 426011 427081 427985 429792 432887 434470 434523 437974 437997 438044 438056 438334 441821 442551 443459 443949 443958 443961 445320 446592 450145 450171 452719 455536 455626 455835 456487 456703 456832 459113 462996 463805 466587 467675 474271 475469 475910 478207 478212 479879 480263 480629 480644 483578 486881 487698 494178 496472 498670 499712 501703 507000 507519 509097 509250 516606 521355 521568 524205 526398 526881 528756 528814 531935 534568 535572 538062 541582 546532 555128 555930 557810 565695 567081 577243 577632 583142 585569 590917 591935 592921 600094 604238 608645 626405 659022 666672 673862 694139 708148 712540 717189 725451 740828 742930 753211 775235 777482 780936 789490 791505 796072 797551 809978 813084 813249 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife swallow"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен глота"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.