Query Metrics
7
Database Queries
7
Different statements
173.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.14 ms (85.16%) |
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 394631 396190 413593 414089 419029 419669 423914 425519 426357 444917 445226 446162 447052 447253 447486 447538 448489 451752 452575 456220 457130 457541 461461 463687 463689 463935 464264 470948 476012 479190 483624 489524 491914 493304 493448 495417 495758 496738 497371 498294 505905 507951 519700 533765 534441 542706 551564 553223 554235 554949 555104 556906 561339 563050 565496 569359 571194 572359 576271 579106 581916 598612 602782 605934 608878 609883 609896 609898 613183 614898 620647 625467 652199 652249 653180 653216 653503 653548 654120 659413 674204 676459 687362 691808 694415 705809 713925 714497 714562 718660 718702 720686 722264 722384 722522 722627 722692 733450 742158 742320 745100 751563 755878 757467 757566 757951 769380 770784 778375 781621 782515 782792 787488 788107 788443 791930 800442 807481 813091 820423 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (9.10%) |
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 714497 461461 493448 534441 605934 614898 479190 448489 554235 551564 609898 414089 419669 452575 457541 463689 476012 426357 470948 444917 447052 447253 447538 445226 447486 457130 491914 495417 495758 483624 733450 757951 820423 519700 556906 571194 652199 653180 653216 653548 654120 674204 687362 713925 722264 652249 676459 691808 705809 722692 659413 722522 722627 569359 602782 613183 620647 625467 787488 788443 782792 807481 742320 769380 782515 813091 742158 751563 757566 745100 755878 757467 770784 609896 714562 718660 718702 720686 778375 781621 788107 791930 425519 396190 394631 451752 463687 464264 563050 565496 581916 608878 609883 598612 800442 446162 456220 463935 413593 419029 423914 505905 498294 507951 496738 497371 489524 493304 533765 572359 576271 579106 542706 555104 653503 694415 722384 553223 554949 561339 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.80%) |
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 394631 396190 413593 414089 419029 419669 423914 425519 426357 444917 445226 446162 447052 447253 447486 447538 448489 451752 452575 456220 457130 457541 461461 463687 463689 463935 464264 470948 476012 479190 483624 489524 491914 493304 493448 495417 495758 496738 497371 498294 505905 507951 519700 533765 534441 542706 551564 553223 554235 554949 555104 556906 561339 563050 565496 569359 571194 572359 576271 579106 581916 598612 602782 605934 608878 609883 609896 609898 613183 614898 620647 625467 652199 652249 653180 653216 653503 653548 654120 659413 674204 676459 687362 691808 694415 705809 713925 714497 714562 718660 718702 720686 722264 722384 722522 722627 722692 733450 742158 742320 745100 751563 755878 757467 757566 757951 769380 770784 778375 781621 782515 782792 787488 788107 788443 791930 800442 807481 813091 820423 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal toys russian"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал toys русск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал toys русск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.90%) |
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.