Query Metrics
7
Database Queries
7
Different statements
185.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.35 ms (83.32%) |
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 44495 382140 384422 403924 406303 418339 418361 418879 418919 419956 421288 424780 428640 430650 434815 435547 439825 443430 445603 449821 451014 456837 457553 459010 459072 461416 461906 462904 463608 468222 472127 472217 474016 474901 476399 478025 479820 482786 482803 485249 485251 486015 487183 489658 499136 500463 502856 503001 507505 509296 509703 510665 511306 511838 513357 513382 514301 514466 515134 516741 517414 518458 519769 521604 523496 523828 524414 525405 525471 526714 528221 528896 540840 541408 550748 552459 552987 555040 556494 564164 564786 565306 566761 569454 570867 571819 572305 575287 583209 584180 584762 586554 587264 587952 589509 593742 598290 604097 606494 607387 621658 679567 680590 714468 720072 744329 762064 796831 797462 797793 ] |
||||||||||||||||||||||||||||||
|
21.35 ms (11.53%) |
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 528896 525471 487183 503001 510665 489658 507505 513357 572305 680590 566761 515134 382140 44495 403924 421288 540840 451014 456837 463608 511306 525405 485251 584180 570867 556494 583209 584762 598290 796831 744329 797462 797793 459010 468222 459072 430650 384422 418919 449821 518458 502856 513382 514466 524414 419956 482803 457553 500463 461416 555040 565306 550748 564164 569454 587952 593742 762064 714468 445603 472127 418339 443430 526714 528221 485249 486015 514301 461906 517414 406303 434815 523496 482786 720072 571819 604097 621658 472217 474016 478025 418879 439825 435547 474901 509703 519769 607387 476399 509296 511838 462904 541408 552459 552987 606494 428640 418361 479820 575287 586554 523828 589509 516741 564786 679567 587264 424780 521604 499136 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.32%) |
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 44495 382140 384422 403924 406303 418339 418361 418879 418919 419956 421288 424780 428640 430650 434815 435547 439825 443430 445603 449821 451014 456837 457553 459010 459072 461416 461906 462904 463608 468222 472127 472217 474016 474901 476399 478025 479820 482786 482803 485249 485251 486015 487183 489658 499136 500463 502856 503001 507505 509296 509703 510665 511306 511838 513357 513382 514301 514466 515134 516741 517414 518458 519769 521604 523496 523828 524414 525405 525471 526714 528221 528896 540840 541408 550748 552459 552987 555040 556494 564164 564786 565306 566761 569454 570867 571819 572305 575287 583209 584180 584762 586554 587264 587952 589509 593742 598290 604097 606494 607387 621658 679567 680590 714468 720072 744329 762064 796831 797462 797793 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cums pussy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cums pussy"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cums pussy"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.80%) |
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.