^ " SELECT `comicbook`.`created_at`, `comicbook`.`updated_at`, `comicbook`.`deleted_at`, `comicbook`.`id`, `comicbook`.`readingdirection`, `comicbook`.`synopsis`, `comicbook`.`cover`, `comicbook`.`path`, `comicbook`.`post_id`, `comicbook`.`rate`, `comicbook`.`nbvote`, `comicbook`.`name`, `comicbook`.`gender_names`, `comicbook`.`nameseo`, `comicbook`.`alternatif`, `comicbook`.`creationdate`, `comicbook`.`img_ranking`, `comicbook`.`logo`, `comicbook`.`banner`, `comicbook`.`status_id`, `comicbook`.`category_id`, `comicbook`.`user_id` FROM `comicbook` LEFT JOIN `status` ON `status`.id = comicbook.status_id LEFT JOIN `tree_item` `category` ON `category`.id = comicbook.category_id LEFT JOIN `user` ON `user`.id = comicbook.user_id WHERE 1 AND status.id = :status_id AND `comicbook`.id != :this_id AND `comicbook`.id in (select comicbook_id from comicbook_gender where gender_id in (select gender_id FROM comicbook_gender where comicbook_id = ) ) ORDER BY RAND() LIMIT 3 "
^ array:2 [
"status_id" => "1"
"this_id" => null
]
^ "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) ORDER BY RAND() LIMIT 3' at line 1"
^ array:1 [
0 => array:5 [
0 => array:7 [
"file" => "/home/agedngyh/public_html/dclass/devups/Tchutte/QueryBuilder.php"
"line" => 1304
"function" => "__findAll"
"class" => "DBAL"
"object" => QueryBuilder {#1719
#link: PDO {#1721
inTransaction: false
attributes: {
CASE: NATURAL
ERRMODE: EXCEPTION
AUTOCOMMIT: 1
PERSISTENT: false
DRIVER_NAME: "mysql"
SERVER_INFO: "Uptime: 135543 Threads: 100 Questions: 54007948 Slow queries: 93 Opens: 586395 Flush tables: 1 Open tables: 4000 Queries per second avg: 398.456"
ORACLE_NULLS: NATURAL
CLIENT_VERSION: "10.2.44"
SERVER_VERSION: "10.2.44-MariaDB"
STATEMENT_CLASS: array:1 [
0 => "PDOStatement"
]
EMULATE_PREPARES: 1
CONNECTION_STATUS: "Localhost via UNIX socket"
DEFAULT_FETCH_MODE: BOTH
}
}
#dbname: "agedngyh_3ag_new"
#defaultjoin: ""
+custom_columns: ""
#collect: []
+_with: []
#object: Comicbook {#643
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#readingdirection: 0
#synopsis: null
+category: Tree_item {#507
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:2 [
0 => "name"
1 => "content"
]
+dv_collection: []
#id: null
#position: null
#slug: null
#status: null
#parent_id: null
#main: null
#chain: null
+tree: Tree {#627
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "label"
]
+dv_collection: []
#id: null
#name: null
#description: 2
}
}
+user: User {#619
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#firstname: null
#lastname: null
#username: null
#email: null
#phonenumber: null
#password: null
#resettingpassword: null
#is_activated: 1
#activationcode: null
#activationcode_expired_at: null
#last_login: null
#lang: "en"
#api_key: null
#session_token: null
#canpublish: 0
#avatar: null
#profile: null
#currency_iso: 0
#config: "{}"
+status: Status {#636
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "label"
]
+dv_collection: []
#id: null
#color: null
#_key: null
#position: 1
#description: null
+entity: Dvups_entity {#633
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#enablenotification: 0
#multi_lang: 0
+dvups_module: Dvups_module {#667
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#favicon: "fas fa-fw fa-cog"
#project: null
+dvups_component: Dvups_component {#637
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
}
}
+dvups_right: array:1 [
0 => Dvups_right {#613
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
}
]
}
}
#address: null
#city: null
#bio: null
#birthdate: null
#cp: null
#devices: null
+country: Country {#620
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "nicename"
]
+dv_collection: []
#id: null
#name: null
#iso: null
#iso3: null
#numcode: null
#phonecode: null
#status: null
}
+wallet: Wallet {#1709
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#status: 1
#reference: null
#amount: 0
}
+nbfollowers: 0
+nbfollowing: 0
+follow_back: 0
+following: 0
+nbpost: 0
}
#cover: null
#path: null
#post_id: null
#rate: null
#nbvote: null
#name: null
#gender_names: null
#nameseo: null
#alternatif: null
#creationdate: null
#img_ranking: null
#logo: null
#banner: null
+status: Status {#1715
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "label"
]
+dv_collection: []
#id: null
#color: null
#_key: null
#position: 1
#description: null
+entity: Dvups_entity {#1716
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#enablenotification: 0
#multi_lang: 0
+dvups_module: Dvups_module {#1717
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#favicon: "fas fa-fw fa-cog"
#project: null
+dvups_component: Dvups_component {#1718
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
}
}
+dvups_right: array:1 [
0 => Dvups_right {#1720
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
}
]
}
}
+gender: null
+member: null
+c_cover: null
+nbviews: null
+nbkola: null
+c_contest_id: null
+last_chapter_title: null
+last_chapter_number: null
+last_chapter_id: null
+rating: null
+nbsubscription: null
+subscribed: null
+"status_id": null
+"category_id": null
+"user_id": null
}
#classmetadata: null
#objectName: "Comicbook"
#table: "comicbook"
#instanceid: null
#objectVar: array:22 [
0 => "created_at"
1 => "updated_at"
2 => "deleted_at"
3 => "id"
4 => "readingdirection"
5 => "synopsis"
6 => "cover"
7 => "path"
8 => "post_id"
9 => "rate"
10 => "nbvote"
11 => "name"
12 => "gender_names"
13 => "nameseo"
14 => "alternatif"
15 => "creationdate"
16 => "img_ranking"
17 => "logo"
18 => "banner"
19 => "status_id"
20 => "category_id"
21 => "user_id"
]
#id_lang: null
#objectValue: array:22 [
0 => null
1 => null
2 => null
3 => null
4 => 0
5 => null
6 => null
7 => null
8 => null
9 => null
10 => null
11 => null
12 => null
13 => null
14 => null
15 => null
16 => null
17 => null
18 => null
19 => null
20 => null
21 => null
]
#nbVar: 22
#listeEntity: []
#objectCollection: []
#softdelete: false
#dvtrashed: false
-select: false
-en: null
#entity_link_list: array:3 [
"status:status" => Status {#1715}
"tree_item:category" => Tree_item {#507}
"user:user" => User {#619}
]
#entity_link_map_list: array:3 [
"status" => "status"
"tree_item" => "category"
"user" => "user"
]
-iterat: null
-update: false
#em: null
#iteration: 0
#limit_iteration: 0
+hasrelation: true
+objectKeyValue: array:22 [
"created_at" => null
"updated_at" => null
"deleted_at" => null
"id" => null
"readingdirection" => 0
"synopsis" => null
"cover" => null
"path" => null
"post_id" => null
"rate" => null
"nbvote" => null
"name" => null
"gender_names" => null
"nameseo" => null
"alternatif" => null
"creationdate" => null
"img_ranking" => null
"logo" => null
"banner" => null
"status_id" => null
"category_id" => null
"user_id" => null
]
+identifier: array:1 [
0 => "id"
]
+_select: ""
+_from: "`comicbook`"
+_set: ""
+_into: ""
+_select_option: "this.`created_at`, this.`updated_at`, this.`deleted_at`, this.`id`, this.`readingdirection`, this.`synopsis`, this.`cover`, this.`path`, this.`post_id`, this.`rate`, this.`nbvote`, this.`name`, this.`gender_names`, this.`nameseo`, this.`alternatif`, this.`creationdate`, this.`img_ranking`, this.`logo`, this.`banner`, this.`status_id`, this.`category_id`, this.`user_id`"
+_where: " AND status.id = :status_id AND this.id != :this_id AND this.id in (select comicbook_id from comicbook_gender where gender_id in (select gender_id FROM comicbook_gender where comicbook_id = ) ) "
+_join: " LEFT JOIN `status` ON `status`.id = comicbook.status_id LEFT JOIN `tree_item` `category` ON `category`.id = comicbook.category_id LEFT JOIN `user` ON `user`.id = comicbook.user_id"
+_order_by: " ORDER BY RAND() "
+_limit: " LIMIT 3"
-query: " SELECT `comicbook`.`created_at`, `comicbook`.`updated_at`, `comicbook`.`deleted_at`, `comicbook`.`id`, `comicbook`.`readingdirection`, `comicbook`.`synopsis`, `comicbook`.`cover`, `comicbook`.`path`, `comicbook`.`post_id`, `comicbook`.`rate`, `comicbook`.`nbvote`, `comicbook`.`name`, `comicbook`.`gender_names`, `comicbook`.`nameseo`, `comicbook`.`alternatif`, `comicbook`.`creationdate`, `comicbook`.`img_ranking`, `comicbook`.`logo`, `comicbook`.`banner`, `comicbook`.`status_id`, `comicbook`.`category_id`, `comicbook`.`user_id` FROM `comicbook` LEFT JOIN `status` ON `status`.id = comicbook.status_id LEFT JOIN `tree_item` `category` ON `category`.id = comicbook.category_id LEFT JOIN `user` ON `user`.id = comicbook.user_id WHERE 1 AND status.id = :status_id AND `comicbook`.id != :this_id AND `comicbook`.id in (select comicbook_id from comicbook_gender where gender_id in (select gender_id FROM comicbook_gender where comicbook_id = ) ) ORDER BY RAND() LIMIT 3 "
-sequence: ""
-parameters: array:2 [
"status_id" => "1"
"this_id" => null
]
-columns: "this.`created_at`, this.`updated_at`, this.`deleted_at`, this.`id`, this.`readingdirection`, this.`synopsis`, this.`cover`, this.`path`, this.`post_id`, this.`rate`, this.`nbvote`, this.`name`, this.`gender_names`, this.`nameseo`, this.`alternatif`, this.`creationdate`, this.`img_ranking`, this.`logo`, this.`banner`, this.`status_id`, this.`category_id`, this.`user_id`"
-columnscount: "COUNT(*)"
-endquery: ""
-initwhereclause: true
-defaultjoinsetted: true
-operators: array:31 [
0 => "="
1 => "<"
2 => ">"
3 => "<="
4 => ">="
5 => "<>"
6 => "!="
7 => "<=>"
8 => "like"
9 => "like binary"
10 => "not like"
11 => "between"
12 => "ilike"
13 => "is"
14 => "&"
15 => "|"
16 => "^"
17 => "<<"
18 => ">>"
19 => "rlike"
20 => "regexp"
21 => "not regexp"
22 => "~"
23 => "~*"
24 => "!~"
25 => "!~*"
26 => "similar to"
27 => "not similar to"
28 => "not ilike"
29 => "~~*"
30 => "!~~*"
]
+tablecollection: ""
-joincollection: []
+softdeletehandled: false
}
"type" => "->"
"args" => array:2 [
0 => " SELECT `comicbook`.`created_at`, `comicbook`.`updated_at`, `comicbook`.`deleted_at`, `comicbook`.`id`, `comicbook`.`readingdirection`, `comicbook`.`synopsis`, `comicbook`.`cover`, `comicbook`.`path`, `comicbook`.`post_id`, `comicbook`.`rate`, `comicbook`.`nbvote`, `comicbook`.`name`, `comicbook`.`gender_names`, `comicbook`.`nameseo`, `comicbook`.`alternatif`, `comicbook`.`creationdate`, `comicbook`.`img_ranking`, `comicbook`.`logo`, `comicbook`.`banner`, `comicbook`.`status_id`, `comicbook`.`category_id`, `comicbook`.`user_id` FROM `comicbook` LEFT JOIN `status` ON `status`.id = comicbook.status_id LEFT JOIN `tree_item` `category` ON `category`.id = comicbook.category_id LEFT JOIN `user` ON `user`.id = comicbook.user_id WHERE 1 AND status.id = :status_id AND `comicbook`.id != :this_id AND `comicbook`.id in (select comicbook_id from comicbook_gender where gender_id in (select gender_id FROM comicbook_gender where comicbook_id = ) ) ORDER BY RAND() LIMIT 3 "
1 => array:2 [
"status_id" => "1"
"this_id" => null
]
]
]
1 => array:7 [
"file" => "/home/agedngyh/public_html/src/edition3ag/ModuleComicbook/Entity/Comicbook.php"
"line" => 493
"function" => "get"
"class" => "QueryBuilder"
"object" => QueryBuilder {#1719}
"type" => "->"
"args" => []
]
2 => array:7 [
"file" => "/home/agedngyh/public_html/App.php"
"line" => 626
"function" => "getSimilarBooks"
"class" => "Comicbook"
"object" => Comicbook {#612
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#readingdirection: 0
#synopsis: null
+category: Tree_item {#337
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:2 [
0 => "name"
1 => "content"
]
+dv_collection: []
#id: null
#position: null
#slug: null
#status: null
#parent_id: null
#main: null
#chain: null
+tree: Tree {#499
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "label"
]
+dv_collection: []
#id: null
#name: null
#description: 2
}
}
+user: User {#851
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#firstname: null
#lastname: null
#username: null
#email: null
#phonenumber: null
#password: null
#resettingpassword: null
#is_activated: 1
#activationcode: null
#activationcode_expired_at: null
#last_login: null
#lang: "en"
#api_key: null
#session_token: null
#canpublish: 0
#avatar: null
#profile: null
#currency_iso: 0
#config: "{}"
+status: Status {#853
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "label"
]
+dv_collection: []
#id: null
#color: null
#_key: null
#position: 1
#description: null
+entity: Dvups_entity {#840
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#enablenotification: 0
#multi_lang: 0
+dvups_module: Dvups_module {#843
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#favicon: "fas fa-fw fa-cog"
#project: null
+dvups_component: Dvups_component {#844
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
}
}
+dvups_right: array:1 [
0 => Dvups_right {#846
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
}
]
}
}
#address: null
#city: null
#bio: null
#birthdate: null
#cp: null
#devices: null
+country: Country {#845
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "nicename"
]
+dv_collection: []
#id: null
#name: null
#iso: null
#iso3: null
#numcode: null
#phonecode: null
#status: null
}
+wallet: Wallet {#839
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#status: 1
#reference: null
#amount: 0
}
+nbfollowers: 0
+nbfollowing: 0
+follow_back: 0
+following: 0
+nbpost: 0
}
#cover: null
#path: null
#post_id: null
#rate: null
#nbvote: null
#name: null
#gender_names: null
#nameseo: null
#alternatif: null
#creationdate: null
#img_ranking: null
#logo: null
#banner: null
+status: Status {#838
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: true
+dvid_lang: false
+dvtranslated_columns: array:1 [
0 => "label"
]
+dv_collection: []
#id: null
#color: null
#_key: null
#position: 1
#description: null
+entity: Dvups_entity {#837
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#enablenotification: 0
#multi_lang: 0
+dvups_module: Dvups_module {#841
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
#favicon: "fas fa-fw fa-cog"
#project: null
+dvups_component: Dvups_component {#831
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: true
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
#label: null
#url: null
}
}
+dvups_right: array:1 [
0 => Dvups_right {#832
#created_at: null
#updated_at: null
#deleted_at: null
+dvfetched: false
+dvold: false
+dvsoftdelete: false
+dvinrelation: false
+dvtranslate: false
+dvid_lang: false
+dvtranslated_columns: []
+dv_collection: []
#id: null
#name: null
}
]
}
}
+gender: null
+member: null
+c_cover: null
+nbviews: null
+nbkola: null
+c_contest_id: null
+last_chapter_title: null
+last_chapter_number: null
+last_chapter_id: null
+rating: null
+nbsubscription: null
+subscribed: null
}
"type" => "->"
"args" => []
]
3 => array:7 [
"file" => "/home/agedngyh/public_html/dclass/devups/Http/Router.php"
"line" => 129
"function" => "scanView"
"class" => "App"
"object" => App {#501
#url: "scan/LYBERTY-/1/1"
#routes: []
#namedRoutes: []
#layout: "layout.app"
}
"type" => "->"
"args" => array:3 [
0 => "LYBERTY-"
1 => "1"
2 => "1"
]
]
4 => array:7 [
"file" => "/home/agedngyh/public_html/index.php"
"line" => 58
"function" => "run"
"class" => "Router"
"object" => App {#501}
"type" => "->"
"args" => []
]
]
]