Query Metrics
7
Database Queries
7
Different statements
402.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.88 ms (52.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting girl"
]
|
||||||||||||||||||||||||||||||
|
166.94 ms (41.43%) |
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 53305 53396 54301 242216 381867 383246 383512 385607 387857 396350 396799 397152 406105 410402 412492 413700 414217 415524 415735 415871 415941 416329 416988 417721 418846 420543 420544 421355 424566 427221 429630 432997 447432 451979 458209 461438 462091 462793 464298 465503 468591 468691 468776 469853 471348 471857 472727 473071 474647 474657 474735 484457 491516 492681 493897 495367 500680 501228 501874 502466 506387 510672 512782 513909 515896 521363 523461 527496 527497 527554 528506 532249 533747 535648 541291 550343 550396 550401 554266 558040 558861 566070 567843 574482 574499 576027 576271 585133 595422 596347 599610 602049 603004 605303 621004 633732 636866 648518 661106 662668 669110 672392 684183 700620 701794 710144 721455 722671 730582 735983 736056 736865 748367 751047 754725 767310 773605 774130 774145 817462 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (3.94%) |
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 533747 633732 710144 53396 420543 427221 415941 468591 491516 558040 574482 576027 558861 596347 471348 424566 492681 506387 523461 242216 700620 661106 736056 751047 730582 736865 748367 817462 535648 527496 662668 684183 621004 636866 735983 773605 387857 385607 383512 410402 420544 414217 417721 472727 465503 500680 462793 672392 550396 554266 421355 416329 458209 412492 469853 429630 527554 528506 527497 521363 474735 451979 513909 541291 567843 605303 603004 501228 396799 701794 669110 722671 721455 754725 774130 767310 774145 396350 406105 415735 418846 585133 468691 473071 464298 550401 576271 432997 461438 474647 462091 447432 468776 471857 501874 512782 495367 510672 493897 532249 381867 54301 413700 415871 474657 566070 595422 602049 383246 53305 415524 416988 484457 550343 599610 515896 397152 502466 574499 648518 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (0.91%) |
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 53305 53396 54301 242216 381867 383246 383512 385607 387857 396350 396799 397152 406105 410402 412492 413700 414217 415524 415735 415871 415941 416329 416988 417721 418846 420543 420544 421355 424566 427221 429630 432997 447432 451979 458209 461438 462091 462793 464298 465503 468591 468691 468776 469853 471348 471857 472727 473071 474647 474657 474735 484457 491516 492681 493897 495367 500680 501228 501874 502466 506387 510672 512782 513909 515896 521363 523461 527496 527497 527554 528506 532249 533747 535648 541291 550343 550396 550401 554266 558040 558861 566070 567843 574482 574499 576027 576271 585133 595422 596347 599610 602049 603004 605303 621004 633732 636866 648518 661106 662668 669110 672392 684183 700620 701794 710144 721455 722671 730582 735983 736056 736865 748367 751047 754725 767310 773605 774130 774145 817462 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг девушк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.36%) |
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.