SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500035 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500035 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983851,282750,387764,467922,134820,685449,553191,55347,116488,223524,752313,247649,408184,218124,508691,719162,976205,1027611,75905,625351,1041715,484708,349583,743757,70393,1040998,1015454,355028,235541,458456,911776,965655,309925,1013527,690142,683256,511570,248476,951030,329405,492722,298048,489505,572709,387322,368197,907284,481341,772598,300936,566503,1027620,83013,551437,860648,605553,978409,410359,1024369,481555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]