Query Metrics
7
Database Queries
7
Different statements
148.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.17 ms (82.71%) |
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 385436 391567 396188 402217 413092 415205 418434 422334 426673 428302 447327 447405 447501 447528 447799 450690 451688 470337 470341 475894 484342 501809 505021 510676 512645 512653 519725 527800 535648 548706 549777 552161 552224 552227 552423 552518 553586 559021 559032 561668 561710 565957 568311 570365 570531 570593 570613 572030 573078 573430 573901 574848 574871 574874 575070 575071 575495 575727 575735 576276 576285 576330 580688 585910 595375 595450 595493 595519 595865 597114 597504 598021 598535 598722 598734 598777 598788 598798 598813 598822 600073 617651 623175 635064 652978 654610 657316 659116 670991 674216 675464 677340 677343 678915 679051 686786 701012 705313 712713 721366 721419 721426 722542 722890 739073 741249 742473 742937 743179 751067 753806 753895 754197 768042 778380 782184 784204 799780 805939 823359 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (10.13%) |
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 768042 742473 617651 778380 782184 598798 549777 652978 678915 598777 595519 595493 572030 575071 575727 580688 548706 559021 559032 570365 552224 552518 574871 574874 576276 552423 570531 576285 595865 585910 598535 598021 597504 451688 418434 570593 573078 573901 552227 570613 623175 597114 595450 600073 512653 535648 568311 659116 657316 686786 705313 675464 799780 805939 742937 743179 784204 741249 754197 598813 823359 575495 574848 722890 712713 721419 565957 598788 598734 751067 739073 753806 753895 635064 701012 426673 402217 391567 413092 501809 527800 598822 598722 595375 396188 415205 450690 484342 519725 575735 561668 561710 475894 470337 428302 447327 447405 447528 510676 505021 385436 447799 470341 422334 447501 512645 553586 573430 552161 575070 576330 677340 679051 721366 722542 654610 670991 677343 721426 674216 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (2.12%) |
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 385436 391567 396188 402217 413092 415205 418434 422334 426673 428302 447327 447405 447501 447528 447799 450690 451688 470337 470341 475894 484342 501809 505021 510676 512645 512653 519725 527800 535648 548706 549777 552161 552224 552227 552423 552518 553586 559021 559032 561668 561710 565957 568311 570365 570531 570593 570613 572030 573078 573430 573901 574848 574871 574874 575070 575071 575495 575727 575735 576276 576285 576330 580688 585910 595375 595450 595493 595519 595865 597114 597504 598021 598535 598722 598734 598777 598788 598798 598813 598822 600073 617651 623175 635064 652978 654610 657316 659116 670991 674216 675464 677340 677343 678915 679051 686786 701012 705313 712713 721366 721419 721426 722542 722890 739073 741249 742473 742937 743179 751067 753806 753895 754197 768042 778380 782184 784204 799780 805939 823359 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian small teen"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск маленькая teen"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск маленькая teen"
]
|
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.