Query Metrics
7
Database Queries
7
Different statements
192.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.57 ms (83.81%) |
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 417662 419093 422272 422807 426183 428454 428457 428798 428807 432837 432852 433721 434219 435747 437322 437352 437361 437583 438219 440645 442372 442415 443553 444739 447581 448362 448458 449232 449858 450830 451013 451086 451713 452986 454048 456062 456736 458018 460154 460189 460192 460195 460283 460284 461601 466711 469952 472913 478107 479019 481874 481946 486023 495358 512531 513784 515047 516832 525270 525551 527158 531923 531979 532041 532064 533959 536331 539830 545908 546199 547993 549644 549661 551035 554387 555958 559008 562952 563924 567914 568539 575241 575289 578007 579371 582615 583201 585155 589607 601089 601234 602959 611327 611588 617195 621734 622665 628653 646469 670715 687137 687363 702306 709385 715270 736368 764151 777750 787829 791759 792310 803137 804071 806742 807402 807407 808416 810718 813268 827903 ] |
||||||||||||||||||||||||||||||
|
19.90 ms (10.32%) |
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 628653 804071 438219 432837 451086 479019 422807 448362 450830 460189 515047 531979 532064 525551 545908 547993 551035 575289 687137 601089 585155 702306 803137 810718 428454 512531 715270 495358 575241 617195 417662 428457 428807 419093 444739 433721 443553 426183 827903 454048 461601 469952 481946 536331 539830 555958 583201 549661 578007 670715 687363 568539 611588 736368 764151 611327 709385 787829 791759 806742 807402 813268 422272 440645 472913 437322 456062 456736 579371 559008 601234 602959 807407 478107 481874 437583 533959 486023 546199 589607 621734 532041 428798 432852 442372 434219 435747 437361 442415 437352 448458 449858 451713 452986 447581 449232 451013 458018 460154 460283 460284 513784 516832 525270 527158 531923 460192 460195 466711 549644 563924 567914 582615 646469 554387 562952 622665 777750 792310 808416 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.18%) |
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 417662 419093 422272 422807 426183 428454 428457 428798 428807 432837 432852 433721 434219 435747 437322 437352 437361 437583 438219 440645 442372 442415 443553 444739 447581 448362 448458 449232 449858 450830 451013 451086 451713 452986 454048 456062 456736 458018 460154 460189 460192 460195 460283 460284 461601 466711 469952 472913 478107 479019 481874 481946 486023 495358 512531 513784 515047 516832 525270 525551 527158 531923 531979 532041 532064 533959 536331 539830 545908 546199 547993 549644 549661 551035 554387 555958 559008 562952 563924 567914 568539 575241 575289 578007 579371 582615 583201 585155 589607 601089 601234 602959 611327 611588 617195 621734 622665 628653 646469 670715 687137 687363 702306 709385 715270 736368 764151 777750 787829 791759 792310 803137 804071 806742 807402 807407 808416 810718 813268 827903 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov step mom"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов step mom"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов step mom"
]
|
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.