Query Metrics
7
Database Queries
7
Different statements
138.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.55 ms (82.51%) |
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 34087 118008 126104 268633 339474 406978 408659 411074 411945 411953 418125 421887 429804 435559 439691 440867 441666 442618 442985 443209 443246 443378 445065 446275 448819 449225 452772 453449 455025 455119 455834 457289 457457 457596 457888 459158 460130 461601 464111 467912 468661 468948 469167 470694 470966 471850 473542 474681 476288 482739 483754 485442 486917 490923 493543 495881 505725 509427 513582 513844 515051 519358 520204 528564 529396 531036 539323 539503 546106 551529 554525 563544 564263 570931 570948 572630 574756 582014 583532 583534 587990 589590 608685 609551 610126 617956 618550 635208 673499 707475 721500 721900 732758 733412 734823 745021 745998 751581 759725 763740 768603 790430 790436 790997 796641 801251 802727 804350 804407 804927 807877 810297 812472 812528 818690 819028 824000 824103 824990 827699 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (10.27%) |
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 411945 408659 445065 406978 443209 448819 453449 455025 574756 564263 804927 810297 469167 457289 418125 421887 452772 519358 520204 490923 483754 118008 440867 411953 493543 460130 482739 528564 467912 443378 505725 509427 441666 459158 461601 471850 455834 495881 721500 442618 442985 455119 470966 486917 515051 485442 429804 468661 457888 513844 476288 563544 589590 443246 439691 457457 474681 126104 268633 339474 34087 824103 819028 818690 824000 824990 827699 449225 457596 531036 582014 570931 673499 707475 608685 618550 635208 587990 610126 812472 790430 796641 804350 733412 802727 759725 732758 745998 721900 790436 790997 804407 807877 812528 470694 446275 464111 546106 411074 435559 473542 468948 529396 539503 539323 513582 551529 583534 570948 554525 572630 583532 617956 609551 801251 734823 745021 763740 768603 751581 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.83%) |
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 34087 118008 126104 268633 339474 406978 408659 411074 411945 411953 418125 421887 429804 435559 439691 440867 441666 442618 442985 443209 443246 443378 445065 446275 448819 449225 452772 453449 455025 455119 455834 457289 457457 457596 457888 459158 460130 461601 464111 467912 468661 468948 469167 470694 470966 471850 473542 474681 476288 482739 483754 485442 486917 490923 493543 495881 505725 509427 513582 513844 515051 519358 520204 528564 529396 531036 539323 539503 546106 551529 554525 563544 564263 570931 570948 572630 574756 582014 583532 583534 587990 589590 608685 609551 610126 617956 618550 635208 673499 707475 721500 721900 732758 733412 734823 745021 745998 751581 759725 763740 768603 790430 790436 790997 796641 801251 802727 804350 804407 804927 807877 810297 812472 812528 818690 819028 824000 824103 824990 827699 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother naked"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин голые"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.23%) |
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.