https://sokol.datads.pro/frontapi/get_stories_categories

Method
POST
HTTP Status
200
IP
127.0.0.1
Profiled on
Token
1fd59b

Query Metrics

23 Database Queries
2 Different statements
5.14 ms Query time
14 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.73 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.h1 AS h1_4, t0.h1text AS h1text_5, t0.domain AS domain_6 FROM story_category t0 WHERE t0.domain = ? AND t0.status = ? ORDER BY t0.id ASC
Parameters: 
[
  "gribu.lv"
  "active"
]
View formatted query    View runnable query    Explain query
2 0.29 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
3 0.29 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
4 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query
5 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
6 0.21 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  35
]
View formatted query    View runnable query    Explain query
7 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query
8 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query
9 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  38
]
View formatted query    View runnable query    Explain query
10 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  39
]
View formatted query    View runnable query    Explain query
11 0.22 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  40
]
View formatted query    View runnable query    Explain query
12 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  41
]
View formatted query    View runnable query    Explain query
13 0.20 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query
14 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  43
]
View formatted query    View runnable query    Explain query
15 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
16 0.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  45
]
View formatted query    View runnable query    Explain query
17 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  46
]
View formatted query    View runnable query    Explain query
18 0.20 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  47
]
View formatted query    View runnable query    Explain query
19 0.20 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  50
]
View formatted query    View runnable query    Explain query
20 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
21 0.22 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query
22 0.18 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query
23 0.20 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?
Parameters: 
[
  54
]
View formatted query    View runnable query    Explain query

sphinx connection

No database queries were performed.

sexycommunity connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
sphinx doctrine.dbal.sphinx_connection
sexycommunity doctrine.dbal.sexycommunity_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
sphinx doctrine.orm.sphinx_entity_manager
sexycommunity doctrine.orm.sexycommunity_entity_manager
auto_generate_proxy_classes doctrine.orm.auto_generate_proxy_classes_entity_manager
auto_mapping doctrine.orm.auto_mapping_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\StoryCategory No errors.
App\Entity\Story No errors.
App\Entity\AdsInfo No errors.
App\EntitySphinx\Ads No errors.
App\Entity\SubscribeLog No errors.
App\Entity\User
  • The field App\Entity\User#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Video#user does not contain the required 'inversedBy="videos"' attribute.
  • The field App\Entity\User#presents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserPresent#receivingUser does not contain the required 'inversedBy="presents"' attribute.
App\Entity\ChatGroup
  • The field App\Entity\ChatGroup#conversations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Conversation#chatGroup does not contain the required 'inversedBy="conversations"' attribute.
App\Entity\Activity No errors.
App\Entity\Comment No errors.
App\Entity\VideoComment No errors.
App\Entity\BlogComment
  • The association App\Entity\BlogComment#parent refers to the inverse side field App\Entity\BlogComment#children which does not exist.
App\Entity\GroupPublication
  • The association App\Entity\GroupPublication#parent refers to the inverse side field App\Entity\GroupPublication#children which does not exist.
App\Entity\Message
  • The association App\Entity\Message#parent refers to the inverse side field App\Entity\Message#children which does not exist.
App\Entity\StoryComment No errors.
App\Entity\GuestbookPublication
  • The association App\Entity\GuestbookPublication#parent refers to the inverse side field App\Entity\GuestbookPublication#children which does not exist.
App\Entity\Blog No errors.
App\Entity\LiveMessage No errors.
App\Entity\Conversation
  • The field App\Entity\Conversation#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Message#conversation does not contain the required 'inversedBy="messages"' attribute.
App\Entity\ChatGroupLock No errors.
App\Entity\Setting No errors.
App\Entity\Category
  • The association App\Entity\Category#city refers to the inverse side field App\Entity\City#categories which does not exist.
App\Entity\Image
  • The association App\Entity\Image#groupPublications refers to the owning side field App\Entity\GroupPublication#avatar which does not exist.
App\Entity\PhotoAlbum No errors.
App\Entity\ImageOld
  • The association App\Entity\ImageOld#groupPublications refers to the owning side field App\Entity\GroupPublication#avatar which does not exist.
App\Entity\UserStatusLog No errors.
App\Entity\MaxOnlineStatInfo No errors.
App\Entity\ChatVerification No errors.
App\Entity\Payment No errors.
App\Entity\Transaction No errors.
App\Entity\Subscription No errors.
App\Entity\Contest
  • The field App\Entity\Contest#info is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContestInfo#contest does not contain the required 'inversedBy="info"' attribute.
App\Entity\Video
  • The field App\Entity\Video#likes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VideoLike#video does not contain the required 'inversedBy="likes"' attribute.
App\Entity\VideoAlbum No errors.
App\Entity\AdsReport No errors.
App\Entity\Voting
  • The field App\Entity\Voting#questions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VotingQuestion#voting does not contain the required 'inversedBy="questions"' attribute.
App\Entity\VotingQuestion
  • The field App\Entity\VotingQuestion#answers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VotingAnswer#question does not contain the required 'inversedBy="answers"' attribute.
App\Entity\VotingAnswer No errors.
App\Entity\UserAgreement No errors.
App\Entity\StoryCategorySub No errors.

sphinx entity manager

No loaded entities.

sexycommunity entity manager

No loaded entities.

auto_generate_proxy_classes entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.