Query Metrics
7
Database Queries
7
Different statements
180.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.42 ms (85.21%) |
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 414604 415950 419219 419320 420635 420648 421835 421954 422145 422152 422154 422169 422194 422196 422202 422208 423923 424210 426765 426993 428483 433211 436933 437589 438934 439666 439670 439689 439705 439719 440980 446148 448084 448831 449635 449760 449845 452039 452383 454812 455276 455870 455974 456736 461890 464175 466211 470501 472276 474309 476333 476644 478414 478536 481167 482195 482443 483428 491348 492331 494496 496017 497469 500623 501458 509642 510553 511254 512551 513095 513620 514200 514656 517325 517418 518507 519547 520826 520851 521698 524657 525253 525277 526051 526381 527676 533182 557154 557161 559050 561470 561488 566312 567209 568378 569109 574446 580808 580950 583547 590759 590867 592027 596766 598190 602744 604046 605689 605762 616489 618543 626399 641708 647682 663294 690323 795963 798509 813084 823582 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (9.56%) |
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 478414 422152 440980 419219 421835 422194 422196 439719 472276 481167 474309 449760 466211 513620 518507 521698 500623 583547 574446 596766 592027 795963 798509 526381 482443 524657 478536 491348 437589 419320 452039 449845 456736 476333 476644 525253 517418 526051 496017 510553 514200 470501 561470 561488 569109 568378 663294 567209 626399 641708 602744 424210 439670 421954 454812 422145 428483 439666 448831 512551 519547 494496 559050 455870 590867 517325 557154 618543 813084 420635 616489 823582 436933 448084 446148 482195 483428 497469 501458 492331 580808 580950 598190 604046 590759 605689 426765 422169 426993 461890 420648 423923 455276 439689 439705 464175 509642 513095 520851 514656 533182 690323 647682 452383 438934 520826 511254 527676 566312 605762 422202 422154 422208 414604 415950 557161 455974 433211 449635 525277 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.40%) |
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 414604 415950 419219 419320 420635 420648 421835 421954 422145 422152 422154 422169 422194 422196 422202 422208 423923 424210 426765 426993 428483 433211 436933 437589 438934 439666 439670 439689 439705 439719 440980 446148 448084 448831 449635 449760 449845 452039 452383 454812 455276 455870 455974 456736 461890 464175 466211 470501 472276 474309 476333 476644 478414 478536 481167 482195 482443 483428 491348 492331 494496 496017 497469 500623 501458 509642 510553 511254 512551 513095 513620 514200 514656 517325 517418 518507 519547 520826 520851 521698 524657 525253 525277 526051 526381 527676 533182 557154 557161 559050 561470 561488 566312 567209 568378 569109 574446 580808 580950 583547 590759 590867 592027 596766 598190 602744 604046 605689 605762 616489 618543 626399 641708 647682 663294 690323 795963 798509 813084 823582 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature brunette pov"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature черноволосая пов"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature черноволосая пов"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
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.