Query Metrics
7
Database Queries
7
Different statements
553.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
327.54 ms (59.13%) |
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 381885 390455 395306 396563 398221 411459 422477 434767 435104 439775 445187 446315 446612 447642 452260 452633 454848 455656 464262 467946 468421 468634 470160 471411 478454 480718 480857 483649 483787 491583 492482 493174 493258 495824 500256 508558 510068 510126 519045 522087 524502 550341 560949 564029 564252 565189 572707 581082 581251 581264 583485 586853 592009 604663 609267 620113 651876 654922 667986 671889 685810 693367 693509 710859 714964 715761 717258 721971 723574 725134 728305 731259 735961 739913 740289 740726 742491 754220 756789 761528 762271 763503 764157 765364 765366 765819 766608 767055 767972 770326 773830 773912 777026 777636 779665 780368 786094 786372 787567 791426 792953 794359 794765 794855 794859 794873 794908 794932 795122 795706 796153 800432 800612 802754 804325 817328 819749 822121 824763 ] |
||||||||||||||||||||||||||||||
|
206.63 ms (37.30%) |
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 381885 390455 395306 396563 398221 411459 422477 434767 435104 439775 445187 446315 446612 447642 452260 452633 454848 455656 464262 467946 468421 468634 470160 471411 478454 480718 480857 483649 483787 491583 492482 493174 493258 495824 500256 508558 510068 510126 519045 522087 524502 550341 560949 564029 564252 565189 572707 581082 581251 581264 583485 586853 592009 604663 609267 620113 651876 654922 667986 671889 685810 693367 693509 710859 714964 715761 717258 721971 723574 725134 728305 731259 735961 739913 740289 740726 742491 754220 756789 761528 762271 763503 764157 765364 765366 765819 766608 767055 767972 770326 773830 773912 777026 777636 779665 780368 786094 786372 787567 791426 792953 794359 794765 794855 794859 794873 794908 794932 795122 795706 796153 800432 800612 802754 804325 817328 819749 822121 824763 ] |
||||||||||||||||||||||||||||||
|
13.07 ms (2.36%) |
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 794873 795706 800432 740726 786372 792953 794765 794855 800612 739913 740289 762271 765366 765819 767972 754220 765364 773912 735961 756789 767055 609267 714964 721971 786094 791426 794359 794908 395306 390455 411459 435104 667986 467946 452633 468634 471411 495824 500256 565189 581082 446315 447642 464262 480857 422477 439775 452260 455656 445187 454848 470160 446612 465885 483649 493258 522087 524502 493174 510068 519045 483787 492482 508558 510126 478454 560949 654922 693509 770326 796153 381885 819749 824763 817328 822121 685810 794932 787567 761528 766608 717258 777636 779665 804325 715761 794859 764157 396563 723574 581251 583485 693367 710859 620113 802754 780368 795122 725134 728305 731259 763503 742491 773830 777026 480718 398221 564029 581264 604663 434767 572707 592009 491583 586853 564252 468421 550341 651876 671889 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раком анал сперма"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак анал сперм"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.27%) |
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.