Query Metrics
7
Database Queries
7
Different statements
146.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.20 ms (82.98%) |
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 474485 543495 547913 549764 549774 557993 562287 562824 562827 562840 562963 562981 563169 563197 563415 563453 563455 567391 572542 574265 576646 577372 581386 583860 583902 590950 591641 592388 592390 592462 592465 592486 593173 595735 595888 603187 605007 605328 605344 606290 610310 615459 615565 619406 620152 620163 620169 620170 622364 623934 624395 629326 644278 644289 644303 644306 644310 644311 644314 644321 644324 644379 649091 649147 650853 651154 651604 661891 670093 670098 671737 671741 671749 671756 671757 671759 672122 672372 674081 677707 677729 677730 680633 684029 684030 691820 691992 692293 692315 692455 692786 692812 693056 694032 694119 694374 698457 699596 699694 699718 703039 703051 703080 703096 703509 703540 705549 705875 705878 706946 708468 712006 716244 716405 716659 722211 727794 730409 744259 807976 ] |
||||||||||||||||||||||||||||||
|
13.62 ms (9.32%) |
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 577372 583902 543495 547913 557993 562287 562840 562981 563169 563455 574265 576646 581386 649147 671756 671759 672372 677707 680633 693056 699596 699694 703051 703096 705878 706946 716405 650853 670098 671737 671749 674081 684029 691820 691992 692455 694119 698457 703080 703509 705549 716244 649091 651604 661891 670093 671741 671757 672122 677729 677730 684030 692293 692315 692786 692812 694032 694374 699718 703540 705875 708468 722211 549764 549774 562824 562827 562963 563197 563415 563453 567391 572542 583860 591641 592390 592486 595735 610310 590950 592462 592465 615459 615565 619406 622364 644379 592388 595888 603187 620170 623934 644314 644321 605007 605328 605344 606290 620152 620163 624395 644311 730409 744259 727794 620169 629326 644278 644289 644303 644306 644310 644324 703039 712006 716659 807976 474485 651154 593173 ] |
||||||||||||||||||||||||||||||
|
3.80 ms (2.60%) |
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 474485 543495 547913 549764 549774 557993 562287 562824 562827 562840 562963 562981 563169 563197 563415 563453 563455 567391 572542 574265 576646 577372 581386 583860 583902 590950 591641 592388 592390 592462 592465 592486 593173 595735 595888 603187 605007 605328 605344 606290 610310 615459 615565 619406 620152 620163 620169 620170 622364 623934 624395 629326 644278 644289 644303 644306 644310 644311 644314 644321 644324 644379 649091 649147 650853 651154 651604 661891 670093 670098 671737 671741 671749 671756 671757 671759 672122 672372 674081 677707 677729 677730 680633 684029 684030 691820 691992 692293 692315 692455 692786 692812 693056 694032 694119 694374 698457 699596 699694 699718 703039 703051 703080 703096 703509 703540 705549 705875 705878 706946 708468 712006 716244 716405 716659 722211 727794 730409 744259 807976 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm vintage"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм vintage"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм vintage"
]
|
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.