Query Metrics
7
Database Queries
7
Different statements
180.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.48 ms (87.65%) |
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 397904 402343 416428 423968 424234 428074 437705 437982 438055 441829 442107 455539 455600 455999 458431 460741 461186 461397 470188 471911 472676 472690 473343 482807 483425 483818 487786 504809 505429 509230 515003 517604 527845 530247 534943 537264 538265 541052 543654 549069 554554 557402 558087 560292 563747 565603 572768 578332 583372 584249 584385 590441 590691 594602 603644 604625 606106 609811 610805 610819 613929 618591 621671 623427 626327 627871 631674 633611 637582 639957 648169 649825 653527 653630 653971 662061 673223 680442 695469 707466 718376 724552 726278 726967 728255 729286 736783 742865 746340 749016 756841 757445 757608 764518 769148 773895 777814 779489 780771 784054 784831 787628 791065 794797 794898 795508 796164 796354 797206 798013 798099 799476 802872 804022 804417 804697 804813 805633 814007 823927 ] |
||||||||||||||||||||||||||||||
|
12.33 ms (6.82%) |
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 461397 578332 613929 637582 623427 791065 726967 517604 779489 455539 397904 594602 609811 797206 796164 814007 823927 534943 554554 560292 649825 798013 742865 764518 604625 610819 621671 537264 584249 626327 798099 653630 455999 530247 648169 472676 563747 557402 558087 606106 627871 805633 749016 736783 777814 804813 423968 424234 483425 618591 603644 461186 458431 527845 631674 804022 653527 428074 441829 442107 437705 482807 487786 515003 470188 471911 473343 572768 584385 541052 707466 565603 804697 799476 784054 724552 746340 757445 757608 773895 437982 438055 509230 504809 538265 483818 505429 610805 543654 794797 787628 460741 633611 802872 728255 795508 472690 549069 680442 695469 662061 673223 590441 590691 639957 794898 756841 796354 726278 769148 729286 780771 784831 804417 416428 653971 455600 583372 718376 402343 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.55%) |
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 397904 402343 416428 423968 424234 428074 437705 437982 438055 441829 442107 455539 455600 455999 458431 460741 461186 461397 470188 471911 472676 472690 473343 482807 483425 483818 487786 504809 505429 509230 515003 517604 527845 530247 534943 537264 538265 541052 543654 549069 554554 557402 558087 560292 563747 565603 572768 578332 583372 584249 584385 590441 590691 594602 603644 604625 606106 609811 610805 610819 613929 618591 621671 623427 626327 627871 631674 633611 637582 639957 648169 649825 653527 653630 653971 662061 673223 680442 695469 707466 718376 724552 726278 726967 728255 729286 736783 742865 746340 749016 756841 757445 757608 764518 769148 773895 777814 779489 780771 784054 784831 787628 791065 794797 794898 795508 796164 796354 797206 798013 798099 799476 802872 804022 804417 804697 804813 805633 814007 823927 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс slut жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс slut жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex slut wife"
]
|
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.