SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307218 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307218 [ RunTime:0.002572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479713,557281,989787,475433,516054,857766,51238,878341,499221,239055,943967,632375,44408,173272,383281,441947,700334,416577,258576,75182,174829,157378,826966,956701,425159,379003,40198,22480,673010,755497,582808,694453,510874,686267,942793,105950,672057,928053,76179,766515,336695,55139,752645,900296,416697,421998,256013,314726,684804,248281,489532,977611,278136,498919,6187,967673,643553,529437,156861,27647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]