Query Metrics
7
Database Queries
7
Different statements
177.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.60 ms (85.28%) |
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 386751 396286 415095 417268 418353 418627 420440 421236 421294 434259 435114 437407 437663 440650 443396 447902 451338 452367 452666 453501 454428 454617 455873 456778 459342 461693 467920 467979 468278 469727 473269 473679 473784 474994 475599 477949 478588 480969 483593 484105 485332 485870 486661 487656 488816 491722 492926 493082 493439 495324 495808 496956 498949 505161 509576 513430 513941 515627 515651 520337 520382 520670 521656 524204 524905 526147 526609 527298 529240 531799 534333 544087 546372 552498 555186 557559 560002 561563 561937 562055 563820 565115 565561 567216 569241 571351 571971 574043 577243 577897 579821 586926 592873 593136 594414 594979 595043 600799 602402 602632 602724 602849 606268 606297 612404 612469 619362 662796 680550 713080 714258 732915 752454 765040 766182 784922 787332 791981 810138 810916 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (9.82%) |
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 452666 468278 475599 461693 455873 473784 420440 467979 469727 459342 485870 513941 498949 520382 524905 534333 810916 752454 454428 452367 418353 515651 483593 713080 714258 467920 592873 491722 396286 437407 443396 421294 435114 418627 451338 477949 447902 520670 524204 531799 527298 474994 544087 555186 569241 571351 579821 577243 680550 562055 563820 567216 586926 602724 602849 612404 602632 612469 606297 784922 791981 766182 765040 619362 810138 480969 473679 473269 478588 526609 529240 488816 495808 496956 484105 485332 521656 526147 486661 487656 509576 513430 495324 505161 437663 594414 421236 552498 434259 454617 520337 515627 787332 493439 561937 594979 593136 602402 662796 557559 415095 574043 493082 595043 606268 600799 732915 453501 492926 386751 565561 417268 440650 456778 546372 577897 560002 561563 565115 571971 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.55%) |
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 386751 396286 415095 417268 418353 418627 420440 421236 421294 434259 435114 437407 437663 440650 443396 447902 451338 452367 452666 453501 454428 454617 455873 456778 459342 461693 467920 467979 468278 469727 473269 473679 473784 474994 475599 477949 478588 480969 483593 484105 485332 485870 486661 487656 488816 491722 492926 493082 493439 495324 495808 496956 498949 505161 509576 513430 513941 515627 515651 520337 520382 520670 521656 524204 524905 526147 526609 527298 529240 531799 534333 544087 546372 552498 555186 557559 560002 561563 561937 562055 563820 565115 565561 567216 569241 571351 571971 574043 577243 577897 579821 586926 592873 593136 594414 594979 595043 600799 602402 602632 602724 602849 606268 606297 612404 612469 619362 662796 680550 713080 714258 732915 752454 765040 766182 784922 787332 791981 810138 810916 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade shower pov"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск shower пов"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск shower пов"
]
|
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.