SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567100 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567100 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981618,227162,1040437,1047990,240003,256391,289198,626299,737532,693499,410895,265901,693091,787460,958615,1044245,469023,562741,639670,183172,865855,157577,575254,43458,156846,661875,870282,740404,837226,565980,359664,250889,3814,144799,690719,1033958,46550,254587,243672,88583,51641,1042595,331010,831507,156086,783232,431132,497471,446856,237502,360567,225515,323252,91684,936421,745775,109574,180493,346576,844218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]