Query Metrics
7
Database Queries
7
Different statements
177.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.22 ms (83.72%) |
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 8064 12880 15190 32594 43207 83131 108094 154576 212138 224587 230925 233397 365907 381970 382445 382937 383588 383801 384350 384452 385706 387374 388425 393499 394029 394045 394116 396072 397166 398018 398451 399190 400050 402566 403411 407877 414139 416321 417155 418465 419558 420071 424231 424843 426736 428384 428810 434086 435937 436982 437837 442429 444728 445349 446766 447133 447815 449744 451622 453156 454353 454358 454491 454622 455129 456200 457255 458133 459405 459786 460160 460707 461096 461190 461476 461773 462923 465435 466871 467012 469563 469696 469813 470153 470246 471130 473977 476033 476967 477479 477638 479392 482616 483602 486808 487157 488109 488296 488926 491297 494911 495020 495321 496201 498898 507434 508727 509360 510354 510655 515703 515795 518556 520932 521376 522818 526480 547306 559388 573675 ] |
||||||||||||||||||||||||||||||
|
17.63 ms (9.96%) |
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 457255 488926 573675 428384 476033 451622 498898 521376 382445 83131 12880 388425 402566 428810 547306 8064 462923 473977 230925 233397 382937 407877 454358 477638 387374 43207 458133 469696 491297 495020 510354 424231 437837 383588 212138 108094 154576 224587 394029 381970 32594 396072 398451 442429 420071 436982 444728 434086 445349 446766 460707 454491 456200 459405 470153 477479 482616 483602 461096 466871 486808 515795 559388 455129 461476 465435 469813 384350 398018 399190 365907 384452 419558 15190 393499 397166 418465 426736 459786 461773 476967 488109 507434 510655 520932 526480 488296 515703 385706 394116 417155 416321 424843 494911 467012 447815 453156 454622 461190 470246 449744 495321 487157 508727 509360 518556 522818 383801 394045 400050 403411 414139 435937 471130 460160 479392 447133 454353 469563 496201 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.89%) |
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 8064 12880 15190 32594 43207 83131 108094 154576 212138 224587 230925 233397 365907 381970 382445 382937 383588 383801 384350 384452 385706 387374 388425 393499 394029 394045 394116 396072 397166 398018 398451 399190 400050 402566 403411 407877 414139 416321 417155 418465 419558 420071 424231 424843 426736 428384 428810 434086 435937 436982 437837 442429 444728 445349 446766 447133 447815 449744 451622 453156 454353 454358 454491 454622 455129 456200 457255 458133 459405 459786 460160 460707 461096 461190 461476 461773 462923 465435 466871 467012 469563 469696 469813 470153 470246 471130 473977 476033 476967 477479 477638 479392 482616 483602 486808 487157 488109 488296 488926 491297 494911 495020 495321 496201 498898 507434 508727 509360 510354 510655 515703 515795 518556 520932 521376 522818 526480 547306 559388 573675 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в темные"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в темных"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.05%) |
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.