Query Metrics
7
Database Queries
7
Different statements
144.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.25 ms (81.01%) |
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 90718 293499 383737 388551 400156 411132 415505 423967 429217 434576 436685 439271 448609 449546 452890 453292 453481 454723 456129 461022 461956 467982 474210 482249 483252 485096 487620 492412 493751 495636 496341 499572 510551 511108 513087 515779 519964 520111 521625 521851 522931 523373 523751 526001 526379 527109 527306 531559 533963 538263 540583 544323 546542 546702 547450 547813 547881 547945 548556 549574 550175 552577 553229 554083 555283 556805 560148 560789 560989 561276 562096 565547 568540 568864 572205 575610 576170 576961 577792 581058 581092 581394 581969 582829 584456 586005 586285 587954 590702 590981 591406 591596 591970 592644 593236 593927 595868 595986 598039 600688 601164 602727 602997 605707 608415 609998 611264 616511 619506 622632 623301 629770 637500 659361 659400 714289 734387 739318 782659 796816 ] |
||||||||||||||||||||||||||||||
|
17.32 ms (11.96%) |
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 547881 548556 550175 553229 575610 584456 547813 549574 546702 568864 582829 714289 556805 560989 565547 581058 586285 590981 591596 601164 609998 598039 600688 629770 590702 591970 608415 587954 592644 593236 734387 739318 782659 293499 448609 436685 411132 454723 388551 429217 461022 461956 487620 483252 496341 520111 581394 659400 423967 449546 467982 482249 492412 499572 527109 531559 521625 495636 521851 547450 560148 572205 544323 547945 560789 561276 577792 546542 552577 554083 555283 568540 576170 581092 659361 591406 623301 637500 605707 622632 593927 602727 611264 616511 796816 434576 439271 90718 452890 453481 474210 456129 522931 493751 510551 511108 523751 538263 562096 602997 400156 513087 526001 540583 515779 527306 519964 526379 533963 485096 581969 576961 586005 619506 595868 595986 383737 415505 453292 523373 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.38%) |
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 90718 293499 383737 388551 400156 411132 415505 423967 429217 434576 436685 439271 448609 449546 452890 453292 453481 454723 456129 461022 461956 467982 474210 482249 483252 485096 487620 492412 493751 495636 496341 499572 510551 511108 513087 515779 519964 520111 521625 521851 522931 523373 523751 526001 526379 527109 527306 531559 533963 538263 540583 544323 546542 546702 547450 547813 547881 547945 548556 549574 550175 552577 553229 554083 555283 556805 560148 560789 560989 561276 562096 565547 568540 568864 572205 575610 576170 576961 577792 581058 581092 581394 581969 582829 584456 586005 586285 587954 590702 590981 591406 591596 591970 592644 593236 593927 595868 595986 598039 600688 601164 602727 602997 605707 608415 609998 611264 616511 619506 622632 623301 629770 637500 659361 659400 714289 734387 739318 782659 796816 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"finger fuck"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"палец секс"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.98%) |
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.