Query Metrics
7
Database Queries
7
Different statements
354.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.05 ms (58.72%) |
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 400995 420599 421569 424214 426802 437671 438045 439616 439757 442805 443759 455599 455922 456455 460731 462133 462315 465353 466241 469003 474988 475379 479957 481933 486590 487677 489060 491431 497179 499374 502749 503314 504791 506050 507647 509101 509657 512743 513474 513480 513503 513518 513780 513943 514572 516718 520851 522203 522690 523019 524014 524370 524371 525303 525955 527257 527731 534683 540794 540802 540803 542902 547717 549638 549646 551525 552348 552355 555129 555130 555139 555968 555984 555989 555992 556009 557119 557571 557592 558316 565862 572683 577888 584771 584890 591131 591394 593296 593384 595217 595518 600193 601476 602019 605117 605152 614487 619508 619516 619526 619884 619888 620754 624909 625440 625441 627773 635074 657768 657775 682303 714468 716577 718750 752626 761039 777006 779039 789858 825299 ] |
||||||||||||||||||||||||||||||
|
122.53 ms (34.59%) |
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 400995 420599 421569 424214 426802 437671 438045 439616 439757 442805 443759 455599 455922 456455 460731 462133 462315 465353 466241 469003 474988 475379 479957 481933 486590 487677 489060 491431 497179 499374 502749 503314 504791 506050 507647 509101 509657 512743 513474 513480 513503 513518 513780 513943 514572 516718 520851 522203 522690 523019 524014 524370 524371 525303 525955 527257 527731 534683 540794 540802 540803 542902 547717 549638 549646 551525 552348 552355 555129 555130 555139 555968 555984 555989 555992 556009 557119 557571 557592 558316 565862 572683 577888 584771 584890 591131 591394 593296 593384 595217 595518 600193 601476 602019 605117 605152 614487 619508 619516 619526 619884 619888 620754 624909 625440 625441 627773 635074 657768 657775 682303 714468 716577 718750 752626 761039 777006 779039 789858 825299 ] |
||||||||||||||||||||||||||||||
|
17.26 ms (4.87%) |
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 555992 555989 565862 657768 714468 507647 513503 555968 572683 605117 619508 474988 426802 438045 424214 460731 777006 789858 779039 619526 509657 520851 512743 825299 462133 552348 555984 558316 549646 557571 584771 542902 552355 555130 555139 593384 595518 624909 752626 475379 479957 437671 455599 502749 522203 525303 489060 506050 509101 525955 534683 487677 527257 591394 513518 593296 619516 456455 499374 462315 584890 716577 614487 718750 420599 551525 555129 605152 761039 635074 400995 421569 439616 439757 442805 465353 469003 524371 540802 540803 540794 486590 504791 513474 516718 524370 600193 466241 549638 602019 527731 601476 443759 481933 524014 497179 513780 514572 491431 682303 556009 557592 591131 619884 595217 619888 625441 513480 620754 577888 523019 557119 657775 455922 627773 513943 503314 547717 522690 625440 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sexy wife"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sexy жен"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sexy жен"
]
|
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.