Query Metrics
7
Database Queries
7
Different statements
148.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.93 ms (82.33%) |
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 384769 388325 389364 395144 398769 400892 413134 415807 421780 424481 425990 426367 427981 428368 431120 434763 439467 440944 443091 445200 446179 447094 448704 449158 449717 450158 451493 451509 453261 454239 456858 459972 462074 462266 464601 465824 470302 471934 472244 472286 475103 475873 475907 479856 482219 484370 484724 486481 492986 500576 502278 506133 512964 513125 514904 515391 519335 521725 522056 522513 523296 524992 528697 533477 534119 535050 536559 541366 544288 544571 549787 561509 562890 564488 565771 566371 568566 574387 574424 576633 577372 586650 591494 598840 599872 600859 604257 605725 606425 613823 622829 635050 684029 716693 721187 724253 727465 727828 730953 732964 735920 750063 751510 751611 761291 765297 771527 775708 778670 784261 790895 799262 799595 810905 810997 814835 817024 817230 817430 818472 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (10.91%) |
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 622829 606425 775708 784261 790895 810997 751611 799595 810905 727828 771527 732964 730953 751510 761291 724253 778670 519335 515391 523296 484724 425990 449717 451493 472286 475103 562890 605725 462074 415807 440944 445200 522056 400892 431120 443091 421780 814835 818472 817024 817230 456858 471934 486481 448704 451509 464601 475873 459972 534119 512964 521725 536559 513125 528697 535050 544571 574424 574387 576633 577372 564488 566371 568566 721187 684029 716693 549787 561509 565771 598840 600859 613823 599872 604257 586650 591494 727465 765297 799262 750063 735920 635050 398769 424481 453261 475907 449158 450158 479856 426367 462266 428368 446179 454239 522513 492986 395144 506133 484370 541366 544288 470302 465824 524992 427981 384769 388325 389364 413134 439467 434763 817430 447094 472244 482219 533477 500576 502278 514904 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.18%) |
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 384769 388325 389364 395144 398769 400892 413134 415807 421780 424481 425990 426367 427981 428368 431120 434763 439467 440944 443091 445200 446179 447094 448704 449158 449717 450158 451493 451509 453261 454239 456858 459972 462074 462266 464601 465824 470302 471934 472244 472286 475103 475873 475907 479856 482219 484370 484724 486481 492986 500576 502278 506133 512964 513125 514904 515391 519335 521725 522056 522513 523296 524992 528697 533477 534119 535050 536559 541366 544288 544571 549787 561509 562890 564488 565771 566371 568566 574387 574424 576633 577372 586650 591494 598840 599872 600859 604257 605725 606425 613823 622829 635050 684029 716693 721187 724253 727465 727828 730953 732964 735920 750063 751510 751611 761291 765297 771527 775708 778670 784261 790895 799262 799595 810905 810997 814835 817024 817230 817430 818472 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn mature"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"there porn mature"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn mature"
]
|
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.