Query Metrics
7
Database Queries
7
Different statements
156.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.60 ms (82.11%) |
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 31503 53553 96521 96997 182749 309449 341622 383641 387251 390024 390680 391275 393326 393677 395674 395727 397232 397306 398908 401184 409828 410941 411014 411681 417881 419064 420190 420559 423657 426032 426197 429763 429799 440654 443218 443243 452843 461086 509805 509808 510395 515833 515892 517847 522130 523312 524183 527412 530039 530054 530788 530798 531239 531260 531261 531836 531840 531849 531861 532653 532792 532804 532948 533064 533371 533382 533556 533949 534028 534551 535358 535644 536288 536290 536339 536616 536681 537675 537913 538817 540291 542975 565243 583711 583921 599852 617410 629333 631162 632601 633521 634122 636288 637008 639784 642000 647939 649497 649579 650175 665973 676022 676092 677307 678073 713113 717849 721711 740269 748530 748926 756219 759948 794557 801275 801923 808327 827874 827899 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (10.77%) |
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 509805 509808 583921 398908 401184 96521 524183 533064 631162 637008 794557 756219 748926 717849 721711 31503 759948 390024 397306 419064 523312 96997 409828 411014 440654 533949 565243 649497 429799 533371 536616 534551 665973 676022 632601 393326 531840 531861 713113 740269 393677 420559 534028 531836 531849 443218 530039 531260 536290 536681 540291 522130 532792 533556 535358 531261 532948 536288 537913 530788 532653 542975 649579 678073 629333 642000 599852 634122 801923 633521 341622 397232 417881 827874 827899 182749 53553 387251 533382 517847 647939 639784 391275 426032 443243 429763 410941 452843 531239 532804 530054 530798 538817 636288 807580 808327 748530 309449 383641 395727 515833 677307 801275 537675 617410 583711 390680 420190 426197 423657 536339 515892 535644 650175 676092 395674 411681 461086 510395 527412 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (2.15%) |
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 31503 53553 96521 96997 182749 309449 341622 383641 387251 390024 390680 391275 393326 393677 395674 395727 397232 397306 398908 401184 409828 410941 411014 411681 417881 419064 420190 420559 423657 426032 426197 429763 429799 440654 443218 443243 452843 461086 509805 509808 510395 515833 515892 517847 522130 523312 524183 527412 530039 530054 530788 530798 531239 531260 531261 531836 531840 531849 531861 532653 532792 532804 532948 533064 533371 533382 533556 533949 534028 534551 535358 535644 536288 536290 536339 536616 536681 537675 537913 538817 540291 542975 565243 583711 583921 599852 617410 629333 631162 632601 633521 634122 636288 637008 639784 642000 647939 649497 649579 650175 665973 676022 676092 677307 678073 713113 717849 721711 740269 748530 748926 756219 759948 794557 801275 801923 808327 827874 827899 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme double anal"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор double анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор double анал"
]
|
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.