Query Metrics
7
Database Queries
7
Different statements
174.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.61 ms (85.97%) |
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 188009 233376 326081 383273 390865 391940 394738 397392 397483 399421 399585 399634 401200 401804 403893 407708 407722 407727 409713 409803 411626 411727 411766 411767 411944 413476 421890 429990 432418 433363 433587 433746 445221 453191 454469 457160 460159 461961 466982 467034 467048 470417 473472 474109 477948 484539 486814 487315 504386 512174 515262 519184 520376 522771 523219 524835 535819 549176 549245 556783 561740 572715 582333 589146 589328 598653 605686 619773 626383 644876 651887 653911 663386 663459 663494 663873 664792 664820 665190 665250 665351 665487 665854 667212 667566 667829 668809 669456 687430 696283 697704 712827 713122 716274 726498 726516 726527 726698 727513 731788 740824 742507 748467 760505 764215 772883 776020 782155 782159 782244 782246 784669 810744 814070 819621 819638 823558 824347 824427 824935 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (8.24%) |
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 760505 409803 619773 383273 484539 512174 776020 326081 433363 390865 470417 461961 653911 556783 394738 397483 399421 413476 823558 535819 663459 665351 665854 664792 697704 663873 726698 740824 772883 727513 731788 748467 726498 457160 399585 582333 561740 687430 696283 589146 626383 233376 519184 522771 411767 474109 487315 429990 473472 549176 598653 504386 403893 407708 433746 644876 524835 460159 651887 668809 712827 572715 605686 726527 432418 391940 477948 486814 520376 401804 411727 445221 819621 824347 819638 454469 453191 663494 665190 665487 667566 664820 665250 713122 663386 667212 667829 669456 716274 589328 782244 810744 726516 782159 784669 742507 764215 782155 782246 397392 421890 467048 549245 401200 467034 515262 466982 188009 399634 411626 433587 409713 407727 407722 411766 411944 814070 824935 824427 523219 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.62%) |
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 188009 233376 326081 383273 390865 391940 394738 397392 397483 399421 399585 399634 401200 401804 403893 407708 407722 407727 409713 409803 411626 411727 411766 411767 411944 413476 421890 429990 432418 433363 433587 433746 445221 453191 454469 457160 460159 461961 466982 467034 467048 470417 473472 474109 477948 484539 486814 487315 504386 512174 515262 519184 520376 522771 523219 524835 535819 549176 549245 556783 561740 572715 582333 589146 589328 598653 605686 619773 626383 644876 651887 653911 663386 663459 663494 663873 664792 664820 665190 665250 665351 665487 665854 667212 667566 667829 668809 669456 687430 696283 697704 712827 713122 716274 726498 726516 726527 726698 727513 731788 740824 742507 748467 760505 764215 772883 776020 782155 782159 782244 782246 784669 810744 814070 819621 819638 823558 824347 824427 824935 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby young girl"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby young девушк"
]
|
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.