Query Metrics
7
Database Queries
7
Different statements
214.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.29 ms (87.27%) |
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 5565 38637 53755 219957 386844 389165 391056 396781 398053 398660 399563 399739 400425 401477 401632 403099 406867 412716 413208 413244 413270 415533 416016 418017 419197 419816 420619 421238 421652 422704 425757 428617 430064 430969 443351 447124 454127 457734 461524 461531 464427 464939 468527 468577 468692 470341 471342 471723 472918 474840 476761 477734 477869 478554 480009 480231 483323 484434 484754 488814 489584 489863 491478 492158 492749 495473 499957 500715 505031 506344 511759 512639 516605 517998 518723 518942 519427 520327 521964 525216 525739 535570 536876 542206 551430 554978 556807 558045 565991 567666 570674 588683 589720 594118 597078 600311 601970 620852 676527 693355 697322 709848 712715 720031 722869 725891 727396 736380 755416 759306 761797 777169 779190 779557 795251 800902 806961 812415 814014 819050 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (7.91%) |
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 620852 428617 468692 420619 800902 558045 401632 589720 480009 697322 398053 570674 492158 516605 521964 536876 567666 421652 464427 412716 461524 489863 542206 676527 386844 806961 425757 484754 491478 478554 489584 525216 518942 727396 693355 594118 812415 468527 720031 5565 759306 814014 535570 777169 398660 421238 399739 484434 525739 474840 464939 396781 399563 406867 389165 401477 413270 779190 418017 565991 443351 492749 499957 519427 454127 597078 430969 470341 461531 506344 471723 511759 413244 471342 480231 476761 422704 413208 556807 588683 419816 472918 457734 736380 416016 415533 709848 495473 488814 712715 403099 779557 391056 219957 725891 38637 53755 554978 551430 755416 505031 722869 400425 477734 468577 512639 500715 795251 430064 601970 477869 600311 520327 419197 483323 518723 447124 819050 761797 517998 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.37%) |
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 5565 38637 53755 219957 386844 389165 391056 396781 398053 398660 399563 399739 400425 401477 401632 403099 406867 412716 413208 413244 413270 415533 416016 418017 419197 419816 420619 421238 421652 422704 425757 428617 430064 430969 443351 447124 454127 457734 461524 461531 464427 464939 468527 468577 468692 470341 471342 471723 472918 474840 476761 477734 477869 478554 480009 480231 483323 484434 484754 488814 489584 489863 491478 492158 492749 495473 499957 500715 505031 506344 511759 512639 516605 517998 518723 518942 519427 520327 521964 525216 525739 535570 536876 542206 551430 554978 556807 558045 565991 567666 570674 588683 589720 594118 597078 600311 601970 620852 676527 693355 697322 709848 712715 720031 722869 725891 727396 736380 755416 759306 761797 777169 779190 779557 795251 800902 806961 812415 814014 819050 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful tits sex"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая сиськ секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.75%) |
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.