Query Metrics
7
Database Queries
7
Different statements
224.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.54 ms (88.74%) |
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 98543 382637 385062 389195 411769 411871 419783 424456 424457 424927 425070 425178 427199 427974 428531 429978 430629 430816 442835 443808 445586 446647 452066 452587 454975 456100 458728 461060 464237 465317 469352 470179 472318 476032 476293 477210 477554 477708 478668 485095 489108 492323 495256 496103 499787 502304 502305 502467 504825 512957 513030 513095 515602 515633 516227 518568 519429 519549 519590 519962 523081 525501 525999 526218 528443 528580 531511 531685 532264 533848 536293 536649 540579 541665 541690 541773 541884 543888 549660 549702 550823 550841 556421 562508 565984 571806 576629 577368 581269 586645 587142 587519 588631 589116 592377 599882 600825 602747 604901 605450 606611 615744 615929 619401 623468 631919 633150 633786 646447 648252 664953 687507 698284 698312 739553 814760 814921 815063 815413 820173 ] |
||||||||||||||||||||||||||||||
|
16.78 ms (7.46%) |
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 739553 664953 541665 98543 385062 427199 425178 820173 814760 815063 814921 815413 452587 458728 477708 469352 512957 502305 504825 519429 525501 533848 495256 518568 531685 461060 549660 556421 581269 543888 646447 586645 631919 588631 589116 599882 619401 633150 587142 592377 600825 604901 606611 587519 615744 430629 446647 424457 470179 424456 476293 429978 430816 452066 464237 476032 424927 443808 489108 502467 540579 496103 526218 477210 531511 571806 605450 389195 442835 478668 472318 513030 519590 525999 532264 528443 536293 536649 515633 519962 565984 549702 550841 687507 648252 698284 550823 562508 615929 425070 427974 445586 513095 519549 528580 502304 499787 411871 485095 411769 477554 454975 541884 541690 541773 576629 633786 602747 419783 456100 465317 492323 523081 382637 623468 516227 428531 515602 577368 698312 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.17%) |
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 98543 382637 385062 389195 411769 411871 419783 424456 424457 424927 425070 425178 427199 427974 428531 429978 430629 430816 442835 443808 445586 446647 452066 452587 454975 456100 458728 461060 464237 465317 469352 470179 472318 476032 476293 477210 477554 477708 478668 485095 489108 492323 495256 496103 499787 502304 502305 502467 504825 512957 513030 513095 515602 515633 516227 518568 519429 519549 519590 519962 523081 525501 525999 526218 528443 528580 531511 531685 532264 533848 536293 536649 540579 541665 541690 541773 541884 543888 549660 549702 550823 550841 556421 562508 565984 571806 576629 577368 581269 586645 587142 587519 588631 589116 592377 599882 600825 602747 604901 605450 606611 615744 615929 619401 623468 631919 633150 633786 646447 648252 664953 687507 698284 698312 739553 814760 814921 815063 815413 820173 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature secretary"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature секретарш"
]
|
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.