Query Metrics
7
Database Queries
7
Different statements
175.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.68 ms (82.94%) |
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 95982 384124 392687 395676 396329 409035 409083 411045 411352 415342 419617 421897 422185 422358 437663 439687 439765 442970 444733 445243 445661 459611 460811 469096 469472 475273 477548 477691 479860 480296 480398 481772 483646 489171 489381 493174 493191 494333 495228 497699 503115 507003 509809 511592 513158 513992 514254 516712 516940 519958 523837 523848 523881 530737 531789 532444 538007 549825 558261 558514 559953 563009 563642 568453 568543 569546 570753 576686 579171 580008 581091 583607 583866 585477 590813 592392 592462 598169 603890 604109 618619 620163 620208 627338 631243 636271 647162 656523 665929 696426 699516 707315 709645 716550 716765 737633 737726 749242 751546 765860 773474 775960 775967 776940 797657 802256 803306 803819 805557 809292 810069 810299 811475 814783 815214 815442 816115 821036 823809 825762 ] |
||||||||||||||||||||||||||||||
|
19.00 ms (10.82%) |
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 592392 598169 631243 775960 809292 810299 811475 775967 805557 737726 603890 776940 411352 479860 421897 384124 444733 516712 519958 493191 495228 493174 507003 489171 489381 494333 523837 439765 409035 590813 627338 445243 422358 656523 803819 411045 815442 823809 816115 814783 815214 821036 530737 514254 523881 532444 531789 469096 583866 563009 696426 699516 716550 665929 707315 709645 583607 585477 592462 620208 604109 618619 620163 803306 802256 810069 737633 765860 773474 749242 751546 797657 409083 475273 395676 95982 513158 576686 568543 581091 549825 580008 439687 422185 509809 503115 511592 419617 442970 825762 480296 480398 477548 516940 513992 558261 569546 647162 716765 558514 568453 579171 636271 415342 392687 477691 460811 523848 483646 538007 469472 396329 437663 481772 445661 459611 497699 570753 563642 559953 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.77%) |
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 95982 384124 392687 395676 396329 409035 409083 411045 411352 415342 419617 421897 422185 422358 437663 439687 439765 442970 444733 445243 445661 459611 460811 469096 469472 475273 477548 477691 479860 480296 480398 481772 483646 489171 489381 493174 493191 494333 495228 497699 503115 507003 509809 511592 513158 513992 514254 516712 516940 519958 523837 523848 523881 530737 531789 532444 538007 549825 558261 558514 559953 563009 563642 568453 568543 569546 570753 576686 579171 580008 581091 583607 583866 585477 590813 592392 592462 598169 603890 604109 618619 620163 620208 627338 631243 636271 647162 656523 665929 696426 699516 707315 709645 716550 716765 737633 737726 749242 751546 765860 773474 775960 775967 776940 797657 802256 803306 803819 805557 809292 810069 810299 811475 814783 815214 815442 816115 821036 823809 825762 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toilet anal milf"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"туалет анал milf"
]
|
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.