Query Metrics
7
Database Queries
7
Different statements
195.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.26 ms (85.09%) |
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 418949 425003 427550 456179 456893 461364 462812 462870 463343 466540 481946 489958 492940 499786 505534 505937 516039 517217 519713 520253 525115 526704 530730 534253 538358 548601 549695 551287 551404 552198 552300 570218 570459 571819 574030 575823 576285 582558 584759 595516 597503 599451 601630 601644 601869 609268 609274 609780 610255 610261 610647 614729 617869 618943 619223 622329 623003 623322 626547 633112 635988 636270 643418 643738 646246 651611 652855 652901 653238 653458 661705 676421 676491 676517 676538 677028 677691 686514 688333 688997 693302 697311 703215 704987 707324 716033 716087 721124 721368 721427 721487 721721 725399 727684 731898 733887 734952 738904 738910 741279 741996 753722 755380 760938 760942 765278 772410 785761 791359 802436 803067 814755 814831 814847 815007 815096 815466 815741 818198 820070 ] |
||||||||||||||||||||||||||||||
|
19.36 ms (9.91%) |
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 551404 597503 814847 466540 456893 492940 575823 688333 595516 599451 635988 462812 425003 456179 461364 516039 815741 549695 570218 652901 676491 676517 676538 697311 686514 716033 609780 643738 623322 791359 733887 738910 760942 765278 772410 727684 731898 755380 738904 617869 505937 820070 525115 703215 619223 636270 626547 725399 734952 633112 517217 652855 622329 601630 614729 618943 427550 489958 520253 584759 571819 526704 418949 814755 815007 481946 530730 570459 548601 574030 688997 721124 661705 704987 721368 677028 693302 610261 601869 741996 707324 601644 760938 499786 814831 815466 818198 815096 462870 463343 505534 534253 552300 582558 646246 651611 676421 677691 721427 721487 576285 609274 610647 623003 643418 609268 803067 802436 741279 753722 716087 721721 785761 538358 653458 551287 610255 519713 653238 552198 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.54%) |
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 418949 425003 427550 456179 456893 461364 462812 462870 463343 466540 481946 489958 492940 499786 505534 505937 516039 517217 519713 520253 525115 526704 530730 534253 538358 548601 549695 551287 551404 552198 552300 570218 570459 571819 574030 575823 576285 582558 584759 595516 597503 599451 601630 601644 601869 609268 609274 609780 610255 610261 610647 614729 617869 618943 619223 622329 623003 623322 626547 633112 635988 636270 643418 643738 646246 651611 652855 652901 653238 653458 661705 676421 676491 676517 676538 677028 677691 686514 688333 688997 693302 697311 703215 704987 707324 716033 716087 721124 721368 721427 721487 721721 725399 727684 731898 733887 734952 738904 738910 741279 741996 753722 755380 760938 760942 765278 772410 785761 791359 802436 803067 814755 814831 814847 815007 815096 815466 815741 818198 820070 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage shaving cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж shaving cock"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж shaving cock"
]
|
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.