Query Metrics
7
Database Queries
7
Different statements
196.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.24 ms (84.98%) |
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 66768 170836 187723 232953 310683 359075 382091 382284 382746 383390 385632 387377 388329 388604 395943 397362 398956 400994 407777 407779 410237 411688 413068 439488 443762 453438 453681 453702 454222 455048 456897 457458 462101 462690 465788 465949 466319 467445 467449 471883 474427 474485 475870 477965 478793 480731 484426 484462 484665 486821 490918 493098 506045 518852 525488 537985 539358 546930 551574 554389 557310 557991 558021 560414 561589 561598 563064 563127 563196 592914 601853 645840 663368 663485 664281 665415 665483 667593 667868 687555 707282 708125 710445 710485 710587 714646 718499 718563 721413 726572 726588 730550 741653 743803 748130 748232 770151 774766 776742 781659 781678 781688 781706 781731 781757 782158 782183 789292 789526 789534 792588 808500 811469 816792 817308 818656 818921 820283 823691 824145 ] |
||||||||||||||||||||||||||||||
|
19.00 ms (9.65%) |
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 382746 710587 781706 781731 782158 782183 781678 781688 726588 726572 741653 808500 187723 398956 395943 665415 592914 789534 748130 789526 748232 743803 710445 387377 439488 466319 474485 454222 490918 484426 310683 397362 818921 824145 537985 563064 667593 721413 667868 708125 718499 718563 776742 781757 811469 730550 770151 781659 359075 385632 561589 557310 601853 382284 388604 407779 411688 407777 453702 462690 453438 453681 456897 493098 455048 457458 465788 525488 474427 558021 546930 551574 563196 663485 663368 710485 557991 477965 471883 475870 383390 413068 478793 400994 443762 467449 480731 467445 484462 486821 506045 382091 687555 792588 484665 518852 410237 563127 66768 465949 554389 462101 388329 816792 823691 820283 539358 560414 561598 707282 664281 714646 170836 232953 818656 817308 665483 645840 789292 774766 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (1.85%) |
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 66768 170836 187723 232953 310683 359075 382091 382284 382746 383390 385632 387377 388329 388604 395943 397362 398956 400994 407777 407779 410237 411688 413068 439488 443762 453438 453681 453702 454222 455048 456897 457458 462101 462690 465788 465949 466319 467445 467449 471883 474427 474485 475870 477965 478793 480731 484426 484462 484665 486821 490918 493098 506045 518852 525488 537985 539358 546930 551574 554389 557310 557991 558021 560414 561589 561598 563064 563127 563196 592914 601853 645840 663368 663485 664281 665415 665483 667593 667868 687555 707282 708125 710445 710485 710587 714646 718499 718563 721413 726572 726588 730550 741653 743803 748130 748232 770151 774766 776742 781659 781678 781688 781706 781731 781757 782158 782183 789292 789526 789534 792588 808500 811469 816792 817308 818656 818921 820283 823691 824145 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature young boy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature young парен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature young парен"
]
|
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.