Query Metrics
7
Database Queries
7
Different statements
275.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
251.26 ms (91.04%) |
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 122425 382006 388022 389209 397599 400401 405975 412578 415634 416102 426213 428793 435520 445010 452422 464967 466786 481652 484260 494552 500828 503966 509383 510828 513721 518908 523376 525336 536359 537273 538603 545504 551527 568651 570649 574456 578763 582581 585258 586404 587344 588219 588973 598926 598970 606268 607671 612311 621699 623327 623335 626354 633480 634191 636578 643485 652772 658854 661410 664227 666099 668082 669448 670201 672843 692734 693245 698469 701223 704391 707974 713085 718878 722853 724280 724508 727569 734218 734528 736775 737280 737361 738101 739442 741621 741700 743949 744892 746103 747067 749929 758290 758561 769191 769382 769568 772025 779934 781946 785752 792563 793635 796045 797182 797650 797798 798481 799409 802230 802683 804617 805238 807873 808482 808521 812817 816875 821673 822547 824022 ] |
||||||||||||||||||||||||||||||
|
12.53 ms (4.54%) |
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 824022 466786 652772 664227 672843 707974 586404 598926 585258 797182 805238 779934 793635 749929 781946 738101 741700 758561 758290 747067 701223 816875 821673 822547 500828 692734 588219 734528 746103 769568 724280 727569 634191 713085 570649 668082 796045 804617 792563 734218 510828 536359 464967 484260 538603 587344 808482 769382 503966 452422 525336 574456 670201 718878 643485 607671 737361 397599 405975 698469 412578 537273 494552 513721 551527 481652 518908 658854 606268 598970 808521 812817 736775 772025 724508 739442 797798 741621 744892 122425 382006 416102 588973 785752 798481 568651 545504 669448 612311 623335 802230 743949 807873 769191 737280 633480 704391 722853 797650 802683 400401 435520 578763 445010 509383 426213 661410 389209 523376 799409 388022 415634 428793 582581 693245 666099 621699 636578 626354 623327 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.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 122425 382006 388022 389209 397599 400401 405975 412578 415634 416102 426213 428793 435520 445010 452422 464967 466786 481652 484260 494552 500828 503966 509383 510828 513721 518908 523376 525336 536359 537273 538603 545504 551527 568651 570649 574456 578763 582581 585258 586404 587344 588219 588973 598926 598970 606268 607671 612311 621699 623327 623335 626354 633480 634191 636578 643485 652772 658854 661410 664227 666099 668082 669448 670201 672843 692734 693245 698469 701223 704391 707974 713085 718878 722853 724280 724508 727569 734218 734528 736775 737280 737361 738101 739442 741621 741700 743949 744892 746103 747067 749929 758290 758561 769191 769382 769568 772025 779934 781946 785752 792563 793635 796045 797182 797650 797798 798481 799409 802230 802683 804617 805238 807873 808482 808521 812817 816875 821673 822547 824022 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy big tits"
]
|
||||||||||||||||||||||||||||||
|
2.27 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy большие сиськ"
]
|
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.