Query Metrics
7
Database Queries
7
Different statements
195.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.77 ms (85.87%) |
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 68658 387670 389579 391451 394161 394490 397102 397427 397760 402084 402195 402398 404443 413584 413641 416397 417735 420083 421369 421489 424387 426159 426179 426675 428107 428772 433164 433202 433253 436316 439323 439769 441326 441383 441401 441623 447146 447423 447434 447435 447438 447486 447499 447514 447807 452286 452568 453824 464181 472764 475237 476962 479754 479774 480945 484980 492822 494072 496090 505130 513313 518547 519841 528999 531631 532286 535706 535882 536505 536876 538239 538604 538709 538740 556573 565283 565952 568127 570046 576301 576980 580853 594213 594353 597818 603285 605323 609898 609926 623200 631620 632296 633533 634155 634499 637122 637425 641677 642044 642304 642687 666865 666968 676328 680127 685001 713880 718714 796916 811275 818183 818787 821917 827279 828128 828431 828433 828443 828764 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (8.46%) |
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 632296 642304 421489 594353 603285 480945 472764 452286 479774 417735 426159 433253 441326 441623 426179 416397 433202 413641 447423 479754 452568 484980 453824 494072 536876 518547 535882 565283 565952 576301 576980 685001 680127 666968 570046 605323 623200 634155 637122 597818 633533 637425 594213 634499 609898 609926 436316 441383 441401 447807 475237 404443 413584 420083 426675 464181 476962 397427 421369 424387 433164 447438 447514 439769 447146 447434 447435 447486 447499 492822 505130 496090 513313 519841 666865 642044 642687 428772 532286 536505 556573 568127 676328 713880 631620 641677 811275 394490 391451 580853 796916 718714 402195 68658 439323 394161 389579 387670 397102 397760 402084 402398 428107 827279 818183 818787 821917 828764 828128 828433 828652 828431 828443 538709 538740 531631 535706 538239 538604 528999 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (2.10%) |
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 68658 387670 389579 391451 394161 394490 397102 397427 397760 402084 402195 402398 404443 413584 413641 416397 417735 420083 421369 421489 424387 426159 426179 426675 428107 428772 433164 433202 433253 436316 439323 439769 441326 441383 441401 441623 447146 447423 447434 447435 447438 447486 447499 447514 447807 452286 452568 453824 464181 472764 475237 476962 479754 479774 480945 484980 492822 494072 496090 505130 513313 518547 519841 528999 531631 532286 535706 535882 536505 536876 538239 538604 538709 538740 556573 565283 565952 568127 570046 576301 576980 580853 594213 594353 597818 603285 605323 609898 609926 623200 631620 632296 633533 634155 634499 637122 637425 641677 642044 642304 642687 666865 666968 676328 680127 685001 713880 718714 796916 811275 818183 818787 821917 827279 828128 828431 828433 828443 828764 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen natural"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen натуральная натуральные"
]
|
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.