Query Metrics
7
Database Queries
7
Different statements
172.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.44 ms (85.13%) |
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 434412 437152 438056 438069 438077 438082 439746 440571 443669 443849 443898 444840 446218 446336 446813 452410 454038 455715 463996 464965 465405 466448 466884 468355 469146 469884 470007 470918 472393 472676 474265 478339 482466 483861 484246 484683 484981 486623 487260 487273 490437 491126 494577 495296 496733 499879 499995 500030 500067 502212 503104 503111 506161 508396 509746 510776 514066 515726 516486 516488 516490 516493 516500 517374 522445 522626 522645 525139 527197 527697 528203 528350 541994 545848 546059 546675 556704 559239 560453 565011 565886 565889 571433 571472 574408 584885 597123 616822 616947 619953 619982 621457 625035 628515 629580 629663 672835 724807 725661 733661 738363 739646 739981 743846 745136 761517 764194 778724 791067 791866 794273 799750 805259 810359 819695 819791 821804 824647 825711 826306 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (8.74%) |
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 455715 565886 791866 739646 764194 444840 500030 506161 516493 495296 514066 522645 672835 799750 739981 825711 556704 470007 824647 819695 778724 446218 559239 496733 434412 443849 438056 463996 443669 466448 525139 509746 597123 437152 545848 565011 616822 619982 629663 625035 805259 745136 761517 629580 794273 810359 452410 454038 499995 487273 503104 484981 733661 508396 438077 439746 516490 560453 440571 528203 478339 826306 819791 499879 619953 616947 469884 438069 474265 527697 527197 821804 724807 738363 565889 438082 443898 515726 571433 470918 487260 791067 546675 469146 472393 522445 541994 621457 628515 500067 503111 516488 517374 502212 446336 465405 468355 484683 510776 466884 472676 528350 483861 464965 486623 522626 516486 584885 484246 494577 490437 725661 743846 571472 482466 446813 491126 516500 574408 546059 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.73%) |
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 434412 437152 438056 438069 438077 438082 439746 440571 443669 443849 443898 444840 446218 446336 446813 452410 454038 455715 463996 464965 465405 466448 466884 468355 469146 469884 470007 470918 472393 472676 474265 478339 482466 483861 484246 484683 484981 486623 487260 487273 490437 491126 494577 495296 496733 499879 499995 500030 500067 502212 503104 503111 506161 508396 509746 510776 514066 515726 516486 516488 516490 516493 516500 517374 522445 522626 522645 525139 527197 527697 528203 528350 541994 545848 546059 546675 556704 559239 560453 565011 565886 565889 571433 571472 574408 584885 597123 616822 616947 619953 619982 621457 625035 628515 629580 629663 672835 724807 725661 733661 738363 739646 739981 743846 745136 761517 764194 778724 791067 791866 794273 799750 805259 810359 819695 819791 821804 824647 825711 826306 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен подборк"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife compilation"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
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.