Query Metrics
7
Database Queries
7
Different statements
213.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.27 ms (86.93%) |
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 391992 397437 408911 410694 412855 413392 415885 416531 416690 432670 432674 432680 438455 440659 441037 446447 447597 448115 448854 452780 459198 459403 465148 475457 477761 483737 493861 512852 513830 514117 514233 516843 525279 531806 535294 535363 542413 543897 547556 547925 551543 552704 554827 554983 560012 563310 565621 565701 567127 567508 575844 575956 582636 585272 587576 592046 592259 592632 594053 602897 605566 608650 618799 619590 630091 634686 641806 650719 650770 656879 659209 659944 675897 678707 682822 686331 702319 711611 716086 720024 722382 722398 739139 744047 746191 749134 750998 754456 759052 761265 766285 770261 771887 780309 781424 782749 783600 786019 790192 793119 794316 794706 796692 796709 797035 797039 797886 798593 800530 800649 803506 806139 806828 807570 807642 809330 809660 811330 811714 812275 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (6.40%) |
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 514233 432680 391992 477761 459198 410694 711611 656879 585272 475457 531806 565701 567508 575956 650719 650770 560012 619590 782749 786019 797886 807570 811714 790192 794706 796692 797035 798593 800649 759052 761265 766285 781424 783600 809330 809660 811330 812275 750998 746191 754456 749134 780309 793119 794316 796709 797039 800530 806139 806828 807642 682822 686331 659944 592632 594053 602897 608650 618799 641806 605566 634686 587576 675897 678707 412855 432674 415885 448854 483737 567127 547556 552704 592046 592259 630091 413392 465148 441037 513830 493861 542413 575844 771887 512852 397437 416531 408911 416690 432670 446447 459403 448115 535294 516843 565621 543897 554983 582636 659209 722382 803506 744047 770261 739139 447597 452780 440659 438455 525279 535363 514117 563310 547925 551543 702319 716086 720024 722398 554827 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (1.81%) |
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 391992 397437 408911 410694 412855 413392 415885 416531 416690 432670 432674 432680 438455 440659 441037 446447 447597 448115 448854 452780 459198 459403 465148 475457 477761 483737 493861 512852 513830 514117 514233 516843 525279 531806 535294 535363 542413 543897 547556 547925 551543 552704 554827 554983 560012 563310 565621 565701 567127 567508 575844 575956 582636 585272 587576 592046 592259 592632 594053 602897 605566 608650 618799 619590 630091 634686 641806 650719 650770 656879 659209 659944 675897 678707 682822 686331 702319 711611 716086 720024 722382 722398 739139 744047 746191 749134 750998 754456 759052 761265 766285 770261 771887 780309 781424 782749 783600 786019 790192 793119 794316 794706 796692 796709 797035 797039 797886 798593 800530 800649 803506 806139 806828 807570 807642 809330 809660 811330 811714 812275 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (1.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home made dildo"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.68%) |
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.