Query Metrics
7
Database Queries
7
Different statements
152.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.95 ms (83.68%) |
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 3533 118141 124494 151062 188337 287436 317791 336547 383020 383722 385228 391659 393107 397656 398940 404212 411198 418490 418622 419998 420774 421162 423572 424115 435411 441850 442870 445880 447517 447539 448338 453156 453261 456229 457968 458475 459688 461738 461937 462701 465252 465707 475776 476621 478284 478533 481409 483430 484076 484717 485317 489573 490217 493304 495482 496295 499427 500250 500576 500815 505285 506112 506287 510332 512821 518990 518992 521898 523062 523236 525792 528327 528882 531656 537905 549627 551260 555116 569870 570282 571151 571905 578068 589071 590360 600204 604409 604421 607761 619828 623842 624472 628116 637437 648618 656891 673217 675375 677362 682515 683567 703494 714183 716746 721798 729337 736207 737452 758691 761754 765055 770501 774241 781397 783162 786813 795136 798584 814041 823309 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (9.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 505285 648618 656891 590360 736207 336547 3533 528327 490217 499427 465252 578068 571905 383020 549627 761754 385228 118141 317791 418622 484717 500250 500815 619828 624472 729337 391659 510332 604409 462701 571151 623842 523236 528882 478284 457968 531656 478533 770501 424115 814041 823309 484076 551260 570282 682515 683567 673217 637437 783162 786813 737452 798584 758691 765055 774241 716746 721798 781397 453156 459688 506112 483430 495482 628116 523062 604421 456229 447539 493304 475776 420774 445880 518990 461937 465707 675375 677362 589071 607761 714183 453261 393107 398940 442870 447517 448338 423572 537905 421162 500576 518992 555116 506287 489573 418490 485317 496295 521898 569870 703494 458475 476621 512821 525792 383722 188337 287436 397656 411198 481409 600204 795136 461738 441850 419998 404212 435411 124494 151062 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.04%) |
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 3533 118141 124494 151062 188337 287436 317791 336547 383020 383722 385228 391659 393107 397656 398940 404212 411198 418490 418622 419998 420774 421162 423572 424115 435411 441850 442870 445880 447517 447539 448338 453156 453261 456229 457968 458475 459688 461738 461937 462701 465252 465707 475776 476621 478284 478533 481409 483430 484076 484717 485317 489573 490217 493304 495482 496295 499427 500250 500576 500815 505285 506112 506287 510332 512821 518990 518992 521898 523062 523236 525792 528327 528882 531656 537905 549627 551260 555116 569870 570282 571151 571905 578068 589071 590360 600204 604409 604421 607761 619828 623842 624472 628116 637437 648618 656891 673217 675375 677362 682515 683567 703494 714183 716746 721798 729337 736207 737452 758691 761754 765055 770501 774241 781397 783162 786813 795136 798584 814041 823309 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public anal hard"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц анал hard"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц анал hard"
]
|
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.