Query Metrics
7
Database Queries
7
Different statements
149.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.01 ms (80.43%) |
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 70077 81869 108107 108221 312919 314021 386563 392789 400703 402877 408947 410806 416408 418950 420360 422106 422270 422275 424325 425045 426121 426649 428269 431052 434653 439900 443549 446872 447164 448505 449135 450171 451132 453269 454085 455504 456557 457154 461609 462261 476995 482896 491447 497565 503702 511649 514311 515334 517393 519886 521701 524711 527617 530057 540539 540697 550299 551178 551273 554511 554872 560861 561682 563316 564327 568551 572843 574804 579311 580884 584710 594768 612442 623162 624853 632699 632712 639990 650488 653876 662594 667320 667886 670414 674752 680977 681304 696490 709406 724177 725409 730270 741338 754705 754742 775976 777181 787409 791227 802117 804071 807609 807635 807958 810317 817400 818693 818987 819000 819016 819531 819720 820915 822316 823017 824366 825246 827305 827905 ] |
||||||||||||||||||||||||||||||
|
18.67 ms (12.51%) |
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 402877 424325 312919 810317 823017 817400 667886 709406 741338 462261 426649 422106 554511 503702 514311 521701 426121 482896 449135 454085 551178 554872 561682 550299 574804 650488 667320 680977 584710 802117 725409 807635 730270 804071 807958 431052 450171 108107 461609 517393 515334 314021 443549 447164 568551 524711 400703 455504 511649 540539 530057 540697 579311 580884 416408 476995 527617 425045 81869 420360 674752 108221 822316 818987 820915 819531 825246 827905 754742 787409 807609 70077 439900 410806 428269 418950 446872 653876 662594 551273 572843 612442 434653 491447 497565 564327 623162 422270 791227 422275 775976 451132 392789 819720 824366 818693 819000 819016 827305 670414 696490 583788 639990 754705 777181 386563 408947 453269 519886 560861 563316 681304 594768 632699 624853 632712 724177 457154 448505 456557 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.92%) |
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 70077 81869 108107 108221 312919 314021 386563 392789 400703 402877 408947 410806 416408 418950 420360 422106 422270 422275 424325 425045 426121 426649 428269 431052 434653 439900 443549 446872 447164 448505 449135 450171 451132 453269 454085 455504 456557 457154 461609 462261 476995 482896 491447 497565 503702 511649 514311 515334 517393 519886 521701 524711 527617 530057 540539 540697 550299 551178 551273 554511 554872 560861 561682 563316 564327 568551 572843 574804 579311 580884 584710 594768 612442 623162 624853 632699 632712 639990 650488 653876 662594 667320 667886 670414 674752 680977 681304 696490 709406 724177 725409 730270 741338 754705 754742 775976 777181 787409 791227 802117 804071 807609 807635 807958 810317 817400 818693 818987 819000 819016 819531 819720 820915 822316 823017 824366 825246 827305 827905 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde handjob"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
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.