Query Metrics
7
Database Queries
7
Different statements
150.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.74 ms (80.71%) |
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 79720 152882 233166 358592 358596 365865 365880 384124 387359 388767 390212 391562 391588 392563 397845 398971 400519 400810 400813 401807 403321 406648 406882 411322 411468 418886 421603 421895 421900 422151 422197 424491 426864 427091 427281 432596 433249 439707 439802 440339 440345 440601 443673 443695 443706 443707 443726 443776 443810 443881 448558 451506 452302 455366 459722 460581 460776 461233 462019 462122 462325 462553 462559 462957 464997 466238 466840 467781 468181 470096 470275 470294 470555 474109 474213 474418 474693 475877 477981 478067 478462 483656 484559 484735 487362 489634 492180 495246 504458 506031 506718 508677 511830 512100 522956 526885 552820 553957 555093 556651 562999 563438 563640 574022 590633 609723 612977 613286 620211 623493 729205 740593 742237 749900 761607 762113 780810 796954 805248 816118 ] |
||||||||||||||||||||||||||||||
|
17.95 ms (11.90%) |
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 365880 552820 443707 443673 620211 470294 555093 623493 401807 79720 440601 422197 504458 421603 478462 439707 427281 391588 406648 506718 421900 563438 470096 474213 459722 467781 484735 424491 443776 816118 492180 427091 462019 562999 443810 511830 474109 466840 609723 233166 613286 474693 152882 387359 470275 742237 439802 489634 474418 411322 553957 612977 421895 411468 390212 475877 478067 358596 796954 365865 563640 433249 462325 443695 512100 384124 740593 462957 455366 462122 749900 762113 440339 462559 392563 391562 451506 522956 443881 406882 426864 508677 443726 484559 477981 464997 466238 461233 526885 452302 400519 432596 468181 403321 805248 574022 398971 397845 590633 440345 418886 462553 422151 483656 443706 780810 400810 400813 506031 460581 460776 448558 470555 495246 487362 358592 556651 729205 761607 388767 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.71%) |
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 79720 152882 233166 358592 358596 365865 365880 384124 387359 388767 390212 391562 391588 392563 397845 398971 400519 400810 400813 401807 403321 406648 406882 411322 411468 418886 421603 421895 421900 422151 422197 424491 426864 427091 427281 432596 433249 439707 439802 440339 440345 440601 443673 443695 443706 443707 443726 443776 443810 443881 448558 451506 452302 455366 459722 460581 460776 461233 462019 462122 462325 462553 462559 462957 464997 466238 466840 467781 468181 470096 470275 470294 470555 474109 474213 474418 474693 475877 477981 478067 478462 483656 484559 484735 487362 489634 492180 495246 504458 506031 506718 508677 511830 512100 522956 526885 552820 553957 555093 556651 562999 563438 563640 574022 590633 609723 612977 613286 620211 623493 729205 740593 742237 749900 761607 762113 780810 796954 805248 816118 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет русской мамки"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс русск мам женщин"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.35%) |
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.