Query Metrics
7
Database Queries
7
Different statements
348.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.47 ms (60.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf мастурбац"
]
|
||||||||||||||||||||||||||||||
|
116.15 ms (33.37%) |
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 99157 191759 383201 383923 384400 387303 388523 389283 390105 450583 462219 472183 475637 483537 489848 494539 511355 532195 534083 543006 553436 555560 558264 558476 559410 559414 581651 581672 587189 596830 603119 603345 607140 613005 619902 627655 636424 644205 645835 645844 652160 665948 666395 669923 670448 687369 706154 707490 707589 708226 712881 714453 714707 717595 725435 725562 733366 735124 735504 735931 737889 739533 740527 743225 744688 744751 746789 751002 752914 752944 754300 755285 760657 770002 771867 777097 777522 777638 777642 780938 785396 785901 787357 788110 788591 793056 795711 795724 798115 803478 804761 805791 806139 806489 806508 808665 808951 809297 810328 811094 812263 812423 817777 818205 819226 819232 819243 819759 823894 824811 825366 826386 826610 826713 826715 827391 827503 827635 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (3.94%) |
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 826610 826713 825366 819243 489848 645835 707589 717595 666395 603119 603345 644205 777097 785901 803478 806508 808665 777522 795724 739533 752914 788591 793056 795711 735124 744688 755285 725562 735931 806139 383923 819232 462219 581672 808951 752944 707490 383201 387303 824811 827503 817777 534083 652160 559414 811094 733366 744751 812263 735504 746789 751002 754300 743225 725435 810328 389283 99157 384400 390105 450583 483537 472183 787357 737889 785396 714453 771867 670448 587189 805791 798115 806489 819226 827391 823894 818205 827635 826386 494539 532195 543006 559410 665948 636424 627655 804761 788110 770002 700231 706154 826715 819759 511355 596830 809297 740527 760657 812423 191759 581651 555560 645844 669923 687369 708226 714707 607140 604910 613005 619902 777638 777642 780938 388523 475637 712881 553436 558264 558476 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (0.74%) |
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 99157 191759 383201 383923 384400 387303 388523 389283 390105 450583 462219 472183 475637 483537 489848 494539 511355 532195 534083 543006 553436 555560 558264 558476 559410 559414 581651 581672 587189 596830 603119 603345 607140 613005 619902 627655 636424 644205 645835 645844 652160 665948 666395 669923 670448 687369 706154 707490 707589 708226 712881 714453 714707 717595 725435 725562 733366 735124 735504 735931 737889 739533 740527 743225 744688 744751 746789 751002 752914 752944 754300 755285 760657 770002 771867 777097 777522 777638 777642 780938 785396 785901 787357 788110 788591 793056 795711 795724 798115 803478 804761 805791 806139 806489 806508 808665 808951 809297 810328 811094 812263 812423 817777 818205 819226 819232 819243 819759 823894 824811 825366 826386 826610 826713 826715 827391 827503 827635 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf мастурбац"
]
|
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.