Query Metrics
7
Database Queries
7
Different statements
184.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.81 ms (87.80%) |
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 7051 395849 396066 396074 396538 400171 401319 406800 410636 412515 419496 421400 421520 421660 421809 422233 422821 427490 430320 430822 437118 437853 441744 442076 443312 447131 447528 447638 451616 452269 460770 465862 466653 467328 468606 470211 476419 476725 482763 486189 493849 496287 497892 504937 507175 509470 523100 526655 527545 530803 541676 545206 550236 552190 552425 554764 555723 557415 558026 558083 558846 558878 559033 560008 560045 561885 562278 564196 564423 565946 568790 569853 569915 572237 572359 573060 574079 574544 574585 575154 575484 576324 576407 580661 580676 581607 582474 584502 585160 585804 585899 588266 589108 591427 592381 596898 598087 598587 599023 599712 603059 607093 609388 660289 670033 670495 689325 702432 713840 714432 722625 723377 725640 732000 743018 747092 788553 813925 814542 826184 ] |
||||||||||||||||||||||||||||||
|
12.97 ms (7.04%) |
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 437853 576324 564196 589108 422233 476419 470211 497892 523100 7051 396074 410636 441744 814542 813925 447131 466653 552190 562278 573060 580676 569853 552425 670033 689325 713840 660289 702432 670495 585804 598587 585899 743018 747092 732000 401319 396066 412515 527545 496287 421520 565946 826184 395849 400171 421400 427490 437118 442076 419496 443312 421809 482763 452269 451616 460770 468606 476725 465862 504937 530803 550236 555723 557415 558083 559033 560045 569915 572359 574079 545206 561885 574544 575154 576407 582474 584502 558846 558878 560008 564423 568790 723377 554764 558026 572237 574585 575484 580661 581607 588266 598087 599023 585160 599712 603059 591427 592381 596898 607093 788553 725640 609388 714432 722625 467328 421660 430320 406800 422821 430822 396538 447638 447528 526655 493849 509470 541676 507175 486189 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.34%) |
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 7051 395849 396066 396074 396538 400171 401319 406800 410636 412515 419496 421400 421520 421660 421809 422233 422821 427490 430320 430822 437118 437853 441744 442076 443312 447131 447528 447638 451616 452269 460770 465862 466653 467328 468606 470211 476419 476725 482763 486189 493849 496287 497892 504937 507175 509470 523100 526655 527545 530803 541676 545206 550236 552190 552425 554764 555723 557415 558026 558083 558846 558878 559033 560008 560045 561885 562278 564196 564423 565946 568790 569853 569915 572237 572359 573060 574079 574544 574585 575154 575484 576324 576407 580661 580676 581607 582474 584502 585160 585804 585899 588266 589108 591427 592381 596898 598087 598587 599023 599712 603059 607093 609388 660289 670033 670495 689325 702432 713840 714432 722625 723377 725640 732000 743018 747092 788553 813925 814542 826184 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая попа"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая жоп"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.72%) |
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.