Query Metrics
7
Database Queries
7
Different statements
215.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.58 ms (88.48%) |
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 79683 385676 385758 391455 398643 404019 409846 412963 417090 417693 417958 419225 420869 422303 422305 425494 425497 427334 432754 438995 441972 442922 443540 444228 446228 447261 450383 450860 451018 453772 455214 456524 459642 469867 470142 471154 471163 471573 472680 474336 476600 477225 478280 478709 485954 487615 488051 489259 490516 495441 495935 501579 504464 506012 513243 516613 523268 523277 527317 531360 542085 544723 550309 553343 557245 557641 561352 569560 571074 575236 582670 587709 588708 589030 601898 623436 624601 636143 651795 652454 661512 671686 676617 696732 707480 722189 723665 727423 729773 735417 736468 738311 741879 747236 747796 754343 754821 757565 763331 763629 765410 772837 777198 777978 779845 782914 785047 785812 787585 788968 791842 792124 792480 793425 793722 794949 796590 805066 810139 817073 ] |
||||||||||||||||||||||||||||||
|
14.82 ms (6.88%) |
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 450383 456524 469867 471163 490516 506012 527317 425497 443540 516613 476600 417958 438995 444228 471573 474336 504464 544723 553343 582670 550309 561352 671686 696732 651795 661512 588708 589030 777978 787585 796590 788968 794949 738311 772837 747796 741879 736468 754343 763629 765410 722189 782914 420869 793425 636143 477225 455214 531360 419225 432754 417693 623436 495441 624601 785047 575236 747236 785812 446228 385676 587709 417090 442922 792480 779845 478709 487615 513243 451018 488051 805066 729773 453772 542085 652454 707480 459642 495935 398643 470142 723665 817073 676617 792124 793722 757565 727423 735417 754821 763331 777198 791842 810139 391455 425494 441972 422303 427334 422305 447261 472680 489259 557641 569560 557245 571074 601898 409846 412963 79683 471154 478280 450860 523277 523268 501579 485954 385758 404019 ] |
||||||||||||||||||||||||||||||
|
2.96 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 79683 385676 385758 391455 398643 404019 409846 412963 417090 417693 417958 419225 420869 422303 422305 425494 425497 427334 432754 438995 441972 442922 443540 444228 446228 447261 450383 450860 451018 453772 455214 456524 459642 469867 470142 471154 471163 471573 472680 474336 476600 477225 478280 478709 485954 487615 488051 489259 490516 495441 495935 501579 504464 506012 513243 516613 523268 523277 527317 531360 542085 544723 550309 553343 557245 557641 561352 569560 571074 575236 582670 587709 588708 589030 601898 623436 624601 636143 651795 652454 661512 671686 676617 696732 707480 722189 723665 727423 729773 735417 736468 738311 741879 747236 747796 754343 754821 757565 763331 763629 765410 772837 777198 777978 779845 782914 785047 785812 787585 788968 791842 792124 792480 793425 793722 794949 796590 805066 810139 817073 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.74%) |
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.