Query Metrics
7
Database Queries
7
Different statements
174.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.82 ms (83.79%) |
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 72782 146508 152157 172068 187704 233862 358449 358481 359420 383224 384553 386191 387198 387359 391923 395596 397174 397863 397894 397901 398956 400473 400478 402383 404664 407191 407500 407809 409599 410182 411468 411627 419517 420375 424463 426434 428882 429089 453438 453930 454187 454194 455048 456384 457991 460175 462557 462690 463260 464450 465344 466164 466173 466244 466807 467449 473954 474485 474870 483346 490918 490924 515026 525376 532698 557512 561453 563072 563444 563535 570182 573806 599716 613177 643362 650625 670513 687195 695598 696415 697203 699370 710568 714183 714901 715972 716277 723592 727050 727812 731810 732308 744294 745732 748139 748239 750445 758614 770011 772333 776892 782217 782278 782626 785435 788611 789290 789551 799359 802416 802768 803298 811003 814909 815529 815722 816455 816793 818167 820298 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (9.26%) |
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 744294 467449 454194 820298 782217 789290 466807 715972 714183 811003 474485 490918 490924 426434 72782 814909 815529 818167 687195 785435 699370 789551 803298 398956 359420 407809 599716 799359 233862 391923 573806 816793 727050 710568 515026 429089 750445 466164 463260 466173 419517 696415 358481 532698 723592 816455 670513 776892 770011 732308 358449 407191 410182 697203 386191 731810 483346 570182 563072 748239 397901 387359 453930 420375 465344 400473 407500 409599 384553 397894 400478 424463 428882 395596 152157 561453 525376 146508 782278 397863 411468 457991 460175 466244 404664 557512 782626 172068 462557 462690 453438 455048 474870 411627 464450 563444 748139 563535 727812 613177 456384 383224 695598 716277 650625 643362 802416 745732 758614 772333 802768 714901 788611 187704 473954 402383 815722 454187 387198 397174 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.42%) |
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 72782 146508 152157 172068 187704 233862 358449 358481 359420 383224 384553 386191 387198 387359 391923 395596 397174 397863 397894 397901 398956 400473 400478 402383 404664 407191 407500 407809 409599 410182 411468 411627 419517 420375 424463 426434 428882 429089 453438 453930 454187 454194 455048 456384 457991 460175 462557 462690 463260 464450 465344 466164 466173 466244 466807 467449 473954 474485 474870 483346 490918 490924 515026 525376 532698 557512 561453 563072 563444 563535 570182 573806 599716 613177 643362 650625 670513 687195 695598 696415 697203 699370 710568 714183 714901 715972 716277 723592 727050 727812 731810 732308 744294 745732 748139 748239 750445 758614 770011 772333 776892 782217 782278 782626 785435 788611 789290 789551 799359 802416 802768 803298 811003 814909 815529 815722 816455 816793 818167 820298 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck young mother"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс young мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс young мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.89%) |
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.