Query Metrics
7
Database Queries
7
Different statements
190.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.57 ms (86.19%) |
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 246506 357782 382234 383818 386357 390178 420032 422233 422252 428961 434281 441005 447350 447476 447548 447562 457018 457953 458778 461696 462673 466219 466940 467273 469675 471347 471916 476366 481284 487010 487712 490790 492197 499444 501720 501732 501749 501760 501799 503064 503215 503887 505042 509675 509780 510362 513072 513396 516536 516542 519841 521888 524003 524380 528066 545809 551419 552232 554146 568081 568369 573776 576014 576280 576379 576381 576384 576401 595493 595516 595519 596618 596629 597503 598087 598774 599433 600403 601313 602725 604116 609731 609896 610183 637037 641711 651924 653239 653248 653254 653516 660522 660959 663536 665645 672475 672485 672486 672564 676927 677006 677029 677400 679088 681525 716127 720985 721225 721408 721447 722820 735625 753343 755587 767504 770579 790569 795696 799778 813419 ] |
||||||||||||||||||||||||||||||
|
15.13 ms (7.93%) |
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 447476 503215 513396 672485 596629 458778 357782 422252 501799 595519 610183 469675 641711 596618 576401 447350 447548 501720 524003 595493 672564 722820 767504 509780 602725 573776 637037 653239 679088 653516 499444 382234 813419 568081 599433 516536 653248 545809 246506 462673 466940 665645 501732 598087 598774 487712 501760 521888 528066 481284 476366 390178 677006 663536 490790 576384 441005 519841 721447 428961 386357 509675 466219 516542 551419 720985 721408 660522 799778 492197 554146 651924 677029 576014 601313 434281 383818 420032 721225 576280 677400 568369 609896 524380 457018 487010 600403 597503 576381 503887 753343 672486 672475 609731 471347 457953 447562 501749 676927 461696 505042 576379 660959 716127 755587 653254 595516 422233 513072 790569 795696 735625 604116 503064 510362 681525 770579 471916 552232 467273 ] |
||||||||||||||||||||||||||||||
|
4.30 ms (2.25%) |
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 246506 357782 382234 383818 386357 390178 420032 422233 422252 428961 434281 441005 447350 447476 447548 447562 457018 457953 458778 461696 462673 466219 466940 467273 469675 471347 471916 476366 481284 487010 487712 490790 492197 499444 501720 501732 501749 501760 501799 503064 503215 503887 505042 509675 509780 510362 513072 513396 516536 516542 519841 521888 524003 524380 528066 545809 551419 552232 554146 568081 568369 573776 576014 576280 576379 576381 576384 576401 595493 595516 595519 596618 596629 597503 598087 598774 599433 600403 601313 602725 604116 609731 609896 610183 637037 641711 651924 653239 653248 653254 653516 660522 660959 663536 665645 672475 672485 672486 672564 676927 677006 677029 677400 679088 681525 716127 720985 721225 721408 721447 722820 735625 753343 755587 767504 770579 790569 795696 799778 813419 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian massage girl"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск массаж девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
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.