Query Metrics
7
Database Queries
7
Different statements
186.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.72 ms (85.11%) |
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 384306 396640 413826 428241 429223 435374 440698 444341 444435 447146 447435 447513 447524 447539 449678 451706 455653 461122 463674 463913 465326 465548 468006 469553 470846 473974 475172 475483 476823 490079 492002 492267 493218 494692 499148 501732 501748 501774 501804 505977 506576 507500 507511 508747 510203 512790 513768 517358 518548 519486 519661 521193 521989 522663 524016 527057 527793 529497 536397 551147 552043 552296 554253 555571 556397 556945 558905 558958 561452 563854 563871 563878 563884 565067 565188 565279 569933 571658 581684 582493 584257 586549 586597 592314 593649 593939 596412 599452 602212 603167 605936 608878 618442 619192 620546 622932 623404 625675 628910 654914 659412 659439 671356 671626 671656 671667 672671 676987 677020 677025 677060 681505 683588 685001 687174 688045 688340 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (9.73%) |
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 671656 608878 384306 470846 671626 672671 659439 556945 455653 501804 507500 527057 451706 429223 428241 565188 671356 681505 687174 596412 586549 396640 447524 447539 476823 468006 508747 527793 490079 501774 440698 510203 461122 465548 654914 676987 683588 475172 493218 519661 584257 565279 592314 605936 628910 602212 473974 444341 449678 463674 505977 555571 551147 593649 435374 518548 444435 659412 677020 501748 465326 563871 513768 552296 501732 499148 519486 563878 447146 492002 558958 688340 447435 512790 552043 447513 524016 469553 554253 685001 569933 563854 521193 677060 688045 463913 475483 494692 558905 517358 556397 582493 586597 506576 507511 522663 593939 529497 671667 561452 413826 563884 623404 618442 619192 492267 625675 603167 622932 620546 599452 581684 521989 571658 536397 677025 565067 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.63%) |
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 384306 396640 413826 428241 429223 435374 440698 444341 444435 447146 447435 447513 447524 447539 449678 451706 455653 461122 463674 463913 465326 465548 468006 469553 470846 473974 475172 475483 476823 490079 492002 492267 493218 494692 499148 501732 501748 501774 501804 505977 506576 507500 507511 508747 510203 512790 513768 517358 518548 519486 519661 521193 521989 522663 524016 527057 527793 529497 536397 551147 552043 552296 554253 555571 556397 556945 558905 558958 561452 563854 563871 563878 563884 565067 565188 565279 569933 571658 581684 582493 584257 586549 586597 592314 593649 593939 596412 599452 602212 603167 605936 608878 618442 619192 620546 622932 623404 625675 628910 654914 659412 659439 671356 671626 671656 671667 672671 676987 677020 677025 677060 681505 683588 685001 687174 688045 688340 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex virgin teens"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс virgin teens"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс virgin teens"
]
|
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.