Query Metrics
7
Database Queries
7
Different statements
199.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.48 ms (86.99%) |
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 33974 91890 100642 161427 177802 195513 229270 336704 383577 385478 390389 390810 454657 462860 464625 474248 475305 478141 483822 488640 488880 495598 504854 520254 521090 523331 525546 530343 531078 533212 533598 533941 535241 538638 540587 546150 546152 546153 546155 547013 549965 551860 554142 555203 556687 558727 561237 563955 564847 571439 571696 574115 574138 575125 575401 576007 577655 578153 578312 580541 583797 584457 584590 595224 597283 598736 600060 607340 609241 611782 615506 617618 618222 618299 618300 618301 618303 618304 619350 620667 620746 621978 623086 626844 627558 628709 629808 631563 631869 632279 638302 638980 641120 646078 652716 661490 663341 666664 673326 673332 680759 704632 705519 707497 718740 719052 735113 737972 759336 761162 766193 768870 777294 785387 785713 799480 804125 816183 818744 821680 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (7.98%) |
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 571696 533941 768870 619350 549965 777294 766193 818744 546155 680759 704632 719052 546150 759336 799480 454657 673332 737972 571439 646078 611782 609241 631869 546152 618304 556687 576007 575401 546153 618299 530343 574115 574138 615506 627558 478141 584590 821680 91890 626844 621978 385478 578312 735113 607340 521090 533598 629808 620746 229270 583797 554142 661490 597283 488880 623086 804125 638980 177802 336704 561237 673326 718740 33974 628709 761162 707497 523331 535241 563955 632279 785713 462860 558727 666664 652716 577655 504854 638302 575125 390389 631563 533212 595224 663341 618303 531078 816183 474248 488640 547013 618222 195513 705519 100642 390810 618301 600060 161427 520254 584457 551860 383577 538638 578153 598736 641120 785387 483822 564847 555203 580541 617618 618300 525546 620667 475305 495598 540587 464625 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.57%) |
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 33974 91890 100642 161427 177802 195513 229270 336704 383577 385478 390389 390810 454657 462860 464625 474248 475305 478141 483822 488640 488880 495598 504854 520254 521090 523331 525546 530343 531078 533212 533598 533941 535241 538638 540587 546150 546152 546153 546155 547013 549965 551860 554142 555203 556687 558727 561237 563955 564847 571439 571696 574115 574138 575125 575401 576007 577655 578153 578312 580541 583797 584457 584590 595224 597283 598736 600060 607340 609241 611782 615506 617618 618222 618299 618300 618301 618303 618304 619350 620667 620746 621978 623086 626844 627558 628709 629808 631563 631869 632279 638302 638980 641120 646078 652716 661490 663341 666664 673326 673332 680759 704632 705519 707497 718740 719052 735113 737972 759336 761162 766193 768870 777294 785387 785713 799480 804125 816183 818744 821680 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car riding sex"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вмашин riding секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин riding секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.78%) |
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.