Query Metrics
7
Database Queries
7
Different statements
144.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.27 ms (83.89%) |
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 74842 107060 118002 151163 234200 382409 384178 385040 386587 387908 390051 390289 391908 391915 391936 394031 395343 396095 396364 397295 397403 398098 398580 398632 398982 401564 402754 407449 410963 414601 417870 419983 424406 424519 424720 424975 426485 428754 430455 433937 435549 441660 442608 444722 445601 450656 452552 453960 455194 457845 459083 459146 459418 459556 464274 468002 471009 471086 475182 479741 480534 482590 485546 487074 487176 488841 491099 495443 496726 500134 507769 511043 511211 513629 515322 516057 541762 544951 547811 547839 557430 573344 584321 591492 598009 604285 610820 613453 617360 626235 634249 649862 651947 659177 663457 674202 675837 682728 696497 699646 713205 713820 723288 726844 729308 729316 741567 756009 760656 761405 763473 770727 779853 783630 789153 795471 795620 806054 824228 825572 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (9.17%) |
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 513629 485546 386587 417870 441660 426485 459418 464274 547839 573344 442608 487176 74842 384178 118002 391915 382409 398982 402754 419983 825572 452552 459146 471086 459556 471009 495443 516057 488841 544951 584321 659177 674202 723288 713820 675837 682728 604285 591492 610820 598009 634249 789153 795620 806054 779853 795471 760656 783630 726844 741567 770727 729308 729316 763473 613453 626235 699646 107060 390289 401564 480534 396364 398580 435549 459083 428754 387908 444722 424519 496726 424406 511211 391936 397295 475182 663457 761405 756009 394031 390051 398632 453960 455194 511043 547811 391908 414601 507769 617360 487074 500134 385040 151163 234200 395343 396095 397403 398098 430455 407449 410963 424720 433937 424975 824228 457845 482590 445601 450656 491099 515322 468002 479741 541762 557430 649862 651947 696497 713205 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.09%) |
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 74842 107060 118002 151163 234200 382409 384178 385040 386587 387908 390051 390289 391908 391915 391936 394031 395343 396095 396364 397295 397403 398098 398580 398632 398982 401564 402754 407449 410963 414601 417870 419983 424406 424519 424720 424975 426485 428754 430455 433937 435549 441660 442608 444722 445601 450656 452552 453960 455194 457845 459083 459146 459418 459556 464274 468002 471009 471086 475182 479741 480534 482590 485546 487074 487176 488841 491099 495443 496726 500134 507769 511043 511211 513629 515322 516057 541762 544951 547811 547839 557430 573344 584321 591492 598009 604285 610820 613453 617360 626235 634249 649862 651947 659177 663457 674202 675837 682728 696497 699646 713205 713820 723288 726844 729308 729316 741567 756009 760656 761405 763473 770727 779853 783630 789153 795471 795620 806054 824228 825572 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette wife"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.