Query Metrics
7
Database Queries
7
Different statements
231.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.90 ms (89.04%) |
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 58201 381913 398325 401824 412910 413270 417800 418380 423561 425440 425545 429814 431052 431811 431953 431962 444968 446783 448839 449264 450995 451696 454241 454554 456921 463710 464366 465061 465933 468018 468673 471323 472484 474467 474550 482349 487101 488588 491353 492338 495154 496086 496088 496794 496795 500947 504488 505379 505384 510200 515002 516816 516975 521219 521227 523274 525725 525749 525752 525757 527664 532406 533264 536637 537247 538960 541994 545505 545848 547265 556328 558765 560453 566711 569053 570159 581995 585109 586476 596556 606487 608363 613751 616644 619166 624841 629658 632440 633139 636110 640222 650983 662894 665051 668160 670039 678662 681691 697028 697761 713082 719144 722055 725397 730556 733353 757211 760210 764037 777882 794733 802114 803208 805704 815566 817242 820648 823439 826763 827489 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (6.72%) |
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 632440 412910 465933 444968 556328 697761 532406 398325 719144 525725 500947 521227 516975 566711 670039 381913 662894 616644 757211 431953 815566 431052 495154 58201 446783 525749 624841 431962 474550 418380 423561 413270 471323 545848 581995 629658 803208 802114 496795 505379 523274 527664 537247 820648 713082 730556 454554 454241 496088 504488 817242 826763 425440 431811 525752 678662 521219 491353 464366 585109 827489 777882 451696 448839 468673 472484 545505 541994 558765 560453 640222 619166 465061 417800 425545 401824 456921 463710 450995 474467 487101 525757 468018 515002 505384 488588 482349 533264 569053 650983 665051 608363 633139 606487 733353 760210 496794 681691 429814 536637 570159 449264 496086 596556 823439 538960 516816 547265 668160 697028 586476 613751 725397 805704 764037 722055 794733 492338 510200 636110 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.52%) |
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 58201 381913 398325 401824 412910 413270 417800 418380 423561 425440 425545 429814 431052 431811 431953 431962 444968 446783 448839 449264 450995 451696 454241 454554 456921 463710 464366 465061 465933 468018 468673 471323 472484 474467 474550 482349 487101 488588 491353 492338 495154 496086 496088 496794 496795 500947 504488 505379 505384 510200 515002 516816 516975 521219 521227 523274 525725 525749 525752 525757 527664 532406 533264 536637 537247 538960 541994 545505 545848 547265 556328 558765 560453 566711 569053 570159 581995 585109 586476 596556 606487 608363 613751 616644 619166 624841 629658 632440 633139 636110 640222 650983 662894 665051 668160 670039 678662 681691 697028 697761 713082 719144 722055 725397 730556 733353 757211 760210 764037 777882 794733 802114 803208 805704 815566 817242 820648 823439 826763 827489 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy lick compilation"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy лиза подборк"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy лиза подборк"
]
|
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.