Query Metrics
7
Database Queries
7
Different statements
145.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.77 ms (84.10%) |
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 389460 413098 423960 423983 424224 427050 429063 438450 438659 455709 469194 485564 486461 490617 492617 492770 492808 492996 498125 508327 515976 517878 526567 529422 531016 542304 542391 542705 543640 543743 543759 547232 551051 555808 556611 560337 560895 562215 562219 564954 570091 575223 579515 581554 590471 595890 596170 597118 598566 598746 598952 599064 599242 599481 600037 600150 600272 604807 609769 623104 627669 627671 629215 629480 630453 631255 631784 632859 632898 632949 633715 634821 636191 637727 638957 644205 648664 652092 652958 653206 653479 655507 658468 659477 660667 666977 667984 668285 669244 669894 672841 685180 686469 686481 689207 694615 697017 698161 701909 701963 703450 704635 706143 708908 709046 709910 711161 711712 712955 731660 736967 742386 743634 747328 749363 761974 777984 784234 791913 810904 ] |
||||||||||||||||||||||||||||||
|
11.59 ms (7.94%) |
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 761974 515976 517878 485564 424224 560895 564954 492808 498125 438450 486461 492996 423983 469194 389460 427050 438659 492770 743634 531016 543743 543759 543640 555808 672841 631255 791913 784234 731660 736967 742386 413098 508327 529422 777984 810904 570091 581554 542304 551051 556611 562215 655507 667984 685180 686469 698161 701909 706143 709046 652958 659477 668285 686481 694615 697017 703450 708908 712955 648664 652092 653206 653479 658468 660667 669244 669894 689207 701963 704635 709910 711712 575223 590471 623104 629480 632949 598952 599242 600037 600150 600272 633715 596170 604807 627669 627671 630453 636191 595890 609769 631784 638957 644205 749363 629215 632898 634821 637727 711161 429063 599064 598566 598746 599481 542705 747328 455709 526567 542391 560337 562219 579515 547232 666977 632859 597118 423960 492617 490617 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.83%) |
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 389460 413098 423960 423983 424224 427050 429063 438450 438659 455709 469194 485564 486461 490617 492617 492770 492808 492996 498125 508327 515976 517878 526567 529422 531016 542304 542391 542705 543640 543743 543759 547232 551051 555808 556611 560337 560895 562215 562219 564954 570091 575223 579515 581554 590471 595890 596170 597118 598566 598746 598952 599064 599242 599481 600037 600150 600272 604807 609769 623104 627669 627671 629215 629480 630453 631255 631784 632859 632898 632949 633715 634821 636191 637727 638957 644205 648664 652092 652958 653206 653479 655507 658468 659477 660667 666977 667984 668285 669244 669894 672841 685180 686469 686481 689207 694615 697017 698161 701909 701963 703450 704635 706143 708908 709046 709910 711161 711712 712955 731660 736967 742386 743634 747328 749363 761974 777984 784234 791913 810904 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск домашн любительск соло"
]
|
||||||||||||||||||||||||||||||
|
2.31 ms (1.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск домашн любительск соло"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian homemade solo"
]
|
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.