SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418904 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418904 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30505,775317,481105,696890,6898,477686,781586,638064,553450,835769,1025396,884319,982083,804384,1017145,432128,299387,1029714,691551,369458,11343,630948,829716,1027479,399691,598791,209303,531979,377493,506352,957776,905870,852466,183747,832531,260253,908009,180652,944864,1013372,549472,772826,296506,616830,249272,794539,841363,989768,605611,901953,710780,654063,924091,456334,1036079,193056,393775,189166,782008,652208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]