SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503941 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503941 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969245,1035110,271304,874603,821873,1020069,761843,487287,124856,1047099,173902,607232,727417,542760,865229,509489,291469,114574,618765,162864,311853,165003,690006,407894,792123,675178,787930,463426,292597,17049,196009,1005335,293159,609021,242154,961572,262804,537298,498846,595306,506802,554946,848629,496062,157273,475966,932343,367998,1020605,644531,1000623,897111,525833,576731,939892,252864,344304,982533,895860,483794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]