SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537099 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537099 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818258,783128,688665,805139,700020,44400,884486,384285,779308,371174,240809,800719,644869,443288,60160,755759,910211,729479,455981,709461,514182,683147,165612,501347,230285,825365,624900,807113,513960,487316,719509,101161,424778,207177,245901,548111,410214,254125,75893,836006,294215,31334,1001360,656517,1027250,954676,164671,560965,335789,557175,689062,804060,366488,269080,789251,436418,325292,686875,427353,211380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]