SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107291 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107291 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973281,24228,32457,957633,527966,912272,56969,261687,1019185,523241,998335,767374,772727,241605,592054,691865,565707,599242,963263,1003069,243911,313721,228184,1013177,355396,198802,194013,339924,519894,81646,768774,152960,568823,55787,76092,496164,796390,102097,678792,1034752,187473,501315,468899,186694,648143,901849,300126,700782,258565,423234,21245,814404,1012127,562925,433023,22612,276629,991451,340132,684073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001242s ]