SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436501 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436501 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741237,277598,398491,289196,729977,657795,261410,328150,646923,29593,259470,913289,815816,119349,614120,1037799,602884,209886,265091,865677,505236,205747,470323,41098,346196,125565,953309,289009,371175,76533,615998,538844,828284,54051,1011598,931520,396086,145120,1013744,33335,709020,665372,49082,778014,719823,356963,808096,884269,419083,870492,983308,411892,156128,378773,959056,519190,986008,288040,470208,655436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]