Query Metrics
7
Database Queries
7
Different statements
196.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.64 ms (86.22%) |
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 53962 62124 98711 382445 385884 387186 388022 393417 453299 457119 457662 464967 465264 484260 499006 500828 505585 512056 531033 531631 534373 538603 543723 545327 552075 553876 554158 556719 570649 575692 578763 582136 587344 588219 589572 589654 603282 610199 628152 634191 644883 646253 650232 651075 660114 663457 668082 677447 687000 692734 694615 698385 713085 713088 715043 719062 722426 724280 724399 725381 727569 730218 731797 734528 737379 738894 741088 744188 746103 749437 749577 750511 750522 751491 752275 754274 754546 761191 761401 762879 767911 769382 769568 772359 774141 774188 775617 776704 777529 778535 780149 782013 783297 784006 786435 787403 787748 789739 790996 796045 799409 800493 800759 802184 802434 802700 803215 803627 803632 804118 807129 808482 810974 811613 816875 816991 821009 821673 822547 825579 ] |
||||||||||||||||||||||||||||||
|
18.44 ms (9.37%) |
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 749437 802434 725381 749577 754546 772359 724399 731797 761191 698385 719062 775617 780149 782013 783297 799409 800759 803632 810974 53962 387186 388022 62124 499006 464967 484260 457119 538603 554158 603282 610199 587344 589654 808482 769382 465264 457662 385884 382445 98711 816875 821673 644883 816991 822547 821009 825579 531033 500828 531631 575692 553876 556719 582136 543723 646253 650232 651075 663457 660114 677447 687000 694615 692734 713088 715043 552075 588219 589572 628152 776704 777529 778535 784006 790996 811613 789739 802700 734528 741088 746103 751491 761401 774188 786435 800493 744188 750522 730218 737379 750511 754274 767911 769568 724280 752275 762879 774141 727569 738894 634191 713085 722426 787403 802184 803215 803627 804118 807129 393417 534373 453299 505585 512056 545327 570649 668082 578763 787748 796045 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.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 53962 62124 98711 382445 385884 387186 388022 393417 453299 457119 457662 464967 465264 484260 499006 500828 505585 512056 531033 531631 534373 538603 543723 545327 552075 553876 554158 556719 570649 575692 578763 582136 587344 588219 589572 589654 603282 610199 628152 634191 644883 646253 650232 651075 660114 663457 668082 677447 687000 692734 694615 698385 713085 713088 715043 719062 722426 724280 724399 725381 727569 730218 731797 734528 737379 738894 741088 744188 746103 749437 749577 750511 750522 751491 752275 754274 754546 761191 761401 762879 767911 769382 769568 772359 774141 774188 775617 776704 777529 778535 780149 782013 783297 784006 786435 787403 787748 789739 790996 796045 799409 800493 800759 802184 802434 802700 803215 803627 803632 804118 807129 808482 810974 811613 816875 816991 821009 821673 822547 825579 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ sexy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits sexy"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.