Query Metrics
7
Database Queries
7
Different statements
185.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.42 ms (85.57%) |
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 2362 2407 2632 2651 3100 14599 16870 191189 385907 386915 392270 393756 395818 397393 397905 401773 409947 413000 418934 419702 423804 424329 424474 424923 426456 428497 429449 436829 443801 447297 448547 449778 453325 454709 458765 461169 461503 462000 463174 466310 466602 470689 473963 479878 482090 482624 482982 484519 485454 486130 490417 494985 494987 495741 499018 502247 502482 506977 510286 512287 518012 520306 522585 522796 523168 523857 524971 527721 531537 538216 543655 549579 550033 550662 560199 562895 566217 567156 579366 602572 604161 607398 616793 619539 622229 643411 673506 678962 687522 700915 702489 702498 704432 712891 714390 716725 718880 724605 728149 728154 728158 728910 729273 741807 752278 757506 761426 767824 782885 784084 786514 791681 792788 793550 793556 795073 800015 800023 804057 825017 ] |
||||||||||||||||||||||||||||||
|
16.14 ms (8.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 461503 482982 429449 482624 392270 413000 562895 482090 486130 473963 550033 678962 466310 520306 728910 607398 495741 523857 449778 531537 712891 549579 461169 494987 643411 702498 502482 395818 454709 418934 518012 424329 729273 792788 543655 622229 502247 604161 510286 484519 619539 385907 724605 560199 485454 522585 567156 14599 2651 825017 506977 447297 616793 550662 423804 470689 522796 191189 490417 463174 448547 386915 499018 466602 479878 512287 397905 443801 523168 494985 436829 524971 419702 393756 453325 424474 602572 538216 409947 401773 424923 462000 566217 426456 428497 527721 458765 579366 687522 728158 716725 757506 3100 16870 714390 2362 2407 793556 2632 784084 702489 700915 767824 728154 786514 795073 397393 704432 728149 800015 761426 804057 673506 800023 718880 782885 741807 793550 791681 752278 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.85%) |
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 2362 2407 2632 2651 3100 14599 16870 191189 385907 386915 392270 393756 395818 397393 397905 401773 409947 413000 418934 419702 423804 424329 424474 424923 426456 428497 429449 436829 443801 447297 448547 449778 453325 454709 458765 461169 461503 462000 463174 466310 466602 470689 473963 479878 482090 482624 482982 484519 485454 486130 490417 494985 494987 495741 499018 502247 502482 506977 510286 512287 518012 520306 522585 522796 523168 523857 524971 527721 531537 538216 543655 549579 550033 550662 560199 562895 566217 567156 579366 602572 604161 607398 616793 619539 622229 643411 673506 678962 687522 700915 702489 702498 704432 712891 714390 716725 718880 724605 728149 728154 728158 728910 729273 741807 752278 757506 761426 767824 782885 784084 786514 791681 792788 793550 793556 795073 800015 800023 804057 825017 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 position sex"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз position 69 секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз position 69 секс"
]
|
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.