Query Metrics
7
Database Queries
7
Different statements
195.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.85 ms (87.25%) |
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 4229 175985 387379 388523 390954 391884 393188 398972 401427 417601 418621 419354 421639 423593 424072 424337 425248 426771 427267 436450 438621 441301 441742 443178 446419 448573 449076 449469 449490 449668 450061 450852 451334 452349 452356 453917 454570 455184 455887 455949 456310 457925 458083 458190 458819 464068 465068 465232 466393 468249 469068 469833 470033 470564 471052 471471 471987 472314 474768 475297 477129 478148 482573 487871 488260 488693 489765 491109 492091 492426 492640 493813 493823 497596 498378 500877 502999 503738 506306 510942 513835 514239 515976 516159 516458 517317 526169 538781 548477 550041 550045 550891 554852 560337 562708 564100 564652 568178 568213 585067 600213 620267 629407 631067 631649 646656 686410 692459 728993 744354 757225 758231 763444 771939 793115 793480 804094 824056 828436 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (7.21%) |
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 418621 419354 441301 417601 421639 424337 425248 585067 482573 449076 449469 449490 450061 452349 468249 488693 492426 446419 452356 457925 471987 450852 455887 455949 456310 477129 487871 489765 500877 516458 506306 526169 538781 502999 513835 469068 471471 488260 493823 560337 568213 548477 550891 554852 646656 550041 550045 564652 620267 631649 600213 793115 763444 771939 757225 629407 448573 453917 458190 387379 401427 464068 175985 388523 390954 436450 451334 465232 471052 424072 426771 427267 438621 449668 454570 441742 466393 470033 516159 497596 498378 491109 510942 517317 492091 514239 515976 568178 692459 793480 744354 728993 631067 804094 686410 4229 824056 826360 828436 455184 469833 470564 391884 474768 493813 458083 475297 503738 564100 562708 758231 393188 398972 423593 465068 472314 443178 458819 478148 492640 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.87%) |
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 4229 175985 387379 388523 390954 391884 393188 398972 401427 417601 418621 419354 421639 423593 424072 424337 425248 426771 427267 436450 438621 441301 441742 443178 446419 448573 449076 449469 449490 449668 450061 450852 451334 452349 452356 453917 454570 455184 455887 455949 456310 457925 458083 458190 458819 464068 465068 465232 466393 468249 469068 469833 470033 470564 471052 471471 471987 472314 474768 475297 477129 478148 482573 487871 488260 488693 489765 491109 492091 492426 492640 493813 493823 497596 498378 500877 502999 503738 506306 510942 513835 514239 515976 516159 516458 517317 526169 538781 548477 550041 550045 550891 554852 560337 562708 564100 564652 568178 568213 585067 600213 620267 629407 631067 631649 646656 686410 692459 728993 744354 757225 758231 763444 771939 793115 793480 804094 824056 828436 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam wife"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер жен"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.76%) |
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.