Query Metrics
7
Database Queries
7
Different statements
183.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.09 ms (84.98%) |
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 397881 404483 404622 405028 405222 405535 407124 408214 410267 413806 415746 419358 426547 426719 430301 430543 443147 443991 446545 447045 448938 450224 452107 452983 453071 454191 460099 460289 462155 462324 463171 464040 464359 466270 466552 466959 466996 468019 470654 472142 482534 483359 483366 484703 486083 490581 492625 495275 496327 496330 496551 500343 500348 500367 502537 502541 502554 502743 505693 514600 516352 517440 517464 519184 519942 523046 525701 531316 531540 532701 533318 546063 546106 547931 548606 549233 551111 554309 557124 559921 563134 563894 573314 577211 578488 588309 589553 593347 597867 603551 603643 604710 606763 610083 633130 637145 641489 653911 663856 665108 665116 665314 666766 666842 667219 667898 668176 668528 724271 726543 726589 726594 728194 728930 748227 748255 748447 807990 814951 827854 ] |
||||||||||||||||||||||||||||||
|
18.12 ms (9.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 454191 726589 452983 502537 597867 443147 426719 814951 490581 453071 495275 502743 496330 546106 547931 551111 563134 665314 748447 748227 466552 466270 470654 516352 724271 492625 519942 430543 653911 525701 397881 426547 496327 500348 577211 667898 603551 603643 748255 726594 462155 405535 405028 413806 482534 573314 578488 523046 483359 827854 500367 563894 405222 407124 446545 468019 502541 559921 408214 447045 531316 404622 452107 533318 517440 531540 666842 668528 604710 637145 419358 410267 443991 460099 466959 496551 500343 517464 667219 554309 588309 593347 641489 726543 610083 807990 404483 463171 460289 505693 486083 462324 483366 448938 450224 464040 466996 502554 532701 519184 464359 548606 546063 557124 663856 665116 666766 668176 665108 589553 606763 728930 728194 633130 415746 472142 430301 484703 514600 549233 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.34%) |
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 397881 404483 404622 405028 405222 405535 407124 408214 410267 413806 415746 419358 426547 426719 430301 430543 443147 443991 446545 447045 448938 450224 452107 452983 453071 454191 460099 460289 462155 462324 463171 464040 464359 466270 466552 466959 466996 468019 470654 472142 482534 483359 483366 484703 486083 490581 492625 495275 496327 496330 496551 500343 500348 500367 502537 502541 502554 502743 505693 514600 516352 517440 517464 519184 519942 523046 525701 531316 531540 532701 533318 546063 546106 547931 548606 549233 551111 554309 557124 559921 563134 563894 573314 577211 578488 588309 589553 593347 597867 603551 603643 604710 606763 610083 633130 637145 641489 653911 663856 665108 665116 665314 666766 666842 667219 667898 668176 668528 724271 726543 726589 726594 728194 728930 748227 748255 748447 807990 814951 827854 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная секс втро"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышку втроем"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.71%) |
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.