SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539710 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539710 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019613,1042359,193069,318138,467005,33184,857998,188644,790055,634659,423042,920003,1019622,13630,485570,368743,374921,802994,393491,942326,776667,69263,948538,104521,2370,836022,711577,562891,492502,840358,326360,996187,886875,224505,543965,573394,184933,442329,732031,328183,358966,185698,602700,52249,781493,902734,66674,306727,992367,53291,155310,666098,778382,222764,625631,547002,50353,585507,53030,739183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]