Query Metrics
7
Database Queries
7
Different statements
153.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.02 ms (82.72%) |
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 387230 395270 398908 407025 407151 407429 408483 411898 412969 413456 413690 415221 415505 418592 421220 423027 424468 429754 431390 437575 438372 439855 441648 445626 448345 450178 451301 452755 454151 454405 458332 459363 459411 460953 461763 462307 463197 463225 464537 465125 466285 468280 468828 470226 472868 473108 473522 476609 479538 486148 487950 489947 491283 492065 494367 494748 504574 505670 505762 507483 507514 509697 514710 516106 516690 518742 519657 520163 521420 521991 523369 524171 524807 528802 536682 540422 540739 541051 541099 552084 553071 554501 555126 556989 558245 558835 558856 558958 560981 562772 563434 567663 572194 574874 575485 577416 582783 589319 598058 598537 599332 601332 602212 604489 623179 624473 627706 632852 633135 633493 634527 636479 662118 704208 722717 729265 756804 766872 780821 782772 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (10.23%) |
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 507514 624473 423027 623179 472868 451301 602212 486148 387230 408483 413456 429754 441648 454405 454151 479538 494748 487950 558245 562772 575485 552084 560981 574874 577416 722717 558835 563434 598058 407025 424468 463197 465125 473108 398908 452755 464537 476609 514710 518742 521991 491283 505670 516106 524807 540739 505762 521420 461763 462307 509697 520163 599332 555126 468280 411898 407429 554501 601332 729265 516690 421220 445626 450178 489947 553071 558958 438372 541051 494367 528802 415505 418592 459411 540422 536682 473522 541099 572194 556989 704208 662118 582783 604489 598537 627706 634527 766872 632852 633493 780821 413690 415221 439855 412969 782772 466285 756804 633135 589319 437575 519657 636479 448345 459363 460953 567663 507483 558856 395270 431390 407151 463225 470226 492065 458332 468828 504574 523369 524171 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.29%) |
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 387230 395270 398908 407025 407151 407429 408483 411898 412969 413456 413690 415221 415505 418592 421220 423027 424468 429754 431390 437575 438372 439855 441648 445626 448345 450178 451301 452755 454151 454405 458332 459363 459411 460953 461763 462307 463197 463225 464537 465125 466285 468280 468828 470226 472868 473108 473522 476609 479538 486148 487950 489947 491283 492065 494367 494748 504574 505670 505762 507483 507514 509697 514710 516106 516690 518742 519657 520163 521420 521991 523369 524171 524807 528802 536682 540422 540739 541051 541099 552084 553071 554501 555126 556989 558245 558835 558856 558958 560981 562772 563434 567663 572194 574874 575485 577416 582783 589319 598058 598537 599332 601332 602212 604489 623179 624473 627706 632852 633135 633493 634527 636479 662118 704208 722717 729265 756804 766872 780821 782772 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с письки в рот кончил"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин в рот сперм"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.