SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437274 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437274 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047798,922033,822507,80328,449043,734540,310544,485758,303498,272034,1003624,154959,745869,566647,178745,406440,91116,896443,670377,200835,458542,337240,212667,686382,859669,92384,48308,627890,632889,588787,992274,587504,518198,390705,213376,848086,337840,227254,1002470,692374,150277,556137,775009,1000480,690708,528493,935726,832843,204889,199039,467935,971684,57175,966110,338823,1031838,783283,902452,47592,70586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]