Query Metrics
7
Database Queries
7
Different statements
173.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.47 ms (84.49%) |
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 20180 361286 388144 389243 396278 405203 405990 418009 419910 419914 420025 420252 420893 420910 422561 422587 422767 422847 423009 423021 425694 426171 428479 429025 429764 433152 435727 445473 452221 452434 452441 452444 453019 457498 458094 458327 458341 459264 460051 463753 475443 477216 477404 482621 488379 492573 497382 498620 499040 499212 501865 504722 508962 511249 511264 511271 512192 512223 516816 525197 526789 527110 533660 537732 537932 542553 544405 549861 551086 552018 555904 556393 558361 558410 559163 559912 561079 561888 565211 565473 566067 568531 574959 575308 575329 576858 578293 578420 580272 586648 592380 592673 595906 595952 597275 597864 598252 599116 600575 600627 604319 607705 622645 623446 630731 642841 649384 653247 654369 665909 672264 695183 706946 709688 712158 740804 761566 768086 819082 820340 ] |
||||||||||||||||||||||||||||||
|
17.63 ms (10.17%) |
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 419914 565211 452444 498620 533660 508962 558361 695183 604319 607705 426171 544405 458327 819082 820340 388144 497382 600575 420893 558410 419910 418009 511249 435727 361286 429025 420252 422767 460051 552018 555904 556393 559163 559912 578420 549861 566067 568531 574959 576858 706946 712158 649384 653247 654369 709688 565473 578293 600627 642841 586648 592380 595906 597275 599116 622645 630731 761566 768086 740804 463753 20180 425694 420025 525197 428479 477404 561079 475443 512223 422587 429764 561888 389243 405990 420910 422561 423021 433152 422847 482621 445473 452221 452434 458341 459264 452441 511264 512192 504722 511271 537732 499040 526789 527110 537932 542553 551086 575329 580272 592673 598252 623446 595952 597864 423009 453019 396278 458094 405203 477216 457498 488379 492573 499212 501865 516816 575308 672264 665909 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.61%) |
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 20180 361286 388144 389243 396278 405203 405990 418009 419910 419914 420025 420252 420893 420910 422561 422587 422767 422847 423009 423021 425694 426171 428479 429025 429764 433152 435727 445473 452221 452434 452441 452444 453019 457498 458094 458327 458341 459264 460051 463753 475443 477216 477404 482621 488379 492573 497382 498620 499040 499212 501865 504722 508962 511249 511264 511271 512192 512223 516816 525197 526789 527110 533660 537732 537932 542553 544405 549861 551086 552018 555904 556393 558361 558410 559163 559912 561079 561888 565211 565473 566067 568531 574959 575308 575329 576858 578293 578420 580272 586648 592380 592673 595906 595952 597275 597864 598252 599116 600575 600627 604319 607705 622645 623446 630731 642841 649384 653247 654369 665909 672264 695183 706946 709688 712158 740804 761566 768086 819082 820340 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock asian"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock азиатк"
]
|
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.