SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415017 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415017 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975740,799298,369043,882401,421491,889198,303057,25065,733208,179253,873955,12447,863305,591078,121998,1005569,39225,793705,235999,4278,996532,464415,512600,120571,2185,402295,971657,617497,193138,774827,1027236,671881,503934,681552,177784,40359,464637,206428,724600,120756,506802,1016340,925347,658189,718694,608763,747909,85208,530996,164566,649211,189865,297454,253681,8486,337112,151232,74569,154569,878642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]