Query Metrics
7
Database Queries
7
Different statements
179.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.35 ms (86.05%) |
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 69883 377287 385231 387717 391619 393526 397495 398138 398233 399885 400493 401453 401960 402390 402866 403257 407550 407700 408730 410428 411750 417043 418161 418193 419361 420304 420586 420588 420736 423333 423937 424213 425195 425588 426627 427753 428517 432398 432487 432488 432527 432544 432994 433385 436477 436568 437434 437982 438741 443468 444607 444964 445612 449468 450676 451271 451494 452222 453093 453508 453730 453960 456207 457549 458161 459738 461560 461698 462068 462172 462571 463397 463661 475728 476446 478347 481238 483592 484318 485671 494616 496793 498287 500890 501526 504047 507451 511405 516226 529663 543592 549642 555992 571594 585737 590196 628723 636936 674101 715601 718967 720022 723269 723867 724715 725290 737070 754229 762334 767620 771685 778606 779533 783781 787116 792075 792918 801486 808164 808535 ] |
||||||||||||||||||||||||||||||
|
14.85 ms (8.28%) |
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 399885 403257 410428 423333 426627 463397 425195 433385 445612 476446 500890 511405 494616 411750 453093 420586 400493 432527 436477 437434 420588 419361 425588 423937 449468 453730 516226 555992 543592 585737 453508 463661 496793 69883 387717 432398 407550 420736 529663 549642 674101 715601 720022 723269 718967 590196 628723 783781 787116 792075 801486 808164 778606 779533 725290 762334 723867 724715 754229 767620 771685 792918 398138 391619 377287 398233 385231 397495 401960 402390 402866 418193 424213 432487 432488 417043 408730 427753 428517 436568 444964 450676 453960 462571 484318 451271 457549 478347 452222 459738 504047 507451 498287 501526 462068 475728 483592 485671 571594 636936 808535 737070 393526 443468 456207 458161 461698 462172 407700 420304 438741 444607 461560 418161 432544 432994 437982 451494 481238 401453 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.49%) |
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 69883 377287 385231 387717 391619 393526 397495 398138 398233 399885 400493 401453 401960 402390 402866 403257 407550 407700 408730 410428 411750 417043 418161 418193 419361 420304 420586 420588 420736 423333 423937 424213 425195 425588 426627 427753 428517 432398 432487 432488 432527 432544 432994 433385 436477 436568 437434 437982 438741 443468 444607 444964 445612 449468 450676 451271 451494 452222 453093 453508 453730 453960 456207 457549 458161 459738 461560 461698 462068 462172 462571 463397 463661 475728 476446 478347 481238 483592 484318 485671 494616 496793 498287 500890 501526 504047 507451 511405 516226 529663 543592 549642 555992 571594 585737 590196 628723 636936 674101 715601 718967 720022 723269 723867 724715 725290 737070 754229 762334 767620 771685 778606 779533 783781 787116 792075 792918 801486 808164 808535 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum boy"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum парен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum парен"
]
|
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.