Query Metrics
7
Database Queries
7
Different statements
361.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.99 ms (58.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк old мужчин"
]
|
||||||||||||||||||||||||||||||
|
125.87 ms (34.85%) |
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 331327 383441 387315 393458 393731 393738 394238 395320 395463 396191 396805 396836 397329 397793 398231 399039 400449 400714 401037 402091 404950 405288 413048 416377 417920 423283 427301 430650 452369 452490 454366 458051 462781 463129 463141 464145 464284 464294 466966 470842 495147 507815 511415 512049 512247 512326 513036 515165 518316 526034 528340 546700 550051 550442 557274 561734 566509 566517 566526 569523 569663 569689 570073 576080 577515 586761 587309 593125 594014 597259 599095 599548 614094 617759 621436 622888 625490 663524 663940 664309 664958 665431 669430 670513 675499 676924 676930 676982 681813 684229 684995 694533 696969 716264 720491 721006 721551 723536 732421 736022 744293 744337 748989 775258 775578 775816 775825 778419 787309 800373 805346 805847 810572 810775 818920 823700 824824 828022 828053 828283 ] |
||||||||||||||||||||||||||||||
|
14.81 ms (4.10%) |
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 512049 512247 495147 512326 463129 569523 599095 586761 787309 416377 466966 405288 430650 396191 828053 546700 723536 452369 464284 464294 395320 401037 518316 470842 452490 577515 676982 593125 398231 664958 614094 599548 617759 775258 744293 775816 400449 462781 663940 676924 669430 670513 696969 664309 684995 561734 810572 736022 721006 778419 463141 818920 824824 823700 625490 775578 569663 569689 570073 557274 622888 383441 394238 331327 413048 427301 528340 684229 694533 621436 395463 393458 454366 526034 507815 513036 663524 587309 800373 396836 397793 550442 576080 828022 399039 458051 393738 464145 566509 675499 676930 665431 681813 566517 566526 597259 594014 775825 805847 805346 748989 744337 732421 716264 720491 393731 402091 396805 511415 417920 400714 397329 423283 721551 550051 404950 515165 810775 387315 828283 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.63%) |
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 331327 383441 387315 393458 393731 393738 394238 395320 395463 396191 396805 396836 397329 397793 398231 399039 400449 400714 401037 402091 404950 405288 413048 416377 417920 423283 427301 430650 452369 452490 454366 458051 462781 463129 463141 464145 464284 464294 466966 470842 495147 507815 511415 512049 512247 512326 513036 515165 518316 526034 528340 546700 550051 550442 557274 561734 566509 566517 566526 569523 569663 569689 570073 576080 577515 586761 587309 593125 594014 597259 599095 599548 614094 617759 621436 622888 625490 663524 663940 664309 664958 665431 669430 670513 675499 676924 676930 676982 681813 684229 684995 694533 696969 716264 720491 721006 721551 723536 732421 736022 744293 744337 748989 775258 775578 775816 775825 778419 787309 800373 805346 805847 810572 810775 818920 823700 824824 828022 828053 828283 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl old man"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк old мужчин"
]
|
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.