Query Metrics
7
Database Queries
7
Different statements
366.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.60 ms (56.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking pussy compilation"
]
|
||||||||||||||||||||||||||||||
|
131.07 ms (35.81%) |
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 387055 421093 421162 421654 425829 425971 430306 430572 432766 434933 436829 442276 447454 449021 450654 454186 454765 455816 455847 455857 456525 457590 461271 463825 463846 465147 465175 466103 466801 468154 468716 470918 471162 474520 474549 475080 476098 476276 476706 477993 482559 483152 483220 484369 485131 488330 490034 491248 491678 494500 495212 497358 502505 503105 504121 509114 511011 511422 512955 513149 514721 517740 519653 520171 522107 522344 522779 525747 526170 527443 528669 535132 536270 539532 539533 540241 554770 556632 556945 557204 558469 563220 569119 576519 581035 586493 594106 606618 640377 649836 650053 650796 656281 683237 690884 694203 697912 715509 717083 721739 743021 759840 768378 771958 774009 777036 795437 803017 803373 804462 805112 808500 808527 813987 814347 814849 815269 817131 817354 827080 ] |
||||||||||||||||||||||||||||||
|
20.81 ms (5.69%) |
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 808500 442276 432766 421162 430572 454186 474549 490034 455816 468716 471162 525747 502505 468154 557204 594106 586493 477993 436829 455847 470918 457590 434933 447454 511422 522779 527443 484369 514721 526170 488330 494500 520171 814849 463846 466801 511011 512955 517740 519653 556632 563220 581035 649836 650796 576519 774009 795437 804462 461271 454765 495212 513149 777036 476098 476706 421093 483152 465175 449021 554770 683237 425829 421654 466103 491678 522107 456525 558469 656281 556945 808527 425971 813987 817354 817131 827080 815269 450654 539533 509114 528669 535132 536270 539532 540241 522344 569119 650053 717083 690884 694203 697912 721739 606618 640377 803373 805112 743021 771958 803017 759840 768378 715509 476276 483220 497358 387055 430306 814347 455857 475080 485131 463825 482559 491248 465147 474520 504121 503105 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (0.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 387055 421093 421162 421654 425829 425971 430306 430572 432766 434933 436829 442276 447454 449021 450654 454186 454765 455816 455847 455857 456525 457590 461271 463825 463846 465147 465175 466103 466801 468154 468716 470918 471162 474520 474549 475080 476098 476276 476706 477993 482559 483152 483220 484369 485131 488330 490034 491248 491678 494500 495212 497358 502505 503105 504121 509114 511011 511422 512955 513149 514721 517740 519653 520171 522107 522344 522779 525747 526170 527443 528669 535132 536270 539532 539533 540241 554770 556632 556945 557204 558469 563220 569119 576519 581035 586493 594106 606618 640377 649836 650053 650796 656281 683237 690884 694203 697912 715509 717083 721739 743021 759840 768378 771958 774009 777036 795437 803017 803373 804462 805112 808500 808527 813987 814347 814849 815269 817131 817354 827080 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза pussy подборк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза pussy подборк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.39%) |
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.