Query Metrics
7
Database Queries
7
Different statements
187.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.54 ms (85.15%) |
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 145314 181304 377241 389500 390680 391437 413971 418423 419483 419758 420352 421562 422512 423893 427950 428315 431448 439845 445493 445745 446300 447158 448829 461729 466369 469566 470256 473184 476649 492829 494370 496269 497901 501958 507512 510588 514820 514832 515433 515982 516291 516350 516584 517788 519086 519556 521829 524317 525044 525686 527917 530384 530709 531180 531223 537913 539210 539319 542864 543844 556036 557449 559161 560029 561136 562796 565254 569260 571213 571834 583923 586504 591187 592005 595510 596168 596880 597263 597963 598568 600273 601698 602607 613508 613836 620215 622932 623264 627809 627813 627814 635188 637049 637086 637460 645327 648543 648871 650851 665806 675009 676025 676523 680116 680182 716892 719336 755101 756390 760794 770148 797195 801749 807175 807927 809508 810109 811689 811738 819232 ] |
||||||||||||||||||||||||||||||
|
19.24 ms (10.27%) |
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 497901 524317 419483 516291 562796 461729 537913 420352 514820 145314 494370 623264 530709 531223 559161 557449 676025 648871 597263 627813 418423 466369 476649 492829 519086 569260 561136 448829 510588 596168 622932 516584 507512 527917 637086 473184 521829 680116 716892 531180 645327 602607 807927 811738 470256 390680 583923 676523 760794 446300 447158 515433 637460 519556 819232 501958 586504 469566 419758 560029 648543 592005 539210 565254 627809 427950 516350 542864 591187 181304 391437 719336 635188 613508 445493 445745 413971 597963 595510 514832 596880 423893 421562 525044 665806 811689 517788 598568 600273 377241 571213 539319 422512 680182 627814 810109 801749 428315 431448 389500 530384 809508 439845 496269 797195 770148 807175 525686 756390 515982 543844 650851 637049 675009 571834 613836 601698 755101 556036 620215 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.36%) |
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 145314 181304 377241 389500 390680 391437 413971 418423 419483 419758 420352 421562 422512 423893 427950 428315 431448 439845 445493 445745 446300 447158 448829 461729 466369 469566 470256 473184 476649 492829 494370 496269 497901 501958 507512 510588 514820 514832 515433 515982 516291 516350 516584 517788 519086 519556 521829 524317 525044 525686 527917 530384 530709 531180 531223 537913 539210 539319 542864 543844 556036 557449 559161 560029 561136 562796 565254 569260 571213 571834 583923 586504 591187 592005 595510 596168 596880 597263 597963 598568 600273 601698 602607 613508 613836 620215 622932 623264 627809 627813 627814 635188 637049 637086 637460 645327 648543 648871 650851 665806 675009 676025 676523 680116 680182 716892 719336 755101 756390 760794 770148 797195 801749 807175 807927 809508 810109 811689 811738 819232 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits babe anal"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ babe анал"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ babe анал"
]
|
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.