Query Metrics
7
Database Queries
7
Different statements
149.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.41 ms (83.69%) |
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 397193 419765 423349 423350 425316 435471 435515 450224 458971 468126 508179 508494 531286 531811 531889 532186 534056 535908 536856 536898 537007 538063 540513 540627 541917 544942 547076 550656 558784 563280 564270 568228 571751 574460 576530 579033 582042 585191 585352 586207 586398 590172 590233 591718 596690 600960 604191 604487 604612 604992 605696 606785 615335 615423 616571 623278 626382 627634 628827 629423 630873 631003 631009 631063 632291 632386 633430 633563 633918 633926 633962 633979 639645 641881 643844 644757 645605 646173 646174 647077 648326 651485 653793 653797 653813 653821 653824 653832 655920 658162 658192 665939 672699 680020 686763 691717 691729 692084 697581 697615 699425 710935 711255 715251 729240 731302 732565 734795 738390 739014 739637 744434 745887 750648 775424 796997 818048 818143 823766 827826 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (9.10%) |
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 604191 458971 818143 732565 425316 531811 531889 535908 550656 651485 715251 692084 658162 576530 628827 633979 604612 633926 585191 615423 631063 745887 643844 568228 691717 606785 653797 653832 591718 615335 435471 435515 508179 586207 586398 796997 585352 419765 508494 632386 823766 632291 532186 547076 590172 734795 744434 731302 739637 750648 629423 633563 423349 538063 648326 653813 590233 605696 697581 574460 540513 537007 536898 665939 397193 818048 739014 571751 827826 534056 536856 544942 541917 564270 579033 582042 646173 647077 658192 680020 711255 645605 653793 653824 686763 646174 653821 655920 672699 699425 558784 563280 600960 627634 596690 631003 604992 631009 633430 633918 639645 738390 729240 604487 623278 626382 644757 697615 641881 630873 540627 531286 423350 775424 691729 633962 468126 616571 710935 450224 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.99%) |
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 397193 419765 423349 423350 425316 435471 435515 450224 458971 468126 508179 508494 531286 531811 531889 532186 534056 535908 536856 536898 537007 538063 540513 540627 541917 544942 547076 550656 558784 563280 564270 568228 571751 574460 576530 579033 582042 585191 585352 586207 586398 590172 590233 591718 596690 600960 604191 604487 604612 604992 605696 606785 615335 615423 616571 623278 626382 627634 628827 629423 630873 631003 631009 631063 632291 632386 633430 633563 633918 633926 633962 633979 639645 641881 643844 644757 645605 646173 646174 647077 648326 651485 653793 653797 653813 653821 653824 653832 655920 658162 658192 665939 672699 680020 686763 691717 691729 692084 697581 697615 699425 710935 711255 715251 729240 731302 732565 734795 738390 739014 739637 744434 745887 750648 775424 796997 818048 818143 823766 827826 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc amateur wife"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc любительск жен"
]
|
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.