Query Metrics
7
Database Queries
7
Different statements
172.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.90 ms (83.22%) |
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 38637 162863 384519 384543 384908 386677 395662 398660 398920 399739 399837 402056 402080 403308 403346 403628 406867 408447 410435 413294 413485 413706 417907 420047 420130 421238 421652 424952 429169 430920 430969 443351 445220 448014 451382 454015 457378 457509 460211 462056 463667 465794 466078 466682 474500 474840 475584 476761 477869 480009 480231 483323 484754 487824 492749 495231 495582 496008 499291 499957 500736 507903 516605 518208 518942 519427 525739 531626 533030 537386 538189 554978 562398 563229 565193 567666 582852 593227 593285 600191 600895 601772 604928 617096 620402 620475 620852 628720 631657 639888 642155 678369 681876 683670 690308 694110 694438 697135 710689 722853 723444 727396 733767 741298 742651 744717 755416 756371 759306 764693 764869 767101 777169 779557 780218 788182 798177 798863 799508 808607 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (9.89%) |
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 398920 484754 554978 710689 727396 417907 690308 480009 492749 519427 430969 495582 694438 600191 620475 531626 451382 563229 496008 628720 518208 399837 722853 474500 495231 567666 620852 421652 410435 788182 538189 694110 413706 403628 395662 413294 518942 780218 487824 443351 499957 500736 384519 537386 593227 457509 462056 562398 480231 476761 642155 733767 384543 678369 759306 402056 639888 798863 755416 799508 474840 777169 582852 756371 499291 764693 386677 430920 399739 420047 525739 421238 402080 403346 162863 617096 384908 466682 477869 507903 466078 808607 779557 429169 565193 483323 631657 601772 764869 533030 516605 420130 723444 475584 424952 620402 593285 600895 413485 457378 463667 460211 681876 454015 767101 448014 683670 604928 741298 742651 403308 38637 398660 697135 406867 408447 445220 798177 744717 465794 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.74 ms (1.59%) |
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 38637 162863 384519 384543 384908 386677 395662 398660 398920 399739 399837 402056 402080 403308 403346 403628 406867 408447 410435 413294 413485 413706 417907 420047 420130 421238 421652 424952 429169 430920 430969 443351 445220 448014 451382 454015 457378 457509 460211 462056 463667 465794 466078 466682 474500 474840 475584 476761 477869 480009 480231 483323 484754 487824 492749 495231 495582 496008 499291 499957 500736 507903 516605 518208 518942 519427 525739 531626 533030 537386 538189 554978 562398 563229 565193 567666 582852 593227 593285 600191 600895 601772 604928 617096 620402 620475 620852 628720 631657 639888 642155 678369 681876 683670 690308 694110 694438 697135 710689 722853 723444 727396 733767 741298 742651 744717 755416 756371 759306 764693 764869 767101 777169 779557 780218 788182 798177 798863 799508 808607 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful big tits"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.04%) |
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.