Query Metrics
7
Database Queries
7
Different statements
198.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.65 ms (86.12%) |
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 34345 386953 391025 396962 399439 401048 401361 401954 402531 405112 408164 413086 415074 421343 421415 428784 431653 434066 434257 439927 442089 442195 442255 445220 445944 446680 447615 451824 451831 459309 462624 463218 463233 463779 464314 466730 468058 469471 471002 472156 473270 474085 475557 476787 478750 478807 479854 482610 483660 484803 485941 486848 490645 491618 492302 493466 496464 498056 498130 505641 506956 507033 507199 509245 510548 511898 514215 516185 517453 518415 518462 518801 520248 521447 523255 525077 527079 528566 531650 532197 535717 544021 544325 546856 552456 553229 555465 555585 557058 561594 563136 564176 565931 570737 571096 573311 579849 583083 596470 598484 598832 600814 601541 601825 606367 630404 645706 648119 662405 663944 664258 665493 666669 671791 673537 679657 720674 745320 769888 773870 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (7.70%) |
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 401954 408164 521447 563136 528566 601541 402531 391025 570737 493466 490645 518801 442195 466730 445944 478807 553229 671791 664258 442089 447615 399439 507033 645706 630404 468058 505641 464314 472156 517453 462624 428784 507199 511898 431653 531650 510548 532197 769888 484803 434257 509245 555465 474085 421343 476787 518462 478750 665493 579849 401361 516185 555585 544021 546856 564176 679657 486848 720674 475557 773870 518415 600814 463779 491618 463233 648119 442255 434066 544325 571096 446680 498130 598832 673537 421415 520248 514215 523255 565931 415074 596470 451824 469471 506956 552456 601825 413086 666669 492302 396962 401048 583083 445220 479854 525077 535717 463218 473270 527079 496464 34345 485941 663944 557058 459309 745320 386953 451831 561594 662405 573311 606367 598484 471002 439927 483660 498056 482610 405112 ] |
||||||||||||||||||||||||||||||
|
4.69 ms (2.37%) |
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 34345 386953 391025 396962 399439 401048 401361 401954 402531 405112 408164 413086 415074 421343 421415 428784 431653 434066 434257 439927 442089 442195 442255 445220 445944 446680 447615 451824 451831 459309 462624 463218 463233 463779 464314 466730 468058 469471 471002 472156 473270 474085 475557 476787 478750 478807 479854 482610 483660 484803 485941 486848 490645 491618 492302 493466 496464 498056 498130 505641 506956 507033 507199 509245 510548 511898 514215 516185 517453 518415 518462 518801 520248 521447 523255 525077 527079 528566 531650 532197 535717 544021 544325 546856 552456 553229 555465 555585 557058 561594 563136 564176 565931 570737 571096 573311 579849 583083 596470 598484 598832 600814 601541 601825 606367 630404 645706 648119 662405 663944 664258 665493 666669 671791 673537 679657 720674 745320 769888 773870 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big vagina fuck"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие вагин секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие вагин секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.