https://admin.softmaster.vn/api/solutions?categories%5B0%5D=29380&categories%5B1%5D=29391&limit=10

Log Messages

Level (7)
Channel (8)
Time Message
deprecation User Deprecated: Since pimcore/pimcore 10.5: Registering bundles through extensions.php is deprecated and will not work on Pimcore 11. Use config/bundles.php to register/deregister bundles.
deprecation User Deprecated: Since symfony/security-core 5.4: Not setting the 5th argument of "Symfony\Component\Security\Core\Authorization\AuthorizationChecker::__construct" to "false" is deprecated.
info Matched route
"api-solutions"
.
deprecation User Deprecated: The "Sensio\Bundle\FrameworkExtraBundle\Configuration\Route" annotation is deprecated since version 5.2. Use "Symfony\Component\Routing\Annotation\Route" instead.
deprecation Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated
deprecation User Deprecated: Since pimcore/pimcore 4.4: Pimcore\Model\Element\ChildsCompatibilityTrait::setChilds is deprecated, please use setChildren() instead. It will be removed in Pimcore 11.
deprecation Deprecated: explode(): Passing null to parameter #2 ($string) of type string is deprecated
deprecation Deprecated: explode(): Passing null to parameter #2 ($string) of type string is deprecated
deprecation Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated
info User specific Condition Part: a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query: SELECT TRIM(`segment`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution') GROUP BY TRIM(`segment`)
info Query done.
deprecation Deprecated: explode(): Passing null to parameter #2 ($string) of type string is deprecated
info User specific Condition Part: a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query: SELECT count(*) FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query done.
info User specific Condition Part: a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query: SELECT TRIM(`interactive`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution') GROUP BY TRIM(`interactive`)
info Query done.
info User specific Condition Part: a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query: SELECT dest as `value`, count(*) as `count` FROM shop_productindex_relations a WHERE fieldname = 'features' AND src IN (SELECT a.o_id FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')) GROUP BY dest
info Query done.
info Load Objects...
info done.
info User specific Condition Part: (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND (o_classId ='solution')
info Query: SELECT dest as `value`, count(*) as `count` FROM shop_productindex_relations a WHERE fieldname = 'categories' AND src IN (SELECT a.o_id FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND (o_classId ='solution')) GROUP BY dest
info Query done.
info Load Objects...
info done.
info User specific Condition Part: a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query: SELECT dest as `value`, count(*) as `count` FROM shop_productindex_relations a WHERE fieldname = 'provider' AND src IN (SELECT a.o_id FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')) GROUP BY dest
info Query done.
info Load Objects...
info done.
info User specific Condition Part: a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Total Condition: active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution')
info Query: SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND a.o_id IN (SELECT DISTINCT src FROM shop_productindex_relations WHERE `fieldname` = 'categories' AND dest IN ('29380','29391')) AND (o_classId ='solution') ORDER BY text desc ,a.o_id LIMIT 10
info Query done.
deprecation User Deprecated: Since symfony/security-bundle 5.4: Setting the $authenticatorManagerEnabled argument of "Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector::__construct" to "false" is deprecated, use the new authenticator system instead.

There are no log messages.

Container Compilation Logs (0)

Log messages generated during the compilation of the service container.

There are no compiler log messages.