Query Metrics
7
Database Queries
7
Different statements
173.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.89 ms (83.36%) |
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 7308 270601 406472 421629 424566 432997 443427 443693 444259 458774 461437 462091 462521 466209 466273 467968 470341 470790 473947 473995 476387 484633 486306 486509 492239 493897 495417 496040 501874 504552 513277 513304 513690 516261 524252 524664 526114 550001 552075 552430 558040 558861 561659 561714 565173 565279 565324 569453 574482 574867 575210 575423 576027 576058 576071 576271 579370 580678 581384 590413 594048 595851 596347 597045 597992 598688 609895 615514 653527 654397 654423 659448 662407 670462 670987 677337 683291 695402 704028 713076 713441 718658 721294 721334 722632 725169 730623 736066 740083 741231 741981 741983 747435 747517 748327 748524 751043 754106 754221 754698 762262 773657 774081 774083 774085 774111 776807 777564 777808 778688 779234 779254 780123 782676 782699 782725 786274 786770 800248 812402 ] |
||||||||||||||||||||||||||||||
|
19.36 ms (11.14%) |
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 552430 670462 695402 670987 654397 677337 552075 786274 786770 782699 730623 741981 748524 741231 747435 774083 754698 754106 773657 777564 777808 780123 526114 473995 424566 501874 558040 576271 574482 574867 576027 576071 561659 558861 580678 596347 432997 458774 467968 462091 443427 513277 486509 493897 565324 466209 524664 495417 484633 496040 470790 659448 595851 597992 762262 443693 722632 713441 662407 704028 713076 721294 653527 609895 615514 778688 779254 812402 782725 800248 740083 747517 782676 736066 748327 774111 754221 741983 774081 774085 751043 779234 598688 462521 7308 444259 406472 597045 473947 575423 581384 683291 654423 594048 776807 725169 718658 721334 270601 470341 524252 513690 466273 486306 492239 504552 579370 565173 576058 561714 565279 569453 575210 550001 590413 421629 461437 476387 513304 516261 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.80%) |
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 7308 270601 406472 421629 424566 432997 443427 443693 444259 458774 461437 462091 462521 466209 466273 467968 470341 470790 473947 473995 476387 484633 486306 486509 492239 493897 495417 496040 501874 504552 513277 513304 513690 516261 524252 524664 526114 550001 552075 552430 558040 558861 561659 561714 565173 565279 565324 569453 574482 574867 575210 575423 576027 576058 576071 576271 579370 580678 581384 590413 594048 595851 596347 597045 597992 598688 609895 615514 653527 654397 654423 659448 662407 670462 670987 677337 683291 695402 704028 713076 713441 718658 721294 721334 722632 725169 730623 736066 740083 741231 741981 741983 747435 747517 748327 748524 751043 754106 754221 754698 762262 773657 774081 774083 774085 774111 776807 777564 777808 778688 779234 779254 780123 782676 782699 782725 786274 786770 800248 812402 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское кастинг порно…"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск кастинг порн"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.79%) |
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.