POST https://couponscode.com/api/ext/search-product

Query Metrics

13 Database Queries
6 Different statements
1.81 ms Query time
1 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status_id AS status_id_5, t0.role_id AS role_id_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.points AS points_9, t0.language AS language_10, t0.currency AS currency_11, t0.timezone AS timezone_12, t0.country AS country_13, t0.twofa AS twofa_14, t0.twofa_confirmed AS twofa_confirmed_15, t0.payout_id AS payout_id_16, t0.payout_details AS payout_details_17, t0.banned_until AS banned_until_18, t0.login_fails AS login_fails_19, t0.last_login_fail AS last_login_fail_20, t0.insert_date AS insert_date_21, t0.avatar AS avatar_22 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "surugiu.daniel@gmail.com"
]
2 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\Plugins\Integrations\Impact"
]
3 0.16 ms
SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1
Parameters:
[
  "impact_fetch_data"
]
4 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\Plugins\Integrations\Skimlinks"
]
5 0.09 ms
SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1
Parameters:
[
  "impact_fetch_data"
]
6 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\Plugins\Integrations\CJ"
]
7 0.08 ms
SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1
Parameters:
[
  "cj_fetch_data"
]
8 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\Plugins\Integrations\Awin"
]
9 0.05 ms
SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1
Parameters:
[
  "awin_fetch_data"
]
10 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
  "api_ext_search_product"
]
11 0.08 ms
SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = ?
Parameters:
[
  "paths"
]
12 0.09 ms
SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = ?
Parameters:
[
  "seo"
]
13 0.22 ms
SELECT 
                p.name,
                p.*, 
                MATCH(p.name) AGAINST(? IN BOOLEAN MODE) AS score
            FROM products p
            WHERE MATCH(p.name) AGAINST(? IN BOOLEAN MODE) AND p.status = ?
            ORDER BY score DESC
            LIMIT 10
Parameters:
[
  "Google Gemini"
  "Google Gemini"
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Options 6
App\Entity\Integrations 4
App\Entity\Channels 4
App\Entity\Cron 3
App\Entity\Users 1

Entities Mapping

Class Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Users
  • The field 'App\Entity\Users#points' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Integrations No errors.
App\Entity\Channels No errors.
App\Entity\Cron No errors.
App\Entity\Modules No errors.
App\Entity\Options No errors.
App\Entity\Products No errors.