Query Metrics
7
Database Queries
7
Different statements
379.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.17 ms (54.28%) |
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 78994 187928 188064 193662 233353 236724 310945 358466 381752 382281 382502 384581 384865 385469 386403 386456 386648 386759 387337 387363 387938 388856 391492 394642 395276 396595 397879 398553 400428 401967 404684 407019 407067 407266 409795 409887 411012 411918 412015 413678 419880 423368 424428 424933 429741 431314 442665 448082 456393 456819 456822 464884 466679 468467 468708 470511 470864 471125 471786 472905 474699 475836 484685 489379 491249 491784 518454 521587 522923 523876 554472 561005 580259 580707 588077 596449 598115 604197 619645 624229 629278 629940 632712 640858 651851 660253 669189 689736 691598 717862 724256 731783 731877 733557 738519 742880 746339 748357 748690 750317 758152 764144 766684 772369 773224 773796 787272 787289 795139 795918 801475 802177 802547 808972 809463 814431 814616 814625 818727 823170 ] |
||||||||||||||||||||||||||||||
|
148.67 ms (39.14%) |
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 78994 187928 188064 193662 233353 236724 310945 358466 381752 382281 382502 384581 384865 385469 386403 386456 386648 386759 387337 387363 387938 388856 391492 394642 395276 396595 397879 398553 400428 401967 404684 407019 407067 407266 409795 409887 411012 411918 412015 413678 419880 423368 424428 424933 429741 431314 442665 448082 456393 456819 456822 464884 466679 468467 468708 470511 470864 471125 471786 472905 474699 475836 484685 489379 491249 491784 518454 521587 522923 523876 554472 561005 580259 580707 588077 596449 598115 604197 619645 624229 629278 629940 632712 640858 651851 660253 669189 689736 691598 717862 724256 731783 731877 733557 738519 742880 746339 748357 748690 750317 758152 764144 766684 772369 773224 773796 787272 787289 795139 795918 801475 802177 802547 808972 809463 814431 814616 814625 818727 823170 ] |
||||||||||||||||||||||||||||||
|
18.11 ms (4.77%) |
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 470864 632712 407019 236724 411012 818727 823170 384581 468467 491249 424428 489379 588077 472905 387337 758152 391492 187928 387363 442665 409795 409887 814431 456819 456822 470511 468708 521587 691598 717862 651851 619645 809463 750317 773224 738519 629940 787272 464884 448082 431314 522923 523876 456393 394642 407067 491784 401967 382502 411918 484685 382281 766684 384865 78994 396595 400428 814625 814616 660253 598115 629278 640858 795918 808972 801475 742880 746339 748690 795139 802547 748357 724256 733557 772369 773796 787289 475836 731877 386456 471125 554472 381752 385469 310945 404684 386648 419880 398553 358466 802177 764144 193662 413678 731783 386759 423368 429741 471786 580259 561005 689736 604197 596449 388856 395276 386403 188064 397879 412015 518454 466679 233353 387938 407266 424933 474699 580707 669189 624229 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal blonde"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал беловолосая"
]
|
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.