Query Metrics
7
Database Queries
7
Different statements
188.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.06 ms (85.24%) |
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 95742 96347 97688 196316 322815 341753 359918 382051 384373 385197 391184 396504 400935 401704 401728 402885 404468 412183 416099 417877 418354 426390 428391 443457 443532 447143 448855 451548 457493 462788 463271 471323 480292 482148 486161 486481 491381 491387 499894 511384 515236 516768 516818 517638 521943 523947 523951 530799 531700 538583 543260 543595 543886 562334 565416 565450 565487 573230 575338 582134 586372 590173 592385 593842 600269 601536 603607 603688 604567 606745 607091 607892 616343 616353 621651 633138 634474 634789 640686 649136 649137 650827 651039 651068 651276 653869 654600 662548 662562 692050 699053 702075 704189 712886 716868 720112 720241 721830 728440 732323 732357 741196 744597 744620 744624 744647 746980 750466 755759 759464 772804 784184 785291 785357 806113 809459 814822 815304 815608 827874 ] |
||||||||||||||||||||||||||||||
|
17.47 ms (9.24%) |
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 416099 95742 97688 382051 96347 417877 418354 814822 457493 499894 515236 538583 543260 565450 649136 653869 712886 651276 716868 604567 590173 593842 600269 607091 616343 744597 744620 732323 744624 601536 401704 443532 447143 396504 480292 402885 827874 384373 391184 443457 412183 815608 486161 516768 530799 531700 462788 543595 543886 573230 702075 692050 720112 721830 662562 582134 603607 621651 633138 634474 592385 603688 606745 809459 744647 784184 785357 482148 401728 491381 516818 196316 359918 341753 400935 815304 448855 471323 565487 662548 649137 651039 651068 704189 586372 616353 806113 772804 741196 746980 732357 750466 634789 720241 428391 463271 521943 491387 523951 404468 486481 511384 517638 562334 565416 654600 699053 575338 640686 607892 785291 755759 759464 728440 385197 451548 523947 650827 322815 426390 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.41%) |
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 95742 96347 97688 196316 322815 341753 359918 382051 384373 385197 391184 396504 400935 401704 401728 402885 404468 412183 416099 417877 418354 426390 428391 443457 443532 447143 448855 451548 457493 462788 463271 471323 480292 482148 486161 486481 491381 491387 499894 511384 515236 516768 516818 517638 521943 523947 523951 530799 531700 538583 543260 543595 543886 562334 565416 565450 565487 573230 575338 582134 586372 590173 592385 593842 600269 601536 603607 603688 604567 606745 607091 607892 616343 616353 621651 633138 634474 634789 640686 649136 649137 650827 651039 651068 651276 653869 654600 662548 662562 692050 699053 702075 704189 712886 716868 720112 720241 721830 728440 732323 732357 741196 744597 744620 744624 744647 746980 750466 755759 759464 772804 784184 785291 785357 806113 809459 814822 815304 815608 827874 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome bbc"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро bbc"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро bbc"
]
|
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.