SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531211 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531211 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308818,912942,714077,665205,721465,625134,70993,944649,994776,767005,397567,74905,635055,77567,988717,411546,308728,860850,193981,1010275,337232,20496,308793,668792,383719,378217,657747,69832,687203,511770,45908,248708,597713,484423,638021,75423,793594,860171,715527,900146,465727,653420,539931,747103,784563,379444,616200,929912,781759,524483,671151,423993,679847,289795,102407,426581,702923,935817,222674,418187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]