Query Metrics
7
Database Queries
7
Different statements
176.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.47 ms (86.59%) |
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 14105 153376 188450 189022 393734 396043 401240 401845 402112 403292 404261 405129 406281 411223 415988 432700 432746 434863 435926 438952 445775 445802 446524 447235 447342 448721 450803 450992 452224 457471 460385 464035 464112 465302 472907 476650 477487 477516 482776 530311 534014 547288 549818 564734 576004 584193 586421 589993 593277 607948 613498 619134 623311 644206 646152 647891 658826 660422 668944 710031 720942 721707 721714 728046 737643 742051 742057 742485 742497 750366 752496 756680 757654 759558 759749 760092 760673 762283 763916 767202 770508 773576 776137 779116 785379 788151 792534 794158 795229 795764 795925 796596 797143 800817 800899 804797 806111 806153 808104 810307 812835 815991 816612 817072 817215 817358 817549 817836 818269 818451 819291 819398 823373 824176 824669 825662 826605 827588 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (7.69%) |
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 448721 547288 742485 763916 817358 623311 776137 750366 760092 403292 721714 549818 607948 795764 800899 737643 795229 797143 742051 728046 757654 759749 770508 760673 796596 613498 534014 153376 406281 405129 411223 815991 817549 817836 827588 476650 668944 742057 752496 773576 393734 401845 188450 817072 819291 824669 822803 823373 824176 825662 826605 530311 710031 785379 794158 795925 762283 759558 804797 808104 756680 646152 445802 767202 806111 445775 465302 402112 435926 434863 452224 464035 586421 644206 189022 438952 477516 415988 450992 14105 647891 660422 816612 792534 812835 742497 774503 800817 810307 482776 818451 788151 404261 457471 576004 564734 432700 446524 447342 472907 779116 720942 464112 477487 721707 593277 806153 401240 447235 450803 589993 619134 432746 460385 584193 658826 396043 818269 819398 817215 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.65%) |
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 14105 153376 188450 189022 393734 396043 401240 401845 402112 403292 404261 405129 406281 411223 415988 432700 432746 434863 435926 438952 445775 445802 446524 447235 447342 448721 450803 450992 452224 457471 460385 464035 464112 465302 472907 476650 477487 477516 482776 530311 534014 547288 549818 564734 576004 584193 586421 589993 593277 607948 613498 619134 623311 644206 646152 647891 658826 660422 668944 710031 720942 721707 721714 728046 737643 742051 742057 742485 742497 750366 752496 756680 757654 759558 759749 760092 760673 762283 763916 767202 770508 773576 776137 779116 785379 788151 792534 794158 795229 795764 795925 796596 797143 800817 800899 804797 806111 806153 808104 810307 812835 815991 816612 817072 817215 817358 817549 817836 818269 818451 819291 819398 823373 824176 824669 825662 826605 827588 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina big ass"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.88%) |
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.