Query Metrics
7
Database Queries
7
Different statements
153.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.63 ms (83.03%) |
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 66611 188552 398655 403650 407685 418747 421835 421868 421871 422161 422203 422292 424093 426515 439524 439635 439720 439813 444298 444679 444917 450220 451517 453230 453242 453714 458730 459946 460258 460750 461318 461989 462140 464547 466085 467055 468890 469034 469390 470474 470939 472392 472691 477985 478320 478372 479115 482323 483022 484463 485712 490001 491240 496873 500046 505622 507128 508603 511314 516480 517069 518762 519589 520826 525610 527773 537267 538005 539546 547870 548388 549231 552285 552857 555400 555995 556519 558883 558898 559059 561453 561495 561505 563161 563749 565661 565724 567502 568596 570950 574433 591024 591033 591512 597094 668645 697000 709257 714380 725220 730186 735932 735934 736137 739739 746715 765218 786120 794218 794878 800528 819754 820377 820381 823582 824194 824212 824311 824453 827396 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (10.22%) |
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 477985 591033 561505 484463 485712 66611 820381 459946 558883 555995 709257 439635 461989 468890 422203 470474 527773 426515 453230 458730 668645 421835 424093 462140 439720 561495 730186 735932 398655 568596 444679 478372 591024 591512 519589 725220 453242 460258 500046 714380 574433 421868 444917 483022 490001 697000 819754 820377 824311 824212 565661 421871 736137 450220 518762 539546 470939 827396 800528 567502 460750 422161 549231 556519 559059 597094 824453 739739 765218 418747 444298 552285 561453 464547 517069 547870 482323 823582 570950 746715 505622 511314 794218 496873 479115 508603 563749 786120 188552 520826 525610 403650 472691 537267 451517 422292 491240 548388 735934 472392 407685 478320 555400 453714 516480 824194 461318 794878 563161 565724 558898 439524 466085 439813 507128 538005 469034 552857 469390 467055 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.84%) |
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 66611 188552 398655 403650 407685 418747 421835 421868 421871 422161 422203 422292 424093 426515 439524 439635 439720 439813 444298 444679 444917 450220 451517 453230 453242 453714 458730 459946 460258 460750 461318 461989 462140 464547 466085 467055 468890 469034 469390 470474 470939 472392 472691 477985 478320 478372 479115 482323 483022 484463 485712 490001 491240 496873 500046 505622 507128 508603 511314 516480 517069 518762 519589 520826 525610 527773 537267 538005 539546 547870 548388 549231 552285 552857 555400 555995 556519 558883 558898 559059 561453 561495 561505 563161 563749 565661 565724 567502 568596 570950 574433 591024 591033 591512 597094 668645 697000 709257 714380 725220 730186 735932 735934 736137 739739 746715 765218 786120 794218 794878 800528 819754 820377 820381 823582 824194 824212 824311 824453 827396 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mature kitchen"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск mature кухн"
]
|
||||||||||||||||||||||||||||||
|
1.62 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.