Query Metrics
7
Database Queries
7
Different statements
169.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.29 ms (82.68%) |
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 384527 387936 389167 394664 395233 397269 400080 400426 401998 404343 413944 414666 415205 417136 419571 420185 426361 429086 429305 429312 429629 443303 446531 446863 447455 456638 461085 461542 463904 463919 463935 464281 465185 468160 469650 470392 474536 475704 475833 477544 479330 479590 482621 482793 483551 483951 487197 489486 489583 489618 490694 491644 491650 491701 493986 497096 503233 505103 505288 505905 506557 508457 510565 514218 515175 515178 517024 519012 525019 529846 530493 530757 532251 534787 536861 537208 538576 543720 550343 556060 560266 568537 569168 571193 579624 580706 580747 582915 586596 586598 598029 598040 599912 602608 602939 611246 612399 619211 620300 624933 628732 662171 675026 679821 691894 717653 727852 739761 747687 750747 767427 772813 775087 776591 790036 790754 797752 810247 814506 814511 ] |
||||||||||||||||||||||||||||||
|
18.56 ms (10.94%) |
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 679821 517024 582915 675026 772813 550343 586596 662171 628732 797752 400080 419571 510565 465185 456638 461542 483951 767427 400426 413944 493986 463919 475833 515175 530493 491644 505288 514218 810247 475704 532251 612399 537208 530757 529846 568537 580747 599912 602608 775087 397269 420185 602939 414666 429086 814506 814511 482621 482793 470392 491701 505103 503233 515178 534787 464281 569168 543720 560266 580706 611246 624933 620300 747687 401998 443303 468160 474536 389167 429312 446531 446863 463904 463935 384527 387936 394664 415205 395233 417136 426361 429305 447455 479330 479590 429629 477544 505905 536861 525019 489486 489583 489618 491650 519012 483551 490694 497096 508457 717653 691894 556060 619211 776591 750747 461085 469650 598029 598040 487197 790754 790036 727852 739761 506557 571193 579624 586598 404343 538576 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.78%) |
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 384527 387936 389167 394664 395233 397269 400080 400426 401998 404343 413944 414666 415205 417136 419571 420185 426361 429086 429305 429312 429629 443303 446531 446863 447455 456638 461085 461542 463904 463919 463935 464281 465185 468160 469650 470392 474536 475704 475833 477544 479330 479590 482621 482793 483551 483951 487197 489486 489583 489618 490694 491644 491650 491701 493986 497096 503233 505103 505288 505905 506557 508457 510565 514218 515175 515178 517024 519012 525019 529846 530493 530757 532251 534787 536861 537208 538576 543720 550343 556060 560266 568537 569168 571193 579624 580706 580747 582915 586596 586598 598029 598040 599912 602608 602939 611246 612399 619211 620300 624933 628732 662171 675026 679821 691894 717653 727852 739761 747687 750747 767427 772813 775087 776591 790036 790754 797752 810247 814506 814511 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite small tits"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite маленькая сиськ"
]
|
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.