Query Metrics
7
Database Queries
7
Different statements
178.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.08 ms (84.80%) |
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 424190 427087 427249 437959 437974 437997 438334 438767 443068 443459 443499 443961 445320 445961 446592 447390 450851 452324 453524 455644 455875 456703 457629 459113 459727 466757 470746 473740 474271 475165 475195 475943 478123 478207 480066 480866 481816 487364 487578 489667 495327 495483 495999 500210 501916 502896 505378 505525 509293 510855 510881 511841 512230 516875 517393 518317 520487 521201 521355 522578 523055 523128 525598 525709 525941 526881 528263 528814 533746 533783 534027 534032 534571 534676 535595 540696 543652 555128 559618 567081 572337 591176 592263 598172 600094 601990 602199 608645 612614 613313 616089 620236 622773 623378 626405 631247 636295 637445 637741 638985 646838 647340 647936 650624 651148 682866 683264 683301 722796 751589 791505 818071 ] |
||||||||||||||||||||||||||||||
|
17.42 ms (9.78%) |
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 459113 459727 495327 525709 602199 443961 437997 455644 470746 391287 427249 475165 505378 509293 522578 534571 495999 437959 453524 818071 474271 567081 559618 683301 608645 600094 791505 389639 438334 456703 411518 437974 478207 518317 526881 495483 501916 528814 525598 505525 626405 389211 466757 389519 445961 517393 487364 487578 533783 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 535595 637741 638985 452324 525941 543652 445320 646838 601990 631247 722796 424190 389895 516875 598172 622773 647936 683264 636295 616089 534027 620236 613313 623378 647340 651148 533746 591176 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.76%) |
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 424190 427087 427249 437959 437974 437997 438334 438767 443068 443459 443499 443961 445320 445961 446592 447390 450851 452324 453524 455644 455875 456703 457629 459113 459727 466757 470746 473740 474271 475165 475195 475943 478123 478207 480066 480866 481816 487364 487578 489667 495327 495483 495999 500210 501916 502896 505378 505525 509293 510855 510881 511841 512230 516875 517393 518317 520487 521201 521355 522578 523055 523128 525598 525709 525941 526881 528263 528814 533746 533783 534027 534032 534571 534676 535595 540696 543652 555128 559618 567081 572337 591176 592263 598172 600094 601990 602199 608645 612614 613313 616089 620236 622773 623378 626405 631247 636295 637445 637741 638985 646838 647340 647936 650624 651148 682866 683264 683301 722796 751589 791505 818071 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск глота"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian swallow"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.67%) |
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.