SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003985s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103904 LIMIT 1 [ RunTime:0.001235s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103904 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439507,995487,847814,765662,605837,35405,254300,29080,906103,55589,436424,660891,636251,124852,981840,446547,539094,614476,646427,117525,170129,867064,167200,860229,635527,767635,924395,632268,860088,974151,617620,365964,77012,288811,774571,308950,494299,890738,18529,1025967,525030,95681,298634,396970,548430,695287,165823,204063,358937,297092,934461,498367,32616,439545,158102,633790,237850,778990,867435,366084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]