Query Metrics
7
Database Queries
7
Different statements
173.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.88 ms (84.56%) |
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 6609 161731 187953 188403 238809 382255 397881 398964 400808 400849 412299 413947 415207 421234 421867 421891 422183 424385 433211 439682 439727 439797 443358 452189 454890 457442 462350 465312 467034 467712 470304 472152 472252 472679 472701 473249 473479 474627 475224 475315 478640 483628 483630 483635 483644 484644 486355 489299 489380 489384 490904 505956 508721 512100 512561 513972 515588 517374 523824 523830 524798 526523 532846 537261 544870 549848 556029 565270 574656 577313 586456 588387 602283 615525 617152 623608 635450 641879 689001 694312 699599 724268 726317 740097 756239 759369 761086 765224 765493 766637 767172 767252 768851 770115 772038 775192 776264 782427 784307 790137 793701 794892 795571 795737 797523 799146 800697 805524 805538 809654 812751 815381 817154 817348 817889 818903 820094 823510 827648 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (9.26%) |
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 187953 473249 465312 490904 556029 439797 415207 512561 397881 478640 473479 513972 549848 799146 412299 421867 439682 457442 462350 472679 526523 489299 523824 483644 238809 467712 515588 565270 617152 422183 475315 489384 505956 512100 400808 454890 483628 523830 161731 413947 766637 765493 439727 6609 817348 544870 635450 776264 790137 767172 770115 740097 472252 823510 602283 623608 794892 809654 756239 759369 443358 467034 537261 188403 421891 472152 724268 472701 475224 400849 489380 508721 483635 486355 483630 424385 470304 689001 615525 484644 817154 818903 524798 740583 765224 815381 817889 820094 827648 574656 699599 694312 588387 641879 795571 800697 793701 805524 805538 768851 795737 382255 452189 772038 784307 398964 517374 532846 577313 586456 775192 797523 726317 761086 812751 767252 782427 433211 421234 474627 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.58%) |
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 6609 161731 187953 188403 238809 382255 397881 398964 400808 400849 412299 413947 415207 421234 421867 421891 422183 424385 433211 439682 439727 439797 443358 452189 454890 457442 462350 465312 467034 467712 470304 472152 472252 472679 472701 473249 473479 474627 475224 475315 478640 483628 483630 483635 483644 484644 486355 489299 489380 489384 490904 505956 508721 512100 512561 513972 515588 517374 523824 523830 524798 526523 532846 537261 544870 549848 556029 565270 574656 577313 586456 588387 602283 615525 617152 623608 635450 641879 689001 694312 699599 724268 726317 740097 756239 759369 761086 765224 765493 766637 767172 767252 768851 770115 772038 775192 776264 782427 784307 790137 793701 794892 795571 795737 797523 799146 800697 805524 805538 809654 812751 815381 817154 817348 817889 818903 820094 823510 827648 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead mature anal"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая mature анал"
]
|
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.