Query Metrics
7
Database Queries
7
Different statements
164.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.13 ms (83.22%) |
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 396330 398235 398719 399143 405528 416820 418578 418607 418738 421152 422134 422733 424362 425034 426675 434378 434693 438878 447697 448327 449322 451014 451248 452720 453332 454531 455471 468022 468135 469755 472230 473133 473907 478963 478970 492718 493220 504958 505101 505692 507737 508430 510224 510291 511348 516015 516656 517798 522383 524592 526461 527193 530026 531184 531908 532655 538963 545372 545465 545469 545599 556747 560225 561495 564120 567737 584762 585983 586339 588070 593615 599833 599966 600252 600481 604053 608442 613860 620298 625753 628507 631604 631947 639760 639767 644986 653520 666863 666880 666894 682911 693024 693753 694907 712286 720235 725309 725649 728340 735631 745964 749732 755478 758218 759488 764081 766372 773416 783108 789939 800226 800884 801041 801084 801949 802570 810299 814114 814883 826873 ] |
||||||||||||||||||||||||||||||
|
17.72 ms (10.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 545372 545469 399143 451014 454531 468022 452720 453332 473133 505692 531184 545465 556747 584762 448327 455471 422733 468135 524592 492718 504958 725649 801084 801041 508430 516015 438878 473907 449322 493220 511348 560225 653520 693024 631604 608442 773416 749732 625753 800884 517798 764081 604053 561495 586339 613860 759488 666863 712286 720235 783108 530026 644986 532655 666880 666894 639767 545599 802570 418738 814883 600481 810299 422134 516656 694907 434693 418607 538963 600252 510291 522383 531908 620298 631947 478963 478970 418578 451248 505101 398719 814114 682911 567737 585983 593615 728340 766372 758218 789939 628507 800226 735631 510224 527193 421152 425034 693753 725309 755478 745964 588070 526461 405528 416820 447697 801949 396330 424362 426675 434378 472230 469755 507737 564120 826873 398235 599966 639760 599833 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.65%) |
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 396330 398235 398719 399143 405528 416820 418578 418607 418738 421152 422134 422733 424362 425034 426675 434378 434693 438878 447697 448327 449322 451014 451248 452720 453332 454531 455471 468022 468135 469755 472230 473133 473907 478963 478970 492718 493220 504958 505101 505692 507737 508430 510224 510291 511348 516015 516656 517798 522383 524592 526461 527193 530026 531184 531908 532655 538963 545372 545465 545469 545599 556747 560225 561495 564120 567737 584762 585983 586339 588070 593615 599833 599966 600252 600481 604053 608442 613860 620298 625753 628507 631604 631947 639760 639767 644986 653520 666863 666880 666894 682911 693024 693753 694907 712286 720235 725309 725649 728340 735631 745964 749732 755478 758218 759488 764081 766372 773416 783108 789939 800226 800884 801041 801084 801949 802570 810299 814114 814883 826873 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt on dick"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм член"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм член"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
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.