Query Metrics
7
Database Queries
7
Different statements
148.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.22 ms (79.63%) |
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 394258 395699 397916 398394 400191 403959 421841 421850 421852 421865 421900 422158 422166 422168 422211 422282 424276 424903 426015 426766 426865 428136 428556 433341 433380 434251 437314 437582 438429 439670 439695 442469 443181 443722 443942 445393 446284 448024 448958 449717 453260 454029 454048 454411 455298 456058 460177 460679 461364 461374 461727 462110 463691 464446 464556 468884 469549 470207 472176 472656 473483 474498 475924 476269 486896 488118 489380 492079 492366 493155 493167 493181 493193 493521 496292 498491 504104 506127 508701 509042 513145 516226 516478 516712 516886 519929 520204 520811 521134 521759 523837 523844 526523 527158 528708 532044 537116 544420 550643 550644 554897 562517 563453 566013 584765 587915 600965 660023 661991 663929 699596 710588 733287 743811 797632 812885 823803 826592 ] |
||||||||||||||||||||||||||||||
|
19.32 ms (13.02%) |
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 516478 516712 520204 516886 523837 475924 544420 600965 400191 439670 421841 422211 433380 461364 421865 422166 454411 489380 493155 523844 493193 498491 528708 516226 445393 426865 526523 699596 448958 456058 797632 403959 537116 660023 395699 428556 453260 455298 461374 464446 464556 486896 460177 527158 462110 562517 554897 663929 710588 743811 394258 472176 474498 397916 472656 492079 463691 566013 449717 509042 493181 493167 521134 422158 398394 422282 438429 443942 424903 426015 434251 442469 448024 506127 527201 532044 461727 492366 584765 676582 587915 812885 488118 520811 521759 823803 454048 550644 446284 508701 493521 421850 426766 421852 421900 439695 443722 513145 661991 733287 443181 826592 460679 473483 550643 469549 424276 437582 496292 433341 504104 563453 454029 422168 428136 437314 470207 476269 468884 519929 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.21%) |
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 394258 395699 397916 398394 400191 403959 421841 421850 421852 421865 421900 422158 422166 422168 422211 422282 424276 424903 426015 426766 426865 428136 428556 433341 433380 434251 437314 437582 438429 439670 439695 442469 443181 443722 443942 445393 446284 448024 448958 449717 453260 454029 454048 454411 455298 456058 460177 460679 461364 461374 461727 462110 463691 464446 464556 468884 469549 470207 472176 472656 473483 474498 475924 476269 486896 488118 489380 492079 492366 493155 493167 493181 493193 493521 496292 498491 504104 506127 508701 509042 513145 516226 516478 516712 516886 519929 520204 520811 521134 521759 523837 523844 526523 527158 528708 532044 537116 544420 550643 550644 554897 562517 563453 566013 584765 587915 600965 660023 661991 663929 699596 710588 733287 743811 797632 812885 823803 826592 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son ass"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son жоп"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son жоп"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.