SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409351 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409351 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219516,57330,336786,604217,310697,884999,886259,663699,604289,223908,685116,580982,867948,692114,168072,62834,924542,458327,22698,247978,753861,987308,369699,315843,116824,981128,901065,441112,789199,454799,835315,659524,678188,574005,130470,359146,15054,882637,933304,250739,937,452949,422476,605602,280532,943499,153725,447619,49697,947014,109318,715624,315382,591712,245927,125003,35133,155617,98088,415199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]