Query Metrics
7
Database Queries
7
Different statements
197.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.24 ms (85.01%) |
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 389211 389519 389639 389895 391287 411518 412881 418293 419028 424190 427081 427087 427249 436444 437974 437997 438334 438767 442003 443068 443459 443499 443961 445320 446592 447390 450851 451279 452324 453524 455644 455875 456703 457629 459113 459727 466757 470746 473740 474271 475195 475571 475943 477094 478123 478207 480066 480629 480866 481816 487364 489667 491096 495327 495483 495999 499616 500210 501916 502896 505378 505525 509293 510855 510881 511841 512230 516875 517393 518317 520487 521201 521355 522578 523055 523128 525598 525709 525941 526809 526881 528263 528814 534027 534032 534571 534676 540696 555128 559618 567081 572337 591176 592263 598172 601990 608645 612614 613313 616089 620236 622773 623378 626405 634536 637445 637741 646838 647340 650624 651148 682866 683301 722796 727055 741760 751589 791505 805292 818071 ] |
||||||||||||||||||||||||||||||
|
18.07 ms (9.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 634536 805292 741760 727055 480629 419028 436444 451279 477094 427081 442003 475571 526809 499616 491096 459113 459727 495327 525709 443961 437997 455644 470746 391287 427249 505378 509293 522578 534571 495999 453524 818071 474271 567081 559618 683301 608645 791505 389639 438334 456703 411518 437974 478207 518317 526881 495483 501916 528814 525598 505525 626405 389211 466757 389519 517393 487364 534032 555128 572337 682866 650624 592263 612614 412881 480066 438767 418293 473740 478123 443499 446592 443068 475943 481816 502896 521201 521355 534676 510881 523055 489667 520487 523128 540696 480866 511841 637445 751589 475195 447390 455875 528263 500210 510855 512230 443459 450851 427087 457629 637741 452324 525941 445320 646838 601990 722796 424190 389895 516875 598172 622773 616089 534027 620236 613313 623378 647340 651148 591176 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (1.88%) |
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 389211 389519 389639 389895 391287 411518 412881 418293 419028 424190 427081 427087 427249 436444 437974 437997 438334 438767 442003 443068 443459 443499 443961 445320 446592 447390 450851 451279 452324 453524 455644 455875 456703 457629 459113 459727 466757 470746 473740 474271 475195 475571 475943 477094 478123 478207 480066 480629 480866 481816 487364 489667 491096 495327 495483 495999 499616 500210 501916 502896 505378 505525 509293 510855 510881 511841 512230 516875 517393 518317 520487 521201 521355 522578 523055 523128 525598 525709 525941 526809 526881 528263 528814 534027 534032 534571 534676 540696 555128 559618 567081 572337 591176 592263 598172 601990 608645 612614 613313 616089 620236 622773 623378 626405 634536 637445 637741 646838 647340 650624 651148 682866 683301 722796 727055 741760 751589 791505 805292 818071 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swallow russian"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глота русск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.