Query Metrics
7
Database Queries
7
Different statements
220.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.29 ms (88.18%) |
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 382934 435596 435603 435621 464933 465646 484783 486141 508759 508905 512415 514226 536185 542235 544874 544876 544899 545149 545150 548917 549040 550912 556140 559313 560047 565031 569266 575378 575381 576497 576791 576880 585359 587491 587657 589593 589614 591924 600731 610263 617578 617729 627077 629557 637318 641010 655452 660817 664224 666077 668957 692756 693695 707478 708548 708594 709865 710222 712257 714703 720071 726448 735506 736014 736310 736691 737868 737889 739305 745206 745276 745715 746820 748262 748280 748290 748299 748311 748648 749685 749830 750654 750975 751419 753223 755080 757039 762182 766515 768234 768278 773747 774661 774674 776065 781269 782485 782769 784710 785367 785651 787755 788530 788531 788662 792258 795902 796378 796388 796803 797086 800116 806194 806811 806821 812312 816878 817885 818359 827499 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (6.95%) |
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 508759 585359 587491 600731 788662 773747 774661 817885 465646 484783 536185 576791 545150 569266 575378 544874 544876 556140 559313 655452 664224 714703 720071 668957 693695 709865 710222 589593 617729 629557 591924 637318 587657 589614 617578 627077 782769 787755 788530 806821 782485 785367 785651 788531 792258 797086 800116 812312 736310 737868 739305 746820 748280 748299 748311 755080 757039 781269 795902 796378 796803 806194 736691 745206 745276 748262 750654 753223 762182 768234 735506 748648 750975 766515 726448 749830 768278 736014 748290 749685 751419 641010 776065 784710 796388 806811 708594 707478 737889 486141 464933 660817 666077 610263 745715 774674 435621 382934 435603 435596 818359 827499 816878 514226 508905 512415 565031 576497 542235 544899 545149 548917 549040 560047 575381 550912 576880 692756 708548 712257 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.61%) |
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 382934 435596 435603 435621 464933 465646 484783 486141 508759 508905 512415 514226 536185 542235 544874 544876 544899 545149 545150 548917 549040 550912 556140 559313 560047 565031 569266 575378 575381 576497 576791 576880 585359 587491 587657 589593 589614 591924 600731 610263 617578 617729 627077 629557 637318 641010 655452 660817 664224 666077 668957 692756 693695 707478 708548 708594 709865 710222 712257 714703 720071 726448 735506 736014 736310 736691 737868 737889 739305 745206 745276 745715 746820 748262 748280 748290 748299 748311 748648 749685 749830 750654 750975 751419 753223 755080 757039 762182 766515 768234 768278 773747 774661 774674 776065 781269 782485 782769 784710 785367 785651 787755 788530 788531 788662 792258 795902 796378 796388 796803 797086 800116 806194 806811 806821 812312 816878 817885 818359 827499 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"clit masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"clit мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"clit мастурбац"
]
|
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.