Query Metrics
7
Database Queries
7
Different statements
182.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.24 ms (86.88%) |
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 185123 185861 348918 386598 405975 417701 418407 418718 423472 425374 425757 426868 428066 428093 431455 431474 432161 440724 444278 444432 447551 455095 456738 456741 457254 459484 459489 459499 465174 466641 468421 469956 471146 471331 474233 476079 478633 483682 492815 494630 495547 495887 518385 521812 523376 523935 527061 531034 532261 534593 539808 541190 543032 549127 550535 550688 553845 558083 558166 570144 570328 575381 579261 583575 584436 586576 589296 591724 602556 603873 605002 607481 607926 610199 615449 620808 625440 626091 628344 631542 636956 640098 640219 650727 652855 653240 673424 678947 681394 687554 693410 709885 720946 721521 727668 729883 737356 744050 744346 746997 758606 762332 767701 770083 770956 775830 776082 777006 780595 781001 786354 788430 790815 792430 798481 799409 802230 806865 810543 812596 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (7.94%) |
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 476079 539808 575381 550535 628344 523376 541190 792430 799409 652855 790815 549127 603873 418718 531034 721521 471146 532261 428093 640098 770083 806865 386598 770956 802230 798481 729883 650727 620808 810543 631542 776082 678947 720946 812596 737356 518385 495887 744346 786354 494630 405975 586576 626091 483682 744050 469956 431474 444432 775830 440724 478633 468421 543032 610199 417701 653240 640219 788430 767701 185123 471331 693410 681394 607926 758606 459489 425374 432161 727668 709885 455095 431455 425757 459484 523935 495547 185861 570328 762332 746997 428066 687554 636956 777006 456741 423472 426868 570144 583575 591724 781001 348918 465174 527061 607481 605002 615449 625440 579261 492815 418407 534593 558083 589296 602556 444278 521812 558166 553845 673424 780595 457254 459499 584436 474233 466641 447551 550688 456738 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.52%) |
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 185123 185861 348918 386598 405975 417701 418407 418718 423472 425374 425757 426868 428066 428093 431455 431474 432161 440724 444278 444432 447551 455095 456738 456741 457254 459484 459489 459499 465174 466641 468421 469956 471146 471331 474233 476079 478633 483682 492815 494630 495547 495887 518385 521812 523376 523935 527061 531034 532261 534593 539808 541190 543032 549127 550535 550688 553845 558083 558166 570144 570328 575381 579261 583575 584436 586576 589296 591724 602556 603873 605002 607481 607926 610199 615449 620808 625440 626091 628344 631542 636956 640098 640219 650727 652855 653240 673424 678947 681394 687554 693410 709885 720946 721521 727668 729883 737356 744050 744346 746997 758606 762332 767701 770083 770956 775830 776082 777006 780595 781001 786354 788430 790815 792430 798481 799409 802230 806865 810543 812596 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"it sexy girl"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy девушк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy девушк"
]
|
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.