Query Metrics
7
Database Queries
7
Different statements
199.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.19 ms (88.26%) |
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 66866 148793 170836 330565 355294 381752 381842 381853 382549 383508 387684 388712 388722 390096 390567 390571 391928 392785 396032 396323 397364 398244 401221 401640 401820 403911 404286 406068 406567 406592 407066 407346 407531 407648 411353 411603 412988 415552 416056 419523 427181 439572 439682 439706 451457 451458 453252 453465 454170 454525 454552 459896 460179 460735 464388 464395 465339 465829 466015 466182 466217 466271 467248 467457 467512 467541 470196 470290 471053 471449 472148 473204 473205 474121 474132 474147 474463 474629 474661 474685 476331 476342 479765 481925 482355 482371 482521 482555 483382 484598 484655 484681 484739 486533 486540 487315 490937 491357 503490 505479 511160 514748 518927 519139 521200 522627 523674 524876 573726 614514 696312 726474 726544 741904 748242 781678 781688 781706 781731 782158 ] |
||||||||||||||||||||||||||||||
|
12.12 ms (6.07%) |
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 451457 467457 474629 401640 412988 439682 451458 481925 474132 514748 484655 518927 397364 482555 388712 486540 381752 406592 411353 415552 407531 459896 464388 748242 381853 476331 401221 460179 476342 465339 465829 471449 388722 416056 479765 483382 490937 519139 484598 503490 396323 392785 726474 330565 170836 390567 398244 406567 406068 407066 411603 482371 482521 696312 614514 726544 471053 407346 467541 401820 467512 407648 505479 419523 439572 391928 390096 404286 474463 524876 466182 466271 382549 403911 484739 522627 473205 573726 390571 454552 464395 482355 467248 472148 470196 474661 454525 460735 439706 454170 466015 466217 474685 511160 486533 487315 66866 383508 355294 381842 387684 396032 427181 453252 453465 474121 781706 781731 782158 781678 781688 741904 148793 521200 491357 523674 474147 473204 484681 470290 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (2.12%) |
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 66866 148793 170836 330565 355294 381752 381842 381853 382549 383508 387684 388712 388722 390096 390567 390571 391928 392785 396032 396323 397364 398244 401221 401640 401820 403911 404286 406068 406567 406592 407066 407346 407531 407648 411353 411603 412988 415552 416056 419523 427181 439572 439682 439706 451457 451458 453252 453465 454170 454525 454552 459896 460179 460735 464388 464395 465339 465829 466015 466182 466217 466271 467248 467457 467512 467541 470196 470290 471053 471449 472148 473204 473205 474121 474132 474147 474463 474629 474661 474685 476331 476342 479765 481925 482355 482371 482521 482555 483382 484598 484655 484681 484739 486533 486540 487315 490937 491357 503490 505479 511160 514748 518927 519139 521200 522627 523674 524876 573726 614514 696312 726474 726544 741904 748242 781678 781688 781706 781731 782158 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин парен"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"зрелая женщин парен"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.