Query Metrics
7
Database Queries
7
Different statements
170.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.28 ms (84.05%) |
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 384433 385324 396980 412855 418883 428115 428497 435487 439579 440538 440779 440816 440879 440954 447722 449688 450829 451281 452184 452299 454471 455730 455978 457990 462747 465708 468829 471707 472544 474153 476586 476841 479936 480508 481167 483179 488132 489271 490813 492462 494299 496611 499726 499731 501253 505298 505639 506741 508226 509594 509609 510413 510930 511069 512613 512733 513975 516924 518600 518817 520249 521091 521170 522037 522782 524944 524991 525234 526545 527382 528157 528603 529233 529864 531197 533200 534325 535533 537814 540952 546213 550052 551125 554770 555065 565973 567757 571762 573165 573273 576970 577439 582563 584638 584711 585400 589607 589697 590712 591160 591958 595097 595200 595226 599370 602249 605702 605762 607518 616778 625770 707617 730994 777003 795758 796248 801953 802781 809876 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (10.30%) |
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 454471 471707 451281 518600 489271 490813 509594 518817 529233 435487 452184 496611 796642 385324 483179 457990 492462 462747 533200 535533 505298 508226 513975 528603 565973 573165 550052 555065 591958 589607 591160 795758 796248 802781 801953 730994 707617 777003 809876 455978 440779 480508 525234 521170 506741 524991 449688 474153 551125 501253 571762 585400 384433 396980 428115 440954 428497 595200 465708 468829 531197 509609 510930 522782 537814 529864 546213 590712 595097 605702 452299 476841 418883 481167 522037 524944 520249 412855 447722 450829 516924 534325 472544 479936 573273 584711 577439 589697 440816 440879 476586 512613 527382 505639 511069 455730 494299 510413 521091 540952 576970 582563 602249 607518 616778 595226 439579 499726 512733 528157 526545 488132 554770 605762 440538 499731 584638 567757 625770 599370 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.54%) |
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 384433 385324 396980 412855 418883 428115 428497 435487 439579 440538 440779 440816 440879 440954 447722 449688 450829 451281 452184 452299 454471 455730 455978 457990 462747 465708 468829 471707 472544 474153 476586 476841 479936 480508 481167 483179 488132 489271 490813 492462 494299 496611 499726 499731 501253 505298 505639 506741 508226 509594 509609 510413 510930 511069 512613 512733 513975 516924 518600 518817 520249 521091 521170 522037 522782 524944 524991 525234 526545 527382 528157 528603 529233 529864 531197 533200 534325 535533 537814 540952 546213 550052 551125 554770 555065 565973 567757 571762 573165 573273 576970 577439 582563 584638 584711 585400 589607 589697 590712 591160 591958 595097 595200 595226 599370 602249 605702 605762 607518 616778 625770 707617 730994 777003 795758 796248 801953 802781 809876 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf cowgirl"
]
|
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.