Query Metrics
7
Database Queries
7
Different statements
221.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.52 ms (88.83%) |
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 210072 274100 388132 392990 405745 409532 428484 432787 434656 451821 453641 453650 454405 454492 456168 456171 456859 457764 457766 457768 457788 458431 458929 459178 467645 467678 470505 470560 470603 470654 470915 470935 470955 474030 474942 475095 476423 477445 484687 487112 491022 495746 495766 497963 501242 501250 501251 501254 504137 506794 506805 512284 517478 520751 523758 526131 527647 531965 532676 532893 537619 543362 543363 543365 543366 543412 543416 543421 543760 543991 544112 551756 557940 561628 566439 567467 575703 579306 589154 589194 589208 591321 591804 595782 595808 595817 597870 598278 602221 608359 610780 622235 622249 650853 653172 659042 675891 676313 676397 678862 692584 694154 694429 698109 710365 710459 712636 712675 715518 717603 728946 732257 732377 732733 758814 775934 798051 799600 806381 807773 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (6.77%) |
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 692584 775934 659042 806381 520751 543365 694429 497963 676397 698109 495766 650853 712636 470915 543363 543991 676313 622249 526131 543366 717603 694154 543412 392990 274100 527647 543760 622235 531965 477445 543362 544112 470935 610780 595782 523758 532893 474942 470560 537619 551756 595808 470505 675891 567467 561628 459178 495746 732733 597870 470654 506805 591804 506794 453641 475095 484687 566439 543421 453650 608359 799600 728946 476423 732377 456168 504137 501254 434656 758814 798051 807773 428484 517478 732257 405745 409532 710459 591321 454405 589208 710365 467645 457764 678862 715518 532676 491022 543416 595817 210072 388132 501251 467678 589154 653172 457788 458431 451821 432787 602221 470955 470603 458929 598278 456859 501242 457766 456171 487112 557940 589194 454492 501250 512284 579306 457768 474030 575703 712675 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.37%) |
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 210072 274100 388132 392990 405745 409532 428484 432787 434656 451821 453641 453650 454405 454492 456168 456171 456859 457764 457766 457768 457788 458431 458929 459178 467645 467678 470505 470560 470603 470654 470915 470935 470955 474030 474942 475095 476423 477445 484687 487112 491022 495746 495766 497963 501242 501250 501251 501254 504137 506794 506805 512284 517478 520751 523758 526131 527647 531965 532676 532893 537619 543362 543363 543365 543366 543412 543416 543421 543760 543991 544112 551756 557940 561628 566439 567467 575703 579306 589154 589194 589208 591321 591804 595782 595808 595817 597870 598278 602221 608359 610780 622235 622249 650853 653172 659042 675891 676313 676397 678862 692584 694154 694429 698109 710365 710459 712636 712675 715518 717603 728946 732257 732377 732733 758814 775934 798051 799600 806381 807773 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex swinger"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс свингер"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.67%) |
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.