Query Metrics
7
Database Queries
7
Different statements
200.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.84 ms (84.35%) |
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 416878 426805 429847 431954 432510 432559 433220 433572 433792 433829 434252 434261 435064 435346 437658 437996 444184 446577 447054 448074 448213 449122 450339 452180 452592 453434 453801 455447 455653 455660 455719 456300 457630 458231 461391 462250 463935 464694 465162 468910 470997 473898 476013 476208 479558 479632 483172 489627 490079 495088 495937 496379 498238 498984 500226 502257 502988 503216 505081 505233 507685 507785 509811 509819 511496 512738 514008 514624 514778 514781 516425 516427 517599 518609 519510 519668 520395 520587 521998 523786 524789 525591 526092 527169 528550 538340 547557 552367 552460 554253 555851 555971 557027 558863 560002 560868 560879 561948 564658 565188 567181 567185 567194 569097 575272 583112 584197 587853 590174 596642 599421 599531 601364 619935 620644 695719 696128 720922 766141 813127 ] |
||||||||||||||||||||||||||||||
|
21.05 ms (10.52%) |
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 525591 528550 555851 557027 564658 555971 561948 565188 567181 567194 560002 567185 695719 696128 552460 583112 584197 599421 619935 596642 813127 720922 433572 479632 433220 433829 434261 446577 453801 458231 463935 473898 476208 431954 432559 435064 435346 444184 464694 479558 416878 434252 437996 452180 452592 456300 470997 447054 455653 465162 476013 500226 509819 512738 516425 516427 517599 518609 523786 527169 483172 489627 502988 505233 514778 526092 538340 490079 495088 496379 502257 505081 507685 511496 514008 524789 498238 498984 503216 509811 514624 514781 519510 519668 520395 520587 521998 547557 569097 620644 432510 455660 437658 457630 450339 455719 507785 461391 433792 455447 495937 554253 558863 560868 575272 560879 552367 590174 601364 587853 599531 766141 429847 448074 448213 449122 453434 426805 462250 468910 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.38%) |
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 416878 426805 429847 431954 432510 432559 433220 433572 433792 433829 434252 434261 435064 435346 437658 437996 444184 446577 447054 448074 448213 449122 450339 452180 452592 453434 453801 455447 455653 455660 455719 456300 457630 458231 461391 462250 463935 464694 465162 468910 470997 473898 476013 476208 479558 479632 483172 489627 490079 495088 495937 496379 498238 498984 500226 502257 502988 503216 505081 505233 507685 507785 509811 509819 511496 512738 514008 514624 514778 514781 516425 516427 517599 518609 519510 519668 520395 520587 521998 523786 524789 525591 526092 527169 528550 538340 547557 552367 552460 554253 555851 555971 557027 558863 560002 560868 560879 561948 564658 565188 567181 567185 567194 569097 575272 583112 584197 587853 590174 596642 599421 599531 601364 619935 620644 695719 696128 720922 766141 813127 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sister"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sister"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sister"
]
|
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.