Query Metrics
7
Database Queries
7
Different statements
165.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.78 ms (83.68%) |
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 233733 389973 391208 391692 401935 407429 407797 407878 408262 409084 411547 411684 411700 413074 416871 418853 419145 419220 420178 421516 428238 437797 439682 443748 444775 447837 451520 453123 454043 454248 458615 460188 460191 460626 460738 463803 464135 464308 464601 464969 467084 468072 469442 472153 472438 473341 474859 475051 475631 476241 478832 479114 485457 486537 486688 487343 487927 487931 487933 487946 489423 490517 490520 491986 493221 493222 494755 496554 505671 512215 512217 513837 518238 519942 522342 523076 523765 526213 528100 529524 531538 544306 544490 545325 545844 552938 555374 555445 556511 559139 560130 561529 574385 576636 576693 576991 579909 585050 600859 603590 604896 607737 610029 610075 614258 662129 662898 663503 673142 738528 770111 792529 800906 801471 805439 808484 815699 815869 816935 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (10.18%) |
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 808484 529524 505671 490517 490520 801471 416871 407429 816935 523076 494755 523765 467084 555445 559139 561529 574385 545325 544306 556511 560130 662129 673142 579909 604896 610075 610029 770111 738528 603590 800906 419220 233733 413074 486688 663503 479114 439682 451520 454248 487933 491986 493222 468072 493221 487343 458615 411547 407797 614258 408262 389973 407878 411684 421516 409084 418853 815699 815869 453123 473341 487931 464601 487927 447837 454043 460626 476241 475051 485457 486537 489423 555374 600859 792529 460188 460191 411700 464135 472438 472153 391692 662898 496554 478832 519942 437797 585050 469442 464308 474859 531538 545844 714349 552938 576991 805439 607737 443748 475631 401935 419145 420178 518238 460738 391208 428238 444775 463803 464969 487946 526213 513837 522342 528100 512215 512217 576636 576693 544490 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.65%) |
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 233733 389973 391208 391692 401935 407429 407797 407878 408262 409084 411547 411684 411700 413074 416871 418853 419145 419220 420178 421516 428238 437797 439682 443748 444775 447837 451520 453123 454043 454248 458615 460188 460191 460626 460738 463803 464135 464308 464601 464969 467084 468072 469442 472153 472438 473341 474859 475051 475631 476241 478832 479114 485457 486537 486688 487343 487927 487931 487933 487946 489423 490517 490520 491986 493221 493222 494755 496554 505671 512215 512217 513837 518238 519942 522342 523076 523765 526213 528100 529524 531538 544306 544490 545325 545844 552938 555374 555445 556511 559139 560130 561529 574385 576636 576693 576991 579909 585050 600859 603590 604896 607737 610029 610075 614258 662129 662898 663503 673142 738528 770111 792529 800906 801471 805439 808484 815699 815869 816935 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy mature fucked"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая mature fucked"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая mature fucked"
]
|
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.