SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 637181 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 637181 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503922,374194,79303,1002154,489562,922858,248702,617607,744138,42695,466135,549909,107436,445413,879839,164701,981875,3820,272148,44521,463825,1029817,404716,657089,615140,910813,55174,342918,481596,794983,761758,481454,167852,96159,112004,894649,332951,118308,22938,1035977,794627,774815,709199,48985,576681,146364,70267,797479,245691,88324,1020378,862139,359168,529794,472844,590538,117250,405449,833878,1045811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 637181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 637181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]