Query Metrics
7
Database Queries
7
Different statements
157.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.02 ms (81.03%) |
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 95673 384757 395676 401985 404429 408928 422673 423886 427362 430484 432565 438316 440815 443179 443732 443759 445530 446443 446684 453734 454392 455599 455631 455772 456519 456736 457422 460218 460807 461368 462133 467002 467683 468672 469352 470071 470585 471124 471176 472506 475911 478032 478596 479121 484553 484821 487588 489060 490196 491275 492523 493166 498239 498388 498442 499365 501708 504841 507282 507710 508820 509630 510876 512217 515350 516023 516622 516624 517078 517386 519304 519962 522690 524361 531116 531214 531540 531545 534981 535344 536288 541833 543576 544472 544834 547473 547485 551909 554526 555967 555968 555983 555984 555989 556005 556612 557128 557571 558316 562894 569087 576719 591082 596048 599953 618856 621317 651609 657768 657774 669012 669386 681547 714468 719336 741269 752626 803095 805638 811738 ] |
||||||||||||||||||||||||||||||
|
18.73 ms (11.85%) |
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 404429 423886 443759 446443 438316 470585 408928 468672 479121 430484 443732 453734 467002 498388 508820 492523 493166 498442 507282 509630 519304 491275 498239 517078 544472 621317 517386 524361 522690 95673 395676 401985 456519 457422 460807 467683 484553 445530 461368 462133 454392 455772 456736 469352 471124 487588 490196 510876 515350 516023 516622 516624 501708 531214 512217 472506 478032 543576 555967 555984 558316 555983 555989 557571 551909 556005 657768 651609 657774 669012 669386 544834 556612 569087 576719 591082 596048 599953 803095 811738 752626 741269 714468 805638 427362 443179 471176 475911 440815 446684 470071 422673 455631 455599 460218 489060 499365 504841 535344 554526 541833 562894 618856 384757 432565 478596 507710 534981 531116 531545 536288 519962 531540 484821 547473 547485 557128 555968 681547 719336 ] |
||||||||||||||||||||||||||||||
|
4.16 ms (2.63%) |
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 95673 384757 395676 401985 404429 408928 422673 423886 427362 430484 432565 438316 440815 443179 443732 443759 445530 446443 446684 453734 454392 455599 455631 455772 456519 456736 457422 460218 460807 461368 462133 467002 467683 468672 469352 470071 470585 471124 471176 472506 475911 478032 478596 479121 484553 484821 487588 489060 490196 491275 492523 493166 498239 498388 498442 499365 501708 504841 507282 507710 508820 509630 510876 512217 515350 516023 516622 516624 517078 517386 519304 519962 522690 524361 531116 531214 531540 531545 534981 535344 536288 541833 543576 544472 544834 547473 547485 551909 554526 555967 555968 555983 555984 555989 556005 556612 557128 557571 558316 562894 569087 576719 591082 596048 599953 618856 621317 651609 657768 657774 669012 669386 681547 714468 719336 741269 752626 803095 805638 811738 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature 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.