SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012632 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012632 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401419,997586,606993,489786,970537,273700,363770,282480,712758,61987,396663,339451,351827,859783,594735,757480,121607,700141,541143,693050,302469,410893,20703,708484,1030505,943515,189053,603210,448511,203579,378925,519776,571557,756217,663912,718992,192638,337859,577772,988713,529119,856013,876366,237206,1037770,763830,221222,237069,940471,660367,720521,989288,936694,436762,102989,80766,293142,499768,308644,460210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012632 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012632 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]