Query Metrics
7
Database Queries
7
Different statements
215.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.81 ms (84.23%) |
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 150336 194687 271234 385359 385928 388078 393330 400696 410791 411257 411757 419739 419998 420718 422357 423837 424011 424483 427192 432181 435378 437758 437761 439920 441420 441595 443248 443874 444001 447068 448214 452683 453480 453514 455913 456741 457580 458253 458755 459087 459503 461443 461553 462050 462284 462597 466880 467549 468179 468399 469277 469757 472400 472609 473284 478721 483528 484403 494106 495529 497201 502350 503943 504206 506185 507541 509192 509975 510794 512458 512645 513865 516312 517548 519394 521422 521991 526774 538415 552248 558270 561895 566354 567830 568079 568847 570260 570307 571420 578385 579893 590633 591196 595367 595388 595459 597049 598010 654812 656072 660905 683293 683304 719555 722964 724238 732160 741604 742234 753896 760394 788356 789287 806789 816599 825540 825593 826527 ] |
||||||||||||||||||||||||||||||
|
26.36 ms (12.21%) |
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 561895 719555 595459 788356 790440 791935 722964 194687 472609 469277 472400 568847 567830 552248 400696 461553 467549 484403 510794 517548 521422 566354 579893 385928 516312 512645 826527 654812 656072 724238 760394 424011 427192 457580 473284 462284 570260 570307 443248 453514 448214 483528 595367 806789 468399 432181 509192 495529 683304 683293 741604 271234 441595 393330 441420 435378 461443 411257 447068 595388 452683 444001 590633 453480 455913 660905 789287 732160 150336 410791 507541 388078 494106 816599 825540 753896 558270 526774 504206 509975 597049 742234 437758 456741 439920 385359 469757 571420 591196 468179 411757 437761 506185 513865 538415 568079 423837 443874 598010 419998 462050 458755 512458 578385 420718 458253 459503 459087 462597 466880 478721 419739 422357 424483 503943 521991 502350 497201 519394 825593 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.96%) |
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 150336 194687 271234 385359 385928 388078 393330 400696 410791 411257 411757 419739 419998 420718 422357 423837 424011 424483 427192 432181 435378 437758 437761 439920 441420 441595 443248 443874 444001 447068 448214 452683 453480 453514 455913 456741 457580 458253 458755 459087 459503 461443 461553 462050 462284 462597 466880 467549 468179 468399 469277 469757 472400 472609 473284 478721 483528 484403 494106 495529 497201 502350 503943 504206 506185 507541 509192 509975 510794 512458 512645 513865 516312 517548 519394 521422 521991 526774 538415 552248 558270 561895 566354 567830 568079 568847 570260 570307 571420 578385 579893 590633 591196 595367 595388 595459 597049 598010 654812 656072 660905 683293 683304 719555 722964 724238 732160 741604 742234 753896 760394 788356 789287 806789 816599 825540 825593 826527 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex rus"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс русск"
]
|
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.