Query Metrics
7
Database Queries
7
Different statements
148.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.82 ms (80.15%) |
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 318700 383985 391287 400826 405128 407442 411693 413286 419979 420178 426294 426600 428697 430297 431691 443134 443622 446029 446964 447882 452194 453239 453574 454177 454428 454560 455979 458000 459379 459637 460418 461036 462461 462817 464031 464985 467705 468900 469285 470041 470432 471190 473823 475260 476319 476321 489272 491164 491860 492449 494325 495287 496329 506345 507199 515356 517697 518941 520520 521875 525307 526201 526967 527420 527426 529294 531538 531541 532700 536503 539329 543970 555007 556586 560123 562423 562962 567063 573196 574678 575656 575703 577037 580642 581744 582449 582833 584044 584045 590870 592985 595097 599354 601660 603507 605565 610647 615031 621787 663427 664368 665113 667644 696513 707464 727900 733148 733587 734572 761066 771482 781787 781792 781812 781875 782024 784922 792819 799180 812943 ] |
||||||||||||||||||||||||||||||
|
19.53 ms (13.17%) |
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 577037 603507 601660 781792 781812 784922 799180 781787 781875 727900 733587 761066 782024 454560 443134 529294 491164 792819 734572 405128 407442 575703 733148 615031 464031 446029 573196 574678 621787 318700 491860 536503 515356 556586 582833 431691 464985 471190 476321 525307 555007 567063 663427 562423 599354 470041 459379 496329 539329 543970 664368 584045 610647 605565 812943 452194 475260 411693 454428 462817 467705 469285 453574 461036 492449 494325 521875 526201 531541 518941 527420 531538 526967 462461 470432 575656 562962 665113 582449 420178 454177 458000 468900 430297 506345 489272 507199 426294 459637 447882 453239 473823 495287 707464 383985 413286 400826 592985 391287 446964 428697 426600 443622 419979 455979 476319 520520 527426 517697 532700 460418 581744 584044 667644 696513 560123 580642 590870 595097 771482 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.79%) |
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 318700 383985 391287 400826 405128 407442 411693 413286 419979 420178 426294 426600 428697 430297 431691 443134 443622 446029 446964 447882 452194 453239 453574 454177 454428 454560 455979 458000 459379 459637 460418 461036 462461 462817 464031 464985 467705 468900 469285 470041 470432 471190 473823 475260 476319 476321 489272 491164 491860 492449 494325 495287 496329 506345 507199 515356 517697 518941 520520 521875 525307 526201 526967 527420 527426 529294 531538 531541 532700 536503 539329 543970 555007 556586 560123 562423 562962 567063 573196 574678 575656 575703 577037 580642 581744 582449 582833 584044 584045 590870 592985 595097 599354 601660 603507 605565 610647 615031 621787 663427 664368 665113 667644 696513 707464 727900 733148 733587 734572 761066 771482 781787 781792 781812 781875 782024 784922 792819 799180 812943 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw milf tits"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw milf сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw milf сиськ"
]
|
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.