Query Metrics
7
Database Queries
7
Different statements
171.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.02 ms (83.05%) |
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 406204 408043 418548 450848 453108 454426 461032 461037 464360 468828 474087 476305 480499 484807 486384 487297 492097 492102 492349 498446 503846 504040 505399 505692 505736 507608 509530 514945 517450 520137 520161 522926 523347 524907 526342 526589 527616 528534 528738 529545 531537 535734 536523 537483 539331 539464 541901 542473 544475 545139 548264 548323 549132 549662 549687 550423 550514 552293 554783 556816 556862 559477 562004 563986 568539 574671 574981 578174 578796 579340 579664 583723 585319 586659 588380 588729 589653 589678 589732 591108 591596 591807 591947 592625 593259 597184 600849 601097 601193 601246 602526 603217 603612 605235 605420 606987 609042 612053 621027 622975 625172 625753 630317 630664 631878 634725 660075 660560 663494 664280 665192 665332 666706 667417 667928 668391 675705 683158 731789 754646 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (10.20%) |
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 476305 660560 535734 542473 528534 665332 601097 592625 486384 520137 578174 579664 625753 450848 524907 563986 589653 578796 492349 630664 549687 667928 589678 660075 537483 663494 597184 568539 552293 556862 545139 548264 520161 579340 665192 509530 505399 589732 464360 593259 605235 461032 574981 559477 588380 474087 548323 591596 667417 480499 591108 549132 574671 600849 503846 468828 556816 634725 541901 631878 504040 562004 492097 588729 526589 461037 522926 603217 536523 586659 601246 612053 606987 528738 591807 625172 517450 531537 583723 622975 454426 406204 527616 754646 666706 585319 621027 664280 505736 601193 498446 408043 550514 529545 523347 453108 549662 609042 683158 675705 505692 507608 539464 484807 591947 554783 603612 668391 492102 514945 630317 539331 605420 544475 418548 602526 526342 487297 550423 731789 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.84%) |
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 406204 408043 418548 450848 453108 454426 461032 461037 464360 468828 474087 476305 480499 484807 486384 487297 492097 492102 492349 498446 503846 504040 505399 505692 505736 507608 509530 514945 517450 520137 520161 522926 523347 524907 526342 526589 527616 528534 528738 529545 531537 535734 536523 537483 539331 539464 541901 542473 544475 545139 548264 548323 549132 549662 549687 550423 550514 552293 554783 556816 556862 559477 562004 563986 568539 574671 574981 578174 578796 579340 579664 583723 585319 586659 588380 588729 589653 589678 589732 591108 591596 591807 591947 592625 593259 597184 600849 601097 601193 601246 602526 603217 603612 605235 605420 606987 609042 612053 621027 622975 625172 625753 630317 630664 631878 634725 660075 660560 663494 664280 665192 665332 666706 667417 667928 668391 675705 683158 731789 754646 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big vagina fuck"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие вагин секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
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.