Query Metrics
7
Database Queries
7
Different statements
133.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
111.00 ms (82.85%) |
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 385479 388005 391985 471004 471039 471049 471063 471066 484255 510917 536192 539658 540782 542479 544580 545155 545157 549640 557607 557822 559414 563779 572682 576450 577308 577987 579496 585806 586906 587205 589868 591576 592648 594426 604461 610128 612621 622159 623696 625298 629930 634961 635028 636644 639480 641789 644172 647096 648193 661523 661902 665592 666053 666058 666101 666670 666673 671519 680300 696131 696144 697306 706013 707443 707481 710280 710446 710901 712784 713416 714352 714373 714407 714569 714739 719146 722125 722158 724505 725199 725435 726629 728952 728955 728984 729036 729045 729880 729932 730189 732184 733724 734207 734318 740326 749487 751256 751954 753580 757166 784174 787238 787285 789477 789568 794410 794535 794580 794583 794597 794626 795113 795353 801395 802248 802292 808254 824479 824594 826651 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (9.64%) |
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 757166 733724 751954 801395 592648 824479 471039 719146 559414 623696 644172 794535 729932 734207 740326 749487 787285 794580 802292 728952 753580 726629 728984 730189 725435 794410 795113 795353 536192 594426 471066 539658 563779 557607 671519 589868 591576 639480 787238 714407 577308 391985 545157 794626 794583 484255 388005 471063 471004 577987 542479 544580 549640 557822 576450 648193 666053 666058 666670 707481 710446 647096 661523 661902 680300 696131 696144 697306 706013 710280 713416 714352 714373 665592 666101 666673 712784 714739 585806 610128 622159 634961 586906 629930 636644 587205 625298 725199 729036 724505 604461 612621 635028 641789 707443 722125 789477 824594 510917 471049 545155 579496 572682 722158 794597 802248 808254 729880 784174 728955 732184 729045 734318 751256 710901 714569 789568 385479 540782 826651 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (2.06%) |
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 385479 388005 391985 471004 471039 471049 471063 471066 484255 510917 536192 539658 540782 542479 544580 545155 545157 549640 557607 557822 559414 563779 572682 576450 577308 577987 579496 585806 586906 587205 589868 591576 592648 594426 604461 610128 612621 622159 623696 625298 629930 634961 635028 636644 639480 641789 644172 647096 648193 661523 661902 665592 666053 666058 666101 666670 666673 671519 680300 696131 696144 697306 706013 707443 707481 710280 710446 710901 712784 713416 714352 714373 714407 714569 714739 719146 722125 722158 724505 725199 725435 726629 728952 728955 728984 729036 729045 729880 729932 730189 732184 733724 734207 734318 740326 749487 751256 751954 753580 757166 784174 787238 787285 789477 789568 794410 794535 794580 794583 794597 794626 795113 795353 801395 802248 802292 808254 824479 824594 826651 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hairy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.08%) |
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.