SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414634 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414634 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031206,711806,45073,738269,723967,780456,198112,845120,208538,179430,417703,866296,980984,94263,311948,749978,627371,261195,330483,877384,652146,660991,132008,54821,665467,309862,698704,728518,710060,167148,303620,333251,801460,336720,561183,767803,132653,774592,737570,298812,281585,607705,863110,74890,134402,376002,394446,843852,697980,840360,612944,731940,606652,64812,905875,366191,920684,397643,408748,822746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]