Query Metrics
7
Database Queries
7
Different statements
155.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.17 ms (81.53%) |
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 282006 282858 395306 395841 395929 396003 397535 410264 413594 415235 416397 417888 418035 427970 428045 429009 429629 444338 445711 446108 446158 447327 447405 447434 447494 447517 447642 447650 447662 447690 448366 451605 451755 454066 457492 459237 460769 461556 462804 463819 463863 463903 463927 463939 464696 465908 466098 473931 476090 477734 479759 484274 484434 484980 490794 491202 491718 492171 496071 496869 497870 499503 502763 505021 510071 510680 512762 518997 521291 522010 523197 524514 526463 527378 528606 530478 530697 531908 533010 533016 536252 536636 544782 549871 552430 555801 556181 558031 561880 565250 573777 575204 575618 575771 604180 627740 630018 632118 637851 646662 660321 671616 677367 681198 698434 706629 714667 714994 716633 719292 721322 721445 737298 740392 742188 742242 744270 754210 760772 791663 ] |
||||||||||||||||||||||||||||||
|
17.91 ms (11.48%) |
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 558031 573777 575204 721445 627740 630018 415235 445711 447690 448366 460769 462804 282858 397535 410264 418035 446158 447650 457492 477734 479759 395841 444338 451605 454066 473931 395929 447327 447494 461556 463939 465908 476090 447405 447517 466098 528606 484434 518997 522010 484274 490794 491202 492171 496869 499503 505021 521291 524514 526463 510071 512762 416397 459237 484980 536252 533010 523197 536636 531908 556181 428045 463863 463927 447434 502763 527378 491718 530478 395306 451755 464696 530697 533016 561880 706629 549871 740392 760772 429009 447642 463819 282006 427970 396003 463903 417888 429629 446108 510680 496071 413594 565250 497870 575771 754210 447662 677367 744270 737298 742188 552430 544782 575618 646662 671616 698434 716633 721322 660321 681198 714667 714994 719292 555801 632118 637851 604180 791663 742242 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (2.15%) |
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 282006 282858 395306 395841 395929 396003 397535 410264 413594 415235 416397 417888 418035 427970 428045 429009 429629 444338 445711 446108 446158 447327 447405 447434 447494 447517 447642 447650 447662 447690 448366 451605 451755 454066 457492 459237 460769 461556 462804 463819 463863 463903 463927 463939 464696 465908 466098 473931 476090 477734 479759 484274 484434 484980 490794 491202 491718 492171 496071 496869 497870 499503 502763 505021 510071 510680 512762 518997 521291 522010 523197 524514 526463 527378 528606 530478 530697 531908 533010 533016 536252 536636 544782 549871 552430 555801 556181 558031 561880 565250 573777 575204 575618 575771 604180 627740 630018 632118 637851 646662 660321 671616 677367 681198 698434 706629 714667 714994 716633 719292 721322 721445 737298 740392 742188 742242 744270 754210 760772 791663 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen big dick"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.13%) |
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.