Query Metrics
7
Database Queries
7
Different statements
148.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.16 ms (84.50%) |
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 230821 233459 387541 405682 412827 415344 417090 420324 420327 423307 423861 423907 425928 426483 429492 443711 448401 449447 452062 453487 453591 453595 453850 453875 454537 456185 456188 457638 458406 459030 459514 466299 466548 469255 471080 472303 474792 475840 476599 477420 479393 479401 485046 487176 490155 490158 492816 492819 495487 495490 495498 495856 499827 500720 504175 504805 507154 508782 508991 509058 509887 511876 516743 517102 517256 520366 520386 521930 523135 523945 533070 533078 534355 534358 534368 535960 536022 537619 538822 547882 550110 550480 552859 553197 558450 565883 568274 570928 573332 597836 598986 599235 615721 615730 617885 625761 634454 644067 650746 673568 673572 678692 694417 712700 725741 729897 740049 751390 752477 761797 763820 782306 784104 789555 803358 811902 814057 823277 828326 828721 ] |
||||||||||||||||||||||||||||||
|
12.97 ms (8.75%) |
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 499827 453595 412827 456185 490158 423907 495856 466548 625761 459514 570928 457638 789555 420324 500720 474792 423307 573332 466299 492816 453875 828326 803358 495487 504175 420327 509058 469255 521930 534368 550480 449447 511876 694417 558450 547882 644067 405682 443711 509887 495498 490155 429492 673572 459030 487176 230821 233459 448401 508782 495490 615730 617885 453850 523945 751390 814057 417090 504805 475840 458406 507154 553197 615721 456188 823277 828721 533070 533078 534358 536022 550110 673568 712700 634454 599235 650746 534355 752477 477420 516743 485046 568274 479401 597836 453487 598986 729897 761797 520386 452062 565883 454537 492819 740049 523135 537619 415344 538822 784104 453591 517102 678692 763820 426483 552859 476599 479393 472303 387541 425928 423861 520366 508991 535960 471080 811902 725741 782306 517256 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.98%) |
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 230821 233459 387541 405682 412827 415344 417090 420324 420327 423307 423861 423907 425928 426483 429492 443711 448401 449447 452062 453487 453591 453595 453850 453875 454537 456185 456188 457638 458406 459030 459514 466299 466548 469255 471080 472303 474792 475840 476599 477420 479393 479401 485046 487176 490155 490158 492816 492819 495487 495490 495498 495856 499827 500720 504175 504805 507154 508782 508991 509058 509887 511876 516743 517102 517256 520366 520386 521930 523135 523945 533070 533078 534355 534358 534368 535960 536022 537619 538822 547882 550110 550480 552859 553197 558450 565883 568274 570928 573332 597836 598986 599235 615721 615730 617885 625761 634454 644067 650746 673568 673572 678692 694417 712700 725741 729897 740049 751390 752477 761797 763820 782306 784104 789555 803358 811902 814057 823277 828326 828721 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden public sex"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.96%) |
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.