Query Metrics
7
Database Queries
7
Different statements
406.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.75 ms (51.81%) |
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 233647 323352 386716 387379 392721 398125 398237 401754 401809 404090 406010 412137 413098 418131 418351 418365 418750 420824 420858 421390 421617 423714 424134 425183 425480 426451 429098 432949 436080 437233 438671 441301 441611 442709 444930 445099 448585 449297 450364 452736 454098 456147 457074 457254 459578 461444 461619 462336 466703 466882 467988 468432 468853 469501 469741 470703 473193 473454 476728 477393 478922 479065 479550 480957 481156 481524 482568 483240 483735 487556 490951 492022 495751 498541 499922 501707 503054 506306 509035 509812 509898 512496 514430 520602 522328 524594 526013 526948 527917 531838 534135 536635 536641 541845 541858 548175 555886 557106 559515 564652 568262 568300 568301 572782 579190 587292 598318 598746 605285 607870 620330 621183 635207 678974 681731 683297 717644 731691 736796 782302 ] |
||||||||||||||||||||||||||||||
|
171.24 ms (42.09%) |
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 233647 323352 386716 387379 392721 398125 398237 401754 401809 404090 406010 412137 413098 418131 418351 418365 418750 420824 420858 421390 421617 423714 424134 425183 425480 426451 429098 432949 436080 437233 438671 441301 441611 442709 444930 445099 448585 449297 450364 452736 454098 456147 457074 457254 459578 461444 461619 462336 466703 466882 467988 468432 468853 469501 469741 470703 473193 473454 476728 477393 478922 479065 479550 480957 481156 481524 482568 483240 483735 487556 490951 492022 495751 498541 499922 501707 503054 506306 509035 509812 509898 512496 514430 520602 522328 524594 526013 526948 527917 531838 534135 536635 536641 541845 541858 548175 555886 557106 559515 564652 568262 568300 568301 572782 579190 587292 598318 598746 605285 607870 620330 621183 635207 678974 681731 683297 717644 731691 736796 782302 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (4.35%) |
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 398237 731691 233647 392721 478922 526013 442709 579190 681731 678974 598746 481524 469501 509812 432949 420824 467988 406010 503054 412137 501707 568301 473193 444930 483735 526948 683297 457254 441301 506306 564652 621183 421390 418351 423714 482568 782302 454098 536641 587292 426451 418750 462336 476728 495751 477393 436080 509898 520602 480957 717644 438671 386716 429098 425183 531838 479065 559515 441611 499922 541845 568262 437233 445099 468432 481156 498541 490951 387379 522328 404090 452736 466703 468853 449297 473454 466882 534135 548175 568300 598318 736796 413098 448585 401754 424134 456147 512496 483240 401809 461619 527917 555886 541858 572782 635207 605285 607870 620330 323352 398125 421617 450364 487556 492022 509035 536635 425480 418131 469741 457074 470703 514430 524594 557106 459578 479550 461444 418365 420858 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur webcam sex"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск вебкамер секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск вебкамер секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.41%) |
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.