Query Metrics
7
Database Queries
7
Different statements
174.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.26 ms (88.88%) |
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 202902 392225 392236 396464 416397 446709 468363 471352 493223 506283 530584 530987 535384 535765 536995 538899 544161 544809 545175 546417 547609 549073 559401 559661 565440 566846 567994 576906 586736 590828 590845 604260 604655 616598 619050 619347 627362 629686 631106 645342 647689 660466 662015 675607 680233 688939 689456 690973 691662 698840 707102 713022 715562 717204 717837 718154 718240 720703 721974 724142 728393 729074 733796 736228 736242 738591 740107 740865 743944 747100 749891 750222 750269 752720 757111 761080 761538 762301 762779 764130 765058 765072 765073 765105 765248 765437 766673 766905 767203 767212 777034 777575 778850 779005 780799 782294 783089 784266 790141 792806 793330 793331 793867 794915 796528 796884 798804 803848 804810 805310 813828 814647 817237 821005 825414 825733 826294 826731 827381 828595 ] |
||||||||||||||||||||||||||||||
|
10.19 ms (5.83%) |
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 805310 826294 536995 794915 765105 689456 559661 396464 750222 825414 827381 733796 790141 825733 817237 765248 747100 757111 576906 803848 784266 736228 750269 740865 631106 202902 416397 813828 821005 468363 535765 530584 546417 565440 547609 567994 544161 549073 559401 566846 647689 662015 675607 688939 690973 707102 713022 715562 718240 720703 660466 691662 645342 680233 717204 718154 721974 586736 604655 604260 629686 590828 590845 616598 783089 793330 793331 793867 777034 777575 779005 792806 796528 796884 804810 740107 765058 765072 767203 736242 765437 728393 729074 765073 724142 738591 743944 749891 762779 766905 752720 761538 762301 766673 619050 619347 698840 782294 798804 392236 446709 392225 826731 538899 544809 767212 471352 828595 506283 530987 545175 778850 761080 764130 814647 493223 717837 780799 535384 627362 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.46%) |
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 202902 392225 392236 396464 416397 446709 468363 471352 493223 506283 530584 530987 535384 535765 536995 538899 544161 544809 545175 546417 547609 549073 559401 559661 565440 566846 567994 576906 586736 590828 590845 604260 604655 616598 619050 619347 627362 629686 631106 645342 647689 660466 662015 675607 680233 688939 689456 690973 691662 698840 707102 713022 715562 717204 717837 718154 718240 720703 721974 724142 728393 729074 733796 736228 736242 738591 740107 740865 743944 747100 749891 750222 750269 752720 757111 761080 761538 762301 762779 764130 765058 765072 765073 765105 765248 765437 766673 766905 767203 767212 777034 777575 778850 779005 780799 782294 783089 784266 790141 792806 793330 793331 793867 794915 796528 796884 798804 803848 804810 805310 813828 814647 817237 821005 825414 825733 826294 826731 827381 828595 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal close-up"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал close up"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал close up"
]
|
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.