Query Metrics
7
Database Queries
7
Different statements
184.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.09 ms (88.47%) |
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 79862 145635 151163 335455 391575 395330 396933 397403 398269 398783 398919 400521 404025 418522 420509 421956 427158 431537 435716 443271 443838 444715 447040 449264 449273 452662 455507 456113 459083 460261 461013 469382 483240 490260 490458 496736 496758 499018 504069 504161 505572 509430 510551 511274 513652 514608 515322 516057 520641 524004 526532 528584 535855 537630 544050 545686 553344 560289 564715 564858 566862 570096 572715 578551 579879 580133 585207 598964 603967 604404 607472 620441 621336 621603 623898 626104 627695 630758 639681 650964 653208 685431 685489 689139 689232 704019 707833 707886 708701 709935 713205 714443 715899 723227 729308 736120 737186 740423 748747 750602 752961 754740 761564 766861 777169 784498 791504 795098 795471 795620 797090 797101 797871 799298 806054 810339 810414 813710 824228 825572 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (6.74%) |
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 151163 535855 689139 514608 797101 766861 443838 435716 564715 544050 564858 585207 750602 496758 685431 524004 748747 761564 427158 515322 713205 708701 579879 404025 469382 607472 509430 795620 603967 570096 639681 623898 452662 397403 824228 398269 396933 456113 545686 421956 449273 511274 797871 496736 715899 504161 79862 685489 707833 621603 723227 418522 505572 490458 752961 490260 537630 516057 795471 797090 580133 707886 653208 630758 621336 443271 335455 400521 444715 799298 810339 499018 627695 431537 449264 526532 460261 714443 572715 510551 398919 813710 777169 810414 736120 398783 483240 513652 709935 620441 598964 737186 704019 553344 784498 825572 754740 729308 740423 528584 560289 566862 604404 455507 650964 145635 395330 578551 447040 626104 791504 461013 520641 391575 806054 459083 420509 504069 795098 689232 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.35%) |
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 79862 145635 151163 335455 391575 395330 396933 397403 398269 398783 398919 400521 404025 418522 420509 421956 427158 431537 435716 443271 443838 444715 447040 449264 449273 452662 455507 456113 459083 460261 461013 469382 483240 490260 490458 496736 496758 499018 504069 504161 505572 509430 510551 511274 513652 514608 515322 516057 520641 524004 526532 528584 535855 537630 544050 545686 553344 560289 564715 564858 566862 570096 572715 578551 579879 580133 585207 598964 603967 604404 607472 620441 621336 621603 623898 626104 627695 630758 639681 650964 653208 685431 685489 689139 689232 704019 707833 707886 708701 709935 713205 714443 715899 723227 729308 736120 737186 740423 748747 750602 752961 754740 761564 766861 777169 784498 791504 795098 795471 795620 797090 797101 797871 799298 806054 810339 810414 813710 824228 825572 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашний секс брюнетк…"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск секс черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.78%) |
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.