Query Metrics
7
Database Queries
7
Different statements
157.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.91 ms (84.51%) |
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 16808 172068 187636 187709 188189 188610 233269 250695 359011 382289 385334 388329 388470 388723 390455 390643 391156 391158 391427 395927 395998 396887 397890 398562 398935 406073 407411 407449 409931 411615 411696 411727 413303 413471 439488 462557 464297 464936 465390 468167 476239 479056 480290 480301 481953 484763 485444 486350 486485 493120 503829 503845 514581 533635 537135 546455 547018 563088 563209 563640 580940 581004 589752 597103 615014 630399 662881 663893 664861 665206 665302 672369 694072 712812 716221 719898 719903 720470 720482 721890 723984 726490 743811 746598 748163 755357 756878 757641 759113 766671 770164 776320 776339 781930 788505 790885 800452 810769 817424 817776 817806 817812 817813 818638 818968 818983 818987 818991 819001 819004 819007 819016 819019 819117 819240 827054 828034 828145 828370 828373 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (9.38%) |
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 720470 672369 485444 743811 827054 828034 781930 766671 406073 188610 748163 409931 819240 411727 819007 464297 468167 719903 630399 818983 396887 395998 382289 187709 480290 756878 819001 712812 503829 828145 563640 817813 819019 818638 479056 589752 580940 391156 723984 514581 391427 385334 484763 828370 493120 250695 828373 546455 788505 597103 800452 398935 413303 810769 390455 790885 664861 359011 817776 817806 817424 533635 662881 746598 720482 462557 465390 694072 776320 476239 388470 818987 563209 188189 407411 563088 233269 721890 537135 615014 395927 663893 464936 486485 398562 413471 819117 547018 759113 665302 407449 819004 388723 481953 503845 411615 776339 390643 16808 719898 439488 818991 819016 726490 755357 757641 581004 486350 397890 411696 818968 817812 172068 716221 770164 187636 388329 480301 665206 391158 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.83%) |
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 16808 172068 187636 187709 188189 188610 233269 250695 359011 382289 385334 388329 388470 388723 390455 390643 391156 391158 391427 395927 395998 396887 397890 398562 398935 406073 407411 407449 409931 411615 411696 411727 413303 413471 439488 462557 464297 464936 465390 468167 476239 479056 480290 480301 481953 484763 485444 486350 486485 493120 503829 503845 514581 533635 537135 546455 547018 563088 563209 563640 580940 581004 589752 597103 615014 630399 662881 663893 664861 665206 665302 672369 694072 712812 716221 719898 719903 720470 720482 721890 723984 726490 743811 746598 748163 755357 756878 757641 759113 766671 770164 776320 776339 781930 788505 790885 800452 810769 817424 817776 817806 817812 817813 818638 818968 818983 818987 818991 819001 819004 819007 819016 819019 819117 819240 827054 828034 828145 828370 828373 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature public fuck"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.