Query Metrics
7
Database Queries
7
Different statements
148.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.21 ms (80.30%) |
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 389612 389973 400854 401140 406217 412583 413100 420311 421181 421207 423320 423336 424056 424443 424675 430255 430303 432172 432831 432886 442494 442771 443274 443760 443761 443763 443767 443812 445182 446811 447618 449180 454251 454317 454322 454542 456369 456883 460731 460745 460750 462319 462799 464322 464703 465335 465355 466085 466101 466118 466207 470560 470772 471056 474016 475121 476342 476344 479040 480742 481591 484377 484484 484601 484914 485691 486531 489461 490262 492719 493093 494557 494786 497337 503965 504604 506050 506997 507540 509481 510571 510750 511691 512831 516393 520890 521260 521516 523040 523169 525349 526077 526083 526737 528071 528258 543343 543812 564786 569427 570521 571210 571680 576643 586015 587530 587817 590959 595061 595931 596966 610311 618803 640029 650487 662896 669276 807340 814431 819823 ] |
||||||||||||||||||||||||||||||
|
20.24 ms (13.64%) |
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 520890 569427 445182 466085 506050 389973 511691 570521 462799 650487 443274 464703 503965 543812 576643 466207 484601 516393 484484 471056 640029 543343 504604 447618 486531 489461 400854 454322 420311 526737 528071 464322 526083 454542 494786 443761 479040 484914 571680 526077 669276 586015 587530 595061 807340 443812 456369 412583 510750 662896 456883 430303 521260 512831 596966 421181 423320 432886 590959 470772 443763 506997 523040 507540 423336 443767 465335 460731 618803 449180 465355 528258 442771 814431 523169 485691 424056 460745 509481 480742 401140 389612 424443 460750 521516 510571 587817 443760 442494 595931 564786 494557 432831 610311 476344 492719 421207 476342 497337 474016 462319 466118 490262 406217 466101 432172 424675 430255 571210 413100 470560 454251 525349 475121 446811 819823 493093 454317 484377 481591 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.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 389612 389973 400854 401140 406217 412583 413100 420311 421181 421207 423320 423336 424056 424443 424675 430255 430303 432172 432831 432886 442494 442771 443274 443760 443761 443763 443767 443812 445182 446811 447618 449180 454251 454317 454322 454542 456369 456883 460731 460745 460750 462319 462799 464322 464703 465335 465355 466085 466101 466118 466207 470560 470772 471056 474016 475121 476342 476344 479040 480742 481591 484377 484484 484601 484914 485691 486531 489461 490262 492719 493093 494557 494786 497337 503965 504604 506050 506997 507540 509481 510571 510750 511691 512831 516393 520890 521260 521516 523040 523169 525349 526077 526083 526737 528071 528258 543343 543812 564786 569427 570521 571210 571680 576643 586015 587530 587817 590959 595061 595931 596966 610311 618803 640029 650487 662896 669276 807340 814431 819823 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cunnilingus amateur hairy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс любительск волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.99%) |
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.