Query Metrics
7
Database Queries
7
Different statements
154.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.79 ms (83.63%) |
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 305626 392493 392729 396313 399518 417274 417308 417493 424741 426461 427179 427301 429124 430713 432707 435735 443711 446456 447495 448557 456201 456634 462275 463093 465617 466847 474792 475625 483531 486568 504303 504692 504770 510586 518913 519319 519492 523138 523903 548670 552534 565044 565912 566886 568283 568440 569427 574580 578709 580271 581206 585023 585747 588267 589786 593212 595654 598431 599410 601291 602929 609712 609746 610608 611336 620275 620285 621288 621578 622037 623855 624216 624508 644078 657777 673092 675370 681400 687205 687541 689272 689315 689693 698293 698708 699056 699338 699347 699480 699798 702838 703193 703897 705624 706673 706985 712021 713262 713618 715231 715323 719703 719716 721798 722523 731080 733181 734824 741127 743009 743396 744711 753993 759570 765904 766644 771874 776396 808114 814128 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (9.10%) |
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 305626 456201 568283 435735 580271 565912 589786 598431 417308 483531 504303 519319 427301 504770 719703 719716 675370 715231 699798 706673 609746 624216 610608 623855 593212 620275 621288 644078 766644 765904 776396 462275 392493 569427 731080 427179 430713 814128 463093 518913 510586 568440 566886 581206 552534 565044 687205 689693 699338 706985 712021 715323 673092 699056 702838 657777 681400 687541 689315 699347 703193 703897 705624 713618 548670 599410 585747 601291 609712 620285 621578 624508 611336 595654 733181 734824 741127 743009 743396 759570 771874 744711 753993 622037 698293 698708 721798 808114 465617 443711 699480 417493 456634 578709 432707 519492 523138 523903 424741 429124 574580 689272 713262 602929 399518 588267 466847 474792 722523 504692 392729 396313 426461 417274 585023 446456 448557 475625 486568 447495 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.49%) |
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 305626 392493 392729 396313 399518 417274 417308 417493 424741 426461 427179 427301 429124 430713 432707 435735 443711 446456 447495 448557 456201 456634 462275 463093 465617 466847 474792 475625 483531 486568 504303 504692 504770 510586 518913 519319 519492 523138 523903 548670 552534 565044 565912 566886 568283 568440 569427 574580 578709 580271 581206 585023 585747 588267 589786 593212 595654 598431 599410 601291 602929 609712 609746 610608 611336 620275 620285 621288 621578 622037 623855 624216 624508 644078 657777 673092 675370 681400 687205 687541 689272 689315 689693 698293 698708 699056 699338 699347 699480 699798 702838 703193 703897 705624 706673 706985 712021 713262 713618 715231 715323 719703 719716 721798 722523 731080 733181 734824 741127 743009 743396 744711 753993 759570 765904 766644 771874 776396 808114 814128 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young hidden"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
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.