Query Metrics
7
Database Queries
7
Different statements
155.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.31 ms (81.70%) |
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 118226 381903 391756 396130 401768 401769 402619 403973 414292 414601 415964 416537 416738 419891 424581 427539 428223 428255 429859 439056 440016 440032 440041 440052 441093 441108 441124 441849 444281 445397 446533 446797 448795 449075 451775 452637 452815 453822 454304 456240 459203 459659 460209 468680 470405 471685 471696 473450 474265 475335 478508 478510 487416 488713 492181 493749 502457 505137 505800 507956 508882 508916 510807 515053 519722 527920 527926 530310 534119 534555 534567 535438 536377 540680 541278 541322 544140 547236 547466 547473 547481 547485 547494 547502 553646 556338 556876 556884 561021 561038 571166 573197 574951 587407 590281 590299 592576 619102 622693 624925 628106 630564 634068 641997 656186 660362 660399 660410 665957 669067 710709 713184 738814 752626 761176 788181 797197 800282 827326 827721 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (11.80%) |
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 788181 800282 473450 535438 571166 471685 544140 547236 590299 797197 761176 419891 452637 460209 547466 556876 515053 738814 440041 429859 414292 440016 541278 547481 556338 547494 561038 573197 660399 752626 454304 827326 541322 391756 381903 441124 471696 493749 415964 530310 556884 641997 502457 510807 428223 478510 527920 669067 451775 403973 459659 396130 656186 660362 592576 534555 444281 446797 665957 561021 456240 401769 710709 508916 574951 508882 827721 488713 441093 416738 427539 428255 439056 519722 505137 630564 449075 424581 505800 507956 474265 534119 401768 624925 118226 416537 414601 487416 534567 459203 619102 440032 440052 492181 446533 540680 527926 445397 441849 478508 402619 547473 547485 660410 590281 468680 453822 536377 475335 547502 553646 587407 634068 628106 452815 470405 713184 441108 448795 622693 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.02%) |
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 118226 381903 391756 396130 401768 401769 402619 403973 414292 414601 415964 416537 416738 419891 424581 427539 428223 428255 429859 439056 440016 440032 440041 440052 441093 441108 441124 441849 444281 445397 446533 446797 448795 449075 451775 452637 452815 453822 454304 456240 459203 459659 460209 468680 470405 471685 471696 473450 474265 475335 478508 478510 487416 488713 492181 493749 502457 505137 505800 507956 508882 508916 510807 515053 519722 527920 527926 530310 534119 534555 534567 535438 536377 540680 541278 541322 544140 547236 547466 547473 547481 547485 547494 547502 553646 556338 556876 556884 561021 561038 571166 573197 574951 587407 590281 590299 592576 619102 622693 624925 628106 630564 634068 641997 656186 660362 660399 660410 665957 669067 710709 713184 738814 752626 761176 788181 797197 800282 827326 827721 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur fisting anal"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск фистинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск фистинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.