Query Metrics
7
Database Queries
7
Different statements
163.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.59 ms (86.10%) |
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 327421 383609 391241 397848 432749 462207 468288 468712 469559 470053 470355 478310 480724 493493 497443 497703 500065 504450 506133 506291 508542 511673 512506 513157 513826 515959 516511 517418 520388 520788 525030 525038 526608 529377 531326 533384 548991 555318 556680 562853 564556 567311 569146 572968 584915 592402 593577 597726 601604 602409 604338 633754 634540 637917 646002 654338 655927 680441 714037 715396 717359 720231 723269 727199 728412 730083 731834 732594 734347 734411 740275 740710 742112 742719 750251 756160 756666 760899 760988 761000 762272 762774 764207 765059 765240 765480 765591 766591 766599 766785 766876 767257 768372 768410 768730 769036 769038 774702 775532 777143 778133 778951 781331 781339 781359 783102 783378 788982 791412 791422 791506 791560 791770 791860 794360 800394 800893 801309 804228 810039 ] |
||||||||||||||||||||||||||||||
|
13.63 ms (8.35%) |
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 781359 783102 801309 804228 734411 740710 742112 762272 767257 783378 791506 791770 794360 800394 810039 728412 731834 734347 760988 766599 768410 768730 769036 730083 764207 765591 766591 732594 760899 765480 766876 727199 742719 750251 633754 634540 714037 715396 720231 774702 777143 791412 791422 800893 432749 500065 762774 765240 765059 781339 778133 778951 756160 756666 769038 781331 397848 468288 504450 515959 548991 572968 637917 775532 506133 526608 646002 517418 562853 564556 593577 717359 723269 791560 761000 740275 768372 766785 788982 791860 516511 327421 469559 470355 493493 508542 513157 520388 520788 497703 511673 529377 513826 525030 478310 480724 555318 567311 569146 584915 655927 654338 680441 556680 601604 602409 592402 597726 604338 462207 383609 525038 391241 468712 470053 512506 533384 497443 506291 531326 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.34%) |
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 327421 383609 391241 397848 432749 462207 468288 468712 469559 470053 470355 478310 480724 493493 497443 497703 500065 504450 506133 506291 508542 511673 512506 513157 513826 515959 516511 517418 520388 520788 525030 525038 526608 529377 531326 533384 548991 555318 556680 562853 564556 567311 569146 572968 584915 592402 593577 597726 601604 602409 604338 633754 634540 637917 646002 654338 655927 680441 714037 715396 717359 720231 723269 727199 728412 730083 731834 732594 734347 734411 740275 740710 742112 742719 750251 756160 756666 760899 760988 761000 762272 762774 764207 765059 765240 765480 765591 766591 766599 766785 766876 767257 768372 768410 768730 769036 769038 774702 775532 777143 778133 778951 781331 781339 781359 783102 783378 788982 791412 791422 791506 791560 791770 791860 794360 800394 800893 801309 804228 810039 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сперма анальный видео"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм анал виде"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.88%) |
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.