Query Metrics
7
Database Queries
7
Different statements
387.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.15 ms (53.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
151.49 ms (39.10%) |
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 392019 397960 398740 403215 414929 415303 415874 418145 420295 426283 427292 427722 428728 429892 430366 435136 440641 441355 443432 445945 448854 450323 450557 450930 451044 452540 458115 460115 460533 466601 467114 467560 467588 467882 468148 468817 473873 477496 482839 483315 484065 485468 485472 486761 490953 493839 499856 500288 502447 508891 510834 513220 516684 517710 527922 529323 530383 530659 531804 542588 544838 546083 553215 558171 558190 559281 559787 582848 584418 588137 589166 590696 592500 602846 618041 623402 626082 630558 633147 636379 640813 645230 650325 650476 653391 663183 666672 667276 675402 689010 712882 713297 716965 721106 723930 724470 730461 739165 745345 748257 749070 753960 782236 786604 786876 788800 791892 796712 796801 798291 799268 800293 802114 802914 805543 806271 814429 815559 816547 818387 ] |
||||||||||||||||||||||||||||||
|
18.83 ms (4.86%) |
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 440641 452540 473873 435136 443432 468148 451044 513220 485472 589166 730461 626082 798291 467588 429892 544838 448854 477496 516684 588137 618041 713297 663183 502447 415303 441355 450557 458115 527922 510834 558190 559281 582848 666672 553215 467560 493839 483315 689010 420295 445945 508891 559787 782236 430366 450323 392019 398740 428728 427722 818387 815559 816547 467114 468817 485468 499856 531804 667276 645230 721106 592500 590696 630558 786604 796801 806271 800293 799268 805543 723930 724470 749070 745345 748257 739165 753960 623402 633147 716965 786876 788800 802114 802914 403215 460533 640813 500288 415874 814429 530383 542588 650325 712882 653391 636379 791892 796712 558171 584418 675402 482839 397960 460115 529323 517710 484065 546083 602846 467882 427292 418145 490953 414929 466601 650476 450930 426283 486761 530659 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (0.97%) |
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 392019 397960 398740 403215 414929 415303 415874 418145 420295 426283 427292 427722 428728 429892 430366 435136 440641 441355 443432 445945 448854 450323 450557 450930 451044 452540 458115 460115 460533 466601 467114 467560 467588 467882 468148 468817 473873 477496 482839 483315 484065 485468 485472 486761 490953 493839 499856 500288 502447 508891 510834 513220 516684 517710 527922 529323 530383 530659 531804 542588 544838 546083 553215 558171 558190 559281 559787 582848 584418 588137 589166 590696 592500 602846 618041 623402 626082 630558 633147 636379 640813 645230 650325 650476 653391 663183 666672 667276 675402 689010 712882 713297 716965 721106 723930 724470 730461 739165 745345 748257 749070 753960 782236 786604 786876 788800 791892 796712 796801 798291 799268 800293 802114 802914 805543 806271 814429 815559 816547 818387 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные дилд pussy"
]
|
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.