Query Metrics
7
Database Queries
7
Different statements
142.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.19 ms (84.06%) |
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 22843 51569 55903 101853 116852 154123 173963 186823 197609 256371 266977 280656 310581 311798 311884 323899 333706 350614 381863 386467 387806 389266 390940 391217 397666 397704 399541 401413 402649 408623 408627 420636 428289 429895 431002 431154 448081 451536 456358 457543 457567 469468 471069 471102 472498 473962 487234 493820 496845 513623 529083 529772 534477 535661 537997 540224 540284 540287 548161 548898 551464 552378 555497 556194 558317 560895 561778 561784 571099 578563 579667 580743 594306 595890 610926 617564 644205 645418 645681 649738 656909 664457 665331 687341 692913 698459 701235 708329 710440 711194 711712 716125 736359 736831 743094 743276 751323 751331 758525 763401 764795 765079 766167 767908 782343 782957 784216 790192 790230 791336 801813 803189 805389 805699 809958 810745 810949 811023 812187 814171 ] |
||||||||||||||||||||||||||||||
|
12.18 ms (8.52%) |
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 493820 578563 457543 431002 428289 431154 256371 311798 311884 266977 310581 387806 448081 487234 540224 540284 496845 472498 548898 645418 656909 665331 687341 561778 571099 594306 617564 805389 736831 743094 758525 767908 763401 751323 751331 610926 698459 782343 782957 791336 323899 397666 401413 154123 397704 408627 471102 402649 429895 551464 451536 471069 469468 381863 420636 513623 197609 186823 173963 280656 22843 51569 55903 390940 391217 399541 408623 814171 456358 457567 473962 529083 534477 535661 540287 529772 537997 555497 558317 560895 579667 552378 561784 645681 716125 649738 692913 711194 664457 710440 711712 548161 556194 580743 595890 644205 801813 803189 810949 811023 812187 790192 784216 790230 805699 809958 736359 764795 743276 765079 766167 701235 708329 810745 101853 116852 333706 386467 389266 350614 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.08%) |
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 22843 51569 55903 101853 116852 154123 173963 186823 197609 256371 266977 280656 310581 311798 311884 323899 333706 350614 381863 386467 387806 389266 390940 391217 397666 397704 399541 401413 402649 408623 408627 420636 428289 429895 431002 431154 448081 451536 456358 457543 457567 469468 471069 471102 472498 473962 487234 493820 496845 513623 529083 529772 534477 535661 537997 540224 540284 540287 548161 548898 551464 552378 555497 556194 558317 560895 561778 561784 571099 578563 579667 580743 594306 595890 610926 617564 644205 645418 645681 649738 656909 664457 665331 687341 692913 698459 701235 708329 710440 711194 711712 716125 736359 736831 743094 743276 751323 751331 758525 763401 764795 765079 766167 767908 782343 782957 784216 790192 790230 791336 801813 803189 805389 805699 809958 810745 810949 811023 812187 814171 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло ласкает себя"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло ласка"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло ласка"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.