SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550026 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550026 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872478,803147,207665,1046247,828168,832104,250186,564927,810722,538383,269851,94606,610341,788749,589937,740525,950480,194729,1022696,891166,17338,556099,169257,105376,94493,732696,492039,909416,789944,562799,988253,408676,953223,208068,700150,869553,482762,948106,724563,1048838,455084,865464,172408,198141,488780,154694,367527,539282,45473,720747,954471,736047,872118,885839,538705,456131,635840,980108,963863,182975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]