Query Metrics
7
Database Queries
7
Different statements
139.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.79 ms (81.52%) |
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 96029 383188 391400 395496 398614 399263 407827 411787 412460 414548 416415 416616 418361 419034 419047 419417 421289 422626 422712 424200 426022 426476 428933 429793 430350 434001 434492 435350 438849 439046 442358 443274 446228 446600 447314 447636 448851 449629 449821 450357 451852 452113 455011 456523 460007 460412 461231 461439 461616 464451 464594 467155 472243 472445 472845 474610 476208 479112 484249 485242 488822 489077 490248 491647 491650 492142 493068 494269 494513 496451 497870 505106 508145 510395 515953 516942 519621 521975 523529 529958 532349 536590 536695 539424 540562 542751 544937 553280 560608 565198 565914 569357 571228 575828 579312 580298 588988 591640 601127 608347 615443 634138 674995 680181 680190 687293 ] |
||||||||||||||||||||||||||||||
|
16.45 ms (11.79%) |
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 446228 496451 488822 383188 421289 430350 435350 412460 447636 451852 472445 472845 461231 505106 516942 519621 560608 687293 588988 395496 416616 448851 476208 426022 426476 443274 461616 447314 461439 479112 439046 449629 449821 521975 492142 490248 491650 493068 523529 418361 539424 544937 579312 510395 450357 434492 608347 434001 414548 429793 540562 615443 422712 422626 515953 489077 565198 565914 438849 391400 398614 419034 428933 472243 508145 494513 464451 419417 419047 455011 460007 474610 680181 494269 529958 634138 399263 571228 601127 452113 575828 580298 407827 442358 532349 460412 542751 591640 424200 456523 446600 485242 491647 96029 411787 467155 416415 680190 569357 464594 536590 484249 497870 674995 536695 553280 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.69%) |
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 96029 383188 391400 395496 398614 399263 407827 411787 412460 414548 416415 416616 418361 419034 419047 419417 421289 422626 422712 424200 426022 426476 428933 429793 430350 434001 434492 435350 438849 439046 442358 443274 446228 446600 447314 447636 448851 449629 449821 450357 451852 452113 455011 456523 460007 460412 461231 461439 461616 464451 464594 467155 472243 472445 472845 474610 476208 479112 484249 485242 488822 489077 490248 491647 491650 492142 493068 494269 494513 496451 497870 505106 508145 510395 515953 516942 519621 521975 523529 529958 532349 536590 536695 539424 540562 542751 544937 553280 560608 565198 565914 569357 571228 575828 579312 580298 588988 591640 601127 608347 615443 634138 674995 680181 680190 687293 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"Ðâð┐ÐÇÐâð│ð░ÐÅ ð║ÐÇð░Ðüð©ð▓ð░ÐÅ ð┐ð¥ð┐ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"упругая красивая жоп"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.99%) |
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.