Query Metrics
7
Database Queries
7
Different statements
158.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.77 ms (83.24%) |
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 83037 401413 471904 486143 487788 497126 500956 506626 529393 529831 530239 531371 531737 535995 538286 538474 544839 544882 546147 550551 551555 559416 572353 572360 575388 575418 575629 576167 576931 584517 585544 603746 605142 605795 621502 626818 634975 642666 643213 645543 646289 650323 668658 670146 690022 696525 699499 701013 712726 715288 720345 722372 725421 726452 730300 730588 738249 739096 740334 742333 744125 748268 748313 749049 751436 753604 754518 754640 759061 767438 768430 771468 773172 774055 774056 774096 774783 788238 788475 790478 792989 793125 794575 795716 796337 800281 802372 803018 803510 803733 804240 805065 810486 811784 812032 812219 812242 812303 812482 813410 817187 819254 820161 820739 821034 821343 824322 824327 824655 824776 824858 824876 824879 825084 827227 827293 827335 827529 827580 828836 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (10.26%) |
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 803018 803510 805065 811784 812032 812242 83037 401413 821343 824876 824879 827227 827293 827580 827335 827529 817187 819254 820739 824322 824858 820161 821034 824327 824655 824776 825084 828836 486143 487788 531737 506626 530239 535995 538286 529831 531371 471904 559416 572353 575629 544882 546147 550551 650323 670146 699499 701013 712726 715288 645543 690022 720345 646289 668658 696525 722372 544839 551555 626818 634975 585544 603746 643213 605142 621502 642666 793125 800281 802372 810486 812482 774783 792989 795716 803733 804240 812303 813410 730300 730588 740334 754518 759061 771468 774055 774096 788475 796337 725421 748313 742333 753604 774056 738249 739096 744125 748268 751436 754640 768430 773172 726452 749049 767438 788238 790478 794575 812219 500956 529393 497126 538474 572360 575388 575418 576931 584517 576167 605795 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.96%) |
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 83037 401413 471904 486143 487788 497126 500956 506626 529393 529831 530239 531371 531737 535995 538286 538474 544839 544882 546147 550551 551555 559416 572353 572360 575388 575418 575629 576167 576931 584517 585544 603746 605142 605795 621502 626818 634975 642666 643213 645543 646289 650323 668658 670146 690022 696525 699499 701013 712726 715288 720345 722372 725421 726452 730300 730588 738249 739096 740334 742333 744125 748268 748313 749049 751436 753604 754518 754640 759061 767438 768430 771468 773172 774055 774056 774096 774783 788238 788475 790478 792989 793125 794575 795716 796337 800281 802372 803018 803510 803733 804240 805065 810486 811784 812032 812219 812242 812303 812482 813410 817187 819254 820161 820739 821034 821343 824322 824327 824655 824776 824858 824876 824879 825084 827227 827293 827335 827529 827580 828836 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женские письки"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женск вагин"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
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.