Query Metrics
7
Database Queries
7
Different statements
141.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.60 ms (83.25%) |
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 399795 417954 418017 424169 425176 425345 425745 426647 426843 428704 428929 429231 429328 431694 437295 437993 438050 443605 443862 444661 444721 444987 445009 446663 447328 447515 447809 449171 451661 452548 455787 455971 456583 457241 459278 460540 460957 462797 463139 463403 463441 463895 465801 466248 466545 466594 466666 468186 469325 470233 470578 471163 471300 473327 473936 474272 475492 475962 476490 476582 476791 476930 478131 479207 479246 479387 479552 481043 483362 483620 485363 485505 486098 490504 491549 492233 492841 494017 494146 494413 495094 495600 497042 497071 497260 498855 498933 506190 512640 513219 516273 516912 518146 518288 518803 524461 525439 525919 526149 543831 559270 559503 559795 561313 561364 561368 563332 564963 565402 581754 583671 584793 586489 586532 587883 588252 588654 596459 599358 799714 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (10.44%) |
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 447328 463139 463441 475492 438050 466545 470578 471163 512640 516912 526149 485363 492233 518146 498933 513219 524461 425745 490504 494413 559270 559503 543831 564963 565402 596459 476490 425176 437295 449171 462797 476791 479387 446663 469325 476582 443605 417954 475962 478131 492841 518288 518803 494146 495094 506190 497260 457241 447515 497071 483620 588252 799714 470233 444661 445009 452548 443862 428929 426647 491549 494017 418017 466666 497042 581754 561313 559795 583671 586489 586532 599358 424169 429328 447809 479207 479552 481043 428704 429231 437993 459278 465801 466248 471300 473327 479246 425345 451661 455971 399795 444721 444987 516273 485505 486098 495600 483362 498855 525919 463403 473936 525439 563332 584793 561364 561368 588654 587883 455787 460540 474272 460957 468186 426843 431694 456583 463895 466594 476930 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.63%) |
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 399795 417954 418017 424169 425176 425345 425745 426647 426843 428704 428929 429231 429328 431694 437295 437993 438050 443605 443862 444661 444721 444987 445009 446663 447328 447515 447809 449171 451661 452548 455787 455971 456583 457241 459278 460540 460957 462797 463139 463403 463441 463895 465801 466248 466545 466594 466666 468186 469325 470233 470578 471163 471300 473327 473936 474272 475492 475962 476490 476582 476791 476930 478131 479207 479246 479387 479552 481043 483362 483620 485363 485505 486098 490504 491549 492233 492841 494017 494146 494413 495094 495600 497042 497071 497260 498855 498933 506190 512640 513219 516273 516912 518146 518288 518803 524461 525439 525919 526149 543831 559270 559503 559795 561313 561364 561368 563332 564963 565402 581754 583671 584793 586489 586532 587883 588252 588654 596459 599358 799714 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая русск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful russian"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.03%) |
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.