Query Metrics
7
Database Queries
7
Different statements
203.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.14 ms (81.74%) |
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 188556 282010 337190 389700 391202 392111 415819 428404 429774 430306 431962 433212 443659 444526 449021 453076 453077 453877 454191 458191 460412 463094 465590 469200 469477 471380 471392 472544 474538 474688 475452 477060 477210 478575 481965 482304 483536 485100 491678 492050 492701 493203 495154 496551 496794 497356 499099 501233 505369 506295 510577 511011 515131 517042 520215 522344 525647 530834 532344 535466 540089 542562 543224 543918 546667 548606 549312 566449 569059 582972 586103 590924 595781 596141 603180 603551 605548 606053 606533 607091 615538 616341 616343 622645 622653 622655 629569 637002 641480 650375 650796 651601 653209 654279 672760 676326 676851 676886 680271 687461 691990 691992 692455 693037 695948 697761 700281 710781 712187 723919 724740 732640 758280 761167 775793 778533 782020 798881 815566 817618 ] |
||||||||||||||||||||||||||||||
|
26.24 ms (12.91%) |
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 495154 453077 499099 497356 540089 389700 493203 474688 491678 532344 697761 605548 458191 501233 337190 817618 549312 693037 815566 449021 606533 732640 650375 496794 471392 415819 188556 430306 478575 485100 453076 469200 443659 453877 463094 506295 475452 520215 433212 603551 454191 472544 477060 522344 469477 616341 429774 778533 629569 653209 672760 724740 650796 543224 511011 569059 582972 676851 471380 517042 622655 622653 710781 615538 546667 775793 758280 680271 700281 712187 590924 606053 603180 798881 428404 431962 483536 496551 492701 566449 695948 641480 392111 460412 548606 525647 761167 282010 596141 782020 477210 687461 543918 535466 676886 637002 515131 651601 482304 492050 444526 691990 586103 481965 505369 542562 391202 510577 530834 474538 654279 691992 622645 607091 616343 723919 465590 676326 692455 595781 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.61%) |
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 188556 282010 337190 389700 391202 392111 415819 428404 429774 430306 431962 433212 443659 444526 449021 453076 453077 453877 454191 458191 460412 463094 465590 469200 469477 471380 471392 472544 474538 474688 475452 477060 477210 478575 481965 482304 483536 485100 491678 492050 492701 493203 495154 496551 496794 497356 499099 501233 505369 506295 510577 511011 515131 517042 520215 522344 525647 530834 532344 535466 540089 542562 543224 543918 546667 548606 549312 566449 569059 582972 586103 590924 595781 596141 603180 603551 605548 606053 606533 607091 615538 616341 616343 622645 622653 622655 629569 637002 641480 650375 650796 651601 653209 654279 672760 676326 676851 676886 680271 687461 691990 691992 692455 693037 695948 697761 700281 710781 712187 723919 724740 732640 758280 761167 775793 778533 782020 798881 815566 817618 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation threesome"
]
|
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.