Query Metrics
7
Database Queries
7
Different statements
432.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.45 ms (50.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
188.72 ms (43.67%) |
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 382918 397200 413106 414123 417530 417952 417955 422602 423247 426628 429040 434616 435748 440711 443056 443488 446370 448041 463770 466784 468594 474021 476610 478431 478442 480266 484097 484400 485308 487089 487114 491059 491661 491849 493876 496176 501979 503941 505878 508827 508857 508876 508989 511332 511706 512576 514609 517937 518668 519682 524207 524430 527607 527623 528092 529054 536463 539101 544963 546840 550096 550560 551256 552064 552131 552602 553946 554366 559150 559198 565842 567223 568498 569761 569766 572011 573582 575453 575482 575750 575754 576655 577543 578785 578910 582829 586803 588048 588568 597113 600402 601223 601829 602783 604329 606694 611336 612055 616000 623842 643233 643653 650607 654626 662009 701325 714851 728384 736470 748660 770200 788923 789877 799661 799793 804913 819608 819613 825563 825781 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (3.94%) |
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 551256 539101 819608 476610 616000 529054 575482 569761 559198 565842 429040 417952 435748 819613 519682 527607 463770 491849 544963 552131 559150 701325 601829 611336 799793 789877 728384 480266 508876 518668 512576 485308 528092 567223 578785 554366 597113 600402 623842 417955 508989 443488 413106 422602 825781 825563 501979 491059 553946 550096 575453 577543 552064 582829 714851 654626 573582 575754 578910 588568 643653 601223 748660 804913 440711 397200 448041 527623 491661 524207 524430 503941 514609 484400 487089 487114 508827 511332 569766 572011 588048 602783 417530 423247 468594 508857 511706 484097 505878 382918 414123 434616 443056 446370 466784 478442 517937 536463 496176 493876 575750 568498 546840 576655 650607 662009 550560 552602 604329 606694 612055 643233 586803 799661 788923 770200 736470 478431 474021 426628 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (0.68%) |
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 382918 397200 413106 414123 417530 417952 417955 422602 423247 426628 429040 434616 435748 440711 443056 443488 446370 448041 463770 466784 468594 474021 476610 478431 478442 480266 484097 484400 485308 487089 487114 491059 491661 491849 493876 496176 501979 503941 505878 508827 508857 508876 508989 511332 511706 512576 514609 517937 518668 519682 524207 524430 527607 527623 528092 529054 536463 539101 544963 546840 550096 550560 551256 552064 552131 552602 553946 554366 559150 559198 565842 567223 568498 569761 569766 572011 573582 575453 575482 575750 575754 576655 577543 578785 578910 582829 586803 588048 588568 597113 600402 601223 601829 602783 604329 606694 611336 612055 616000 623842 643233 643653 650607 654626 662009 701325 714851 728384 736470 748660 770200 788923 789877 799661 799793 804913 819608 819613 825563 825781 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl bondage"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.41%) |
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.