Query Metrics
7
Database Queries
7
Different statements
199.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.21 ms (83.15%) |
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 48166 97823 233676 389793 391667 391833 391897 391951 392097 397410 398989 400342 401001 411246 417067 426871 438702 444129 446425 453654 456280 461974 462019 462151 465284 467781 470117 470389 470394 470577 470690 470934 470945 472075 476402 476636 481727 482078 482774 483960 489860 492038 494198 494643 494835 495234 496357 498171 499996 500214 502366 503499 505240 509437 512563 513652 514028 516312 516356 522450 525695 527284 533679 534083 534469 537981 539341 546656 546659 546661 546876 560413 566399 566443 567240 576127 601532 608172 617640 623155 623745 625275 626019 664483 685422 687833 688927 704343 707865 714865 719883 728922 731652 731658 735358 735658 736541 736675 736847 741382 741711 758185 761812 764150 764176 768705 769141 776121 777618 779124 780725 782034 782131 787060 794073 796954 799928 819264 824547 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (8.34%) |
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 664483 685422 687833 567240 617640 623155 623745 779124 731652 764176 794073 736847 741711 735358 714865 401001 494835 505240 537981 576127 688927 546656 776121 601532 782131 389793 397410 461974 560413 392097 456280 514028 513652 500214 675594 761812 707865 566443 780725 769141 736541 782034 48166 522450 233676 446425 417067 546661 470934 476402 462151 462019 509437 516312 489860 499996 777618 470389 608172 546876 444129 498171 534469 741382 525695 400342 398989 824547 470690 492038 494643 411246 470117 539341 704343 626019 731658 758185 764150 787060 467781 527284 546659 482078 512563 470945 566399 472075 496357 625275 391897 728922 768705 391667 533679 796954 391833 438702 494198 426871 534083 736675 719883 735658 799928 470577 495234 470394 481727 476636 453654 483960 97823 391951 516356 482774 465284 502366 819264 503499 ] |
||||||||||||||||||||||||||||||
|
8.92 ms (4.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sex wife"
]
|
||||||||||||||||||||||||||||||
|
2.88 ms (1.44%) |
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 48166 97823 233676 389793 391667 391833 391897 391951 392097 397410 398989 400342 401001 411246 417067 426871 438702 444129 446425 453654 456280 461974 462019 462151 465284 467781 470117 470389 470394 470577 470690 470934 470945 472075 476402 476636 481727 482078 482774 483960 489860 492038 494198 494643 494835 495234 496357 498171 499996 500214 502366 503499 505240 509437 512563 513652 514028 516312 516356 522450 525695 527284 533679 534083 534469 537981 539341 546656 546659 546661 546876 560413 566399 566443 567240 576127 601532 608172 617640 623155 623745 625275 626019 664483 685422 687833 688927 704343 707865 714865 719883 728922 731652 731658 735358 735658 736541 736675 736847 741382 741711 758185 761812 764150 764176 768705 769141 776121 777618 779124 780725 782034 782131 787060 794073 796954 799928 819264 824547 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.86%) |
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.