Query Metrics
7
Database Queries
7
Different statements
175.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.78 ms (85.89%) |
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 73070 351473 388756 395759 409066 419176 435404 435648 437816 452488 459569 469501 475132 476883 483373 487086 490164 490273 507415 507460 507788 508837 508843 508876 510147 511040 511332 532514 549527 554373 556412 562192 562687 568783 576406 578717 578737 578752 578764 578770 578810 579559 580609 586582 591328 594553 604464 605275 605494 606988 606989 607004 607017 607029 610121 615786 616648 616866 618685 621582 622707 625026 628718 628837 631015 633611 633823 636066 642572 642928 650859 651294 651335 664801 665399 678308 687362 687443 689061 691414 702509 702740 706660 715397 715402 716982 718309 720187 721156 721249 721469 723660 724489 730323 736169 737261 743429 748153 748787 755723 775274 779913 782376 787251 789109 791410 796563 797292 798013 798972 799772 802003 807504 809575 812265 817482 820695 823361 824904 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (8.15%) |
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 622707 625026 721156 785027 511040 820695 490164 579559 702509 586582 607029 782376 507788 508837 665399 556412 508876 490273 419176 435648 817482 554373 718309 715402 610121 779913 807504 476883 487086 507415 508843 511332 437816 578717 549527 578737 562687 715397 578770 580609 631015 591328 594553 616866 618685 633611 616648 607004 642928 798013 748787 730323 621582 633823 799772 802003 812265 435404 469501 409066 823361 824904 507460 510147 578810 562192 568783 578752 650859 678308 689061 651294 687443 721469 607017 628837 642572 604464 628718 605275 605494 606988 615786 636066 787251 789109 791410 796563 809575 724489 737261 748153 755723 743429 736169 606989 706660 716982 720187 775274 797292 798972 73070 475132 483373 395759 351473 388756 723660 452488 459569 532514 576406 578764 651335 664801 687362 691414 721249 702740 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.09%) |
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 73070 351473 388756 395759 409066 419176 435404 435648 437816 452488 459569 469501 475132 476883 483373 487086 490164 490273 507415 507460 507788 508837 508843 508876 510147 511040 511332 532514 549527 554373 556412 562192 562687 568783 576406 578717 578737 578752 578764 578770 578810 579559 580609 586582 591328 594553 604464 605275 605494 606988 606989 607004 607017 607029 610121 615786 616648 616866 618685 621582 622707 625026 628718 628837 631015 633611 633823 636066 642572 642928 650859 651294 651335 664801 665399 678308 687362 687443 689061 691414 702509 702740 706660 715397 715402 716982 718309 720187 721156 721249 721469 723660 724489 730323 736169 737261 743429 748153 748787 755723 775274 779913 782376 787251 789109 791410 796563 797292 798013 798972 799772 802003 807504 809575 812265 817482 820695 823361 824904 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cheating girl"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cheating девушк"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cheating девушк"
]
|
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.