Query Metrics
7
Database Queries
7
Different statements
415.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.87 ms (49.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
180.88 ms (43.54%) |
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 382266 403373 404019 408164 408411 413084 418259 421137 421613 430562 432318 432696 440581 440852 442143 445266 445560 448064 448337 448802 449260 449302 456367 457797 459295 460853 460904 462359 464243 469195 474809 476149 476853 479281 479285 479303 482618 482755 484218 485059 487479 495992 496086 497161 499233 499527 500184 501352 504870 510827 511633 515002 517867 519762 526627 527356 528628 531308 547825 553321 555980 559459 562381 563670 564711 565201 582220 582932 587865 588555 589360 590218 591996 595308 595514 595941 596347 601407 601664 602487 610202 612429 612550 613956 617087 617636 619917 626872 627487 639051 640252 652931 660606 667917 689520 693155 708232 710349 715138 719192 720802 724335 732915 744184 750732 761294 770615 770662 776316 779913 781586 782557 785624 788236 790998 793642 806183 812429 813187 821370 ] |
||||||||||||||||||||||||||||||
|
19.60 ms (4.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 689520 693155 719192 720802 601664 612550 595308 613956 640252 591996 601407 589360 590218 595941 627487 776316 779913 790998 806183 813187 788236 793642 732915 744184 750732 770615 782557 761294 770662 724335 602487 612429 715138 781586 785624 812429 382266 432318 449260 460904 476149 421613 442143 479285 418259 430562 449302 421137 448337 457797 479281 515002 499527 504870 495992 526627 500184 511633 517867 519762 821370 448802 496086 582220 565201 413084 440581 485059 652931 403373 404019 408164 440852 432696 408411 445266 456367 460853 464243 469195 474809 459295 476853 445560 448064 462359 479303 482755 528628 531308 499233 510827 497161 501352 527356 482618 484218 487479 547825 562381 553321 555980 559459 564711 582932 708232 710349 660606 667917 563670 588555 639051 595514 596347 610202 617087 619917 626872 587865 617636 ] |
||||||||||||||||||||||||||||||
|
4.46 ms (1.07%) |
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 382266 403373 404019 408164 408411 413084 418259 421137 421613 430562 432318 432696 440581 440852 442143 445266 445560 448064 448337 448802 449260 449302 456367 457797 459295 460853 460904 462359 464243 469195 474809 476149 476853 479281 479285 479303 482618 482755 484218 485059 487479 495992 496086 497161 499233 499527 500184 501352 504870 510827 511633 515002 517867 519762 526627 527356 528628 531308 547825 553321 555980 559459 562381 563670 564711 565201 582220 582932 587865 588555 589360 590218 591996 595308 595514 595941 596347 601407 601664 602487 610202 612429 612550 613956 617087 617636 619917 626872 627487 639051 640252 652931 660606 667917 689520 693155 708232 710349 715138 719192 720802 724335 732915 744184 750732 761294 770615 770662 776316 779913 781586 782557 785624 788236 790998 793642 806183 812429 813187 821370 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face lick"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face лиза"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"face лиза"
]
|
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.