Query Metrics
7
Database Queries
7
Different statements
150.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.16 ms (79.68%) |
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 236902 400143 402247 413904 442198 443751 444041 445748 453453 455281 459128 461046 461055 461271 462457 463291 463712 464450 464466 464472 465641 465665 465985 466165 467004 467072 467075 467913 469509 470416 472821 474153 475631 475632 478963 479019 480367 480787 483248 486253 486533 486711 487632 488749 489373 491399 491938 492272 492309 493093 493207 494771 495253 496098 502505 502806 504423 505836 508593 509197 512919 513437 513541 514589 514740 514746 514757 514811 515354 515678 515914 516021 516473 517011 517013 517735 518486 518576 518927 519215 519218 519618 519936 520679 520805 522611 522898 525663 526060 526270 527014 528299 528403 528753 529401 530700 531423 531498 531525 531991 534210 534250 534309 541074 541327 542969 549548 586433 595758 596075 609816 626546 628653 629866 640691 664288 665397 684914 687980 712824 ] |
||||||||||||||||||||||||||||||
|
20.55 ms (13.63%) |
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 491938 515354 513541 492309 442198 444041 480787 472821 509197 494771 520805 483248 486711 515678 519618 526060 525663 516473 487632 486253 515914 531423 469509 517013 236902 464450 491399 455281 474153 522611 530700 512919 534250 508593 522898 531525 542969 541074 549548 596075 463712 466165 478963 400143 462457 453453 459128 464466 465641 470416 514757 518486 519215 502806 505836 514746 516021 518576 492272 493207 514740 517011 526270 528403 493093 496098 504423 514811 518927 519218 519936 527014 413904 528753 480367 467004 475632 486533 489373 514589 528299 443751 488749 495253 529401 534309 502505 531991 513437 517735 520679 531498 534210 461055 467075 541327 664288 684914 712824 665397 687980 609816 595758 628653 586433 626546 629866 640691 402247 461271 464472 467913 475631 445748 463291 465985 467072 461046 465665 479019 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.77%) |
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 236902 400143 402247 413904 442198 443751 444041 445748 453453 455281 459128 461046 461055 461271 462457 463291 463712 464450 464466 464472 465641 465665 465985 466165 467004 467072 467075 467913 469509 470416 472821 474153 475631 475632 478963 479019 480367 480787 483248 486253 486533 486711 487632 488749 489373 491399 491938 492272 492309 493093 493207 494771 495253 496098 502505 502806 504423 505836 508593 509197 512919 513437 513541 514589 514740 514746 514757 514811 515354 515678 515914 516021 516473 517011 517013 517735 518486 518576 518927 519215 519218 519618 519936 520679 520805 522611 522898 525663 526060 526270 527014 528299 528403 528753 529401 530700 531423 531498 531525 531991 534210 534250 534309 541074 541327 542969 549548 586433 595758 596075 609816 626546 628653 629866 640691 664288 665397 684914 687980 712824 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature красивая"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature красивая"
]
|
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.