Query Metrics
7
Database Queries
7
Different statements
147.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.08 ms (81.30%) |
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 286389 416155 417983 418088 418361 421563 423955 425971 435404 450143 459368 460767 461401 461836 464658 469361 470283 470609 471310 473115 480214 480726 481249 485948 487424 492646 499379 502887 505318 508516 519272 520144 520206 521752 522648 523474 523855 524743 525156 526105 528030 528466 543974 544515 545099 548725 553428 555206 555696 556561 559614 559985 566055 566061 568368 569274 571797 571840 576904 576935 578739 583598 584660 585170 588794 590892 595192 596176 598633 599230 601634 606734 611588 611812 613246 617614 628659 658810 660111 660435 687259 712243 747066 760181 771177 771182 771255 775707 776582 780706 784717 789491 789571 790008 791356 792412 795143 795148 797262 798622 799394 802947 805212 809481 812265 812387 813894 814274 815010 815075 816326 819652 820406 820783 821671 821741 822080 822512 823217 826763 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (10.91%) |
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 470283 480726 418361 508516 487424 519272 524743 523474 505318 526105 523855 502887 522648 569274 559614 595192 601634 528030 417983 425971 815075 820783 821671 821741 822080 814274 819652 820406 826763 816326 823217 813894 815010 822512 450143 461836 471310 469361 492646 499379 520144 521752 528466 525156 520206 464658 481249 485948 543974 548725 556561 568368 571797 553428 559985 566055 566061 571840 576904 584660 544515 545099 555206 576935 658810 687259 712243 660111 660435 555696 578739 583598 613246 617614 596176 588794 598633 599230 611812 585170 590892 606734 611588 628659 784717 789571 798622 812387 775707 776582 795143 795148 760181 790008 791356 797262 802947 771255 747066 771177 771182 780706 789491 792412 799394 805212 809481 812265 460767 416155 421563 459368 470609 480214 286389 423955 435404 418088 461401 473115 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (2.04%) |
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 286389 416155 417983 418088 418361 421563 423955 425971 435404 450143 459368 460767 461401 461836 464658 469361 470283 470609 471310 473115 480214 480726 481249 485948 487424 492646 499379 502887 505318 508516 519272 520144 520206 521752 522648 523474 523855 524743 525156 526105 528030 528466 543974 544515 545099 548725 553428 555206 555696 556561 559614 559985 566055 566061 568368 569274 571797 571840 576904 576935 578739 583598 584660 585170 588794 590892 595192 596176 598633 599230 601634 606734 611588 611812 613246 617614 628659 658810 660111 660435 687259 712243 747066 760181 771177 771182 771255 775707 776582 780706 784717 789491 789571 790008 791356 792412 795143 795148 797262 798622 799394 802947 805212 809481 812265 812387 813894 814274 815010 815075 816326 819652 820406 820783 821671 821741 822080 822512 823217 826763 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking pov"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза пов"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.33%) |
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.