Query Metrics
7
Database Queries
7
Different statements
196.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.62 ms (87.64%) |
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 405911 467670 490811 532086 538832 539624 541361 541597 541605 541625 541643 544261 544307 544308 544326 544340 546747 546954 547352 547859 547869 548228 549265 549267 549362 549405 549421 549780 549899 549945 550322 556796 557206 557352 560091 562857 563530 563532 566697 567368 569295 570778 570804 572544 572563 572568 572653 574204 574269 574281 576722 579922 580253 581119 581320 583827 583854 589761 593299 614327 618868 619409 622412 629966 648963 649536 654400 668950 670114 671316 671760 672099 672112 678008 681115 681148 682466 683371 684267 684961 688078 690860 694537 700743 702088 702895 702974 702977 703040 703070 703535 704084 704540 705915 706612 708418 708790 709211 712714 713695 715501 719059 719062 719094 722190 722197 722664 722684 724867 727299 730853 732437 737621 744278 752072 756418 758987 786031 788462 800629 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (7.16%) |
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 567368 576722 549362 572653 563532 574269 563530 581320 593299 618868 619409 709211 467670 539624 532086 549267 550322 581119 583827 541597 544307 544326 569295 544340 549405 549945 570778 681148 688078 702977 703040 712714 654400 668950 671316 702895 704084 708790 549421 556796 557352 788462 758987 800629 730853 737621 756418 732437 724867 752072 702974 703535 715501 719062 722664 538832 546747 548228 574204 541605 541625 544261 566697 546954 580253 583854 572544 589761 490811 544308 579922 549780 570804 547352 572568 649536 700743 719059 719094 678008 683371 702088 722684 648963 672099 684267 684961 706612 708418 722190 547869 549899 557206 562857 572563 622412 786031 727299 744278 614327 629966 703070 722197 541643 405911 560091 574281 541361 547859 549265 681115 690860 704540 705915 670114 694537 713695 671760 672112 682466 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (2.04%) |
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 405911 467670 490811 532086 538832 539624 541361 541597 541605 541625 541643 544261 544307 544308 544326 544340 546747 546954 547352 547859 547869 548228 549265 549267 549362 549405 549421 549780 549899 549945 550322 556796 557206 557352 560091 562857 563530 563532 566697 567368 569295 570778 570804 572544 572563 572568 572653 574204 574269 574281 576722 579922 580253 581119 581320 583827 583854 589761 593299 614327 618868 619409 622412 629966 648963 649536 654400 668950 670114 671316 671760 672099 672112 678008 681115 681148 682466 683371 684267 684961 688078 690860 694537 700743 702088 702895 702974 702977 703040 703070 703535 704084 704540 705915 706612 708418 708790 709211 712714 713695 715501 719059 719062 719094 722190 722197 722664 722684 724867 727299 730853 732437 737621 744278 752072 756418 758987 786031 788462 800629 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens film"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens фильм"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens фильм"
]
|
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.