Query Metrics
7
Database Queries
7
Different statements
146.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.73 ms (81.91%) |
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 383987 388219 391386 395503 396527 399876 405507 406350 414651 419358 419403 419989 420120 420192 421250 424876 427983 429764 444745 445345 446167 449595 452139 453929 457165 460706 461765 464188 468010 468012 473722 473735 476120 484786 484801 489328 491446 495014 496270 506496 510284 516021 518476 521850 522130 526920 529202 530381 530744 531189 531534 532737 532804 536562 537908 539232 540400 540433 542590 543234 543515 543808 543920 545747 545801 545803 550774 556699 556835 558447 562508 568053 574410 574559 575721 575890 580368 582035 583714 585377 592728 596196 596643 599932 601707 603252 603623 603684 603724 604507 610060 612061 617420 620165 625412 625444 631193 633798 633806 634153 634203 637121 637145 642039 643112 643377 646001 647994 650385 650476 650955 666876 680206 684312 716882 720938 731665 749152 767601 805487 ] |
||||||||||||||||||||||||||||||
|
16.37 ms (11.20%) |
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 531189 532804 603684 596643 720938 406350 536562 510284 633806 540433 543920 516021 530381 805487 495014 405507 575721 556699 625444 444745 680206 604507 468012 506496 574410 650955 419989 562508 634203 596196 633798 529202 414651 496270 642039 419358 383987 427983 464188 545747 610060 617420 643377 574559 558447 518476 603724 749152 521850 650476 716882 445345 620165 767601 550774 603623 452139 484786 646001 599932 637145 461765 522130 543234 684312 601707 429764 542590 582035 585377 731665 631193 468010 537908 532737 540400 543808 543515 556835 476120 388219 575890 539232 453929 473722 526920 650385 643112 396527 612061 545803 545801 419403 592728 460706 634153 420192 395503 491446 583714 399876 580368 625412 473735 603252 568053 647994 637121 449595 421250 424876 489328 531534 420120 530744 666876 457165 484801 446167 391386 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.73%) |
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 383987 388219 391386 395503 396527 399876 405507 406350 414651 419358 419403 419989 420120 420192 421250 424876 427983 429764 444745 445345 446167 449595 452139 453929 457165 460706 461765 464188 468010 468012 473722 473735 476120 484786 484801 489328 491446 495014 496270 506496 510284 516021 518476 521850 522130 526920 529202 530381 530744 531189 531534 532737 532804 536562 537908 539232 540400 540433 542590 543234 543515 543808 543920 545747 545801 545803 550774 556699 556835 558447 562508 568053 574410 574559 575721 575890 580368 582035 583714 585377 592728 596196 596643 599932 601707 603252 603623 603684 603724 604507 610060 612061 617420 620165 625412 625444 631193 633798 633806 634153 634203 637121 637145 642039 643112 643377 646001 647994 650385 650476 650955 666876 680206 684312 716882 720938 731665 749152 767601 805487 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black cock глубокийминет минет оральн секс"
]
|
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.