Query Metrics
7
Database Queries
7
Different statements
222.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.05 ms (85.03%) |
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 381890 382791 384121 391983 401508 401769 419891 420193 428179 428224 429957 439023 439031 439038 441110 449068 452547 452637 453585 454981 456239 460209 471330 478904 482813 483704 485338 486767 492181 505590 505599 506321 506516 506839 507284 508909 509422 511251 511343 512072 512935 514867 514876 515435 517724 519698 521814 523614 530420 531887 534550 534555 536475 538045 544140 545467 547236 547466 547468 547474 547488 547847 548443 550144 550938 554208 556876 556887 559787 561040 571809 572654 573204 574951 575418 575601 576899 576916 581477 584183 590289 590299 605133 605219 619109 625785 627146 627470 630732 634026 634076 634739 634900 641997 643213 643224 652758 656916 656933 660373 660412 664149 668688 669012 669038 669080 671052 672950 689074 704352 709693 735194 742353 761176 786911 794292 799782 824340 825514 825649 ] |
||||||||||||||||||||||||||||||
|
18.78 ms (8.45%) |
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 439023 454981 505590 384121 625785 506516 506839 508909 517724 519698 669012 559787 576916 590289 689074 471330 452637 530420 554208 643213 429957 576899 550144 550938 630732 799782 456239 420193 506321 514867 439038 428179 439031 428224 449068 452547 512072 512935 660412 660373 672950 581477 641997 786911 478904 483704 511343 509422 794292 556887 656933 534555 548443 575418 572654 735194 742353 391983 575601 668688 401508 401769 634026 704352 382791 482813 652758 709693 824340 825514 531887 544140 545467 547236 656916 584183 634076 590299 761176 523614 505599 538045 485338 574951 381890 825649 486767 515435 507284 514876 521814 571809 619109 511251 453585 634739 634900 643224 627470 627146 441110 419891 492181 534550 536475 460209 547466 547488 547847 556876 573204 547468 547474 669038 671052 664149 669080 561040 605133 605219 ] |
||||||||||||||||||||||||||||||
|
6.85 ms (3.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.17%) |
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 381890 382791 384121 391983 401508 401769 419891 420193 428179 428224 429957 439023 439031 439038 441110 449068 452547 452637 453585 454981 456239 460209 471330 478904 482813 483704 485338 486767 492181 505590 505599 506321 506516 506839 507284 508909 509422 511251 511343 512072 512935 514867 514876 515435 517724 519698 521814 523614 530420 531887 534550 534555 536475 538045 544140 545467 547236 547466 547468 547474 547488 547847 548443 550144 550938 554208 556876 556887 559787 561040 571809 572654 573204 574951 575418 575601 576899 576916 581477 584183 590289 590299 605133 605219 619109 625785 627146 627470 630732 634026 634076 634739 634900 641997 643213 643224 652758 656916 656933 660373 660412 664149 668688 669012 669038 669080 671052 672950 689074 704352 709693 735194 742353 761176 786911 794292 799782 824340 825514 825649 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск фистинг жен"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск фистинг жен"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade fisting wife"
]
|
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.