Query Metrics
7
Database Queries
7
Different statements
166.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.15 ms (85.86%) |
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 391158 397780 407567 417080 425405 428799 454416 454930 457010 459128 464936 465246 465437 466492 469121 472336 473634 474102 474509 476246 476270 478265 479355 480397 483350 487396 502840 504620 506009 510937 511609 513541 525734 533711 535053 535811 539641 541738 546336 547413 547464 547781 550172 550429 551704 554226 555444 570932 572259 574252 575663 576463 576493 584400 590306 594856 595086 595309 599768 599995 605266 614384 621315 623939 628148 642075 660364 660688 663893 669857 669899 693055 696052 703556 705516 705736 706900 714042 715881 716339 717009 719899 721755 724023 739925 739950 745558 746095 748353 756192 759369 761147 765359 772284 786388 788404 788734 790885 798935 803025 805287 806057 806403 807636 812979 815388 815616 816340 817455 817594 817846 818225 819020 819053 819151 819240 820656 821688 821783 828370 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (8.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 806057 807636 812979 705516 479355 469121 478265 487396 817846 815388 815616 819151 821688 535053 547464 693055 703556 621315 628148 642075 806403 788734 759369 599995 746095 590306 717009 391158 716339 483350 756192 719899 820656 715881 739925 739950 765359 465437 816340 504620 454930 466492 576493 660688 724023 761147 407567 539641 511609 550429 464936 459128 472336 502840 476246 397780 457010 417080 599768 572259 525734 533711 575663 663893 669857 669899 696052 786388 546336 550172 721755 772284 425405 570932 614384 803025 474509 476270 506009 474102 428799 513541 595309 480397 454416 473634 510937 819240 821783 817455 818225 828370 535811 574252 547413 551704 555444 706900 576463 584400 623939 594856 748353 788404 798935 745558 705736 554226 465246 595086 817594 547781 660364 805287 605266 790885 714042 541738 819053 819020 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.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 391158 397780 407567 417080 425405 428799 454416 454930 457010 459128 464936 465246 465437 466492 469121 472336 473634 474102 474509 476246 476270 478265 479355 480397 483350 487396 502840 504620 506009 510937 511609 513541 525734 533711 535053 535811 539641 541738 546336 547413 547464 547781 550172 550429 551704 554226 555444 570932 572259 574252 575663 576463 576493 584400 590306 594856 595086 595309 599768 599995 605266 614384 621315 623939 628148 642075 660364 660688 663893 669857 669899 693055 696052 703556 705516 705736 706900 714042 715881 716339 717009 719899 721755 724023 739925 739950 745558 746095 748353 756192 759369 761147 765359 772284 786388 788404 788734 790885 798935 803025 805287 806057 806403 807636 812979 815388 815616 816340 817455 817594 817846 818225 819020 819053 819151 819240 820656 821688 821783 828370 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature woman public"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.87%) |
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.