Query Metrics
7
Database Queries
7
Different statements
182.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.97 ms (88.20%) |
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 185753 246506 382234 386357 387359 390178 420032 422252 427219 428961 434429 441005 447350 447476 447548 453697 454066 457018 458778 462673 466219 466940 467273 469675 475547 476366 478760 481284 482069 487010 487712 489110 490790 492197 499444 501720 501732 501746 501760 501799 502006 503064 503215 509675 509780 513328 513396 516536 516542 518328 519841 520599 521888 523567 523978 524003 525533 526834 527660 528066 545809 554777 558617 560396 561721 563796 568081 569622 572010 572016 573776 576039 576384 576401 595493 595519 596618 596629 598087 598774 599433 601618 602725 603583 604116 609731 615004 616798 621527 622986 637037 641711 653239 653247 653248 653253 653516 663536 665645 672485 672528 672540 672547 672561 672564 677006 679088 683288 721225 722820 731652 744479 753343 758980 761607 767504 768114 791924 810842 813419 ] |
||||||||||||||||||||||||||||||
|
12.27 ms (6.72%) |
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 509780 653253 672540 672528 672547 672561 622986 602725 810842 758980 185753 554777 558617 576039 563796 569622 572016 572010 653247 615004 603583 478760 447476 482069 454066 503215 489110 499444 513396 525533 523567 502006 453697 523978 501799 501746 382234 672485 672564 722820 481284 476366 813419 791924 561721 596618 596629 458778 434429 422252 466219 427219 516542 595519 595493 492197 526834 568081 573776 576401 599433 469675 447350 447548 516536 501720 520599 524003 641711 560396 653239 679088 653516 616798 601618 767504 420032 462673 466940 637037 621527 457018 390178 677006 663536 653248 545809 246506 490790 683288 744479 753343 768114 598087 598774 428961 386357 387359 487712 509675 501760 521888 503064 528066 518328 576384 441005 467273 501732 513328 519841 527660 609731 475547 487010 721225 731652 761607 604116 665645 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.66%) |
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 185753 246506 382234 386357 387359 390178 420032 422252 427219 428961 434429 441005 447350 447476 447548 453697 454066 457018 458778 462673 466219 466940 467273 469675 475547 476366 478760 481284 482069 487010 487712 489110 490790 492197 499444 501720 501732 501746 501760 501799 502006 503064 503215 509675 509780 513328 513396 516536 516542 518328 519841 520599 521888 523567 523978 524003 525533 526834 527660 528066 545809 554777 558617 560396 561721 563796 568081 569622 572010 572016 573776 576039 576384 576401 595493 595519 596618 596629 598087 598774 599433 601618 602725 603583 604116 609731 615004 616798 621527 622986 637037 641711 653239 653247 653248 653253 653516 663536 665645 672485 672528 672540 672547 672561 672564 677006 679088 683288 721225 722820 731652 744479 753343 758980 761607 767504 768114 791924 810842 813419 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian massage"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск массаж"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.