Query Metrics
7
Database Queries
7
Different statements
177.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.14 ms (86.11%) |
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 282649 392579 405805 411435 411559 420830 421618 424334 426821 433352 433385 433636 437243 441691 441897 443038 458564 459686 459991 460118 461392 465915 476397 480087 490275 490356 493878 495111 495409 495646 499950 500265 506353 509155 509520 513017 513321 513748 521478 524259 524869 525198 525772 528424 535101 541670 555965 558187 559387 561981 564801 572228 574128 574942 593105 595838 595967 599378 601947 604978 606897 606931 609146 610532 613227 622416 622730 625254 626332 630943 649056 650076 650648 651376 655558 662042 662050 662183 663165 669504 680585 695544 696455 702313 706470 706498 708729 709739 710185 716182 718882 722381 736218 739675 756302 763077 763640 763842 764280 775295 777750 778014 781052 782015 784831 788050 791553 793494 793959 794445 795773 797296 802024 803137 804480 807681 810005 814284 824314 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (8.09%) |
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 595838 604978 574942 669504 680585 500265 702303 509520 524259 495111 513321 535101 490275 555965 572228 574128 649056 662042 695544 702313 710185 650076 706470 708729 650648 651376 662183 663165 595967 609146 610532 613227 622416 625254 622730 599378 606931 630943 606897 709739 480087 490356 513017 525772 495409 513748 493878 499950 601947 777750 421618 411559 420830 441691 441897 437243 814284 824314 458564 506353 525198 528424 541670 718882 716182 722381 558187 561981 626332 795773 802024 775295 781052 793494 791553 807681 736218 763640 756302 739675 763077 763842 764280 778014 782015 784831 793959 794445 797296 803137 804480 810005 459686 459991 433636 424334 392579 405805 426821 461392 465915 476397 433352 433385 460118 495646 509155 524869 696455 706498 655558 662050 564801 593105 788050 521478 411435 443038 559387 282649 ] |
||||||||||||||||||||||||||||||
|
2.60 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 282649 392579 405805 411435 411559 420830 421618 424334 426821 433352 433385 433636 437243 441691 441897 443038 458564 459686 459991 460118 461392 465915 476397 480087 490275 490356 493878 495111 495409 495646 499950 500265 506353 509155 509520 513017 513321 513748 521478 524259 524869 525198 525772 528424 535101 541670 555965 558187 559387 561981 564801 572228 574128 574942 593105 595838 595967 599378 601947 604978 606897 606931 609146 610532 613227 622416 622730 625254 626332 630943 649056 650076 650648 651376 655558 662042 662050 662183 663165 669504 680585 695544 696455 702313 706470 706498 708729 709739 710185 716182 718882 722381 736218 739675 756302 763077 763640 763842 764280 775295 777750 778014 781052 782015 784831 788050 791553 793494 793959 794445 795773 797296 802024 803137 804480 807681 810005 814284 824314 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sister homemade"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sister домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sister домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.