Query Metrics
7
Database Queries
7
Different statements
420.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.31 ms (50.75%) |
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 397053 400156 400169 400857 407177 417064 421325 423561 425582 427799 430832 430834 434102 435768 446337 451262 457772 457902 458518 459565 464682 468301 468834 469245 471888 473494 479700 482243 488733 490024 491678 492519 492760 494525 496088 499791 507559 515808 517039 524667 530109 530870 531075 531523 533337 534733 534757 541646 541923 544686 550131 550634 557657 558068 558391 560212 562136 565202 565317 566277 567572 567743 570024 570219 573234 573871 577323 579475 581128 581428 582540 582549 585161 586152 590469 593092 595835 598113 598653 598745 599025 599434 601425 601710 602607 602633 611817 612042 616184 627153 627711 631179 637656 643411 651253 665027 684230 687269 687503 693185 699650 709624 730977 742848 769401 776521 780086 780124 788289 800450 804469 804691 805049 806777 808190 809574 812171 814871 818929 828433 ] |
||||||||||||||||||||||||||||||
|
184.18 ms (43.82%) |
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 397053 400156 400169 400857 407177 417064 421325 423561 425582 427799 430832 430834 434102 435768 446337 451262 457772 457902 458518 459565 464682 468301 468834 469245 471888 473494 479700 482243 488733 490024 491678 492519 492760 494525 496088 499791 507559 515808 517039 524667 530109 530870 531075 531523 533337 534733 534757 541646 541923 544686 550131 550634 557657 558068 558391 560212 562136 565202 565317 566277 567572 567743 570024 570219 573234 573871 577323 579475 581128 581428 582540 582549 585161 586152 590469 593092 595835 598113 598653 598745 599025 599434 601425 601710 602607 602633 611817 612042 616184 627153 627711 631179 637656 643411 651253 665027 684230 687269 687503 693185 699650 709624 730977 742848 769401 776521 780086 780124 788289 800450 804469 804691 805049 806777 808190 809574 812171 814871 818929 828433 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (3.87%) |
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 496088 602607 490024 565202 616184 800450 730977 808190 427799 459565 446337 562136 582549 585161 400857 425582 451262 515808 494525 499791 573234 541923 577323 582540 595835 598745 598653 643411 544686 665027 430832 407177 423561 435768 457772 468301 517039 534757 534733 530109 469245 558391 570024 557657 558068 566277 687503 687269 693185 709624 570219 573871 581428 586152 601425 598113 602633 599434 627711 593092 599025 637656 806777 776521 788289 804469 805049 742848 601710 699650 809574 464682 471888 434102 400156 524667 488733 828433 611817 804691 812171 531075 417064 482243 458518 468834 565317 579475 581128 560212 430834 491678 492760 473494 567572 780086 590469 631179 541646 651253 684230 612042 627153 769401 780124 567743 397053 400169 421325 814871 818929 479700 457902 507559 531523 533337 530870 492519 550131 550634 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small beautiful boobs"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая красивая boobs"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая красивая boobs"
]
|
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.