Query Metrics
7
Database Queries
7
Different statements
162.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.41 ms (82.09%) |
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 187819 305931 310679 383785 385752 390738 395679 397008 400138 402419 405191 407288 407424 407458 408179 409061 411621 415847 424461 442407 443184 443727 453159 454259 454446 460040 460262 460908 461963 462021 462105 462694 463837 464418 464942 465395 466007 466171 466263 467036 468154 468630 468941 469338 469774 470560 471056 472595 474085 474795 475858 476282 476342 476344 477936 480834 482303 482527 484467 485745 490038 493098 493163 496999 503047 505671 506801 511356 513123 513434 517446 518836 518856 519260 522592 522863 522918 522923 526010 527624 534334 538888 541614 544502 546993 549233 555201 555286 555394 559058 563155 565097 573763 578701 581348 591792 603243 605147 636249 663895 681075 691518 714309 716784 722212 728352 733416 748253 770112 770199 784249 784307 796831 800712 801029 801883 812377 815943 816545 824791 ] |
||||||||||||||||||||||||||||||
|
18.89 ms (11.62%) |
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 534334 463837 546993 591792 468941 469338 385752 305931 310679 402419 411621 816545 815943 464418 517446 519260 538888 475858 490038 565097 555201 555286 691518 722212 681075 716784 605147 800712 801029 812377 728352 770112 733416 784249 801883 477936 187819 461963 522592 460040 493163 383785 415847 482303 485745 518856 511356 464942 578701 407288 474085 462021 522923 405191 496999 544502 527624 468630 482527 506801 549233 541614 466007 469774 505671 484467 453159 467036 395679 390738 407424 408179 409061 442407 824791 454446 471056 472595 462105 470560 493098 513434 522918 503047 513123 518836 522863 526010 460262 468154 476282 480834 555394 563155 573763 663895 714309 559058 581348 636249 603243 796831 770199 748253 784307 407458 443727 462694 400138 454259 460908 466171 466263 474795 476342 476344 397008 424461 443184 465395 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.70%) |
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 187819 305931 310679 383785 385752 390738 395679 397008 400138 402419 405191 407288 407424 407458 408179 409061 411621 415847 424461 442407 443184 443727 453159 454259 454446 460040 460262 460908 461963 462021 462105 462694 463837 464418 464942 465395 466007 466171 466263 467036 468154 468630 468941 469338 469774 470560 471056 472595 474085 474795 475858 476282 476342 476344 477936 480834 482303 482527 484467 485745 490038 493098 493163 496999 503047 505671 506801 511356 513123 513434 517446 518836 518856 519260 522592 522863 522918 522923 526010 527624 534334 538888 541614 544502 546993 549233 555201 555286 555394 559058 563155 565097 573763 578701 581348 591792 603243 605147 636249 663895 681075 691518 714309 716784 722212 728352 733416 748253 770112 770199 784249 784307 796831 800712 801029 801883 812377 815943 816545 824791 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза волосатая mature"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick hairy mature"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза волосатая mature"
]
|
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.