Query Metrics
7
Database Queries
7
Different statements
189.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.15 ms (86.83%) |
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 97098 130506 320078 358596 381883 388219 395137 397232 400936 401640 404732 414339 414368 414374 414621 422049 427966 429768 429804 437470 443786 453095 468655 476103 480299 482514 484392 484693 485133 485703 491771 492563 497537 500363 500369 516329 520753 522880 522886 525626 530015 530020 530796 530912 531126 532966 533382 535620 536538 536586 537771 541846 543855 544439 545368 545383 551065 557162 562823 562828 565346 571136 576727 580290 589240 597018 599941 600401 603340 604890 604902 617416 617428 617652 629409 632650 633741 636299 641705 646904 647994 649545 664305 665085 666549 666579 673363 673366 674492 681137 690809 692796 716887 727449 731805 731816 738821 748231 748236 748239 748242 760240 775869 775942 780701 788262 790248 798948 801960 802062 802610 805594 810061 810771 815413 815737 817080 823944 824052 824130 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (7.94%) |
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 484693 530020 532966 522886 545368 633741 404732 414339 427966 429804 476103 480299 482514 491771 537771 536586 530015 522880 535620 485133 543855 545383 562828 646904 649545 666549 599941 801960 617416 788262 414621 453095 414368 500369 497537 817080 823944 824052 551065 557162 674492 571136 629409 597018 802062 731816 632650 815413 565346 681137 604890 790248 727449 748242 748236 414374 500363 530912 536538 604902 485703 130506 97098 815737 544439 664305 617652 641705 798948 748231 748239 810061 443786 358596 320078 381883 397232 665085 690809 666579 673363 673366 692796 603340 775869 775942 802610 805594 810771 760240 731805 738821 780701 388219 400936 422049 429768 468655 530796 533382 516329 525626 531126 562823 580290 541846 647994 589240 636299 617428 716887 437470 492563 576727 600401 520753 395137 401640 484392 824130 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.40%) |
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 97098 130506 320078 358596 381883 388219 395137 397232 400936 401640 404732 414339 414368 414374 414621 422049 427966 429768 429804 437470 443786 453095 468655 476103 480299 482514 484392 484693 485133 485703 491771 492563 497537 500363 500369 516329 520753 522880 522886 525626 530015 530020 530796 530912 531126 532966 533382 535620 536538 536586 537771 541846 543855 544439 545368 545383 551065 557162 562823 562828 565346 571136 576727 580290 589240 597018 599941 600401 603340 604890 604902 617416 617428 617652 629409 632650 633741 636299 641705 646904 647994 649545 664305 665085 666549 666579 673363 673366 674492 681137 690809 692796 716887 727449 731805 731816 738821 748231 748236 748239 748242 760240 775869 775942 780701 788262 790248 798948 801960 802062 802610 805594 810061 810771 815413 815737 817080 823944 824052 824130 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group mature gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group mature gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group mature gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.87%) |
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.