Query Metrics
7
Database Queries
7
Different statements
152.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.00 ms (80.43%) |
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 390707 423697 428771 432438 433310 433397 433946 446527 447023 447095 447231 447883 448293 450515 450570 450702 451254 451673 452627 453683 453721 453723 453732 455153 455621 455860 456541 456888 457108 457630 459970 462999 469013 471596 471743 473605 475195 475368 475575 476995 477675 478267 478281 479967 481401 483190 483356 483411 483417 483431 484225 486377 486879 488156 488541 489353 489705 489714 489719 493280 494670 502200 502333 503491 503506 503514 505923 507131 507349 507846 511193 511436 511845 511938 512540 513384 513398 513725 514004 516090 516094 516999 518069 520065 520818 522215 524143 524606 524789 525452 526568 527031 545939 546626 552367 552966 555997 560509 562795 565077 565084 569583 574414 575236 586219 586358 589957 590221 599533 601387 620024 623436 643489 644914 765155 786776 787309 793608 800373 806423 ] |
||||||||||||||||||||||||||||||
|
20.06 ms (13.12%) |
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 489714 524606 786776 455621 479967 502333 513398 488541 486879 503506 503514 569583 475368 545939 457108 562795 455860 447231 471743 520065 469013 478281 511436 489705 456541 518069 494670 502200 552966 574414 433946 447883 503491 516094 525452 483411 507349 514004 524143 423697 489719 565084 471596 451673 447023 481401 507131 513725 513384 526568 450702 511938 546626 800373 524789 432438 450515 451254 473605 589957 643489 806423 787309 765155 511845 512540 459970 552367 453723 575236 623436 455153 493280 489353 484225 453732 586358 433397 433310 475195 476995 475575 507846 483190 483431 560509 565077 555997 448293 450570 452627 505923 520818 793608 527031 511193 447095 428771 457630 488156 477675 462999 486377 516090 478267 601387 483356 522215 453683 453721 586219 644914 456888 483417 599533 516999 590221 620024 446527 390707 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (2.44%) |
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 390707 423697 428771 432438 433310 433397 433946 446527 447023 447095 447231 447883 448293 450515 450570 450702 451254 451673 452627 453683 453721 453723 453732 455153 455621 455860 456541 456888 457108 457630 459970 462999 469013 471596 471743 473605 475195 475368 475575 476995 477675 478267 478281 479967 481401 483190 483356 483411 483417 483431 484225 486377 486879 488156 488541 489353 489705 489714 489719 493280 494670 502200 502333 503491 503506 503514 505923 507131 507349 507846 511193 511436 511845 511938 512540 513384 513398 513725 514004 516090 516094 516999 518069 520065 520818 522215 524143 524606 524789 525452 526568 527031 545939 546626 552367 552966 555997 560509 562795 565077 565084 569583 574414 575236 586219 586358 589957 590221 599533 601387 620024 623436 643489 644914 765155 786776 787309 793608 800373 806423 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam handjob"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.85%) |
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.