Query Metrics
7
Database Queries
7
Different statements
232.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.79 ms (87.24%) |
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 252068 400361 402238 404251 415360 420600 424074 426683 428814 428961 439525 439599 443365 443367 443811 447246 458777 459751 460732 460747 462085 465805 469874 470272 470289 470731 470737 471073 473928 474106 474485 474493 475453 476381 476749 479044 479134 484439 484851 490924 494369 506051 511691 533514 543671 543825 545528 546936 547753 550227 552076 556845 557993 558052 561357 563038 563144 566081 567670 569660 574808 575514 575819 576292 576380 595465 597061 597833 597984 598508 603160 610595 611700 611890 621043 649084 657025 657064 659858 660272 668607 673038 676978 677021 679388 694160 694533 696964 698488 701049 708803 717745 721368 721438 721496 725579 730381 737416 740331 742174 742194 743142 744025 744698 747558 749896 759543 766578 772532 775797 776396 779798 780446 786998 800321 801272 807333 811814 823359 ] |
||||||||||||||||||||||||||||||
|
19.67 ms (8.46%) |
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 673038 668607 677021 679388 721438 597833 597984 780446 801272 811814 759543 742174 744025 698488 649084 657025 749896 563144 574808 546936 563038 576292 611700 428961 475453 476381 420600 443367 484439 533514 610595 404251 550227 567670 676978 566081 569660 465805 775797 701049 742194 545528 474106 543671 657064 721496 696964 717745 603160 597061 598508 621043 800321 807333 740331 766578 769740 737416 747558 725579 786998 575819 543825 558052 476749 252068 447246 428814 471073 439599 443811 552076 557993 556845 561357 400361 470289 479134 424074 443365 458777 459751 470737 474485 479044 470731 511691 490924 494369 694533 611890 779798 743142 772532 460732 473928 460747 506051 823359 547753 660272 708803 694160 721368 659858 595465 730381 744698 776396 402238 469874 575514 576380 415360 484851 462085 470272 439525 474493 426683 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.03%) |
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 252068 400361 402238 404251 415360 420600 424074 426683 428814 428961 439525 439599 443365 443367 443811 447246 458777 459751 460732 460747 462085 465805 469874 470272 470289 470731 470737 471073 473928 474106 474485 474493 475453 476381 476749 479044 479134 484439 484851 490924 494369 506051 511691 533514 543671 543825 545528 546936 547753 550227 552076 556845 557993 558052 561357 563038 563144 566081 567670 569660 574808 575514 575819 576292 576380 595465 597061 597833 597984 598508 603160 610595 611700 611890 621043 649084 657025 657064 659858 660272 668607 673038 676978 677021 679388 694160 694533 696964 698488 701049 708803 717745 721368 721438 721496 725579 730381 737416 740331 742174 742194 743142 744025 744698 747558 749896 759543 766578 772532 775797 776396 779798 780446 786998 800321 801272 807333 811814 823359 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young rus sex"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young русск секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young русск секс"
]
|
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.