Query Metrics
7
Database Queries
7
Different statements
172.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.45 ms (78.57%) |
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 33727 185606 187516 193874 233670 359134 366011 382387 384455 385361 393789 395556 395640 395881 397859 415556 418418 444227 452150 452445 454226 467162 472146 475080 476278 477906 481566 489595 493094 493206 494672 504214 506049 515026 516473 518064 518296 518840 519227 523442 523805 524397 524722 526029 529125 534237 542737 543960 544960 545530 547915 549362 550764 552325 555903 557517 558051 558840 559117 559877 563056 566709 567162 569933 574538 575737 578709 579938 581688 581707 584062 584537 585140 585711 589835 597599 597821 601853 603627 613170 618895 619514 623617 634812 640403 665315 667291 667566 667847 682177 683369 684019 684963 696316 699025 705455 714752 715528 721057 721563 726831 728237 729920 730758 732061 735829 736393 740125 741109 753204 760505 782155 796125 803088 803776 804991 808556 813920 820482 823913 ] |
||||||||||||||||||||||||||||||
|
25.13 ms (14.58%) |
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 524722 575737 699025 529125 385361 382387 415556 823913 813920 506049 493094 552325 547915 665315 667566 667847 705455 667291 721563 696316 714752 544960 563056 579938 803776 804991 808556 740125 796125 803088 726831 753204 728237 760505 730758 735829 736393 619514 640403 715528 782155 359134 187516 193874 397859 233670 366011 515026 504214 601853 467162 393789 395640 820482 585140 452445 472146 475080 493206 526029 534237 494672 518296 545530 550764 559117 559877 581707 543960 549362 557517 558051 558840 566709 578709 581688 584062 542737 584537 682177 683369 684019 684963 555903 567162 569933 574538 585711 597821 613170 634812 597599 603627 589835 618895 623617 729920 741109 732061 721057 477906 481566 454226 418418 444227 452150 476278 516473 523442 524397 489595 518064 518840 519227 523805 384455 185606 395881 395556 33727 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.95%) |
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 33727 185606 187516 193874 233670 359134 366011 382387 384455 385361 393789 395556 395640 395881 397859 415556 418418 444227 452150 452445 454226 467162 472146 475080 476278 477906 481566 489595 493094 493206 494672 504214 506049 515026 516473 518064 518296 518840 519227 523442 523805 524397 524722 526029 529125 534237 542737 543960 544960 545530 547915 549362 550764 552325 555903 557517 558051 558840 559117 559877 563056 566709 567162 569933 574538 575737 578709 579938 581688 581707 584062 584537 585140 585711 589835 597599 597821 601853 603627 613170 618895 619514 623617 634812 640403 665315 667291 667566 667847 682177 683369 684019 684963 696316 699025 705455 714752 715528 721057 721563 726831 728237 729920 730758 732061 735829 736393 740125 741109 753204 760505 782155 796125 803088 803776 804991 808556 813920 820482 823913 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young kissing"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young kissing"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young kissing"
]
|
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.