Query Metrics
7
Database Queries
7
Different statements
355.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.00 ms (59.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short mature pussy"
]
|
||||||||||||||||||||||||||||||
|
120.07 ms (33.80%) |
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 181009 382549 383390 411421 419521 422353 422354 422360 424461 429552 443752 443833 446948 454017 454135 454231 454241 454256 454259 458281 460608 460618 460736 462694 462695 464129 465339 465829 465955 466127 466134 466164 466170 466216 466249 466836 466995 468173 469881 470199 470304 470307 472628 474402 474407 474408 474418 474795 476344 476619 477709 477716 477965 478793 479040 479050 479055 479095 479096 479141 480059 480301 483378 484421 484423 484441 484451 484459 484566 484582 484590 484643 484721 487314 487325 488378 489138 489207 489987 490513 490923 490927 491417 496057 497202 497206 499551 500458 502903 503565 505693 506055 506214 510353 511520 513833 516003 517989 518827 518829 518837 519150 519573 520860 520916 527016 527872 529512 544486 544493 570966 596334 605576 668641 728235 728452 748233 748389 801143 807990 ] |
||||||||||||||||||||||||||||||
|
17.26 ms (4.86%) |
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 728235 748233 801143 429552 462694 468173 469881 470199 477709 477965 454135 454259 466134 466164 466170 466216 466249 466995 470304 470307 474407 474795 479095 479141 383390 411421 422360 458281 460608 465339 465829 474402 474418 476344 476619 478793 419521 424461 454017 454231 479050 443752 466127 506055 510353 511520 518829 518837 529512 483378 484590 499551 519573 484423 484441 484451 489987 490923 497206 513833 516003 519150 484421 484582 487314 490927 496057 497202 520860 520916 527872 382549 443833 460618 464129 488378 491417 500458 502903 480301 544486 544493 668641 605576 728452 748389 807990 422354 462695 479096 465955 472628 460736 466836 479055 454256 477716 479040 505693 484566 484643 484721 506214 484459 487325 489138 518827 474408 503565 517989 570966 596334 446948 454241 527016 489207 490513 480059 422353 181009 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (0.81%) |
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 181009 382549 383390 411421 419521 422353 422354 422360 424461 429552 443752 443833 446948 454017 454135 454231 454241 454256 454259 458281 460608 460618 460736 462694 462695 464129 465339 465829 465955 466127 466134 466164 466170 466216 466249 466836 466995 468173 469881 470199 470304 470307 472628 474402 474407 474408 474418 474795 476344 476619 477709 477716 477965 478793 479040 479050 479055 479095 479096 479141 480059 480301 483378 484421 484423 484441 484451 484459 484566 484582 484590 484643 484721 487314 487325 488378 489138 489207 489987 490513 490923 490927 491417 496057 497202 497206 499551 500458 502903 503565 505693 506055 506214 510353 511520 513833 516003 517989 518827 518829 518837 519150 519573 520860 520916 527016 527872 529512 544486 544493 570966 596334 605576 668641 728235 728452 748233 748389 801143 807990 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short 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.