Query Metrics
7
Database Queries
7
Different statements
145.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.55 ms (83.60%) |
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 3793 79720 391868 410435 417068 422495 423790 428777 444934 447216 451506 455850 456277 459208 460457 461732 466060 469026 470828 473118 475996 477188 477794 481244 546572 553242 573291 584226 587963 588060 588173 589085 590485 591207 592838 593151 597929 599360 600358 603708 605002 608273 611573 612247 616995 618137 620235 621099 623461 623948 624599 626489 627721 630507 632696 633737 635041 640905 659350 678180 679306 680572 680579 682296 682321 689156 690744 695914 697720 701220 701613 701875 702635 702954 704261 707616 711555 712869 717986 723874 726177 727056 733231 733498 740115 740207 740531 745805 746331 748609 756804 759958 760973 766903 769866 771068 774245 775173 777172 781003 781621 782301 782978 788828 790844 794090 795963 795989 796011 800562 800565 802001 803485 804524 805141 805152 807510 809519 810706 811621 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (10.37%) |
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 678180 680579 682296 682321 689156 695914 697720 701613 711555 680572 701875 712869 659350 679306 690744 701220 702954 707616 717986 546572 553242 573291 584226 589085 590485 591207 592838 597929 612247 618137 630507 633737 599360 611573 616995 620235 621099 623948 624599 635041 600358 603708 627721 587963 588060 588173 593151 605002 608273 626489 781003 790844 794090 796011 800562 800565 805141 810706 775173 782301 782978 809519 811621 740115 759958 795963 795989 802001 805152 740531 745805 746331 748609 723874 740207 760973 774245 733231 771068 726177 727056 733498 756804 766903 769866 623461 632696 640905 702635 704261 777172 781621 788828 803485 804524 807510 3793 423790 447216 459208 473118 477794 417068 422495 444934 451506 455850 456277 460457 461732 466060 469026 470828 475996 477188 481244 79720 391868 410435 428777 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.80%) |
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 3793 79720 391868 410435 417068 422495 423790 428777 444934 447216 451506 455850 456277 459208 460457 461732 466060 469026 470828 473118 475996 477188 477794 481244 546572 553242 573291 584226 587963 588060 588173 589085 590485 591207 592838 593151 597929 599360 600358 603708 605002 608273 611573 612247 616995 618137 620235 621099 623461 623948 624599 626489 627721 630507 632696 633737 635041 640905 659350 678180 679306 680572 680579 682296 682321 689156 690744 695914 697720 701220 701613 701875 702635 702954 704261 707616 711555 712869 717986 723874 726177 727056 733231 733498 740115 740207 740531 745805 746331 748609 756804 759958 760973 766903 769866 771068 774245 775173 777172 781003 781621 782301 782978 788828 790844 794090 795963 795989 796011 800562 800565 802001 803485 804524 805141 805152 807510 809519 810706 811621 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum-in-mouth"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum mouth"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum mouth"
]
|
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.