Query Metrics
7
Database Queries
7
Different statements
161.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.36 ms (87.47%) |
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 391296 398385 457600 478103 478621 493681 495059 500086 510056 529337 530464 533793 535617 535856 536066 536429 536623 540565 542865 542986 543555 544262 544878 545175 546486 552816 555473 562465 564294 566379 566396 566767 583546 584247 592282 600499 603291 603680 618124 621622 630680 637497 651753 656841 658434 663516 669262 670754 671905 681747 685118 702355 702359 707383 710220 713425 715587 722298 724570 727655 730962 732123 732224 732865 732931 733057 734153 734177 744480 744764 745784 747197 748469 748477 759698 760394 760851 761001 763426 769524 774064 780371 787247 788010 788653 794172 794562 795196 795476 795861 796781 796784 798723 801381 801567 802159 804942 808243 816177 824129 824615 827687 828074 828106 828122 828142 828181 828255 828296 828351 828374 828444 828555 828614 828659 828665 828687 828739 828832 ] |
||||||||||||||||||||||||||||||
|
10.80 ms (6.68%) |
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 828832 828106 828374 828739 828074 828296 828122 828142 828181 828351 824129 828255 827687 828659 828665 828687 828614 828444 478621 478103 535617 536623 535856 510056 530464 536066 500086 544262 546486 552816 555473 583546 566379 542865 566396 651753 670754 671905 681747 722298 710220 656841 658434 669262 685118 713425 715587 592282 600499 603291 637497 621622 603680 618124 630680 780371 788010 795476 798723 801567 788653 794562 795196 802159 744764 748477 761367 787247 794172 795861 796781 804942 808243 727655 730962 732931 734153 745784 759698 760851 761001 724570 733057 747197 769524 734177 760394 763426 774064 732224 732865 744480 748469 702355 702359 796784 536429 663516 707383 584247 391296 732123 801381 457600 543555 398385 816177 824615 828555 493681 529337 533793 540565 495059 542986 562465 566767 544878 545175 564294 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.87%) |
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 391296 398385 457600 478103 478621 493681 495059 500086 510056 529337 530464 533793 535617 535856 536066 536429 536623 540565 542865 542986 543555 544262 544878 545175 546486 552816 555473 562465 564294 566379 566396 566767 583546 584247 592282 600499 603291 603680 618124 621622 630680 637497 651753 656841 658434 663516 669262 670754 671905 681747 685118 702355 702359 707383 710220 713425 715587 722298 724570 727655 730962 732123 732224 732865 732931 733057 734153 734177 744480 744764 745784 747197 748469 748477 759698 760394 760851 761001 763426 769524 774064 780371 787247 788010 788653 794172 794562 795196 795476 795861 796781 796784 798723 801381 801567 802159 804942 808243 816177 824129 824615 827687 828074 828106 828122 828142 828181 828255 828296 828351 828374 828444 828555 828614 828659 828665 828687 828739 828832 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женя мамки"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.85%) |
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.