Query Metrics
7
Database Queries
7
Different statements
127.46 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.54 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.66 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big strip"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.21 ms |
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 430396 469148 493427 568590 670706 710771 634711 602625 600799 782075 739961 763081 760698 385385 421420 461010 638688 806053 699358 523973 394214 553248 571446 701501 702838 701847 635856 806748 751001 410203 699059 464989 434032 484743 527408 696928 668701 607276 436447 504997 532213 669421 603248 757436 523967 585077 700799 391070 450291 487415 421325 558214 559807 390938 521977 504271 425500 519520 667864 511523 719909 430704 431126 715719 466149 469134 644849 487427 561607 706984 706676 423786 442196 510440 416288 419804 559081 495970 565065 555657 702430 559106 457945 465033 490608 702850 475202 594431 449925 594830 ] |
||||||||||||||||||||||||||||||
| 4 | 2.30 ms |
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 385385 390938 391070 394214 410203 416288 419804 421325 421420 423786 425500 430396 430704 431126 434032 436447 442196 449925 450291 457945 461010 464989 465033 466149 469134 469148 475202 484743 487415 487427 490608 493427 495970 504271 504997 510440 511523 519520 521977 523967 523973 527408 532213 553248 555657 558214 559081 559106 559807 561607 565065 568590 571446 585077 594431 594830 600799 602625 603248 607276 634711 635856 638688 644849 667864 668701 669421 670706 696928 699059 699358 700799 701501 701847 702430 702838 702850 706676 706984 710771 715719 719909 739961 751001 757436 760698 763081 782075 806053 806748 ] |
||||||||||||||||||||||||||||||
| 5 | 104.54 ms |
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 385385 390938 391070 394214 410203 416288 419804 421325 421420 423786 425500 430396 430704 431126 434032 436447 442196 449925 450291 457945 461010 464989 465033 466149 469134 469148 475202 484743 487415 487427 490608 493427 495970 504271 504997 510440 511523 519520 521977 523967 523973 527408 532213 553248 555657 558214 559081 559106 559807 561607 565065 568590 571446 585077 594431 594830 600799 602625 603248 607276 634711 635856 638688 644849 667864 668701 669421 670706 696928 699059 699358 700799 701501 701847 702430 702838 702850 706676 706984 710771 715719 719909 739961 751001 757436 760698 763081 782075 806053 806748 ] |
||||||||||||||||||||||||||||||
| 6 | 1.83 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие strip"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.37 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие strip"
]
|
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.