Query Metrics
7
Database Queries
7
Different statements
150.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.44 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 389712 442542 457660 467948 480700 515690 517835 520474 521724 521731 525760 530213 530218 534254 539501 539524 540690 541197 541201 541202 541206 546470 549232 550824 553683 559337 559615 561020 571230 581988 583351 584257 585173 585913 586104 588261 591011 593910 600819 601576 602183 602508 602665 605909 610173 612581 617849 621596 627001 629776 629813 631514 631908 632635 634615 635686 636564 637304 641956 643098 647599 650808 653313 669851 678225 693930 699681 700647 703211 718265 718782 719182 720151 724740 725723 733519 737018 740481 741937 743794 745340 745357 748152 751261 755627 758239 761981 762994 763145 763802 763902 767632 774255 778639 779461 779719 781030 781621 781626 782930 784016 784682 786265 792510 795801 799476 802971 804474 806050 811051 811975 814234 817881 819326 824939 824974 825850 825968 828647 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (10.06%) |
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 778639 781626 699681 534254 669851 585913 617849 779461 586104 761981 700647 629813 737018 741937 792510 762994 703211 637304 763145 758239 784682 782930 605909 748152 724740 784016 799476 811975 725723 781621 634615 802971 550824 740481 539524 559615 602665 806050 786265 549232 635686 480700 517835 530213 745340 751261 591011 650808 804474 540690 581988 553683 559337 621596 593910 520474 530218 755627 467948 561020 627001 811051 647599 600819 631908 457660 442542 612581 588261 585173 584257 571230 718782 824974 602508 636564 525760 541201 601576 515690 825968 583351 720151 610173 541206 541197 541202 817881 718265 774255 767632 814234 631514 763802 643098 641956 632635 521724 719182 653313 819326 602183 828647 539501 693930 678225 546470 629776 733519 743794 780386 779719 781030 745357 763902 389712 825850 824939 521731 795801 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.86%) |
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 389712 442542 457660 467948 480700 515690 517835 520474 521724 521731 525760 530213 530218 534254 539501 539524 540690 541197 541201 541202 541206 546470 549232 550824 553683 559337 559615 561020 571230 581988 583351 584257 585173 585913 586104 588261 591011 593910 600819 601576 602183 602508 602665 605909 610173 612581 617849 621596 627001 629776 629813 631514 631908 632635 634615 635686 636564 637304 641956 643098 647599 650808 653313 669851 678225 693930 699681 700647 703211 718265 718782 719182 720151 724740 725723 733519 737018 740481 741937 743794 745340 745357 748152 751261 755627 758239 761981 762994 763145 763802 763902 767632 774255 778639 779461 779719 781030 781621 781626 782930 784016 784682 786265 792510 795801 799476 802971 804474 806050 811051 811975 814234 817881 819326 824939 824974 825850 825968 828647 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck and swallow"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс глота"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
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.