Query Metrics
7
Database Queries
7
Different statements
148.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.57 ms (82.73%) |
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 396877 409585 411370 417384 418124 419777 421010 426009 430835 431126 434561 438058 442910 444158 444227 445367 445630 451430 452692 455502 457889 460750 466025 466085 466130 466262 468929 469471 470169 470772 470783 472169 472855 472956 475410 475865 477580 482228 482618 482643 486366 490274 490901 490946 491227 491405 492515 493493 494786 508595 512257 512739 513033 515420 515865 515922 516550 518280 518566 519945 519948 520237 520428 520473 522827 522847 524952 524990 525795 526029 527121 528261 529565 546930 555582 558009 558645 561853 563477 564949 565936 566521 567153 567429 568083 571267 572042 575790 576100 576379 577120 577364 577365 578467 580318 580321 580646 583969 588631 592444 594874 596809 598601 601027 601253 602933 606317 615740 615929 618476 623266 644038 649080 663864 663888 663952 675515 681686 689755 807492 ] |
||||||||||||||||||||||||||||||
|
16.40 ms (11.07%) |
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 601253 491227 431126 689755 615740 411370 519945 519948 594874 592444 430835 580646 527121 421010 451430 522847 563477 577120 580321 580318 596809 457889 486366 472956 469471 409585 491405 526029 564949 572042 558009 663952 588631 434561 444227 466025 466085 512257 515865 492515 490946 522827 396877 598601 561853 524952 576379 438058 482228 529565 515922 524990 568083 663864 644038 470772 470169 472855 419777 490274 518280 649080 577365 807492 444158 577364 475410 663888 578467 445367 615929 452692 482618 508595 494786 528261 575790 442910 520428 418124 472169 681686 455502 518566 468929 513033 520473 477580 466262 567153 571267 601027 520237 618476 583969 675515 417384 493493 512739 576100 602933 567429 470783 515420 460750 525795 490901 445630 623266 426009 482643 546930 555582 565936 566521 558645 606317 466130 475865 516550 ] |
||||||||||||||||||||||||||||||
|
2.64 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 396877 409585 411370 417384 418124 419777 421010 426009 430835 431126 434561 438058 442910 444158 444227 445367 445630 451430 452692 455502 457889 460750 466025 466085 466130 466262 468929 469471 470169 470772 470783 472169 472855 472956 475410 475865 477580 482228 482618 482643 486366 490274 490901 490946 491227 491405 492515 493493 494786 508595 512257 512739 513033 515420 515865 515922 516550 518280 518566 519945 519948 520237 520428 520473 522827 522847 524952 524990 525795 526029 527121 528261 529565 546930 555582 558009 558645 561853 563477 564949 565936 566521 567153 567429 568083 571267 572042 575790 576100 576379 577120 577364 577365 578467 580318 580321 580646 583969 588631 592444 594874 596809 598601 601027 601253 602933 606317 615740 615929 618476 623266 644038 649080 663864 663888 663952 675515 681686 689755 807492 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни под стол"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс стол"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.