Query Metrics
7
Database Queries
7
Different statements
175.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.05 ms (81.46%) |
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 395622 418881 420596 427161 428157 429927 436178 437548 437587 438095 438807 439516 439726 441191 456933 460997 462272 476492 477043 479011 480726 484032 487693 490723 490916 491457 492507 493277 493287 495631 499618 501198 501650 502634 504644 505431 505750 505923 506816 507563 508695 509904 509965 510428 511548 511600 511911 512385 512544 512738 513039 513566 515371 516391 516919 516922 518798 518943 519496 519857 520126 522971 523260 523539 523625 523913 525513 525840 526057 527172 527304 527355 528257 542062 552851 562176 563396 565321 565474 565476 567716 570840 571509 572913 576007 580236 582811 586539 590221 595383 596235 597488 597963 598500 598592 600364 601364 601395 602923 604097 607045 609199 609230 609464 610694 617040 618334 625359 626302 626364 650289 651214 653267 653463 653507 655697 658661 661394 691713 746083 ] |
||||||||||||||||||||||||||||||
|
21.32 ms (12.14%) |
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 420596 512738 516919 520126 504644 508695 510428 511548 511600 511911 519496 526057 528257 491457 493277 523625 492507 493287 499618 523539 651214 460997 519857 617040 429927 479011 439726 512544 512385 527172 552851 570840 580236 571509 572913 600364 601364 601395 609464 746083 456933 477043 437587 476492 438807 505923 516391 484032 490723 505431 518943 501650 516922 518798 487693 501198 502634 507563 525840 653267 441191 462272 565321 691713 505750 525513 490916 542062 567716 576007 658661 565476 604097 586539 596235 427161 395622 428157 523913 515371 495631 527304 527355 506816 509965 513039 522971 509904 418881 661394 595383 653463 562176 582811 437548 480726 438095 513566 653507 598500 598592 439516 563396 565474 609199 626364 650289 607045 610694 626302 590221 618334 436178 523260 625359 602923 655697 597488 597963 609230 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (2.14%) |
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 395622 418881 420596 427161 428157 429927 436178 437548 437587 438095 438807 439516 439726 441191 456933 460997 462272 476492 477043 479011 480726 484032 487693 490723 490916 491457 492507 493277 493287 495631 499618 501198 501650 502634 504644 505431 505750 505923 506816 507563 508695 509904 509965 510428 511548 511600 511911 512385 512544 512738 513039 513566 515371 516391 516919 516922 518798 518943 519496 519857 520126 522971 523260 523539 523625 523913 525513 525840 526057 527172 527304 527355 528257 542062 552851 562176 563396 565321 565474 565476 567716 570840 571509 572913 576007 580236 582811 586539 590221 595383 596235 597488 597963 598500 598592 600364 601364 601395 602923 604097 607045 609199 609230 609464 610694 617040 618334 625359 626302 626364 650289 651214 653267 653463 653507 655697 658661 661394 691713 746083 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск boyfriend"
]
|
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.