Query Metrics
7
Database Queries
7
Different statements
184.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.50 ms (85.26%) |
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 181096 370905 387732 395469 397889 401201 401463 403109 406071 406330 408685 411203 411910 419619 429884 430732 432348 432350 443408 443690 445464 446786 447853 448350 460404 462235 464410 465990 466984 468501 470492 471012 471020 472698 477975 481652 484551 485958 488363 489207 492325 492418 493467 496844 500690 504041 507616 510876 522098 523627 533424 534209 556612 559973 563734 581385 588411 591045 591997 593060 598274 601182 605765 610209 612160 612263 612304 614059 617392 623955 630649 634758 642813 643919 650431 697272 701709 712197 714468 719176 721956 724514 724520 726814 729192 729935 729972 730075 735912 739762 739778 739782 739788 740586 741899 742777 756494 759755 760175 768878 770038 781917 782022 793670 793716 795348 803738 804268 808243 808671 810014 812481 814374 814376 818502 819773 824520 824531 825063 828179 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (8.77%) |
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 563734 591045 612160 642813 610209 612263 614059 593060 630649 781917 729972 724520 742777 735912 739778 739782 740586 793716 462235 466984 408685 460404 500690 522098 411203 510876 714468 492325 768878 493467 484551 429884 814376 556612 729935 387732 818502 492418 701709 712197 581385 643919 782022 739762 759755 401201 623955 401463 824520 825063 828179 523627 534209 533424 650431 697272 721956 634758 598274 617392 729192 810014 726814 739788 770038 724514 760175 756494 612304 795348 803738 432348 448350 559973 419619 443408 432350 430732 808243 488363 446786 468501 395469 406330 824531 496844 504041 812481 370905 181096 485958 471020 406071 588411 471012 472698 477975 489207 507616 601182 819773 804268 591997 481652 447853 464410 605765 793670 730075 808671 741899 719176 470492 443690 397889 403109 411910 814374 445464 465990 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (2.05%) |
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 181096 370905 387732 395469 397889 401201 401463 403109 406071 406330 408685 411203 411910 419619 429884 430732 432348 432350 443408 443690 445464 446786 447853 448350 460404 462235 464410 465990 466984 468501 470492 471012 471020 472698 477975 481652 484551 485958 488363 489207 492325 492418 493467 496844 500690 504041 507616 510876 522098 523627 533424 534209 556612 559973 563734 581385 588411 591045 591997 593060 598274 601182 605765 610209 612160 612263 612304 614059 617392 623955 630649 634758 642813 643919 650431 697272 701709 712197 714468 719176 721956 724514 724520 726814 729192 729935 729972 730075 735912 739762 739778 739782 739788 740586 741899 742777 756494 759755 760175 768878 770038 781917 782022 793670 793716 795348 803738 804268 808243 808671 810014 812481 814374 814376 818502 819773 824520 824531 825063 828179 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural milf hairy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные milf волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
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.