Query Metrics
7
Database Queries
7
Different statements
150.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.42 ms (86.25%) |
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 154497 397953 418182 421518 439683 459135 459515 498856 500381 503020 507225 510702 527035 535775 538772 543640 545294 548425 549065 550875 564243 565991 574280 579853 583589 586321 588105 593619 599515 609423 611284 619292 625793 625949 628756 629208 629813 630920 630924 634730 637613 643791 644223 647147 647390 648948 650498 663883 667156 676713 677878 679666 680675 687324 697666 699678 700296 700478 701472 704194 704314 707506 712252 717614 718305 720090 725401 726173 729055 732916 736347 748281 749032 750852 761822 761941 762449 762811 765518 765645 765676 767707 767991 768586 768871 768881 769275 773313 773945 776427 779312 779748 787268 791145 791208 791222 796523 796730 798932 798960 802068 803770 804680 804721 807012 808016 808154 808343 809917 812007 812288 812433 816710 818559 819808 823177 824123 826498 827628 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (8.36%) |
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 619292 629813 791145 791222 812433 776427 779748 804680 736347 765518 787268 762811 767707 769275 726173 765676 768881 630920 643791 803770 808016 809917 579853 717614 802068 804721 761822 154497 418182 818559 816710 819808 827628 503020 535775 538772 565991 548425 549065 697666 699678 647147 667156 676713 687324 712252 720090 718305 564243 625793 609423 588105 599515 807012 808343 812007 798960 796730 808154 762449 773313 765645 748281 767991 768871 634730 700296 527035 732916 824123 637613 812288 704314 439683 498856 768586 644223 630924 397953 421518 826498 459135 459515 500381 545294 543640 550875 583589 647390 679666 701472 707506 650498 593619 625949 628756 621014 779312 791208 798932 729055 749032 725401 761941 750852 611284 796523 629208 823177 700478 680675 704194 574280 586321 773945 507225 663883 648948 510702 677878 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.41%) |
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 154497 397953 418182 421518 439683 459135 459515 498856 500381 503020 507225 510702 527035 535775 538772 543640 545294 548425 549065 550875 564243 565991 574280 579853 583589 586321 588105 593619 599515 609423 611284 619292 625793 625949 628756 629208 629813 630920 630924 634730 637613 643791 644223 647147 647390 648948 650498 663883 667156 676713 677878 679666 680675 687324 697666 699678 700296 700478 701472 704194 704314 707506 712252 717614 718305 720090 725401 726173 729055 732916 736347 748281 749032 750852 761822 761941 762449 762811 765518 765645 765676 767707 767991 768586 768871 768881 769275 773313 773945 776427 779312 779748 787268 791145 791208 791222 796523 796730 798932 798960 802068 803770 804680 804721 807012 808016 808154 808343 809917 812007 812288 812433 816710 818559 819808 823177 824123 826498 827628 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watch жен"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"watch wife with"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watch жен"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.