Query Metrics
7
Database Queries
7
Different statements
164.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.80 ms (81.21%) |
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 384342 385095 386756 389304 389525 397888 398160 416969 420266 424562 426793 437878 443423 443682 444136 448098 454151 466040 467817 474760 481913 486565 487096 498104 500472 507401 511009 512302 515568 523314 526107 535089 536096 543198 546732 556987 558056 559698 559914 565155 565351 568826 570204 572813 573676 576307 591273 596653 618899 635236 645268 652567 654439 656710 659306 659579 666590 668401 679143 680616 681621 688106 694537 699788 705702 708807 716996 718479 718655 719139 721767 724475 726918 727814 732167 736824 740331 742035 743877 747574 747904 750546 753800 755178 759668 760942 762739 764524 771610 775826 784198 785922 786513 794733 799463 800068 800956 802666 802871 804053 804563 804783 807513 808054 808790 813355 813713 814779 815371 815447 815941 817008 817190 818369 818413 820617 821771 822207 823018 826972 ] |
||||||||||||||||||||||||||||||
|
22.11 ms (13.42%) |
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 721767 800956 802666 804563 808054 474760 437878 565351 558056 543198 656710 526107 817190 820617 822207 823018 818369 818413 821771 826972 536096 481913 546732 652567 699788 666590 680616 694537 654439 679143 705702 708807 718479 559698 559914 576307 635236 596653 618899 800068 804783 813355 740331 742035 750546 753800 762739 747574 755178 760942 732167 743877 759668 736824 716996 785922 786513 802871 804053 808790 398160 498104 454151 535089 444136 486565 719139 500472 556987 511009 515568 386756 815371 817008 813713 815941 507401 565155 645268 681621 668401 688106 799463 727814 747904 726918 771610 775826 794733 443423 443682 384342 397888 426793 448098 466040 467817 512302 416969 815447 764524 724475 659306 659579 814779 487096 572813 718655 807513 424562 420266 573676 568826 570204 591273 784198 523314 385095 389304 389525 ] |
||||||||||||||||||||||||||||||
|
2.90 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 384342 385095 386756 389304 389525 397888 398160 416969 420266 424562 426793 437878 443423 443682 444136 448098 454151 466040 467817 474760 481913 486565 487096 498104 500472 507401 511009 512302 515568 523314 526107 535089 536096 543198 546732 556987 558056 559698 559914 565155 565351 568826 570204 572813 573676 576307 591273 596653 618899 635236 645268 652567 654439 656710 659306 659579 666590 668401 679143 680616 681621 688106 694537 699788 705702 708807 716996 718479 718655 719139 721767 724475 726918 727814 732167 736824 740331 742035 743877 747574 747904 750546 753800 755178 759668 760942 762739 764524 771610 775826 784198 785922 786513 794733 799463 800068 800956 802666 802871 804053 804563 804783 807513 808054 808790 813355 813713 814779 815371 815447 815941 817008 817190 818369 818413 820617 821771 822207 823018 826972 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking tits"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.74%) |
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.