Query Metrics
7
Database Queries
7
Different statements
179.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.73 ms (84.88%) |
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 13646 72822 96200 213573 326289 382304 382591 384803 385225 385314 385343 386033 387951 388436 388782 389511 389945 395460 397232 401108 401768 404587 407313 408175 408472 412991 413304 415030 415977 418840 418864 428624 440087 440274 441848 443164 444124 452271 452832 454171 454529 458927 467935 468339 469046 469375 472857 478261 490106 492222 493088 493838 499927 508560 509063 510480 534991 543846 544751 548162 550366 560077 560920 560993 567126 569225 576626 578478 585968 601043 604430 605033 607464 621310 621315 628104 632087 644453 658819 670364 690875 694532 698409 698531 699578 703556 707318 714752 716129 720122 737522 737578 739558 744389 752639 752656 772039 785934 788178 789659 791580 795136 795142 799290 801896 802493 802519 802828 802925 803327 803919 805925 810830 813945 814288 814910 815074 815388 815798 819151 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (9.55%) |
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 607464 601043 621315 801896 795136 385225 469046 550366 560993 544751 567126 716129 397232 499927 548162 543846 569225 670364 690875 658819 585968 803919 739558 752639 752656 605033 644453 698409 802925 13646 386033 96200 388782 389511 412991 440274 415977 428624 418864 452832 454171 458927 478261 720122 407313 467935 492222 493838 490106 714752 604430 385314 213573 382304 382591 388436 404587 441848 468339 508560 326289 72822 510480 788178 401108 387951 385343 408472 443164 560077 454529 509063 578478 418840 534991 632087 791580 389945 813945 815798 814288 814910 815388 819151 815074 472857 707318 698531 694532 699578 703556 560920 576626 628104 621310 789659 799290 802828 802519 803327 744389 795142 737522 737578 772039 802493 805925 395460 401768 415030 440087 408175 444124 452271 384803 493088 413304 469375 785934 810830 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.59%) |
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 13646 72822 96200 213573 326289 382304 382591 384803 385225 385314 385343 386033 387951 388436 388782 389511 389945 395460 397232 401108 401768 404587 407313 408175 408472 412991 413304 415030 415977 418840 418864 428624 440087 440274 441848 443164 444124 452271 452832 454171 454529 458927 467935 468339 469046 469375 472857 478261 490106 492222 493088 493838 499927 508560 509063 510480 534991 543846 544751 548162 550366 560077 560920 560993 567126 569225 576626 578478 585968 601043 604430 605033 607464 621310 621315 628104 632087 644453 658819 670364 690875 694532 698409 698531 699578 703556 707318 714752 716129 720122 737522 737578 739558 744389 752639 752656 772039 785934 788178 789659 791580 795136 795142 799290 801896 802493 802519 802828 802925 803327 803919 805925 810830 813945 814288 814910 815074 815388 815798 819151 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mother"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.