Query Metrics
7
Database Queries
7
Different statements
140.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.10 ms (82.84%) |
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 418520 419793 420335 425313 425493 425624 427794 432990 435878 437156 437847 440441 446793 447536 447828 448472 449078 450413 454592 455009 455984 456328 457542 457563 457572 457910 458957 459143 459347 460211 461750 461896 462592 464017 464506 467130 468893 469069 469183 469452 470521 471918 472222 474118 475270 475831 475986 476911 479426 480895 483828 486675 489249 489288 490003 491569 492134 492247 493037 493801 496964 498285 499770 503403 503577 504024 505222 506749 507783 510310 512607 513458 513473 515480 516454 516513 518238 519489 519735 523042 523457 523476 523807 525472 526094 527765 530774 532140 532885 534342 535478 535577 539441 543240 546149 549711 549739 555468 555480 556703 556707 557648 564860 567006 569632 569970 581722 582016 591623 600671 602146 612356 615006 618690 619366 654436 674758 676154 680838 798612 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (10.33%) |
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 483828 454592 457572 457563 476911 496964 523042 499770 535478 523807 557648 546149 618690 448472 469452 469069 516513 489249 523476 512607 513458 525472 456328 535577 676154 518238 457910 515480 569632 680838 435878 475831 425313 446793 539441 523457 492134 461750 507783 654436 491569 489288 469183 556703 582016 615006 798612 419793 455009 471918 480895 510310 425624 556707 447828 498285 602146 555480 437847 468893 493037 490003 504024 464506 506749 493801 440441 462592 519735 470521 527765 534342 564860 600671 427794 513473 555468 420335 464017 532140 612356 455984 530774 567006 674758 549739 619366 474118 432990 503403 425493 450413 472222 492247 449078 459347 461896 475986 486675 505222 532885 479426 543240 581722 549711 569970 457542 459143 475270 467130 418520 437156 447536 458957 460211 516454 519489 526094 503577 591623 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.75%) |
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 418520 419793 420335 425313 425493 425624 427794 432990 435878 437156 437847 440441 446793 447536 447828 448472 449078 450413 454592 455009 455984 456328 457542 457563 457572 457910 458957 459143 459347 460211 461750 461896 462592 464017 464506 467130 468893 469069 469183 469452 470521 471918 472222 474118 475270 475831 475986 476911 479426 480895 483828 486675 489249 489288 490003 491569 492134 492247 493037 493801 496964 498285 499770 503403 503577 504024 505222 506749 507783 510310 512607 513458 513473 515480 516454 516513 518238 519489 519735 523042 523457 523476 523807 525472 526094 527765 530774 532140 532885 534342 535478 535577 539441 543240 546149 549711 549739 555468 555480 556703 556707 557648 564860 567006 569632 569970 581722 582016 591623 600671 602146 612356 615006 618690 619366 654436 674758 676154 680838 798612 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в шортах с большой жопой"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в шорт большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.