Query Metrics
7
Database Queries
7
Different statements
174.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.99 ms (84.74%) |
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 75936 188079 334950 383659 383665 383780 387198 388098 390582 390941 391075 392756 393087 394446 396954 396971 397227 402419 408197 411236 411742 411942 450762 451488 452240 452248 454241 455579 457991 464278 465390 465570 465949 466229 474398 480290 487351 493098 498626 513144 522343 525269 527016 527570 544506 554390 555436 555788 564169 570966 585214 592973 593531 603612 604251 617377 624366 660688 664825 665508 667314 678959 681075 685864 690760 690761 702362 703438 707251 707418 710605 715551 720004 720455 721461 721470 726537 726713 727757 733109 733132 734709 744216 745929 759477 760619 770112 779341 779593 781667 784307 788152 799631 800712 802723 804418 808691 809701 810151 815196 815529 817070 817313 817360 817406 817957 818955 819012 819027 819030 819508 820688 820772 823611 824022 824152 824459 825155 826759 827198 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (9.48%) |
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 522343 487351 493098 685864 554390 808691 726537 784307 411942 392756 498626 452248 334950 820772 815196 450762 570966 592973 593531 604251 760619 802723 726713 455579 454241 527016 457991 390582 451488 465390 465949 480290 466229 75936 819030 820688 819012 819027 823611 826759 827198 817406 817360 818955 555436 564169 690760 690761 703438 707251 585214 617377 809701 810151 804418 727757 734709 781667 788152 799631 744216 733109 733132 779593 387198 402419 819508 824152 825155 465570 525269 702362 681075 720004 720455 555788 624366 800712 745929 759477 770112 715551 779341 383659 603612 383665 383780 188079 394446 393087 388098 391075 390941 396954 396971 397227 408197 411236 411742 817070 817957 815529 824022 817313 824459 452240 464278 513144 527570 474398 544506 721461 665508 667314 678959 707418 710605 721470 660688 664825 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.73%) |
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 75936 188079 334950 383659 383665 383780 387198 388098 390582 390941 391075 392756 393087 394446 396954 396971 397227 402419 408197 411236 411742 411942 450762 451488 452240 452248 454241 455579 457991 464278 465390 465570 465949 466229 474398 480290 487351 493098 498626 513144 522343 525269 527016 527570 544506 554390 555436 555788 564169 570966 585214 592973 593531 603612 604251 617377 624366 660688 664825 665508 667314 678959 681075 685864 690760 690761 702362 703438 707251 707418 710605 715551 720004 720455 721461 721470 726537 726713 727757 733109 733132 734709 744216 745929 759477 760619 770112 779341 779593 781667 784307 788152 799631 800712 802723 804418 808691 809701 810151 815196 815529 817070 817313 817360 817406 817957 818955 819012 819027 819030 819508 820688 820772 823611 824022 824152 824459 825155 826759 827198 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature licking pussy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature лиза pussy"
]
|
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.