Query Metrics
7
Database Queries
7
Different statements
171.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.83 ms (83.88%) |
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 78412 150405 184359 381811 387885 391893 392967 394543 397700 397891 398210 398700 403245 405820 411574 420782 421131 443838 454456 457786 469764 470242 470917 474012 474016 477046 484721 495043 504201 506820 517620 519240 526597 530286 532681 533050 533523 533929 534004 534640 535585 535602 535612 536063 536544 536958 540443 542770 542821 543658 544252 544661 544751 545096 545210 545420 545584 547966 553241 554811 555152 557371 557977 557981 558626 561046 563644 568180 568188 575667 578413 580413 582864 583955 630578 645493 648984 649276 650978 651287 651317 651420 653175 653712 653889 654217 660084 667075 671243 676788 677584 679415 680587 682291 682351 692457 693789 694027 694265 694346 697153 705398 707239 712501 712892 714126 715158 716564 719726 719963 720208 721972 722104 722967 723433 741152 745311 755134 785118 802483 ] |
||||||||||||||||||||||||||||||
|
16.60 ms (9.68%) |
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 755134 741152 745311 630578 707239 719963 723433 785118 802483 405820 78412 411574 397700 397891 398210 519240 533929 534004 474012 557977 558626 578413 542770 557981 470242 474016 421131 454456 477046 469764 470917 457786 526597 484721 495043 506820 504201 150405 184359 394543 391893 392967 381811 387885 398700 403245 420782 443838 517620 533523 534640 535585 535602 536063 540443 536544 536958 530286 532681 533050 535612 543658 544661 544751 545096 547966 557371 568180 575667 580413 542821 545420 545584 554811 555152 563644 544252 545210 553241 561046 568188 582864 583955 651287 651420 653712 653889 660084 671243 676788 680587 692457 693789 694027 694346 712501 715158 719726 722104 722967 645493 648984 649276 650978 651317 653175 654217 667075 677584 679415 682291 682351 694265 697153 705398 712892 714126 716564 720208 721972 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.62%) |
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 78412 150405 184359 381811 387885 391893 392967 394543 397700 397891 398210 398700 403245 405820 411574 420782 421131 443838 454456 457786 469764 470242 470917 474012 474016 477046 484721 495043 504201 506820 517620 519240 526597 530286 532681 533050 533523 533929 534004 534640 535585 535602 535612 536063 536544 536958 540443 542770 542821 543658 544252 544661 544751 545096 545210 545420 545584 547966 553241 554811 555152 557371 557977 557981 558626 561046 563644 568180 568188 575667 578413 580413 582864 583955 630578 645493 648984 649276 650978 651287 651317 651420 653175 653712 653889 654217 660084 667075 671243 676788 677584 679415 680587 682291 682351 692457 693789 694027 694265 694346 697153 705398 707239 712501 712892 714126 715158 716564 719726 719963 720208 721972 722104 722967 723433 741152 745311 755134 785118 802483 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"свингерское"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.