Query Metrics
7
Database Queries
7
Different statements
201.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.82 ms (84.16%) |
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 386156 413277 413929 417497 418720 418879 419063 419394 420418 426062 428570 435462 437084 437462 438178 438364 439151 439845 441017 444812 445314 445493 445745 447151 447608 448224 449470 450438 455017 457140 459130 460301 461804 463688 464193 469134 469604 470256 472114 476480 477180 477359 478057 478255 480326 482921 495421 495710 496802 497030 498012 498110 498209 499178 500781 504163 504303 506800 506823 507512 508541 509330 509663 510206 512931 514020 514999 516051 516599 517330 518462 518722 521244 523113 524680 525092 525441 525450 525854 527609 527978 529228 541060 551275 552273 552701 557976 557985 558563 558581 560016 560029 560664 564961 568655 572259 572334 580142 588041 589425 592005 594422 602186 603121 603488 609105 614446 620743 622773 628067 680484 720836 733579 743610 748684 765807 776544 784657 787075 810772 ] |
||||||||||||||||||||||||||||||
|
20.40 ms (10.11%) |
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 589425 588041 620743 628067 810772 765807 787075 733579 743610 614446 784657 463688 476480 420418 438364 444812 450438 459130 478255 386156 418720 419063 460301 461804 419394 449470 477180 469134 478057 512931 518722 521244 510206 524680 500781 504303 516599 523113 525092 482921 509663 527978 541060 560029 592005 437084 445314 447151 447608 455017 497030 498209 514020 558581 560016 564961 557976 558563 568655 580142 594422 602186 603121 776544 748684 417497 470256 413277 437462 439151 441017 448224 428570 472114 509330 514999 517330 495421 498012 506800 516051 557985 622773 438178 435462 518462 499178 498110 506823 525450 551275 560664 720836 552701 572259 445493 445745 457140 418879 426062 464193 527609 495710 504163 496802 680484 552273 439845 469604 508541 413929 529228 507512 525441 477359 525854 572334 603488 609105 480326 ] |
||||||||||||||||||||||||||||||
|
4.50 ms (2.23%) |
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 386156 413277 413929 417497 418720 418879 419063 419394 420418 426062 428570 435462 437084 437462 438178 438364 439151 439845 441017 444812 445314 445493 445745 447151 447608 448224 449470 450438 455017 457140 459130 460301 461804 463688 464193 469134 469604 470256 472114 476480 477180 477359 478057 478255 480326 482921 495421 495710 496802 497030 498012 498110 498209 499178 500781 504163 504303 506800 506823 507512 508541 509330 509663 510206 512931 514020 514999 516051 516599 517330 518462 518722 521244 523113 524680 525092 525441 525450 525854 527609 527978 529228 541060 551275 552273 552701 557976 557985 558563 558581 560016 560029 560664 564961 568655 572259 572334 580142 588041 589425 592005 594422 602186 603121 603488 609105 614446 620743 622773 628067 680484 720836 733579 743610 748684 765807 776544 784657 787075 810772 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe webcam"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe вебкамер"
]
|
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.