SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510529 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510529 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111112,485447,660926,227992,15201,404238,271942,501498,922351,44664,946373,921729,422820,892972,106006,984490,273246,40048,176260,992058,794085,771797,329382,79069,314605,452098,1009660,787390,21141,639182,538264,420739,941034,131016,845850,316930,161060,894341,443189,715686,880075,350435,491870,961446,514662,124684,178375,472497,222009,902927,821260,882328,176129,895448,521656,958842,156592,584710,1032461,1037276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]