Query Metrics
7
Database Queries
7
Different statements
181.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.34 ms (84.48%) |
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 10934 384863 394006 397997 405699 418146 424043 425610 426738 429706 430896 433581 453759 455591 458212 459135 459573 465439 465720 467982 469080 474304 476320 478023 480513 485657 490392 492010 497809 507389 509401 510766 511612 517038 520279 522082 522530 524122 524954 526427 527109 527541 528874 529045 529048 529997 536912 537957 539302 540752 542530 545774 545913 546702 547945 549796 553229 553475 554620 555747 555975 556449 556843 556905 557284 557582 558274 560148 560431 560738 562449 563114 566937 568391 569627 571657 574710 575610 576170 576254 576692 577482 581158 583384 583567 584284 585217 586757 586954 590807 590981 592852 596812 600467 600491 601790 602791 603576 605966 609146 617146 618306 618368 624176 636278 639133 648670 650075 650607 652052 652806 662518 681501 712001 714289 748996 757421 772441 792021 823995 ] |
||||||||||||||||||||||||||||||
|
18.18 ms (10.02%) |
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 529045 537957 539302 520279 529997 476320 583567 545913 542530 545774 553475 652052 681501 557582 566937 574710 577482 586954 600467 601790 590807 609146 585217 617146 586757 618368 772441 757421 712001 430896 394006 425610 429706 433581 474304 459573 397997 823995 490392 459135 480513 526427 497809 524954 528874 511612 527541 492010 556843 555975 556905 563114 554620 581158 583384 648670 555747 576254 596812 618306 792021 748996 10934 426738 507389 384863 405699 418146 424043 467982 469080 485657 458212 478023 453759 455591 465720 522082 527109 540752 509401 510766 522530 529048 517038 524122 536912 465439 553229 560148 560738 568391 569627 575610 547945 556449 571657 576692 546702 557284 558274 562449 576170 584284 662518 650075 650607 652806 714289 549796 560431 590981 592852 602791 603576 605966 624176 636278 639133 600491 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.55%) |
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 10934 384863 394006 397997 405699 418146 424043 425610 426738 429706 430896 433581 453759 455591 458212 459135 459573 465439 465720 467982 469080 474304 476320 478023 480513 485657 490392 492010 497809 507389 509401 510766 511612 517038 520279 522082 522530 524122 524954 526427 527109 527541 528874 529045 529048 529997 536912 537957 539302 540752 542530 545774 545913 546702 547945 549796 553229 553475 554620 555747 555975 556449 556843 556905 557284 557582 558274 560148 560431 560738 562449 563114 566937 568391 569627 571657 574710 575610 576170 576254 576692 577482 581158 583384 583567 584284 585217 586757 586954 590807 590981 592852 596812 600467 600491 601790 602791 603576 605966 609146 617146 618306 618368 624176 636278 639133 648670 650075 650607 652052 652806 662518 681501 712001 714289 748996 757421 772441 792021 823995 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"finger for girl"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"палец девушк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"палец девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
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.